I cannot unhide columns in a old spreadsheet which I wish to modify. I have removed protection (Review shows Protect Sheet). Columns A thru AN are shown.
Highlight all cells, Home, Format, Visibilty, Unhide Columns does nothing. Also Highlight all cells, Right click, unhide does not work.
Is it possible I could have deleted columns at an earlier date? Can you delete columns?
I created a new sheet and it has columns A thru IV visible.
On this new sheet I can hide columns then resore then by, Highlight all cells, Right Click, Unhide. However Home, Format, Visibility, Unhide does not work.
What is happening? Your help would be greatly appreciated.