If the AutoRecover option is turned on, you can automatically save versions of your file while you’re working on it. How you recover something depends on when you saved it. If you’ve saved the file. Open the file you were working on.

Tip: To change where your application automatically saves your templates, click File > Options > Save and type the folder and path you want to use in the Default personal templates location box. Any new templates you save will be stored in that folder, and when you click File > New > Personal, you'll see the templates in that folder.

Total row Once you add a total row to a table, Excel gives you an AutoSum drop-down list to select from functions such as SUM, AVERAGE, and so on.When you select one of these options, the table will automatically convert them to a SUBTOTAL function, which will ignore rows that have been hidden with a filter by default.

Whether it's for work or personal use, you can connect to a virtual private network (VPN) on your Windows PC. A VPN connection can help provide a more secure connection and access to your company's network and the internet, for example, when you’re working from a coffee shop or similar public place.

On the settings page for that app, change the setting for Let this app run in the background.Here’s a summary of each option: Always.The app is always allowed to run in the background—receive info, send notifications, and stay up to date—even when you’re not actively using it.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

You can insert the current date and time in an Excel cell as static values or as dynamic values. A static value is one that doesn’t change when the worksheet is recalculated or opened. A dynamic value is one that is updated each time formulas are recalculated.

Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.

To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.

sum_range Optional.The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied).. Sum_range should be the same size and shape as range.If it isn't, performance may suffer, and the formula will sum a range of ...