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

Excel simple double click, unexpectedly can complete so many showy operations! Today, Xiao Wang teacher will introduce to everyone, Excel double-click the great power, see you know a few!

01. Hide or show the functional area Move the cursor to any block of the functional area such as "Start" or "Insert". Double-click to hide the functional area. Double-click again to show the functional area.

02. Move the selected cell quickly To select the rightmost cell, we can move the cursor to the right of the current cell and double-click. At this time, we can quickly jump to the rightmost cell, and so on!

When we want to copy the format in a cell to other cells, we just need to double-click the "format brush" and then click on other cells to get the same format as the cell.

04, fast fill There are many friends are input 1, 2, directly drag down to achieve the filling effect. If the data is too long to drag up is also very laborious, it is better to double-click directly to the pleasure, once to give you the whole end!

05, automatic filling formula formula is the same, when you manually enter a string of formulas, we can also directly double-click, the same can achieve the effect of fast filling formula.

06, adaptive row height, column width often open Excel tables, found that the rows or columns inside are crowded, some data have become #. It doesn't matter. Double-click. Move the cursor to the top of the cell, double click when it becomes a black double arrow, Excel will adjust to the optimal width, and the same is true for height.

This article comes from Weixin Official Accounts: Word Alliance (ID: Wordlm123), author: Wang Qi

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.