Hiding a range

  • Thread starter Thread starter Ed Davis
  • Start date Start date
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.
 
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.
 
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.
 
Back
Top