A Table name in Excel 2010 (Windows) is distinctly visible on the Table Tools tab. Here you can easily change the Table’s defined name.
![Excel Excel](/uploads/1/2/5/5/125541330/751742509.gif)
11 Excel tips for power users. (Slicers are available for pivot tables but not regular tables in Excel for Mac 2016.). While VLOOKUP is a popular way to find data in one Excel table.
Excel 2011 (Mac) doesn’t easily reveal the Table name even though there’s a standard Table tab on the Ribbon. You have to make sure the Table is active, then choose Table Rename, which will select the entire table and highlight the table name in the Name box. (You don’t have to actually rename the table.) In Excel 2010 you can also see the Table name by choosing Formulas Name Manager. In Excel 2011 you choose Insert Name Define to see the Table name. Knowing a Table’s name is important in Excel. It’s the first step in understanding structured Table data. Post author @Tom, I haven’t heard of Excel 2011 not letting you rename the tables.
I just created on from some data, selected the Name box drop-down and clicked on Table3 to select it, then typed in MyTable and hit enter. The name was changed and Excel didn’t even squawk. I also went to Excel Preferences and selected Tables to check the settings. Nothing amiss there. The first box will allow table names in formulas, but that’s the only thing remotely close to what your having problems with. Just wondering if you can select a Table by using the Name Box?. Clive In Excel 2010 (Windows) you can’t rename or delete a table using the Names Manager.
The only way I’ve found so far is to pick any cell or select the existing table name (eg Table1, Table2, Table3, etc.) and convert the table back to a rangethen the existing table name (Table3, etc) disappears. Then I can create a new table.
Trying to rename the table name in the name box seems to create a new name but leaves the old one behind. Excel 2010 (Win) has a “Names Manager” that doesn’t seem to work for doing this. Post author If you need a formula next to a table and don’t want the “Tables” version in the formula, manually type in the cell reference instead of clicking the cell. For instance, assume a table has the range A1:B5 and you want to type a formula in cell C2 that adds the first data row of the table, you would type =A2+B2 and hit enter. The formula would not change. If, however, you clicked the cell A2 with the mouse, a table reference would appear and spoil your whole day.
П™‚ As far as having the table names grayed out, I’m not sure what that is all about.
When I change data in my combo chart, the chart's formatting reverts to the default, despite have a template applied. It seems you can't save or apply a combo chart template properly. Claims there's some setting somewhere that's doing this: Windows OptionsAdvanced ChartProperties follow chart data point for current workbook. Need Mac equivalent; could not find via search in Help or other. No one in that chain posted the Mac equivalent, so I'm posting here for more exposure. If anyone knows a way to stop Excel from reverting the formatting, that'd be great.
It's extremely frustrating.