To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which …

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 …

Unlike other Microsoft 365 programs, Excel does not provide a button to number data automatically. However, you can easily add sequential numbers to rows of data by dragging …

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

When you create an Excel table, a table Header Row is automatically added as the first row of the table, but you have to option to turn it off or on.

You can quickly total data in an Excel table by enabling the Total Row option, and then use one of several functions that are provided in a drop-down list for each table column.

To confirm that Power Query recognized your headers in the top row, select Home > Transform, and then select Use first row as headers. Power Query converts the first row of data to a …

How to change the column width and row height, including how to use the AutoFit feature, in your Excel worksheet.

You can create a cell style that includes a custom border, and then you can apply that cell style when you want to display the custom border around selected cells.

To insert a row, pick a cell or row that's not the header row, and right-click. To insert a column, pick any cell in the table and right-click. In the example shown below for rows, a row will be …