How to quickly format dataset table - Excel Tips and Tricks - video Dailymotion

RabiGurungXybernetics

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

Transcript

00:00This is how you can quickly format your table in Excel.

00:03You put your cursor anywhere on your dataset table here and you press ALT and then it will

00:09give you this auto format pop-up window here.

00:12You can select any format you want, you can actually scroll down and see different types

00:16that you have.

00:17I'm going to go ahead and select say this one here and click OK and it will automatically

00:21format your table for you in a very nice fashion.

00:24And as you can see, by default the auto format is not accessible in any of your ribbon or

00:30your quick access toolbar.

00:31However, if you like to add auto format in your quick access toolbar, this is how you

00:36do it.

00:37First you go to file and then you go options and then in here, the Excel options, you click

00:43on quick access toolbar.

00:45If you want to add the auto format on your ribbon, you just click on this and follow the same

00:51steps here.

00:52You're going to go ahead and do a pull down here.

00:54On the pull down you say all commands and then you're going to scroll down a few times

01:00and look for auto format this one here.

01:03Once you find it, click on add and it should appear right here and click OK.

01:09Now you can see an icon appears on your quick access toolbar here.

01:13Now if you click on it, the auto format pop-up is accessible via your quick access toolbar.

01:18Going where you are, click on that slide in here.

01:20Coming in here now.

01:22Coming here.

01:23I have checked.

01:25I see.

01:25Anytime now.

01:26Welcome.

01:27Exactly last time.

01:27Here.

01:28See what happens.

01:28Speaking in here.

01:29Friends.

01:29Well I don't know about that because the e-lo universe gets changed.

01:30No one can see that in my opinion.

01:31How much is there.

01:32Okay?

01:33Can I come into my opinion.

01:33So let me tell you what I mean.

How to quickly format dataset table - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended