Possible to Keep some cells visible while rows are hidden?

[thewiseguy]

Hello all. Is it possible to keep columns A-D visible, if I were to hide rows where there was no data in column O? In this example, rows 4,5,6,7,9,11-16

ASRC-Working_v2023.10.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
2					ECM	Building	Area	Location	Annual Operating Hours	Existing Fixture Description	Qty.	Watts	Product	New ECM Description	Qty. (ECM)	Watts
3	Table of Contents				1	0	Common Area	Vestibule	3120	Troffer 2x4 F32T8 3L	1	88	Fixture	2X4 LED Flat Panel [WS-MCCT]	1	27
4	Dashboard												Accessory
5	Project Items												Accessory
6	Input												Materials
7	Proposal												Materials
8	Line-by-Line												Rental	Roll Off Dumpsters – 30 Yard	3
9	TOC												Control
10	BOM				2	0	Common Area	Lobby	3120	Troffer 2x4 F32T8 3L	10	88	Fixture	2X4 LED Flat Panel [WS-MCCT]	10	27
11	Labor Add. (BOM)												Accessory
12	Project Level Items (BOM)												Accessory
13	Recycle (BOM)												Materials
14	Shipping (BOM)												Materials
15	Project Detail (Install)												Rental
16	Checklist (Install)												Control
17	BOM (Install)				3	0	Common Area	Lobby	3120	Downlight 8" CFL 4-pin 32W 1L	12	34	Fixture	8"LED Round Downlight [14W-MCCT]	12	14
18	LxL (Install)												Accessory
19	Damaged Fixture (Install)												Accessory
20	Recycle Request (Install)												Materials
21	Labor Budget (Install)												Materials
22	Lighting&Controls(PSEG)												Rental
23													Control
24					4	0	Common Area	Cafeteria	3120	0			Fixture
25													Accessory
26													Accessory
27													Materials
28													Materials
29													Rental
30													Control
Line-by-Line

Cell Formulas
Range	Formula
F3,F10,F17,F24	F3	=Input!F4
G3:I3,G10:I10,G17:I17,G24:I24	G3	=Input!K4
J3,J10,J17,J24	J3	=IF(Input!I4="","",Input!I4)
K3:L3,K10:L10,K17:L17,K24:L24	K3	=Input!Q4
M3,M10,M17,M24	M3	=IFERROR(XLOOKUP(Input!Q4,TblExisting[Description],TblExisting[Watt/Fixture]),"")
N3:N30	N3	=Input!Y4
O3:O30	O3	=IFERROR(RIGHT(Input!AA4,LEN(Input!AA4)-FIND(" ",Input!AA4)),"")
P3:P30	P3	=IF(O3="Leave As Is","0",Input!AB4)
Q3,Q10,Q17,Q24	Q3	=(XLOOKUP(Input!AA4,Tbl_Area[MaskedPartNumber],Tbl_Area[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Decorative[MaskedPartNumber],Tbl_Decorative[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Downlight[MaskedPartNumber],Tbl_Downlight[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Exit_and_Emergencies[MaskedPartNumber],Tbl_Exit_and_Emergencies[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Flat_Panel[MaskedPartNumber],Tbl_Flat_Panel[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Flood_Light[MaskedPartNumber],Tbl_Flood_Light[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Garage_and_Canopy[MaskedPartNumber],Tbl_Garage_and_Canopy[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Highbay[MaskedPartNumber],Tbl_Highbay[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Linear[MaskedPartNumber],Tbl_Linear[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Lowbay[MaskedPartNumber],Tbl_Lowbay[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Strip[MaskedPartNumber],Tbl_Strip[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Troffer[MaskedPartNumber],Tbl_Troffer[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Vapor_Tight[MaskedPartNumber],Tbl_Vapor_Tight[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Wall_Mount[MaskedPartNumber],Tbl_Wall_Mount[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Wrap[MaskedPartNumber],Tbl_Wrap[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_A_Lamp[MaskedPartNumber],Tbl_A_Lamp[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_BR_Lamp[MaskedPartNumber],Tbl_BR_Lamp[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Candle_Lamp[MaskedPartNumber],Tbl_Candle_Lamp[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_CFL_Lamp[MaskedPartNumber],Tbl_CFL_Lamp[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Filament_Lamp[MaskedPartNumber],Tbl_Filament_Lamp[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Globe_Lamp[MaskedPartNumber],Tbl_Globe_Lamp[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_HID_Lamp[MaskedPartNumber],Tbl_HID_Lamp[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_MR_Lamp[MaskedPartNumber],Tbl_MR_Lamp[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Par_Lamp[MaskedPartNumber],Tbl_Par_Lamp[Watts_for_Proposal],XLOOKUP(Input!AA4,Tbl_Linear_Lamp[MaskedPartNumber],Tbl_Linear_Lamp[Watts_for_Proposal]))))))))))))))))))))))))))

 

[6StringJazzer]

No. A row is either completely visible, or completely hidden. Excel does not support hiding part of a row. If you could do that then the row numbers at the left would be all out of whack.

BTW you are asking for trouble with the merged cells.