How to quickly format dataset table - Excel Tips and Tricks

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?,