Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Excel 2003 - Linking Formulas, Worksheet to Worksheet | Excel Discussion (Misc queries) | |||
Linking Formulas, Worksheet to Worksheet - Excel 2003 | Excel Discussion (Misc queries) | |||
How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions |