• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Keyboard Shortcut

If you pay close attention to the underlined items (accelerators) then you will be able to figure out on your own.


If you right-click on sheet tab then you will find 'h' underlined for Hide...


So building on Faseeh's route : ALT + H + H (Hide) and ALT + H + U (Unhide)

Note: Unhide will be disabled when there are no sheets to unhide!
 
Hi Sri...


Thank you for sharing the tip.


But when I do this, I get 'fill color' option for ALT + H + H (for first H it is going to home and second H it is going to 'fill color' as it is mentioned in the ribbon)


And for ALT + H + U, functions open up for me (under editing)


I am using excel 2007.


Am I missing something here?


Regards,

Kaushik
 
Dear Sri,

You can try....

Shortcut for Hiding a sheet Alt → H → O → U → S )

Shortcut for Unhiding a sheet Alt → H → O → U → H )


---Muneer
 
Good morning kaushik03


Alt + W + H TO HIDE

If you press the Alt key you will see the first combination keys as letters in a black square, look for the one you want, press that letter and then you will see the second letter to press, some times there are further letters to press depending on what you are wanting.

Takes longer to read than do but when you get used to the combinations all that time going from mouse to keyboard will be dramatically cut.

This is for Excel 2010, older versions of Excel may have different key combinations but pressing the Alt key will show you the way to go
 
You must log in or register to reply here.
Back
Top