Discover how to quickly format the reset table in Excel. Also, how do I change the format of a data table in excel? Sometimes we also like to ask how do I organize large data set in Excel or how do I auto format rows and columns in Excel? In this video, I will also show the shortcut for all the format in Excel.
These are the steps covered in the video.
AutoFormat Using Hotkey
1) Place cursor in the table
2) Alt+O+A
Add AutoFormat To Quick Access Toolbar
1) File ~ Options
2) Quick Access Toolbar
3) All Commands
down 7times
4) AutoFormat
5) Add >>
6) OK
How do I change the format of a data table in Excel?,How do I organize large data sets in Excel?,How do I auto format rows and columns in Excel?,What is the shortcut for auto format in Excel?,