LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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...



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to update functions in excel sheet? Inass Excel Worksheet Functions 1 February 22nd 05 05:14 PM
Print multiple excel charts within one sheet to fit to a page lik. lal Excel Discussion (Misc queries) 1 February 18th 05 09:47 PM
How to make empty cells as zero in excel add-ins for SQL Server an Microlong Excel Worksheet Functions 0 January 12th 05 06:31 AM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 09:03 PM
Viewing Excel spreadsheets Jimbola Excel Discussion (Misc queries) 1 November 28th 04 06:59 PM


All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"