Teach you simple techniques to quickly complete Excel operations

1. Quick Insert blank line

If you want to insert consecutive blank rows on a worksheet, drag the mouse down to select the number of rows you want to insert on it, right-click, and select Insert from the shortcut menu to insert a blank line above the line.

If you want to insert a blank row above some rows, you can hold down the CTRL key, select the row labels on which you want to insert blank rows, select the entire row, and then right-click, and choose Insert from the shortcut menu.

2. Fast interchange of data in two columns

In Excel, there is a simple way to quickly swap the contents of two columns of data. When the data in column A is selected, move the mouse over the right edge of column A and the cursor changes to a cross arrow.

Hold down the SHIFT key while holding down the left mouse button and drag the mouse to the right, and a dotted line appears when you drag to the right edge of column B, and the "C:c" prompt appears (as shown in Figure 1).

Figure 1

Then loosen the SHIFT key and the left mouse button to complete the exchange of a and B data.

3. Quickly enter fractions in a cell

If you want to enter 2/3 in Excel, just enter "2/3" in the cell, and when you press ENTER, the contents of the cell change to "February 3," as shown in Figure 2, how do you enter a fraction in a cell?

Figure 2

Original address: http://soft.zol.com.cn/45/454728.html

There are two ways to choose: One is to enter a 0 in a cell, then enter a space, then enter "2/3" and then press ENTER.

Alternatively, enter a single quotation mark in English half-width before entering the score, and then enter "2/3" so that you can enter the score 2/3 correctly after you press ENTER. (as shown in Figure 3).

Figure 3

4. Fast input Date

Read the 3rd tip above, in the input date, if you want to enter "February 3", also do not have a word to enter a word, as long as in the cell input "2/3", click the Enter key on it.

When you change to February 3, double click on the cell and it will also appear as a "2006-2-3" format, but after the mouse leaves, it reverts to the "February 3" style.

If you want to enter the current date, press CTRL +; Key combinations can be quickly entered.

        Note : more Wonderful tutorials please focus on the Triple computer Tutorials section, triple Computer office group: 189034526 Welcome to join