Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to update functions in excel sheet? | Excel Worksheet Functions | |||
Print multiple excel charts within one sheet to fit to a page lik. | Excel Discussion (Misc queries) | |||
How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Viewing Excel spreadsheets | Excel Discussion (Misc queries) |