Rows

[gin]

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

 

[Don Guillett]

Use the cells button to the left of the column letters and above the row
numbers
1. format>row>unhide
or
2. format>row>row height>set to 12.75

 

[gin]

I tried that and it did not work.

Use the cells button to the left of the column letters and above the row
numbers
1. format>row>unhide
or
2. format>row>row height>set to 12.75

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Gord Dibben]

Do you have autofilter on?

Are the missing rows maybe set to very tiny height?

Select above and below the missing rows and Format>Row>Height.

Set to 10 or similar.


Gord Dibben MS Excel MVP

 

[AltaEgo]

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.