Hiding unused cells/rows/columns

[aacross]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I know I have used this feature before, but I can't remember how I did it, and I can't seem to find any hints in the help file or searching through the forum - probably because I am calling it the wrong thing!

How do you 'delete' unused rows/columns, so that all you see on a worksheet is the cells you have entered data into, or the ones you want to actually see? I have tried, Hide, Freeze etc., but these are not producing what I want. I know this is simple, but I can't for the life of me find the command to do what I want!

 

[CyberTaz]

I'm not sure of exactly how you're going about it but the Hide command is
what you're looking for.

Select all columns to the right of your workspace then use Format> Columns>
Hide. Do the same for al rows below your data using Format> Rows> Hide. If
that doesn't provide the effect you want you'll have to be more descriptive
of what that objective is.

Keep in mind that columns/rows/cells cannot actually be physically removed
from a sheet, nor can any be added.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[aacross]

Thanks, but this is not what I mean. This just hides some columns/rows, but they just get replaced with others, as there seems to be infinitesimal rows and columns. The appearance I am after ends up looking a little like a print preview. If I have cells A1:G20 being used and want to hide/'delete' everything else it ends up with grey Borders around the cells I want to keep. It just helps focus the attention on the important information.

 

[aacross]

Scrub last post! You were right, I just wasn't going far enough! Selecting the first column to hide, then pressing Shift, Ctrl and right arrow highlighted all the columns I wanted to hide, and same for rows.

Thanks again.

 

[CyberTaz]

There ya go

Regards |:>)
Bob Jones
[MVP] Office:Mac