ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   worksheet help (https://www.excelbanter.com/excel-discussion-misc-queries/193380-worksheet-help.html)

Rajesh Chandra

worksheet help
 
Dear Support

How can i access the options in the sheet menu ( like renaming the sheet ,
delete, changing the tab colour ... ) by keyboard only as it can save a lot
of time for me.
--
With Thanks
Regards

Rajesh Chandra

Franz Erhart

worksheet help
 
Right click the tab of the sheet and the menu with all options will pop up.

"Rajesh Chandra" wrote:

Dear Support

How can i access the options in the sheet menu ( like renaming the sheet ,
delete, changing the tab colour ... ) by keyboard only as it can save a lot
of time for me.
--
With Thanks
Regards

Rajesh Chandra


Dave Peterson

worksheet help
 
I use xl2003.

I can use the accelerator keys (the letters that underlined) to get access to
that menu item.

If I wanted to change the tab color, I could use:

alt-o,h,t
(alt-o is for fOrmat, h is for worksHeet, t is for Tab)


What does this do:
alt-o-h-r



Rajesh Chandra wrote:

Dear Support

How can i access the options in the sheet menu ( like renaming the sheet ,
delete, changing the tab colour ... ) by keyboard only as it can save a lot
of time for me.
--
With Thanks
Regards

Rajesh Chandra


--

Dave Peterson


All times are GMT +1. The time now is 01:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com