Unable to unhide the column A & B, Please Help

thespardian

Board Regular
Joined
Aug 31, 2012
Messages
119
Office Version
  1. 2016
  2. 2013
Platform
  1. Windows
Hi! there
I have the workbook given in the link below. The cloumn A and B of the sheet1 are being displayed. I tried to unhide it and change the width of the column but all in vain. I tried to delete the hidden columns but Col A and B always remain hidden.
Any help to unhide the said columns would be highly appropriated.

Please download the file because column A And B is displayed in online view.
Book1.xlsx

TIA
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Try this:
1) Press F5 (goto), and type 'A1' and press Enter.
2) Press Ctrl-Space to select the whole column.
3) Press Shift-RightArrow to also select column B
4) Right-click column C and select Unhide.
 
Upvote 0
On the view tab, select Freeze panes then unfreeze panes. Does that work?
Thanks a ton! Its working........100% working
I was really worried about these columns because this file contain a lot of worksheet and data. And all the formulas were dependent on these columns. You resolved the biggest problem for me. For which i am really thankful to you from the bottom of my heart. Stay blessed.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,142
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top