Unhide a single column in a group of hidden columns

[Hayley]

Hi everyone, first time posting.


If I have a group of columns hidden...let's say A:G...and I want to unhide column G only, is there a way to do that without unhiding everything and then re-hiding all but G?


And is there a different way to do it if the column I want to unhide is in the middle of the group? (e.g. want to unhide column D)


Love love LOVE this website!

Thanks,

Hayley

 

[Luke M]

I think you'd have to use the Goto box and Keyboard shortcuts.


Let's say you want to unhide column D.

1. Hit Ctrl+g to bring up Goto dialogue

2. Input D1, hit ok

3. Hit Ctrl+shift+0

 

[Hayley]

That worked!


Thanks SO much!!!