- How to turn on autosave in excel upper left corner how to#
- How to turn on autosave in excel upper left corner plus#
Every monthly issue is delivered straight to your inbox and packed with easy-to-follow instructions to help you learn new techniques on the fly.
How to turn on autosave in excel upper left corner how to#
Master Excel and MS Officeįor more ideas on how to make Excel’s untapped features work for you, check out Dartnell’s Inside Microsoft Excel-PLUS. These two awesome features will help you deal with lengthy data in no time. Excel provides many date-specific options on the Auto Fill Options dropdown list, such as Fill Days, Fill Weekdays, and Fill Months. For example, to start at 0 and increase by 0.5 in each row, type the first two rows of data, select those cells, and use the selection box in the lower-right corner to invoke AutoFill.īenefits: You can also use AutoFill with other number formats such as date and time.
How to turn on autosave in excel upper left corner plus#
Type the number 1 and hit, then select that cell and hover your mouse over the black box in the lower-right corner of the cell until the cursor forms a plus sign.
But it’s a pretty robust feature that’s certainly worth a try when you’ve got a monstrous and tedious job to do.Īnother idea: When you need to create a list of data that follows a pattern, let Excel’s Auto Fill feature do the mundane work for you.Įxample: To create a list from 1 to 10, follow these steps: Remember: Flash Fill is a work in progress, and sometimes Excel can’t keep up with you. Then do the same for the list of last names. After you type a few names, select them and then drag the selection box in the lower right corner to see if Excel can figure out what you’re doing and fill in the rest of the first names.Select the Automatically Flash Fill check box and click OK.Choose Advanced from the list on the left side of the Excel Options dialog box.Click on the File tab on the main ribbon, and choose Options. First, ensure that Flash Fill is enabled.With this feature, Excel can finish what you start. Try this: Consider using Flash Fill if you have a list of first and last names (or other combined data) and you need to separate the first names and last names into different cells. Here are two automatic-fill features to ease that task. But entering that data into your document and formatting it correctly can be time-consuming and tedious. Excel is great when you’ve got large amounts of data to maintain.