Viewing an Excel sheet w/out all the empty fields...

L

lostinexcel

How do you create a spreadsheet that only shows the fileds with data in them?
-How do you get rid of all the empty rows/columns, to ease viewing for those
who are easily confused by excel spreadsheets?
(I don't know how else to emaplin my question... I just don't want the
extra columns & rows there, if that's possible...)
Please help...
 
B

Biff

Hi!
I just don't want the extra columns & rows there, if that's possible...
Click to expand...

Just hide them!

Suppose the last column in your sheet that contains data is column H. You
can hide columns I:IV so that after column H all you see is a big empty gray
expanse of nothingness! You can do the same with rows, too.

To hide columns I:IV

Hit function key F5

In the Reference box enter: I:IV

Click OK

Within that selected range, right click and select Hide.

Repeat the process for rows. Of course, you would use row NUMBERS like
100:65536

Biff
 
Top