Lock or unlock specific areas of a protected worksheet
You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of a protected sheet. Follow these steps: …
TOCOL function - Microsoft Support
Returns the array in a single column. =TOCOL (array, [ignore], [scan_by_column]) The TOCOL function syntax has the following arguments: array The array or reference to return as a …
Protection and security in Excel - Microsoft Support
Excel gives you the ability to protect your work, whether it’s to prevent someone from opening a workbook without a password, granting Read-Only access to a workbook, or even just …
Protect a workbook - Microsoft Support
To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets, you can protect the structure of your Excel workbook …
Accessibility best practices with Excel spreadsheets
This topic gives you step-by-step instructions and best practices for making your Excel spreadsheets accessible and unlock your content to everyone, including people with …
Use the Field List to arrange fields in a PivotTable - Microsoft …
You can change the design of the PivotTable by adding and arranging its fields. If you want to sort or filter the columns of data shown in the PivotTable, see Sort data in a PivotTable and Filter …
Guidelines and examples of array formulas - Microsoft Support
Beginning with the September 2018 update for Microsoft 365, any formula that can return multiple results will automatically spill them either down, or across into neighboring cells. This change …
Load the Analysis ToolPak in Excel - Microsoft Support
If you need to develop complex statistical or engineering analyses, you can save steps and time by using the Analysis ToolPak. You provide the data and parameters for each analysis, and …
Manage workbook links - Microsoft Support
Here's how to ensure that you are retrieving the latest values from your source workbooks. Sometimes, you need to change the source workbook, a workbook link breaks, or you may no …
Add a data series to your chart - Microsoft Support
After creating a chart, you might need to add an additional data series to the chart. A data series is a row or column of numbers that are entered in a worksheet and plotted in your chart, such …
Video: Import a chart - Microsoft Support
Import an Excel chart into another app. Open the Excel workbook that contains the chart. Select the chart, and then select Home > Copy. Open an Office document, and select the place …