You can select cells and ranges in a table just like you would select them in a worksheet, but selecting table rows and columns is different from selecting worksheet rows and columns.

You can apply conditional formatting to a range of cells (either a selection or a named range), an Excel table, and in Excel for Windows, even a PivotTable report.

Learn how to select cells, ranges, entire columns or rows, or the contents of cells, and discover how you can quickly select all data in a worksheet or Excel table.

To select an entire table, click in the table, and then click the Table Move Handle in the upper-left corner. To select a row, column, cell, or group of cells, click and drag your mouse pointer to …

Learn how to highlight, sort, and filter, your tables (or data in another supported format) with Copilot in Excel.

Add or change a fill of a table cell, including applying colors, gradients, textures, and patterns, in PowerPoint for Mac.

Highlight alternate rows or columns of data with colors or patterns to improve the readability of your Excel worksheets.

Use AutoFilter or built-in comparison operators like "greater than" and "top 10" in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can …

Unlike other Microsoft Office programs, such as Word, Excel does not provide a button that you can use to highlight all or individual portions of data in a cell. However, you can mimic …

You can use conditional formatting to highlight cells that contain values which meet a certain condition. Or you can format a whole cell range and vary the exact format as the value of each …