ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Missing Rows (https://www.excelbanter.com/excel-discussion-misc-queries/163225-missing-rows.html)

Carter

Missing Rows
 
My worksheet is missing some rows. The numbers on the left side are
3,4,5,6,8,9 Etc. Where is number 7 ? I tried the unfreeze, but no luck.

--
Carter

Andy Smith[_2_]

Missing Rows
 
Select rows 6-8 and do Format / Row / Unhide

--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard and Poor''s, NYC



"Carter" wrote:

My worksheet is missing some rows. The numbers on the left side are
3,4,5,6,8,9 Etc. Where is number 7 ? I tried the unfreeze, but no luck.

--
Carter


Peo Sjoblom

Missing Rows
 
Press F5, type A7 and press enter, do formatrowunhide


--


Regards,


Peo Sjoblom



"Carter" wrote in message
...
My worksheet is missing some rows. The numbers on the left side are
3,4,5,6,8,9 Etc. Where is number 7 ? I tried the unfreeze, but no luck.

--
Carter




Gary''s Student

Missing Rows
 
Select all the rows

1. make sure they are not hidden:
Format Rows Unhide


2. make sure they are not too short:
Format Rows Height something reasonable
--
Gary''s Student - gsnu200750


"Carter" wrote:

My worksheet is missing some rows. The numbers on the left side are
3,4,5,6,8,9 Etc. Where is number 7 ? I tried the unfreeze, but no luck.

--
Carter


RagDyeR

Missing Rows
 
Have you tried to select row 6 & 8 and then:
<Format <Rows <Unhide

If that doesn't work,
Select rows 6 & 8 and then:
<Format <Rows <Height
And enter 12,
Then <OK.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Carter" wrote in message
...
My worksheet is missing some rows. The numbers on the left side are
3,4,5,6,8,9 Etc. Where is number 7 ? I tried the unfreeze, but no luck.

--
Carter




Niek Otten

Missing Rows
 
HI Carter,

Select the row before the first missing one thru the one following the last missing one
FormatRowUnhide


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Carter" wrote in message ...
| My worksheet is missing some rows. The numbers on the left side are
| 3,4,5,6,8,9 Etc. Where is number 7 ? I tried the unfreeze, but no luck.
|
| --
| Carter



Carter

Missing Rows
 
Thanks That fixed it.
--
Carter


"Andy Smith" wrote:

Select rows 6-8 and do Format / Row / Unhide

--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard and Poor''s, NYC



"Carter" wrote:

My worksheet is missing some rows. The numbers on the left side are
3,4,5,6,8,9 Etc. Where is number 7 ? I tried the unfreeze, but no luck.

--
Carter



All times are GMT +1. The time now is 08:26 PM.

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