To change the name of some other sheet, you first need to activate it and then use the above steps. Rename Sheets Using the Format Option in the Ribbon You can also access the option to rename sheets through the Excel ribbon: Click the Home tab In the Cell group, click on the Format option Click on the Rename Sheet option.
#Mac microsoft excel keyboard shortcuts pro#
Pro Tip: In case you want to move to the next sheet, you can use the keyboard shortcut Control PageUpPageDown (hold the Control key and then press the PageUP key to move to the next sheet or PageDown key to move to the previous sheet.
While this is not one of the easy keyboard shortcuts, once you get used to it, you may find it a better way to rename sheets in Excel. Once you have the cursor where you want to add the text, enter in manually.ĪLT O H R You need to press these keys one after the other in a succession. This will put the sheet name in the edit mode Enter the name of the sheet that you want Hit the Enter key (or click anywhere in the worksheet) If you want to rename multiple sheets, you need to do these above steps for all the sheets.Īlso, if you want to add a prefixsuffix to the sheet name, you the arrow keys to move the cursor when youre in the edit mode in the tab. So lets get started This Tutorial Covers: Rename Sheets with a Simple Double Click Rename Sheets with a Keyboard Shortcut Rename Sheets Using the Format Option in the Ribbon Rename Sheets Using VBA Add PrefixSuffix to All Sheet Names in One Go Sheet Naming Rules in Excel Rename Sheets with a Simple Double Click Using a mouse is the easiest way to change the name of a sheet in Excel.īelow are the steps to rename a sheet using the mouse double-click: Place your cursor over the sheet tab that you want to rename Double-click on it.
In this Excel tutorial, I will show you some simple ways to rename a sheet in Excel (including a keyboard shortcut).Īnd in case you want to rename all the sheets as one go (such as adding a prefix or suffix to all the sheets), check out the section on using VBA to do this (its not complicated).
#Mac microsoft excel keyboard shortcuts code#