What are Tables?
Tables are a fantastic Excel feature that was first introduced in Excel 2007. They allow you to define parts of an Excel workbook as a ‘Table’, which enables many useful features, including allowing formulas to be automatically filled down when data is added and automatic formatting of the Table’s contents.
You can learn everything you need to know about Tables in our Expert Skills Books and E-books, but this article focuses on accessing the Table Tools > Design tab on the Ribbon. This tab is needed to work with Tables, but some users have difficulty finding it.
What is the Table Tools > Design tab for?
The Table Tools > Design tab allows to to change many different settings that apply to Tables, including the Table’s name and style.
You can also convert a Table back into an ordinary Range using this tab and quickly create Pivot Tables and Slicers.
All of the features shown on this tab are explained in our Expert Skills Books and E-books.
Accesing Table Tools > Design
The Table Tools > Design tab should appear whenever you click inside a cell that is part of a Table.
This will not happen with an ordinary Excel Range, it will only happen if the cells have been specifically converted into a Table.
If you think the cells have been defined as a Table and still can’t see the Table Tools > Design tab, it’s most likely that someone has disabled it by customizing the Ribbon.
Resetting the Ribbon
If you think someone has hidden the Table Tools > Design Ribbon tab you can bring it back by resetting the Ribbon.
To reset the Ribbon, right-click anywhere on it and click Customize the Ribbon from the shortcut menu.
The Excel Options dialog appears with the Customize Ribbon tab selected.
The simplest way to reset the Ribbon is to click the Reset button at the bottom of the dialog and click Reset all customizations from the drop-down menu.
After resetting the Ribbon the Table Tools > Design tab should be re-enabled.
If you want to do this without resetting all of your Ribbon customizations you can choose Tool Tabs from the Customize the Ribbon drop-down menu at the top of the dialog and can then confirm whether Table Tools > Design is enabled.
Excel can be very difficult to use if someone has used Ribbon customization to make it very different to the default. Ribbon customization is also covered in depth in our Expert Skills Books and E-books.
The screenshots in our books and e-books always use the default Ribbon settings without any customizations.
These are the only up-to-date Excel books currently published and includes the new Dynamic Arrays features.
They are also the only books that will teach you absolutely every Excel skill including Power Pivot, OLAP and DAX.