Home |
Search |
Today's Posts |
#1
|
|||
|
|||
i have rows missing on my spreadsheet but i cannot unhide them?
i have a spreadsheet with rows missong but when i highlight them to unhide
they dont unhide, I do not know how to get them back. Can anyone help? Thanks |
#2
|
|||
|
|||
Emma,
They may not be hidden. 1) They may have very low heights, so select all your cells - click the button to the upper left of cell A1 - and then hover your cursor over a row button until the cursor changes to the row height icon. Then double clike. 2) They may be filtered. Try Data / Filter / Autofilter. HTH, Bernie MS Excel MVP "Emma130176" wrote in message ... i have a spreadsheet with rows missong but when i highlight them to unhide they dont unhide, I do not know how to get them back. Can anyone help? Thanks |
#3
|
|||
|
|||
I have the same problem, Excell seems to be hiding rows on it's own. When I
try to Unhide the rows or set the row height, nothing happens. I have about 1200 rows in the sheet but it's hiding about 600 rows. I can manually mouse click on the row to unhide the data but once I save the file it hides other (seemingly random) rows. Spencer "Bernie Deitrick" wrote: Emma, They may not be hidden. 1) They may have very low heights, so select all your cells - click the button to the upper left of cell A1 - and then hover your cursor over a row button until the cursor changes to the row height icon. Then double clike. 2) They may be filtered. Try Data / Filter / Autofilter. HTH, Bernie MS Excel MVP "Emma130176" wrote in message ... i have a spreadsheet with rows missong but when i highlight them to unhide they dont unhide, I do not know how to get them back. Can anyone help? Thanks |
#4
|
|||
|
|||
I'm opening a new post.
"Bamff" wrote: I have the same problem, Excell seems to be hiding rows on it's own. When I try to Unhide the rows or set the row height, nothing happens. I have about 1200 rows in the sheet but it's hiding about 600 rows. I can manually mouse click on the row to unhide the data but once I save the file it hides other (seemingly random) rows. Spencer "Bernie Deitrick" wrote: Emma, They may not be hidden. 1) They may have very low heights, so select all your cells - click the button to the upper left of cell A1 - and then hover your cursor over a row button until the cursor changes to the row height icon. Then double clike. 2) They may be filtered. Try Data / Filter / Autofilter. HTH, Bernie MS Excel MVP "Emma130176" wrote in message ... i have a spreadsheet with rows missong but when i highlight them to unhide they dont unhide, I do not know how to get them back. Can anyone help? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I modify the spreadsheet to fit less rows per page? | Excel Discussion (Misc queries) | |||
Rename rows/ in an Excel Spreadsheet | Excel Discussion (Misc queries) | |||
cells() and counting number or rows on spreadsheet | Excel Worksheet Functions | |||
How can I separate rows to the bottom of the page with missing inf | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel |