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 …
Filter by using advanced criteria - Microsoft Support
Microsoft Office Excel uses the separate criteria range in the Advanced Filter dialog box as the source for the advanced criteria. The following sample data is used for all procedures in this …
How to correct a #N/A error in the VLOOKUP function
Solution: You can try to fix this by adjusting your VLOOKUP to reference the correct column. If that’s not possible, then try moving your columns.
Basic tasks in Excel - Microsoft Support
Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key …
Record your actions as Office Scripts - Microsoft Support
To create a new Office Script, press the Record Actions button, then start taking the steps you want to automate. For this example, we're taking a data range, converting it to an Excel table, …
Excel not responding, hangs, freezes or stops working
You can safe mode troubleshoot in one of two ways: The Microsoft Support and Recovery Assistant fully automates the safe mode isolation process to let you know if the problem is due …
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Present your data in a Gantt chart in Excel - Microsoft Support
Present your data in a Gantt chart in Excel. A Gantt chart helps you schedule your project tasks and then helps you track your progress. Need to show status for a simple project schedule …
Use a screen reader to sort or filter a table in Excel
Use Excel with your keyboard and a screen reader to sort and filter tables. We have tested it with Narrator, JAWS, and NVDA, but it might work with other screen readers as long as they follow …
Create, load, or edit a query in Excel (Power Query) - Microsoft …
Create, load, or edit a query in Excel (Power Query) Power Query offers several ways to create and load Power queries into your workbook. You can also set default query load settings in the …
Add a pie chart - Microsoft Support
Click the chart and then click the icons next to the chart to add finishing touches: To show, hide, or format things like axis titles or data labels , click Chart Elements . To quickly change the …