(Excel Tip-1) Format Painter
Before I started to use format painter for applying cell formatting, I was using paste special with the shortcut key.
- Select the cell or a range from where you want to copy cell formatting.
- Go to ➜ the Home Tab ➜ Clipboard.
- Make double-click on the “Format Painter” button.
- As soon as you do this, your cursor will convert into a paintbrush.
- You can apply that formatting anywhere in your worksheet, in another worksheet, or, even in another workbook.
(Excel Tip-2) Rename a Worksheet
I always found it quicker than using a shortcut key to change the name of a worksheet. All you have to do is just double-click on the sheet tab and enter a new name.
Let me tell you why this method is faster than using a shortcut. Suppose if want to rename more than one worksheet using a shortcut key.
Before you change the name of a worksheet, you need to activate it. But if you use the mouse it will automatically activate that worksheet and edit the name with only two clicks.
(Excel Tip-3) Fill Handle
I am sure shortcut addicts always use a shortcut key to drag formulas and values in downward cells. But using a fill handle is more impressive than using a shortcut key.
- Select the cell in which you have a formula or a value that you want to drag.
- Make a double click on the small square box at the right bottom of the cell selection border.
This method only works if you have values in the corresponding column and it works only in the vertical direction.
(Excel Tip-4) Hide Ribbon
If you want to work in a distraction-free mode, you can do this by collapsing your Excel ribbon.
Just make double-click on the active tab in your ribbon and it will collapse the ribbon. And if you want to expand it back just double-click on it again.
(Excel Tip-5) Edit a Shape
You often use shapes in our worksheets to present some messages and you have to insert some text into those shapes. Besides the typical method, you can use a double click to edit a shape and insert the text into it.
You can also use this method to edit and enter text in a text box or into a chart title.
(Excel Tip-6) Column Width
Whenever you have to adjust the column width you can double-click on the right edge of the column header. It auto-sets the column width according to the column data.
The same method can be used to auto-adjust row width.
(Excel Tip-7) Go to the Last Cell
This trick can be useful if you are working with a large dataset. By using a double click, you can go to the last cell in the range which has data.
You have to click on the right edge of the active cell to go to the right side and on the left edge if you want to go to the left side.
(Excel Tip-8) Chart Formatting
If you use Control + 1 to open formatting options to format a chart, then I bet you’ll love this trick. All you have to do is just make double-click on the border of the graph to open the formatting option.
(Excel Tip-9) Pivot Table Double Click
Let’s say someone sent you a pivot table without the source data. As you already know Excel stores data in a pivot cache before creating a pivot table.
You can extract data from a pivot table by double-clicking on data values. As soon as you do this Excel will insert a new worksheet with the data which has been used in the pivot table.
(Excel Tip-10) Drag Drop Menu
There is a right-click drop-down menu in Excel that few users know about. To use this menu all you need to do is select a cell or a range of the cell and then right-click and while holding it, drop the selection to somewhere else.
