Hotkeys for Renaming and moving Sheets

Pyromantic

Board Regular
Joined
Aug 9, 2006
Messages
58
Right, so I admit it. I'm a hotkey junky, I want to learn everything I can to save even just a few seconds.

Right now, I was just curious are there any hotkeys that allow me to:

1.) Rename the activesheet
2.) Open the Move or sheet sheet window

And in addition to that, are there any resources on the net that list all available hotkeys for Excel ? I find that the help files are incomplete.

Thanks for reading!
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good afternoon Pyromantic

I don't beleive there are standard hotkeys for those actions, but you could quite easily write your own and store them in the personal.xls sheet or an add-in. These combinations will do what you require :
Alt + ohr
Alt + em

As to your other question, Chip Pearson's site has a couple of sheets available for download that generates a list of all available Excel hotkeys.

http://www.cpearson.com/excel/ShortCuts.htm

HTH

DominicB
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Hi Pyromantic,

you may be a hotkey junkie, but the Mouse actions for Rename and Move Sheet are so easy I doubt you'll find a hotkey to match. To Rename a sheet double-click the tab and the Rename dialog is displayed. To Move a sheet click and hold when clicking on the Tab, and drag to the desired sheet position.
 

Pyromantic

Board Regular
Joined
Aug 9, 2006
Messages
58
Thansk for the help guys. I agree, if the mouse is already in the palm of your hand, it's quick enough to use it but I find more and more my fingers seem stuck to the keyboard.


Cheers
 

Forum statistics

Threads
1,141,136
Messages
5,704,485
Members
421,353
Latest member
jekoxien15

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
Top