#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default EXCEL Worksheet

Can anyone tell me how to eliminate the extra cells that display on an EXCEL
Worksheet? I got one back that now displays 66000 rows. This makes it hard
to navigate.
--
Rosie Bouquin
Utility Customer Services Officer
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 299
Default EXCEL Worksheet

Hide the ones you don't need


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"Rosie Bouquin" wrote in message
...
Can anyone tell me how to eliminate the extra cells that display on an
EXCEL
Worksheet? I got one back that now displays 66000 rows. This makes it
hard
to navigate.
--
Rosie Bouquin
Utility Customer Services Officer



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,202
Default EXCEL Worksheet

Can anyone tell me how to eliminate the extra cells that display on
an EXCEL Worksheet? I got one back that now displays 66000
rows. This makes it hard to navigate.


As Peo suggested, hide the ones you don't want. On the assumption you don't
know how to do this...

Click on the number in the header of the first row you want to hide. Next,
depress and hold down the Control and Shift keys... while they are down,
press the End key followed by the Right Arrow key. This will select all of
the rows from the first row you clicked on up to the last row on the grid.
Next, click Format/Row/Hide from the Excel menu. You can repeat this
procedure to hide columns as well (just choose Format/Column/Hide from the
menu (notice it is Column this time, not Row) when you get to that stage in
the procedure.

Rick

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
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 lukerush Excel Worksheet Functions 2 September 7th 06 05:05 PM
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet Aster Excel Worksheet Functions 3 March 12th 06 09:58 AM
Excel 2003 - Linking Formulas, Worksheet to Worksheet windsong Excel Discussion (Misc queries) 4 November 15th 05 03:10 PM
Linking Formulas, Worksheet to Worksheet - Excel 2003 windsong Excel Discussion (Misc queries) 2 November 14th 05 01:37 AM
How to link Excel worksheet tab names to dates in each worksheet? Pat Excel Worksheet Functions 9 January 31st 05 07:51 AM


All times are GMT +1. The time now is 06:42 AM.

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"