Forum Discussion
tonykaz
Mar 12, 2021Copper Contributor
Table Formatting
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 Ta...
SergeiBaklan
Mar 12, 2021Diamond Contributor
- tonykazMar 12, 2021Copper ContributorI have no idea what you are showing me. That has nothing to do with built in table formatting.
- SergeiBaklanMar 13, 2021Diamond Contributor
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.
- mtarlerMar 12, 2021Silver Contributor
tonykaz I'm guessing this is what you want to see:
obviously I still have it. I'm still in Version 2101
- tonykazMar 14, 2021Copper ContributorI did a repair Office 365 from control panel and now my menu is back. The one you posted is what I was missing. It had disappeared completely. Now it works as normal. Thank you for letting me know it hasn't been deprecated or something. May I ask how you took the screen shot? I can't seem to get the snipper to launch in order to capture a menu like that.