View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

Hi!

I just don't want the extra columns & rows there, if that's possible...


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

"lostinexcel" wrote in message
...
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...