Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Rows Still M.I.A.
Still having this issue:
I have this spreadsheet and the row #'s go in order from #1 thru 9131 and then the next row # is 11,725 Question: Why is this happening? Question: HOW did this happen? Question: HOW do I make all of the rows between 9132 & 11725 display? Someone wrote back that that row hieght was set to 0....so I selected all of the rows in between and reset the row hieght to 12.75....but it didnt work. The rows are still MIA. I have noticied that the rows 1-9132 have a light blue color font on the row numbers and then row #11725 has the standard black color font. And there appears to be a heavy line seperating Row #9132 & 11725 e.g. 9131 9132 ------ 11725 |
#2
|
|||
|
|||
"BenJAMMIN" wrote in message ... Still having this issue: I have this spreadsheet and the row #'s go in order from #1 thru 9131 and then the next row # is 11,725 Question: Why is this happening? Question: HOW did this happen? Question: HOW do I make all of the rows between 9132 & 11725 display? Someone wrote back that that row hieght was set to 0....so I selected all of the rows in between and reset the row hieght to 12.75....but it didnt work. The rows are still MIA. I have noticied that the rows 1-9132 have a light blue color font on the row numbers and then row #11725 has the standard black color font. And there appears to be a heavy line seperating Row #9132 & 11725 e.g. 9131 9132 ------ 11725 The rows are hidden. That's what the heavy line indicates. Select rows 9132 & 11725 and then Format|Row|Show. I use the Swedish version of Excel, the actual name on your PC may be different. /Fredrik |
#3
|
|||
|
|||
Ben,
You may have a filter applied. Try using Data | Filter | Autofilter to toggle it off. HTH, Bernie MS Excel MVP "BenJAMMIN" wrote in message ... Still having this issue: I have this spreadsheet and the row #'s go in order from #1 thru 9131 and then the next row # is 11,725 Question: Why is this happening? Question: HOW did this happen? Question: HOW do I make all of the rows between 9132 & 11725 display? Someone wrote back that that row hieght was set to 0....so I selected all of the rows in between and reset the row hieght to 12.75....but it didnt work. The rows are still MIA. I have noticied that the rows 1-9132 have a light blue color font on the row numbers and then row #11725 has the standard black color font. And there appears to be a heavy line seperating Row #9132 & 11725 e.g. 9131 9132 ------ 11725 |
#4
|
|||
|
|||
Thanks! This did the trick!
"Bernie Deitrick" wrote: Ben, You may have a filter applied. Try using Data | Filter | Autofilter to toggle it off. HTH, Bernie MS Excel MVP "BenJAMMIN" wrote in message ... Still having this issue: I have this spreadsheet and the row #'s go in order from #1 thru 9131 and then the next row # is 11,725 Question: Why is this happening? Question: HOW did this happen? Question: HOW do I make all of the rows between 9132 & 11725 display? Someone wrote back that that row hieght was set to 0....so I selected all of the rows in between and reset the row hieght to 12.75....but it didnt work. The rows are still MIA. I have noticied that the rows 1-9132 have a light blue color font on the row numbers and then row #11725 has the standard black color font. And there appears to be a heavy line seperating Row #9132 & 11725 e.g. 9131 9132 ------ 11725 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
Copying Rows when hiding other rows | Excel Worksheet Functions |