How to Edit Hyperlink in Excel (5 Quick & Easy Ways) See screenshot attached. The original question seems clear to me: "For example, 'testName' refers to 'sheet1'!A1:B2 with scope Workbook. In the Formula box, edit the formula. Once the Name Manager is open, you have several options. These answers were helpful in solving a similar issue while trying to define a named range with Workbook scope. To specify the type of permission for the user who you selected, in the Permissions box, select or clear the Allow or Deny check boxes, and then click Apply. You can also open the Name Manager using the keyboard shortcut Control + F3. The "ah-HA!" Always save your worksheet before removing named ranges in case you haveproblems and need to revert to the original. Fix: Name Manager Delete Option Greyed Out on Excel - Saint On the Home tab, click the Format Cell Font popup launcher. A correction: It's best to use a regular expression evaluate the name of the Sheet. Growing list of Excel Formula examples (and detailed descriptions) for common Excel tasks. Or you can have a glance at our other articles in the ExcelDemy.com blog! Is there a single-word adjective for "having exceptionally strong moral principles"? Sort and filter listed names defined (range) names or table names. One way, and possibly the easiest way, of defining names is using the Name Box, located above column A in the worksheet. 1. Choose the account you want to sign in with. Inserting new hyperlinks, even in unlocked cells. I can find no reason why table names cannot be edited - although in some odd way it seems that tables shouldn't need to be edited (they should expand and contract with the table itself - I see your point though - you want a new column out there on the right I presume). Once you have a named range, just use it just like a cell reference.