Donate SIGN UP

M/s Excel

Avatar Image
whiskeryron | 12:43 Thu 14th Mar 2013 | Technology
9 Answers
I have a page in M/S Excel of my DVD catalogue, numbering 001- 348. I recently added more & I know for certain that I clicked save. When I open Excel now the 1st number on the page is 295. Whatever I do I cannot get the page to open @ 001. My system is W7 & the browser I am using is Safari + Google. Can anyone please help me to get back to how it was ?

WR.
Gravatar

Answers

1 to 9 of 9rss feed

Best Answer

No best answer has yet been selected by whiskeryron. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
-- answer removed --
Question Author
Yes Doc, I cannot find 001- 294.

Ron.
To unhide row 1 in the worksheet in Excel 2007

Type the cell reference A1 in the Name Box and press the Enter key on the keyboard.
Click on the Home tab on the ribbon.
Click on the Format icon on the ribbon to open the drop down list.
Choose Hide & Unhide > Unhide Rows from the drop down list.
Row 1 will become visible.

To unhide row 1 in the worksheet in Excel versions 97 to 2003

Type the cell reference A1 in the Name Box and press the Enter key on the keyboard.
Click on the Format menu.
Choose Row > Unhide in the menu.
Row 1 will become visible.

To unhide multiple Rows in the worksheet - all versions of Excel

For example, you want to unhide rows 2, 4, and 6.

In the row header drag select to highlight rows 1 to 7.
Right click on the selected rows.
Choose Unhide from the menu.
The hidden rows and the row letters will be visible.
You can opt to unhide them, from the menus I think. Or they may be 0mm wide, again columns can be formatted. First select all by clicking that top left axis join.
I find it quicker to click on the furthest left column header you can see.

Click and hold on the letters at the top of the column and move the mouse to the left to highlight the numbers. Then right click and select 'unhide'.
-- answer removed --
Question Author
Thanks for your suggestions, but no change.

WR.
you havent got the "split" screen function on have you, and inadvertanly scrolled down so its just not showing a big chunk of data
If the unhide method doesn't work, can you perhaps post a screenshot somewhere of what it looks like? That might give us a better idea of the problem.

1 to 9 of 9rss feed

Do you know the answer?

M/s Excel

Answer Question >>