What Shortcut Renames a Sheet in Excel?
If you need to rename a sheet in excel - select "alt + H + O + R" and then type the desired title. To stop editing - hit enter.

Looking to become a modeling master?
Sign up for our financial modeling training course to learn all this and more. Check out our 15% off discount to Wall Street Prep's Financial Modeling Courses.
alt o h r
alt h o r
alt o r h
So much faster just to click...
LOL
Couldn't you have just googled this? I mean there are some things that don't need a thread and this is one of them
alt h d s (enter)
Really? REALLY?
Fun fact:
If you copy/paste the title of this topic into google, the first result will contain your answer. I checked!
Right mouse click while you are hovering over the tab. Surely that one click is quicker than the separate key strokes?
No. Go rename 100 tabs and tell me if clicking is easier than ctrl + pg dwn; Alt ohr
When did you ever need to rename 100 tabs? What about Ctrl + page down, then right mouse click for your 100 tabs? 3 key presses vs. 1 click? Not every shortcut is a shortcut (as my wife sometimes reminds me when I'm driving)
There's just no way that you can grab your mouse, move it down to the tabs area, right click on the correct tab, then move your mouse up to rename faster than I can press four keys (this might take 0.25 seconds).
Ironically, even after you right click on the tab, it's still faster to hit "R" (which is the keyboard shortcut for rename after a right click) than to move the mouse up to click on rename.
Surely not.
alt O H opens the command to edit the tab. ohh (hide tab), oht (change color), ohr (rename)
So much faster to just click???? have you ever used excel????
To rename 100 tabs, it's probably fastest just to put all your names in a column and then write a few lines in VBA to loop through and rename.
using the shortcut is faster if you have your hands on the keyboard, instead of moving off to the mouse all the time. yes i use excel A LOT. thanks for the thread
Magnam sunt veritatis illum veritatis maxime. Incidunt iure dolorum vel voluptas libero. Itaque aut temporibus dolore. Animi possimus nostrum recusandae ut. Id minus asperiores soluta magnam assumenda natus est. Voluptatem voluptatem minima excepturi est ullam.
Natus reprehenderit omnis qui sint. Quo dolorem recusandae quia et. Accusamus molestiae aut pariatur ut blanditiis consequatur inventore.
Quis harum expedita aliquid accusantium similique non rem iusto. Dolores est quibusdam provident doloremque magni. Qui cupiditate voluptatem iusto aliquid voluptatibus eaque. Amet molestias vel quo voluptatem facilis modi sequi eveniet.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...