![]() |
Row Numbers
I set up a worksheet yesterday and the row numbers started with 1 (as
always). However, I went back into the worksheet today and the first row number is 4. I did not hide any and cannot figure out were rows 1-3 went. Any help is appreciated! Thanks, Les |
Row Numbers
If you can't scroll up to see those lines, try:
ctrl-g type: 1:3 and hit enter Then Format|row|Unhide If you still can't see those rows when you scroll up, then try: Window|Unfreeze panes And scroll up. WLMPilot wrote: I set up a worksheet yesterday and the row numbers started with 1 (as always). However, I went back into the worksheet today and the first row number is 4. I did not hide any and cannot figure out were rows 1-3 went. Any help is appreciated! Thanks, Les -- Dave Peterson |
Row Numbers
Click the select cells button to the right of column A and above row 1.
Click FORMAT in the menu, select ROW and click UNHIDE to redisplay the MIA rows. You could have inadvertently dragged the row divider with an errant mouse click & drag, which might explain why your rows are hidden. -- Kevin Backmann "WLMPilot" wrote: I set up a worksheet yesterday and the row numbers started with 1 (as always). However, I went back into the worksheet today and the first row number is 4. I did not hide any and cannot figure out were rows 1-3 went. Any help is appreciated! Thanks, Les |
Row Numbers
And if that doesn't work, try changing the row height while you've got those
rows selected. -- David Biddulph "Dave Peterson" wrote in message ... If you can't scroll up to see those lines, try: ctrl-g type: 1:3 and hit enter Then Format|row|Unhide If you still can't see those rows when you scroll up, then try: Window|Unfreeze panes And scroll up. WLMPilot wrote: I set up a worksheet yesterday and the row numbers started with 1 (as always). However, I went back into the worksheet today and the first row number is 4. I did not hide any and cannot figure out were rows 1-3 went. Any help is appreciated! Thanks, Les -- Dave Peterson |
Row Numbers
Thanks, I had to unfreeze panes to see 1:3 again.
Les "Dave Peterson" wrote: If you can't scroll up to see those lines, try: ctrl-g type: 1:3 and hit enter Then Format|row|Unhide If you still can't see those rows when you scroll up, then try: Window|Unfreeze panes And scroll up. WLMPilot wrote: I set up a worksheet yesterday and the row numbers started with 1 (as always). However, I went back into the worksheet today and the first row number is 4. I did not hide any and cannot figure out were rows 1-3 went. Any help is appreciated! Thanks, Les -- Dave Peterson |
All times are GMT +1. The time now is 05:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com