Apply, create, or remove a cell style - Microsoft Support
A cell style is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading. To prevent anyone from making changes to specific cells, you can also use a cell style that locks cells. Microsoft Office Excel has several built-in cell styles that you can apply or modify.
Apply shading to alternate rows or columns in a worksheet
Learn two ways to apply shading to every other row or column in a worksheet: using conditional formatting or Excel table style. See the steps, formulas, and examples for each technique.
Apply or remove cell shading - Microsoft Support
For example, if you frequently create workbooks where all the cells are green, you can create a template to simplify this task. To do this, follow these steps:
Lock or unlock specific areas of a protected worksheet
Learn how to protect a worksheet and enable some cell editing, while leaving other cells locked. Follow the steps to unlock specific cells and ranges, or use passwords or permissions to allow users to edit certain areas.
Using IF with AND, OR, and NOT functions in Excel
Learn how to use IF, AND, OR, and NOT functions in Excel to make logical comparisons and return values based on conditions. See examples, formulas, and tips for conditional formatting with these functions.
Accessibility best practices with Excel spreadsheets
Best practices for making Excel spreadsheets accessible. Check accessibility while you work in Excel. Create accessible tables. Use an accessible template. Add text to cell A1. Add alt text to visuals. Add accessible hyperlink text and ScreenTips. Use accessible font format and color. Create accessible charts. Rename worksheets.
Change the format of a cell - Microsoft Support
Learn how to apply formatting to cells and data in Excel, such as bold, font color, font size, and styles. Find out how to modify and format cells with predefined styles, borders, fill colors, and more.
LOOKUP function - Microsoft Support
Learn how to use LOOKUP function to search for a value in a single row or column and return a value from the same position in another row or column. Compare LOOKUP with VLOOKUP and XLOOKUP, and see examples of vector and array forms.
XLOOKUP function - Microsoft Support
Learn how to use the XLOOKUP function to find things in a table or range by row, with examples and syntax. XLOOKUP can return the first match, the closest match, or a wildcard match, and can handle nested or reverse searches.
View previous versions of Office files - Microsoft Support
Learn how to access and restore previous versions of Excel files stored in OneDrive or SharePoint in Microsoft 365. This feature can help you recover from mistakes, malware, or unwanted changes by others.
Create a PivotTable to analyze worksheet data - Microsoft Support
Learn how to create a PivotTable from an existing table or range, or from multiple tables, Power BI datasets, or other sources. Follow the steps to add fields, change calculations, refresh data, and use recommended PivotTables.