HELP!!! sheet rows numbers are not consecutive; tried to unhide but didn't
work;

Use the cells button to the left of the column letters and above the row
numbers
1. formatrowunhide
or
2. formatrowrow heightset to 12.75

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gin" wrote in message
...
HELP!!! sheet rows numbers are not consecutive; tried to unhide but didn't
work;

I tried that and it did not work.

"Don Guillett" wrote:

Use the cells button to the left of the column letters and above the row
numbers
1. formatrowunhide
or
2. formatrowrow heightset to 12.75

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gin" wrote in message
...
HELP!!! sheet rows numbers are not consecutive; tried to unhide but didn't
work;

Do you have autofilter on?

Are the missing rows maybe set to very tiny height?

Select above and below the missing rows and FormatRowHeight.

Set to 10 or similar.


Gord Dibben MS Excel MVP

On Thu, 25 Jun 2009 16:42:01 -0700, gin
wrote:

I tried that and it did not work.

"Don Guillett" wrote:

Use the cells button to the left of the column letters and above the row
numbers
1. formatrowunhide
or
2. formatrowrow heightset to 12.75

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gin" wrote in message
...
HELP!!! sheet rows numbers are not consecutive; tried to unhide but didn't
work;

If a filter is active a drop-down arrow will appear in heading rows (usually
row 1). If this is the case, turn off your auto filter.
XL 2003
Select Data, Filter, Autofilter.
XL2007
Data tab, Sort & Filter group, Filter.


If rows are hidden

1) Drag select the rows on either side of the hidden row(s).
2) Press (hold all at the same time and release) [Ctrl]/[Shift]/9 (number 9
on the keyboard).

If rows are tiny

Click Cell A1.
Press [Ctrl]/[Shift]/[End] (highlights the used area of the spreadsheet

XL2003
Click Format, Row, and then click AutoFit.

XL2007
On the Home tab, in the Cells group, click Format.
Under Cell Size, click AutoFit Row Height.





--
Steve

"gin" wrote in message
...
I tried that and it did not work.

"Don Guillett" wrote:

Use the cells button to the left of the column letters and above the row
numbers
1. formatrowunhide
or
2. formatrowrow heightset to 12.75

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gin" wrote in message
...
HELP!!! sheet rows numbers are not consecutive; tried to unhide but
didn't
work;