Excel 2007 : Hiding unused portion of a worksheet?

[Efuddy]

I only want to see the part of each worksheet that I am using. I want to make all the rest invisible. Can I do this??

[master.osgood]

If you want, just right click on the column and press "Hide". Sometimes what I do for the boxes I dont need people to see is simply make the writing in the box White so it cannot be seen by the ***** eye or printed out.

[Efuddy]

Thanks Master.osgood.

I selected the entire region with shift-end-arrow, then right-click, "hide".

Works great!

[master.osgood]

If you look at the top (if you were hiding columns) there will be a slightly thicker dark grey line - that will show you where there are hidden cells.

To unhide, you can simply double click them and they will pop out one at a time, or you can highlight the columns on either side of the hidden areas and right click again and this time it is un-hide.

Enjoy