Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Wooster
 
Posts: n/a
Default extra rows and columns

How do I hide the extra rows and columns in a excel file I don't use. For
example I will not use column P -ZZ or row 55-1,000.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten
 
Posts: n/a
Default extra rows and columns

Select the rows. FormatRowsHide.
Same for columns

--
Kind regards,

Niek Otten

"Wooster" wrote in message
...
How do I hide the extra rows and columns in a excel file I don't use. For
example I will not use column P -ZZ or row 55-1,000.



  #3   Report Post  
Posted to microsoft.public.excel.newusers
gls858
 
Posts: n/a
Default extra rows and columns

Wooster wrote:
How do I hide the extra rows and columns in a excel file I don't use. For
example I will not use column P -ZZ or row 55-1,000.

Highlite the columns right click select hide. Rows work the same way.

gls858
  #4   Report Post  
Posted to microsoft.public.excel.newusers
David McRitchie
 
Posts: n/a
Default extra rows and columns

Hi Wooster,
Hiding columns and rows is fine if you have data in there that you do not want to
show. But if the purpose is to hide or not print because the last cell indication
is wrong (ctrl+end), then you should fix your spreadsheets and the empty
rows and columns are using up space in the workbook.

The use of the PrintArea or hiding cells is frequently used to mask other
problems. If you delete rows or columns Excel remembers that you used up to
certain rows and columns, and will not reset that indication when you delete
rows or columns. So Excel still thinks your are using rows and columns that
you are not.

The easiest to use and fix the entire workbook at once was the macro in the
following article: Did you stop reading before you got to the DeleteUnused macro.
"Why do my scrollbars go to row 500 -- my data ends in cell E50?"
http://www.contextures.com/xlfaqApp.html#Unused


There is no save in the DeleteUnused macro, you will have to save the file when the
macro finishes, or before you exit Excel.. You want to use the macro. You will simply not be able to do
it manually with consistency.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Wooster" wrote in message ...
How do I hide the extra rows and columns in a excel file I don't use. For
example I will not use column P -ZZ or row 55-1,000.



Reply
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 swap rows and columns? [email protected] Excel Discussion (Misc queries) 5 September 21st 05 08:07 AM
inserting columns within certain rows only crimsonkng Excel Discussion (Misc queries) 4 July 14th 05 05:13 PM
delete extra columns and rows matt charlton Excel Discussion (Misc queries) 1 June 7th 05 08:46 PM
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns foofoo Excel Discussion (Misc queries) 1 April 2nd 05 12:02 AM
how do i delete the extra empty rows and columns that i dont need. lindaY Excel Discussion (Misc queries) 3 March 20th 05 04:48 PM


All times are GMT +1. The time now is 11:28 PM.

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

About Us

"It's about Microsoft Excel"