cell starts with big numbers

dagur777 · Oct 6, 2003

I open a excel file which cell starts with big row numbers (1013, 1014, etc.). I checked it and did make sure there is no hide cells (using unhide) or any protection on the worksheet. Could anyone tell me how to change to the normal sheet starts from A1, A2,....?

A B C D .....
1013
1014
1015
1016
...

Suppose should be:
A B C D .....
1
2
3
4
...

Dagur777

melone · Oct 6, 2003

Try unfreezing the pane..... Window -> Unfreeze Pane

lilliput1 · Oct 6, 2003

To be safe, first copy the entire sheet to another sheet say sheet 2. Then on sheet 2 Delete rows 1 to 1012. If sheet 2 comes out to what you want, you can delete sheet 1.

joerd · Oct 7, 2003

Did you really select the entire sheet (Ctrl-A) before trying to unhide?

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

cpretty · Oct 7, 2003

You may not have hidden rows. Sometimes people hide rows using this method. You may have rows with zero height, so also try setting row height to a size which you can read (std = 8.43).

Joerd's suggestion will also apply to this method.

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

cell starts with big numbers

dagur777

Chemical

Recommended for you

melone

Electrical

lilliput1

Mechanical

joerd

Chemical

cpretty

Mechanical

Similar threads

Part and Inventory Search

Sponsor