Forum Discussion
Solved
How do I delete the name of a range which is grayed out?
I downloaded a workbook for depreciation and want to simplify some of the formulas. Some of the formulas refer to several named ranges and I would like them to just refer to a cell or several cells....
Data48 is a table.
Press F5 or Ctrl+G to activate the Go To dialog.
Select Data48, or type this name into the box, then click OK.
The table should now be selected.
If you want to get rid of the name (without removing the data), click Convert to Range in the tools group of the Design tab of the ribbon (under Table Tools), and confirm.
Data48 is a table.
Press F5 or Ctrl+G to activate the Go To dialog.
Select Data48, or type this name into the box, then click OK.
The table should now be selected.
If you want to get rid of the name (without removing the data), click Convert to Range in the tools group of the Design tab of the ribbon (under Table Tools), and confirm.
Worked perfectly! Thank you!!