Shulou(Shulou.com)11/24 Report--

Perhaps the most disturbing thing in the office is that the forms handed in are typed back and done over and over again.

There is no additional unit here, and there is no content in the space there!

Such a small problem, for those who do not know Excel, may need to work overtime for 2 hours to complete.

For those who know a little Excel, it can be done in a minute!

Let's see how Xiao E will teach you how to solve such problems quickly.

After completing the form in the first move, I found that I didn't add "¥" to indicate the amount?

Do you want to re-enter one by one!

No need.

It can be solved with a shortcut key!

First select the data column that needs to be added units, and then press [Ctrl+Shift+4], all the data has a "¥" symbol!

The second trick is the same, forget to add the "yuan" unit, it is impossible for Chinese to have shortcut keys, right?

There are no keyboard shortcuts, but there is also "format cells"!

❶ selects the data column that needs to add units, and press [Ctrl+1] to call up "format cells"

❷ find [Custom], type "Yuan" directly after "G / Common format", and click "OK".

This will add a good unit "yuan" for all the data!

The third step is that the problem of forgetting to add a unit has been solved, then if.

The whole form forgot to write "absenteeism" for employees who were late?

A blank cell always needs to be entered manually.

In fact, you don't have to.

Here only need to combine the use of two keyboard shortcuts, you can fill in all the unfilled cells with one button!

❶ locates the space.

Select all the forms first, press [Ctrl+G] to locate, and click "location conditions" in the lower left corner.

Select Null value in the pop-up window, and then press OK to find all the spaces in the table.

❷ fill in the content.

When a null value is found, keep the mouse still and enter "absence"

Press another shortcut key [Ctrl+Enter] to fill in the batch, and all the blanks will be filled in with "absence"!

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: dried Fish Editor: Zhu Lan

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.