ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Excell spread sheet: reinstate number of rows to 50 (https://www.excelbanter.com/new-users-excel/220633-excell-spread-sheet-reinstate-number-rows-50-a.html)

Monica

Excell spread sheet: reinstate number of rows to 50
 
In my excell spread sheet, I need to find out how to reinstate a specific
number of rows. It is an address spread sheet with approx 40-50 rows. As it
stands now I cannot get to the bottom of the number of rows, and so cannot
access the tabs at the bottom of the spread sheet that say Sheet 2, Sheet 3
etc, where a lot of other info is stored.

Max

Excell spread sheet: reinstate number of rows to 50
 
Some guesses at your predicaments, & tinkers to try:
1. Click Window Unfreeze pane (panes may be frozen?)
2. Click Tools Options View tab Check "Sheet tabs" OK (sheet tabs at
bottom cannot be seen?)
3. Select the entire sheet. Click Format Row Unhide (rows hidden?)

If some options appear grayed out, then you might need to do this first:
Click Tools Protection Unprotect (sheet protected?)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Monica" wrote:
In my excell spread sheet, I need to find out how to reinstate a specific
number of rows. It is an address spread sheet with approx 40-50 rows. As it
stands now I cannot get to the bottom of the number of rows, and so cannot
access the tabs at the bottom of the spread sheet that say Sheet 2, Sheet 3
etc, where a lot of other info is stored.


curlydave

Excell spread sheet: reinstate number of rows to 50
 
On Feb 12, 12:01*pm, Monica wrote:
In my excell spread sheet, I need to find out how to reinstate a specific
number of rows. It is an address spread sheet with approx 40-50 rows. As it
stands now I cannot get to the bottom of the number of rows, and so cannot
access the tabs at the bottom of the spread sheet that say Sheet 2, Sheet 3
etc, where a lot of other info is stored.


Are the rows hidden??

Shane Devenshire[_2_]

Excell spread sheet: reinstate number of rows to 50
 
Hi,

Try maximizing your spreadheet. And if necessary the Excel program.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Monica" wrote:

In my excell spread sheet, I need to find out how to reinstate a specific
number of rows. It is an address spread sheet with approx 40-50 rows. As it
stands now I cannot get to the bottom of the number of rows, and so cannot
access the tabs at the bottom of the spread sheet that say Sheet 2, Sheet 3
etc, where a lot of other info is stored.



All times are GMT +1. The time now is 07:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com