Do you want BuboFlash to help you learning these things? Or do you want to add or correct something? Click here to log in or create user.



Important notes for names
  • Use valid characters Always begin a name with a letter, an underscore character (_), or a backslash (\). Use letters, numbers, periods, and underscore characters for the rest of the name.

    Exceptions: You can’t use "C", "c", "R", or "r" for the name, because they’re already designated as a shortcut for selecting the column or row for the active cell when you enter them in the Name or Go To box.

  • Don’t use cell references — Names can’t be the same as a cell reference, such as Z$100 or R1C1.

  • Don’t use a space to separate words — Spaces cannot be used in the name. Consider how you can write the name using no spaces. Or, use an underscore character (_) or a period (.) as word separators. Examples: DeptSales, Sales_Tax or First.Quarter.

  • Maximum 255 characters — A table name can have up to 255 characters.

  • Use unique table names — Duplicate names aren’t allowed. Excel doesn’t distinguish between upper and lowercase characters in names, so if you enter “Sales” but already have another name called “SALES" in the same workbook, you’ll be prompted to choose a unique name.

If you want to change selection, open document below and click on "Move attachment"

Rename an Excel table - Microsoft Support
e shown in the Address bar, which appears to the left of the Formula bar. When you select any table from the list, Excel will automatically jump to that table—even if it's on another worksheet. <span>Important notes for names Use valid characters — Always begin a name with a letter, an underscore character (_), or a backslash (\). Use letters, numbers, periods, and underscore characters for the rest of the name. Exceptions: You can’t use "C", "c", "R", or "r" for the name, because they’re already designated as a shortcut for selecting the column or row for the active cell when you enter them in the Name or Go To box. Don’t use cell references — Names can’t be the same as a cell reference, such as Z$100 or R1C1. Don’t use a space to separate words — Spaces cannot be used in the name. Consider how you can write the name using no spaces. Or, use an underscore character (_) or a period (.) as word separators. Examples: DeptSales, Sales_Tax or First.Quarter. Maximum 255 characters — A table name can have up to 255 characters. Use unique table names — Duplicate names aren’t allowed. Excel doesn’t distinguish between upper and lowercase characters in names, so if you enter “Sales” but already have another name called “SALES" in the same workbook, you’ll be prompted to choose a unique name. Rename a table in Excel for the web Note: This is one of several beta features, and currently only available to a portion of Office Insiders at this time. We'll continue to optimize the


Summary

statusnot read reprioritisations
last reprioritisation on suggested re-reading day
started reading on finished reading on

Details



Discussion

Do you want to join discussion? Click here to log in or create user.