Hiding a range

E

Ed Davis

Is it possible to hide a range of cells?
I have a range J18:J33 I would like to hide.
I know I can hide columns but there is information above J18 and below J33 I
would not like to hide.
 
D

Dave Peterson

You could hide the rows, too.

But if there's stuff in other columns, you're in the same situation.

You could give the cells a custom format of: ;;; (3 semicolons)
The cells will look empty, but you'll be able to see what's in them by selecting
the range and looking at the formula bar.
 
E

Ed Davis

Thanks Dave
I knew of this method but was hoping there was another way.
I have decided to stay with this method.
Thank you for your help.
 
Top