Format Painter In Excel

The simple idea with the format painter is to copy and paste formatting from one section to another. Let’s say you have specific formatting (Font Style and Color, Background Color to a Cell, Bold, Border, etc.) in the range B2:D7, and with format painter, you can copy that formatting to range B9: D14 with a click.

1. First of all, select the range B2:D7.
2. After that, go to the Home Tab ➜ Clipboard and then click on “Format Painter”.
3. Now, select cell C1 and it will automatically apply the formatting on B9: D14.

The format painter is fast and makes it easy to apply to format from one section to another. 

AutoFormat in Excel

 If you deal with financial data, then auto format can be one of your best tools. It simply applies the format to small as well as large data sets (especially when data is in tabular form).

1. First of all, you need to add it to the quick access toolbar (here are the steps).
2. After that, whenever you need to apply the format, just select the data where you want to apply it and click on the AUTO FORMAT button from the quick access toolbar.
3. It will show you a window to select the formatting type and after selecting that click OK.

The AUTOFORMAT is a combination of six different formattings and you have the option to disable any of them while applying it.

Undo-Redo In Excel

 Just like sort buttons you can also add undo and redo buttons to the QAT. The best part about those buttons is you can use them to undo a particular activity without pressing the shortcut key again and again.

Worksheet Copy

To create a copy of a worksheet in the same workbook drag and drop in the best way.

You just need to click and hold the mouse on the sheet’s name tab and then drag and drop it, to the left or right, where you want to create a copy. 

Bullet Points

The easiest way to insert bullet points in Excel is by using custom formatting and here are the steps for this:

1. Press Ctrl + 1 and you will get the “Format Cell” dialogue box.
2. Under the number tab, select custom.
3. In the input bar, enter the following formatting.
   1. ● General;● General;● General;● General
4. In the end, click OK.

Now, whenever you enter a value in the cell Excel will add a bullet before that.

 

Clipboard

There is a problem with normal copy-paste that you can only use a single value at a time.

But here is the kicker: When you copy a value, it goes to the clipboard and if you open the clipboard you can paste all the values which you have copied. To open a clipboard, click on the go to Home Tab ➜ Editing and then click on the down arrow.

It will open the clipboard on the left side, and you can paste values from there.

Status Bar

 The status bar is always there but we hardly use it to the full. If you right-click on it, you can see there are a lot of options you can add.

Move Data

 I’m sure you think about copy-paste but you can also use drag-drop for this.

Simply select the range where you have data and then click on the border of the selection. By holding it move to the place where you need to put it.