Mar 12 2021 12:31 PM
Did the built in table formatting get removed from Excel? i am looking where it used to be on the ribbon and I no longer have options to choose a table format. The only 2 options are New Table Style or New Pivot Table Style. Running Version 2102 build 13801.20266 click to run on Windows 10. Trying to decide if I need to reinstall or if this is by design.
Mar 12 2021 12:42 PM
@tonykaz It's on the Home ribbon. Otherwise, just press Ctrl-T.
Mar 12 2021 03:27 PM
Mar 12 2021 03:28 PM
Mar 12 2021 03:56 PM - edited Mar 12 2021 03:59 PM
@tonykaz I'm guessing this is what you want to see:
obviously I still have it. I'm still in Version 2101
Mar 13 2021 06:34 AM
It depends on what do you mean.
"Format as Table" icon was added in Excel 2007 to convert the range into the structured table. It is deprecated and in modern Excel for this purposes is the icon Table in the Insert tab of the ribbon. Same could be done by Ctrl+T in desktop version or Ctrl+L both in Excel Online and Excel Desktop.
If apply formatting / style to the table, that is "Table Design" tab which appears on ribbon if you stay on the cell within already created table.
Mar 13 2021 06:43 AM
Mar 13 2021 08:04 PM
Mar 14 2021 08:24 AM