Search results
Results From The WOW.Com Content Network
To filter for unique values, click Data > Sort & Filter > Advanced. To remove duplicate values, click Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.
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.
There are two ways to apply shading to alternate rows or columns —you can apply the shading by using a simple conditional formatting formula, or, you can apply a predefined Excel table style to your data. Technique 1: Apply shading to alternate rows or columns by using conditional formatting.
In this topic. 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.
Unhide the first column or row in a worksheet. How to hide and unhide columns and rows in an Excel worksheet. Restrict access to only the data you want to be seen or printed.
Analyze Data in Excel empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas. In addition, Analyze Data provides high-level visual summaries, trends, and patterns.
Want to use sparklines in Excel? Learn how to use sparklines to show data trends and visually represent your data within a cell of an Excel worksheet.
Insert subtotals in a list of data in a worksheet. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013. You can automatically calculate subtotals and grand totals in a list for a column by using the Subtotal command. Important: Subtotals are not supported in Excel tables.
Use a stylus or your finger to write a math equation by hand. If you're not using a touch device, use your mouse to write out the equation. You can select portions of the equation and edit them as you go, and use the preview box to make sure Word is correctly interpreting your handwriting.
Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.
In this tutorial, you start with a blank Excel workbook. The sections in this tutorial are the following: Import data from a database. Import data from a spreadsheet. Import data using copy and paste. Create a relationship between imported data. Checkpoint and Quiz. At the end of this tutorial is a quiz you can take to test your learning.