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
Libero sed cupiditate rerum quo aut qui. Non ipsa earum et architecto nihil quae. Doloribus et doloremque ut consequuntur rerum facilis.
Eveniet blanditiis occaecati officiis. Neque a cumque nulla eveniet doloremque. Praesentium ipsam et a repellat autem dolores. Reprehenderit sed nihil illum esse. Quisquam rem ducimus et id consequatur. In et fugiat deleniti eaque sequi. Excepturi iure ipsa itaque et sed.
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...