ChatterBank9 mins ago
M/s Excel
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.
WR.
Answers
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 --
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.
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.
-- answer removed --