Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unable to unhide any Rows beyond Row 1022 in excel
I have a very large workbook and when I try to unhide the rows it does not
work. When I click on row 1022 with the mouse and scrowl down, the # of rows it tells me is only 64516? What is happening? I'm hoping to make the template smaller by making sure that there is no formula's and formatting in the rows below a particular row. Once I do this to 15 worksheet in the template I would like to again hide the "unneeded rows". -- MJM |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unable to unhide any Rows beyond Row 1022 in excel
If the rows are truly hidden, go to the vary last row. Then put your mouse
pointer just below the last ROW NUMBER (in gray) untl you see the pointer change to a doulble arrow pointing up and down. Right click and select unhide from the menu. [It's a little tricky to get the arrows to stay while clicking, so you don't accidently click row 64516. You may have to try a couple of times.] Hope this helps. "MikeM" wrote: I have a very large workbook and when I try to unhide the rows it does not work. When I click on row 1022 with the mouse and scrowl down, the # of rows it tells me is only 64516? What is happening? I'm hoping to make the template smaller by making sure that there is no formula's and formatting in the rows below a particular row. Once I do this to 15 worksheet in the template I would like to again hide the "unneeded rows". -- MJM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hidden rows automatically unhide when I open Excel Spreadsheet. | Excel Discussion (Misc queries) | |||
How to hide and unhide Rows & Columns | Excel Worksheet Functions | |||
how do i unhide a worksheet in excel 2003? unhide tab don't work | Excel Discussion (Misc queries) | |||
Unable to group rows or columns on an excel worksheet | Excel Discussion (Misc queries) | |||
Why cannot I unhide the hidden rows ? | Excel Discussion (Misc queries) |