Before diving into the New Sheet shortcut in Excel for Mac we must make sure our keyboard settings are set to disable the default functions of the Function keys. This allows us to use the Function keys as shortcuts, and not as volume or brightness control that Mac defaults to.
One of our first blog posts shows how to change your settings to work with the Excel Skin: Using your Excel Skin
Now that we have changed the settings we can execute this easy, one modifier key shortcut.
While in any worksheet in Microsoft Excel, click Shift + F11
A new worksheet will appear as a tab in the bottom left of the Excel window.
And it’s that easy! Having multiple sheets in the same workbook can help keep your data clean and easy to read, as well as all in the one attachment. I always suggest transferring all data that is being used into the same workbook for easy access.
To help cycle through worksheets easier see this post: Cycling Sheets
Comments will be approved before showing up.