Go to the Review tab and click on the Check Accessibility command. Unnamed sheets will get flagged as an accessibility issue when you run the accessibility checker and you will then be able to rename them. Having unnamed sheets represents an accessibility issue because anyone that relies on a screen reader won’t be able to tell what is in a sheet based on those generic default sheet names. This will only work if you haven’t already renamed the sheet from the default name of Sheet1, Sheet2, Sheet3 etc… Rename a Sheet Using the Accessibility Menu You can use the keyboard to rename a sheet.Pressing O will select the Format command and then pressing R will select the Rename Sheets option from the Format command. Then pressing H will select the Home tab. Pressing the Alt key will activate the hot keys in the ribbon. Unfortunately, there isn’t a dedicated keyboard shortcut for renaming a sheet.īut we can take advantage of the Alt hot key shortcuts.Īlt H O R will get you to the Rename Sheet command in the Home tab. It’s not very intuitive that it is grouped in a button labelled Format. Unfortunately, this command is too hidden to be of any use. Make sure the sheet you want to rename is the active sheet ➜ go to the Home tab ➜ click on Format in the Cell section ➜ select Rename Sheet from the options. It’s a bit hidden, but there is a command in the Home tab for renaming a sheet. Double click to rename is a fairly common mouse shortcut across various tools.Once you learn about this mouse trick to rename your sheets, it will likely be your preferred method.ĭouble left click on the sheet tab which you would like to rename. This is the quickest and easiest way of them all. You need to discover the right click menu exists before you can use it!.This is easy to perform and only requires two mouse clicks once you know about it.The current sheet name will become highlighted and you can type your new name and press the Enter key to confirm. Right click on the sheet you would like to rename then select Rename from the options. When you right click on any of the sheet tabs in a workbook, there are a variety of options available including the ability to rename a sheet from this menu. Keep your sheet names short and you won’t have any issues! Rename a Sheet Using the Right Click Menu Usually the only rule that anyone comes up against is the maximum length of 31 characters. Sheet names can’t begin or end with an apostrophe character.įortunately, these rules aren’t extremely restrictive and most users won’t ever have any issues.Sheet names can’t contain any of these characters / \ ? * :.Sheet names can’t be longer than 31 character.Here is a list of all the rules you will need to follow when naming your sheets. There are some other conventions and characters that aren’t allowed when naming a sheet. If you try to name a sheet History, then you will get the above warning message letting you know it is a reserved name and can’t be used. There are limits to what you can name a sheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |