Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

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

2025-03-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > IT Information >

Share

Shulou(Shulou.com)11/24 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

IT Information

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report