Apply Password Protection to an Excel File: Overview When you apply password protection to an Excel file, you prevent people from opening it without knowing the required password. After password protection is enabled on a file, no one can open it without the password. Therefore, password-protecting files poses some risk. This is because if
Record a Macro in Excel: Overview You can easily record a macro in Excel. Macros are small programs that record your actions as you perform a task in Excel. The actions are then saved as a Visual Basic Module, which is a type of program. When you run the macro later, it repeats your
Change the Chart Type in Excel: Overview After creating a chart, you can change the chart type in Excel. Alternatively, you can also choose a different sub-type of the same general chart type you first selected. Either way, note that if you change the chart type, you may lose custom formatting you have applied
Add Excel Tables to a Data Model in Excel 2019: Overview You can manually add Excel tables to a data model in Excel 2019 or Excel for Office 365 workbooks. You can then use them as the data source for PivotTables and PivotCharts. However, note that this process changed from earlier versions of Excel.
AutoSave in Excel for Office 365: Overview AutoSave in Excel for Office 365: How to Enable AutoSave in Excel for Office 365 This tutorial shows you how to use AutoSave in Excel for Office 365. AutoSave in Excel for Office 365 is automatically enabled when you save a workbook using the newest file formats
Compare Workbooks in Excel: Overview This lesson shows you how to compare workbooks in Excel. To compare workbooks in Excel, first open the workbooks to compare to each other. To then compare them side by side, with each workbook taking an equal portion of the screen, click the “View” tab in the Ribbon. Then
Trace Error in Excel: Overview Trace Error in Excel lets you trace arrows back to cells referenced by a formula if it displays an error. The Trace Error tool is available when auditing a worksheet within a workbook. Note that the formula cell that you select must contain an error to use the Trace Error
Recover Unsaved Workbooks in Excel: Overview You can try to recover unsaved workbooks in Excel. To see if Excel has automatically saved a copy of an unsaved workbook, click the “File” tab in the Ribbon. Then click the “Open” command at the left side of the backstage view. In the area to the right