column A is missing. not hidden.

[cmhoz]

i've come across something very odd on a worksheet i've inherited.

column A is missing.

it is not hidden. i have highlighted all and done 'unhide' columns. nothing.

it is not tiny. i have highlighted all and done 'column width' = 10. nothing.

i know it's there... if i put my cursor into B1 and press the left arrow, the cursor moves to A1, i can just see the blinking end of the cursor and can make changes to data in the column A cells.

where did it go?!?

 

[tasos8282]

12 years and probably some excel versions later, still working....many many thanks!

 

[Alexandro]

From your worksheet menu click on Window > Unfreeze Panes.

Then select any cell and hit the Home key.

I registered just to say thank you

 

[LUVE]

13 years and probably some excel versions later, still working....many thanks thanks!

 

[treborsheroes]

From your worksheet menu click on Window > Unfreeze Panes.

Then select any cell and hit the Home key.

As like Alexandro, registered just to say thanks buddy!

 

[danjuma]

From your worksheet menu click on Window > Unfreeze Panes.

Then select any cell and hit the Home key.

The only solution that worked! Many thanks!

 

[Tutube Bama]

From your worksheet menu click on Window > Unfreeze Panes.

Then select any cell and hit the Home key.

14 years later, still works! I only created an account here just to thank you. Thanks a bunch!

 

[Charlotte65]

From your worksheet menu click on Window > Unfreeze Panes.

Then select any cell and hit the Home key.

20 years later and still helping! Thank you!

 

[yepster]

yep, still works. Thanks!

 

[arosen]

From your worksheet menu click on Window > Unfreeze Panes.

Then select any cell and hit the Home key.

2024 and still helpful! You saved me a lot of extra work! Thanks!

 

[makhsan]

2024 and it helps! Brilliant!