Unhide many columns at once

[neeraj2050]

Hi All,
Greetings!!
I am having an excel file in which many columns are hidden. If I want to unhide few columns at once instead of doing the same one by one, is it possible without any VBA.


Thanks in advance!!
Regards
Neeraj Kumar Agarwal

 

[Marc L]

Hi !

Select all cells, with CTRL + A for example, then on any column title
do a right click and select appropriate option …
​

 

[Hui]

Select and Drag across the Column Headers
or
Select a Column Header, Hold Shift and Click on a Column Header afterv the hidden Columns
Right Click on the Column headers
Unhide

Enjoy

 

[neeraj2050]

Hi,
Thanks for the suggestion!
Please find the sample file. I do not want all the hidden columns to get unhidden. I want few of them to get unhidden. If I select two columns then all the hidden columns in between will get unhidden.
Regards
Neeraj Kumar Agarwal

 

[Hui]

Use the same Click and Drag I described above but continue to hold the Ctrl Key Down

eg:
Click and Drag D:F
whilst holding the Ctrl Key down Click and Drag I:K
repeat
Then right click on any Select Header and Unhide

 

[neeraj2050]

Thanks a lot Sir!!