Faster than keyboard shortcuts! These 5 Excel double-click hide functions teach you to play with Excel table making.

Hello everyone, I am the witty and lovely Qiu Xiao E~

Are you still frantically scrolling to jump to the bottom of the table?

Are you still dragging frantically to select a range?

Are you still adjusting the row height and column width one by one?

……

Small E tells you, in fact, only need to double-click the mouse, can save a lot of time, but also can effectively prevent arm pain hand cramps.

You don't believe me? Then let's verify it together ~

Double-click to jump to the bottom of the selected table area of any cell, move the mouse to the bottom of the cell, double-click, you can jump to the bottom.

Put it on the right and jump to the far right.

The top and bottom operations are the same.

Double-click to select a large range of areas, hold down the [Shift] key, double-click the rightmost cell, you can select the right area.

Double-click on the bottom to select the lower area.

Isn't that fast? Whoosh! It's done!

Double-click adjust row height to select all columns, double-click column width to adjust to the appropriate column width in batches.

Select all rows, double-click row height can also be adjusted in batches.

Double-click Format Brush to brush Format infinitely Double-click Format Brush to brush Format infinitely. To stop, press Esc key or click Format Brush button again.

Double-click Pivot In a Pivot, double-click a summary item to view the specific components of the data.

This article comes from Weixin Official Accounts: Autumn Leaf Excel (ID: excel100), Author: Wise Qiu Xiao E, Editor: Zhu Lan