Hidden but not hidden columns

[TTSMike]

Columns A and B are not hidden but almost appear as though they are behind the row number column of values. C1 is the top left most visible cell. I have checked the following:

• A and B are NOT hidden, I have checked this via a variety of methods including inspecting the document.
• A and B are not 0 width - I have resized the entire sheet in a variety of ways.
• I select C1 and press the left arrow key. B1 appears in the "Name Box" and the contents appears in the formula bar. Same applied if I press left arrow again for A1.
• Sheet is not lock nor password protected.
• All three colleagues using it have no idea how this happened, nor can fix this.

 

[maabadi]

Welcome to MrExcel Message Board.
1. What is width size of Column A & B?
2. Are you Test it with Format Painter. Take Format from Column C or D or ... And give to to all cells in sheet (Select triangle above row 1 before fist column).
3. If your file is Macro-enabled Version (.xlm or .xlsm). Please check you don't have worksheet or workbook event that hides them.

 

[RoryA]

Did you try Unfreeze panes?