This article brings you relevant knowledge aboutexcel. It mainly introduces some tips that novices must know, including quickly hiding rows and columns, quick jumps in the worksheet, and quick adjustments. Two column positions and so on, I hope it will be helpful to everyone.
Related learning recommendations:excel tutorial
Select the columns that need to be hidden at the same time mark, press the left mouse button and drag quickly to the left to hide the selected column.
Select multiple column labels containing hidden columns at the same time and double-click the mouse to unhide the columns.
There is too much data in the table and it is inconvenient to view. Double-click the cell border to quickly jump to the bottom or top.
Select a column, hold down the Shift key, and drag the border to quickly adjust the position of the two columns.
Before sorting the table, enter consecutive serial numbers in the blank column.
After sorting operation, sort the serial number column in ascending order to quickly return to the previous state.
Are you still using Ctrl G to open the positioning window and then select the positioning conditions? In fact, one click is enough.
Select part of the area first, then hold down the Shift key and double-click the cell border to quickly select the current area. area before or after.
Hold down the Shift key and click the close button in the upper left corner to close all open ones workbook.
These Excel skills may seem simple, but if applied skillfully, they can also improve work efficiency.
Related learning recommendations:excel tutorial
The above is the detailed content of 7 simple and practical Excel tips. For more information, please follow other related articles on the PHP Chinese website!