Common skills in office tabulation, learn to get twice the result with half the effort

Excel tabulation is often used in office work. Now let's introduce some common tips to make your form easier to use.

1. Quick uniform date format

An Excel registration form is often circulated everywhere, resulting in an inconsistent format of dates, which looks really messy, as shown in the following picture

At this point, we just need to select the date bar that needs to be uniformly formatted, click [data]-[breakdown] on the toolbar, and select [date] in step 3 and click finish.

two。 Batch date to calculate the day of the week

Sometimes we need to pinpoint the date to what day of the week, if there are a large number, it is very troublesome to look it up one by one. Of course, there are tricks in Excel.

First, let's paste the date to the column where the week needs to be converted, as shown in the figure.

Select the date after pasting, right-click [format Unit], click [number]-[date], and click on the day of the week to OK!

Look, isn't it easy?

3. Ingenious use of Ctrl+E extraction

The Ctrl+E shortcut key plays a great role in Excel, and it can help us to extract and fill Excel cells.

4. Freeze the first line of Excel content

When you look up Excel, you often don't freeze the first line of Excel, so today the editor is here to teach you how to operate.

As shown in the figure:

5. Quickly delete blank lines in batch

If there are too many blank rows in the table, it is too troublesome to delete them one by one. At this time, you only need to select the data area, click F5, and select [Positioning]-[positioning condition]-[null value] in the following figure to quickly select the blank row.

When selected, right-click [Delete]-[move the cell up below] or [whole row].

Look, is it much cleaner?