Instead of typing the table and column names in your formula (also known as structured references) manually, if you select the cells in the table using your mouse, Excel will input these for you.

Scatter charts use two columns of data for each point. By default, Excel ... line chart, add additional numbers in cells below your existing data. Right-click the chart, choose "Select Data ...

Microsoft Excel's CHOOSECOLS ... cell B9 to select a valid game number, safe in the knowledge that even if you add extra columns to your table, CHOOSECOLS and the named range in data validation ...

Adding space between Excel columns is usually a simple matter of increasing your column widths. But when the columns contain different types of data, such as numbers and text, increasing the width ...

Quickly add a blank row between multiple rows of data ... value 2. Select the values 1 and 2 (cells F2:F3 above) and double-click the fill handle. Excel will auto-fill the cells in column F.

Step 1: Select the column to the right of where you want to add the new column. Just click the top of the column and Excel will highlight it. Step 2: Right-click on the column and select Insert ...

You may think you already know all about them, but Excel keeps adding more ... a bar and a column chart displaying the quarterly revenue for each quarter for each department. Line charts help you spot ...

Sorts are a simple task in Microsoft Excel ... data set is simple on purpose so you can easily discern the different groups as a result of the multiple column sorts. For each group, simply add ...