Personally, I find using the keyboard shortcut to be the best way to insert a new worksheet in Excel. If you are a fan of keyboard shortcuts, this is probably the fastest way to insert a new worksheet in an already open workbook in excel.īelow is the keyboard shortcut to insert a new worksheet SHIFT + F11įor this shortcut, hold the SHIFT key and then press the F11 key.Īnother keyboard shortcut that does the same job is ALT + SHIFT + F1 (hold the ALT and the SHIFT keys and press the F1 key)
Keyboard Shortcut to Insert a New Worksheet Changing the Default Number of Sheets with New Excel Workbooks.
Insert New Sheet Using the Insert Dialog Box.Keyboard Shortcut to Insert a New Worksheet.And on further investigation nor does PowerPoint 2010, Visio 2010, or Outlook 2010 (I didn’t check all the Office programs). Microsoft Excel 2010 (and likely earlier versions), does NOT have any option available to view existing key combinations or to create your own. I was alerted to this lack because of a comment on one of my blog posts - Ctrl+Shift+C activates the Format Painter in Word, but doesn’t do so in Excel, even though Excel also has the Format Painter function. Or you can modify those that are already assigned in Word (though I wouldn’t advise it, because if you have to reinstall Word or you use someone else’s machine your keyboard shortcuts won’t work the same as the ones you’ve set up for your installation of Word).Īssigning keyboard shortcuts has been a feature in Word for years, and I just assumed that the other Office products would have similar functionality. One of the things I like about Word is that you can specify your own keyboard shortcuts for your macros and for functions that don’t already have a key combination.
0 kommentar(er)
