7 simple and practical Excel tips

This article brings you relevant knowledge about excel. 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

1. Quickly hide rows and columns

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.

2. Quick jump within the worksheet

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.

3. Quickly adjust the position of two columns

Select a column, hold down the Shift key, and drag the border to quickly adjust the position of the two columns.

4. Sorting also has regret medicine

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.

#5. One-click quick positioning formula

Are you still using Ctrl G to open the positioning window and then select the positioning conditions? In fact, one click is enough.

6. Quickly select a continuous area

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.

7. Quickly close multiple Excel workbooks

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!