Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

Powerful Double-click In Microsoft Excel

Date:2021-2-22 Author:Sandra

In our daily work on Excel, you definitely use the mouse while operating the keyboard. Actually, some operations can be easily done with the mouse directly. So let’s get started to know the powerful double-click in Excel.

Quickly Move The Selected Cell

If you want to move your cursor to any top position quickly, we take the right direction as an example. We can move the cursor to the right side of the current cell and double-click, at this time, we can quickly jump to the rightmost cell. Same in other directions.

Powerful Double-click In Microsoft Excel

Automatically Adapt to Width And Height

After frequently opening an Excel table, you may find that the rows or columns in it are crowded, and some data has become # signs. It doesn’t matter, double-click. Move the cursor to the top of the cell and double-click when it turns into a black two-way arrow. At this time, Excel will adjust to the best width. Similarly, the height is set in the same way.

Powerful Double-click In Microsoft Excel

Quickly Format Painter

When we want to copy the format in a cell to other cells, we only need to select the cell, double-click the “Format Painter”, and then click other cells to quickly copy the format.

Powerful Double-click In Microsoft Excel

Quickly Fill

There are many friends who first enter 1, 2 and drop down your mouse to achieve the filling effect. If the data is too long, this way is also very troublesome. So you can also quickly achieve the filling by double-click.

Powerful Double-click In Microsoft Excel

Auto Fill Formula

When you enter a line of formula, you can also achieve the filling effect quickly by double-click.

Powerful Double-click In Microsoft Excel

Automatically Show or Hide The Ribbon

Place your cursor at any position of ribbon, like Home, Insert, Page Layout and so on, then double-click on it.

Powerful Double-click In Microsoft Excel

Hope these six double-click tips in Excel would be helpful to you.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *