Hiding partial rows (but not full columns)

[ScorchedLemonade]

I suspect this is not possible but I figure I might as well ask.

Is it possible in Excel to hide part of a row (without hiding the full intersecting columns). Obviously there'd be a problem with the cell/axis labelling but I thought that maybe it could be done in a specific situation:

namely that the window is split, with frozen panes and that the rows were always paritally hidden along the first pane (but not the second (which would have a separate axis).

e.g. if the split was between column G & H then the row would be hidden from A to G (but not from H onwards) - and columns A-G wouldn't be completely hidden. Perhaps, for instance rows 4,5,7 and 13would be hidden in the left pane only.

This would only allow for a limited type of hiding but actually that is appropriate for what I am trying to do.

 

[GlennUK]

What you want obviously can't be done within a window, not even when the window is split. What you need is a duplicate sheet, and have a window for the orginal and another window for the duplicate, and arrange the windows to be side by side. Even that might not do exactly what you want.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.