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

The title of the original text: "the 3 moments that most want to burst Excel!" Did you get shot? "

Hello, everyone! I am a lovely book that is frantically waiting for manuscript.

Today, I would like to ask you, what are the following questions you have encountered when using Excel?

If you have encountered it, but do not know how to solve it, you might as well move on.

I forgot to save the hard-working data for several hours when I made the form, but the hand slip point became [do not save] when it was closed!

I believe that your mood at this time must be.

To avoid this, we can actually set the time for Excel to save automatically.

👉 procedure:

❶, click the "Files" tab-- Click "options"-- Select "Save"-- change the interval between saving automatic recovery information to 1 minute.

In this way, the Excel form is automatically saved every 1 minute, and the save path is in the "automatic recovery file location" below.

❷ if Excel is closed and unsaved: paste the file recovery address into my computer's search bar, and you can find the form you made a minute ago.

Tip: although this method can restore Excel to the maximum extent, it is still recommended that everyone form the habit of saving in real time.

When you can't find an object to use Excel, you will also encounter the problem of not finding an object, like this.

There are usually two reasons.

There are no objects in the ❶ table itself, that is, there are no corresponding pictures or graphics in the table, so it cannot be located.

The ❷ object is hidden, so it cannot be located.

👉 solution:

Click the [File] tab-- [options]-- Select [Advanced]-- display options for this workbook-- for objects, display all.

In this way, the hidden objects are displayed and then conditionally positioned.

Manual summation Excel students must often need to sum the data, I would like to ask the students, if you get a copy of such data:

What method will you use to make the sum?

Calculate manually with a calculator?

Hee hee, you are awesome!

In fact, as long as you use the shortcut key [Alt+=], you can sum with one button!

👉 procedure:

Select the data-- [Alt+=] summation.

Well, does this shortcut make you feel like summing So easy?

To sum up, we talked about three practical tips for Excel today:

❶ forget to save the form: you can set the save time and search for files at the recovery address when you accidentally close it.

❷ cannot find objects: no objects or objects are hidden in the table, just set to show all objects

Manual calculation of ❸ data summation: the shortcut key [Alt+=] can be summed quickly.

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: witty Qiu Xiao E

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.