4 Excel Tips for using the highest frequency

4 Excel Tips for using the highest frequency

1. Insert any number of empty lines

When you select the row and place the cursor in the lower-right corner, when you press SHIFT, you will notice that the cursor becomes the shape shown in the following figure.

Then you can drag

You'll notice how many rows you drag, and how many blank lines you'll insert. This insertion method is more flexible than selecting a certain number of rows and then inserting them.

2. Two-column interchange

In the following table, select column C, the cursor at the edge, press SHIFT while pressing the left mouse button is not loose, drag to column B, when a dashed line in front of column B, release the left mouse button to complete the swap.

Put it on the sideline

Press left button to drag until column B

Complete

3, Batch set sum formula

Select the area that includes the yellow row, and press ALT and = (press ALT key and then equal sign) to complete the sum formula input.

4. Two worksheets to view an Excel file at the same time

View-New Window

Set up a rearrange window

Arrangement Way

Post-rearrangement effect