Protect a worksheet - Microsoft Support
Worksheet protection is a two-step process: the first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password. In your Excel file, select the worksheet tab that you want to protect. Tip: You can select multiple, non-contiguous cells by pressing Ctrl+Left-Click.
Insert a chart from an Excel spreadsheet into Word
The simplest way to insert a chart from an Excel spreadsheet into your Word document is to use the copy and paste commands. You can change the chart, update it, and redesign it without ever leaving Word. If you change the data in Excel, you can automatically refresh the chart in Word.
Turn automatic completion of cell entries on or off
Microsoft Office Excel completes text entries that you start to type in a column of data — if the first few letters that you type match an existing entry in that column. If you want to stop automatic completion, you can turn this option off.
Display or hide zero values - Microsoft Support
Hide or display zero values in Excel worksheets by using an option in the Advanced tab, or by using a number format, using a conditional format, a function, and by hiding zeros in PivotTable reports.
Paste options - Microsoft Support
Keyboard Shortcut: Press Ctrl+Alt+V. In the Paste Special box, pick the attribute you want to paste. Note: Depending on the type of data you copied and the Paste option you picked, some other options might be grayed out.
Move or copy cells, rows, and columns - Microsoft Support
If some cells, rows, or columns on the worksheet are not displayed, you have the option of copying all cells or only the visible cells. For example, you can choose to copy only the displayed summary data on an outlined worksheet. On the Home tab, in …
Hide or display the Paste Options button - Microsoft Support
By default, Excel and Word display a Paste Options button on the worksheet or document to provide you with special options, such as Keep Source Formatting, when you paste content. If you don't want to see this button every time that you paste content, you can turn this option off.
Fill a formula down into adjacent cells - Microsoft Support
You can use the Fill command to fill a formula into an adjacent range of cells. Simply do the following: Select the cell with the formula and the adjacent cells you want to fill. Click Home > Fill, and choose either Down, Right, Up, or Left.
Create conditional formulas - Microsoft Support
You can use the AND, OR, NOT, and IF functions to create conditional formulas. For example, the IF function uses the following arguments. Formula that uses the IF function. logical_test: The condition that you want to check. value_if_true: The value to return if the condition is True.
Create or change a cell reference - Microsoft Support
In one or several formulas, you can use a cell reference to refer to: Data from one or more contiguous cells on the worksheet. Data contained in different areas of a worksheet. Data on other worksheets in the same workbook. For example: This formula: Refers to: And Returns: =C2.
Enable or disable macros in Microsoft 365 files
Block suspicious macros in Office on Windows 10 S. How malware can infect your PC. Improve security, evaluate and mitigate the risks of running macros, and see how to enable or disable macros for Microsoft 365.