| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Header Mystery
I have a spreadsheet that starts with row heading one and then the next row
is 1865. I'm confused! I tried to unhide the rows, but they are not hidden. What else could it be? I'm using Excel 2003 Any help would be greatly appreciated Karen |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row Header Mystery
Hit Ctrl+A to select all cells and then try unhiding the row from menu
FormatRowUnhide -- Jacob "Karen" wrote: I have a spreadsheet that starts with row heading one and then the next row is 1865. I'm confused! I tried to unhide the rows, but they are not hidden. What else could it be? I'm using Excel 2003 Any help would be greatly appreciated Karen |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row Header Mystery
Could be zero height. Select row 1, shift select row 1865, double check that
you can't unhide the rows, the Format/ Rows/ Height, either Autofit or some suitable number. -- David Biddulph "Karen" wrote in message ... I have a spreadsheet that starts with row heading one and then the next row is 1865. I'm confused! I tried to unhide the rows, but they are not hidden. What else could it be? I'm using Excel 2003 Any help would be greatly appreciated Karen |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row Header Mystery
I'd try:
Window|Unfreeze panes Then scroll up (you may have to try unhiding the rows again). Or maybe.... Data|filter|show all Karen wrote: I have a spreadsheet that starts with row heading one and then the next row is 1865. I'm confused! I tried to unhide the rows, but they are not hidden. What else could it be? I'm using Excel 2003 Any help would be greatly appreciated Karen -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row Header Mystery
You have Freeze Panes enabled and have slid rows 2 to 1864 under row 1
Just scroll up to see rows. Gord Dibben MS Excel MVP On Wed, 2 Dec 2009 08:52:01 -0800, Karen wrote: I have a spreadsheet that starts with row heading one and then the next row is 1865. I'm confused! I tried to unhide the rows, but they are not hidden. What else could it be? I'm using Excel 2003 Any help would be greatly appreciated Karen |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row Header Mystery
Thanks - I just gave that a try and it's still the same.
Thanks again, Karen "David Biddulph" wrote: Could be zero height. Select row 1, shift select row 1865, double check that you can't unhide the rows, the Format/ Rows/ Height, either Autofit or some suitable number. -- David Biddulph "Karen" wrote in message ... I have a spreadsheet that starts with row heading one and then the next row is 1865. I'm confused! I tried to unhide the rows, but they are not hidden. What else could it be? I'm using Excel 2003 Any help would be greatly appreciated Karen . |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row Header Mystery
Thanks - I just gave that a try and it's still the same.
Thanks again, Karen "Dave Peterson" wrote: I'd try: Window|Unfreeze panes Then scroll up (you may have to try unhiding the rows again). Or maybe.... Data|filter|show all Karen wrote: I have a spreadsheet that starts with row heading one and then the next row is 1865. I'm confused! I tried to unhide the rows, but they are not hidden. What else could it be? I'm using Excel 2003 Any help would be greatly appreciated Karen -- Dave Peterson . |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row Header Mystery
Thank you for your help - I'm sorry, I don't understand what you are saying.
Karen "Gord Dibben" wrote: You have Freeze Panes enabled and have slid rows 2 to 1864 under row 1 Just scroll up to see rows. Gord Dibben MS Excel MVP On Wed, 2 Dec 2009 08:52:01 -0800, Karen wrote: I have a spreadsheet that starts with row heading one and then the next row is 1865. I'm confused! I tried to unhide the rows, but they are not hidden. What else could it be? I'm using Excel 2003 Any help would be greatly appreciated Karen . |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row Header Mystery
Thanks - That's exactly what I did prior to posting this and nothing changed.
Thanks, Karen "Jacob Skaria" wrote: Hit Ctrl+A to select all cells and then try unhiding the row from menu FormatRowUnhide -- Jacob "Karen" wrote: I have a spreadsheet that starts with row heading one and then the next row is 1865. I'm confused! I tried to unhide the rows, but they are not hidden. What else could it be? I'm using Excel 2003 Any help would be greatly appreciated Karen |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row Header Mystery
Send the workbook to me personally via email.
gorddibbATshawDOTca Change the AT and DOT Gord On Wed, 2 Dec 2009 11:49:03 -0800, Karen wrote: Thank you for your help - I'm sorry, I don't understand what you are saying. Karen "Gord Dibben" wrote: You have Freeze Panes enabled and have slid rows 2 to 1864 under row 1 Just scroll up to see rows. Gord Dibben MS Excel MVP On Wed, 2 Dec 2009 08:52:01 -0800, Karen wrote: I have a spreadsheet that starts with row heading one and then the next row is 1865. I'm confused! I tried to unhide the rows, but they are not hidden. What else could it be? I'm using Excel 2003 Any help would be greatly appreciated Karen . |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row Header Mystery
If anyone is interested...........been a while<g
Karen sent me the workbook. Autofilter was enabled on column S only and sheet was filtered. Remove filter and show all retrieved the hidden rows. Gord On Wed, 02 Dec 2009 12:21:32 -0800, Gord Dibben <gorddibbATshawDOTca wrote: Send the workbook to me personally via email. gorddibbATshawDOTca Change the AT and DOT Gord On Wed, 2 Dec 2009 11:49:03 -0800, Karen wrote: Thank you for your help - I'm sorry, I don't understand what you are saying. Karen "Gord Dibben" wrote: You have Freeze Panes enabled and have slid rows 2 to 1864 under row 1 Just scroll up to see rows. Gord Dibben MS Excel MVP On Wed, 2 Dec 2009 08:52:01 -0800, Karen wrote: I have a spreadsheet that starts with row heading one and then the next row is 1865. I'm confused! I tried to unhide the rows, but they are not hidden. What else could it be? I'm using Excel 2003 Any help would be greatly appreciated Karen . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Mystery | Excel Discussion (Misc queries) | |||
| Mystery object | Excel Discussion (Misc queries) | |||
| One of lifes little mystery? | Excel Worksheet Functions | |||
| MYSTERY!! | Excel Discussion (Misc queries) | |||
| Mystery Cell | Excel Discussion (Misc queries) | |||
Linear Mode
