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 disabilities. You learn, for example, how to work with the Accessibility Checker to tackle accessibility issues while you're creating your spreadsheet.
Insert an object in your Excel spreadsheet - Microsoft Support
Embed an object in a worksheet. Click inside the cell of the spreadsheet where you want to insert the object. On the Insert tab, in the Text group, click Object . In the Object dialog box, click the Create from File tab. Click Browse, and select the file you want to insert.
Turn off Scroll Lock - Microsoft Support
If a check is not visible, Scroll Lock does not appear in the Excel status bar. Simply check the box to have the status appear on the status bar. If Scroll Lock is on, your cursor moves between columns and rows, not cells. Here's how to turn off Scroll Lock.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
It's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
Replace a formula with its result - Microsoft Support
Replace a formula with its result. You can convert the contents of a cell that contains a formula so that the calculated value replaces the formula. If you want to freeze only part of a formula, you can replace only the part you don't want to recalculate.
ADDRESS function - Microsoft Support
This article describes the formula syntax and usage of the ADDRESS function in Microsoft Excel. Find links to information about working with mailing addresses or creating mailing labels in the See Also section.
Lock or unlock specific areas of a protected worksheet
To enable some cell editing, while leaving other cells locked, it's possible to unlock all the cells. 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.
Use Excel as your calculator - Microsoft Support
Use Excel as your calculator. Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. Or use the AutoSum feature to quickly total a series of values without entering them manually in a formula. After you create a formula, you can copy it ...
Format numbers - Microsoft Support
Fix text-formatted numbers by applying a number format. Format numbers as dates, currency, or even fractions to cells in a worksheet. For example, if you’re working on your quarterly budget, the Currency number format shows your numbers as money.
Access your Account Privacy Settings - Microsoft Support
Go to the File tab, select Account (or Office Account in Outlook) in the bottom of the left pane, and then choose Manage Settings. To access your privacy settings in the new Outlook for Windows: On the View tab, select View settings and choose General. Select Privacy and data then choose Privacy settings.
XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.