Excel Table Name Greyed Out. as i understand, in excel 2010 (windows), you cannot delete a table using the names manager. the name manager in my excel workbook seems to be disabled. Highlight the table name and enter a new name. go to table tools > design > properties > table name. this means you can have a named range called myrange with a scope of workbook and another named range. To remove the table, select it again, and in the table design tab, select convert to range. On a mac, go to the table tab > table name. if the names are like table1, table2 etc., then these are names that get created when you convert a rabge to a. I can only change table names, cannot edit. you can tell because when you select a1, you see the table design tab show up in the ribbon. 3 reasons with solutions to name manager delete option greyed out in excel. Your only option here is to pick any cell or select the existing.
from answers.microsoft.com
as i understand, in excel 2010 (windows), you cannot delete a table using the names manager. Highlight the table name and enter a new name. if the names are like table1, table2 etc., then these are names that get created when you convert a rabge to a. Your only option here is to pick any cell or select the existing. go to table tools > design > properties > table name. To remove the table, select it again, and in the table design tab, select convert to range. I can only change table names, cannot edit. you can tell because when you select a1, you see the table design tab show up in the ribbon. 3 reasons with solutions to name manager delete option greyed out in excel. this means you can have a named range called myrange with a scope of workbook and another named range.
Excel greyed out ribbon commands Microsoft Community
Excel Table Name Greyed Out as i understand, in excel 2010 (windows), you cannot delete a table using the names manager. go to table tools > design > properties > table name. Your only option here is to pick any cell or select the existing. the name manager in my excel workbook seems to be disabled. I can only change table names, cannot edit. 3 reasons with solutions to name manager delete option greyed out in excel. To remove the table, select it again, and in the table design tab, select convert to range. you can tell because when you select a1, you see the table design tab show up in the ribbon. as i understand, in excel 2010 (windows), you cannot delete a table using the names manager. On a mac, go to the table tab > table name. Highlight the table name and enter a new name. if the names are like table1, table2 etc., then these are names that get created when you convert a rabge to a. this means you can have a named range called myrange with a scope of workbook and another named range.
