Excel Keyboard to Insert Sheet & Rename Sheet. Excel Magic Trick 1565. (Sheet Tab or Worksheet)

This video shows how to insert an Excel Sheet (also known as Sheet Tab or Worksheet) with the Excel Keyboard: Shift + F11. Also see keyboard to Rename a Sheet: Alt, H, O, R.

[Not_Likely_]

Renaming tabs using only the keyboard is one of my favorites. I don't know why, but it is! Thanks for posting!

[katerina]

This is awesome Mike, full package, insert and rename
🤗

[wayneedmondson]

Hi Mike.. thanks for the SHIFT+F11 keyboard to add a new sheet. I discovered that SHIFT+ALT+F1 does the same. So.. another option. Thanks again for all the EXCEL awesomeness at EIF. Thumbs up!

[SyedMuzammilMahasanShahi]

Good to know the shortkeys. Thanks for the share.

[johnborg]

Thanks Mike. Alt+O+H+R works just the same. Alt+H+O+R, same thing....always learning. :) :)

[sachinrv]

Sharing plenty Mike : 1 ALT+D+P (PIVOT TABLE), 2 ALT+O+H+R (RENAMING THE SHEET), 3 ALT+E+L (DELETING THE SHEET), 4 ALT+E+M (MOVING THE SHEET UP OR DOWN THE LINE), 5 ALT+H (ACTIVATING THE RIBBON ABOVE FORMULA BAR, 6 CTRL+5 (TO STRIKE OUT), 7 ALT + : (FOR SELECTING HIGHLIGHTED RANGE OF CELLS), 8 ALT+I+F (OPENING FORMULA DILOGUE BOX), 9 CTRL+A (FOR OPENIING SPECIFIC FORMULA DILOGUE BOX AFTER THE FUNCTION NAME IS TYPED, 10 CTRL+SPACE BAR (SELECTING ENTIRE COLUMN), 11 SHFT+SPACE BAR(SELECTING ENTIRE ROW).. 12 CTRL+F3 (MANAGING NAMES), I keep this handy in note pad.. practice makes the man or woman perfect..

[naveedulhaq]

Thanks Mike.

A related shortcut Suggestion:
To Color Sheet Tab = Alt, H, O, T & select color

[brianxyz]

I'd like to see Microsoft change the Insert Sheet behavior by having new sheets inserted to the right of the current sheet. This seems much more practical to me. In the video when you were adding new month sheets it would be easier to work with if the sheets appeared in the correct order, i.e., Jan, Feb, etc.

On a somewhat related note, I'd love for Microsoft to add the ability to sort sheets alphabetically and by date created when you right click on the sheet selector area in the lower left-hand of the app. Maybe even add in predefined sort orders as determined by the user.

[GeertDelmulle]

Nice Excel Quickie! :-)
Maybe you can do one on “F4” — I rediscovered that one some time ago...
Real time saver on repeated tasks.

[GooogleGoglee]

I have a question for you, I use WPS software which is really similar to Excel, almost equal.
I have a problem selecting an entire 'word' inside a cell using the keyboard.
Example: CTRL + SHIFT + Left
this should select the last word, but this doesn't happen and it select the whole cell. Is there any other combination of key or something I am missing on the software preferences/options?
Any idea?
Thanks

[JonathanExcels]

Do you distinguish between keyboard shortcuts and menu acceleration? I teach they are different but maybe I am wrong.