Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
Combine text from two or more cells into one cell in Microsoft Excel
Combine data in Excel using the CONCAT function Select the cell where you want to put the combined data. Type =CONCAT (. Select the cell you want to combine first. Use commas to separate the cells …
Sort data in a range or table in Excel - Microsoft Support
Open a new workbook in Excel for the web or open a current workbook. If your data is formatted as an Excel table, then you can quickly sort and filter it with the filter buttons in the header row. If your data …
Change the column width and row height - Microsoft Support
How to change the column width and row height, including how to use the AutoFit feature, in your Excel worksheet.
Apply shading to alternate rows or columns in a worksheet
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.
Lock or unlock specific areas of a protected worksheet
How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit.
Ways to count values in a worksheet - Microsoft Support
Counting is an integral part of data analysis, whether you are tallying the head count of a department in your organization or the number of units that were sold quarter-by-quarter. Excel provides multiple …
Create a PivotTable to analyze worksheet data - Microsoft Support
How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.
Use conditional formatting to highlight information in Excel
Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly …
Create and format tables - Microsoft Support
Learn about the many ways to create a table in an Excel worksheet, and how to clear data, formatting, or table functionality from a table in Excel. Discover more in this video.