To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same …

When you use the Microsoft Excel products listed at the bottom of this article, you can use a worksheet formula to covert data that spans multiple rows and columns to a database format …

To insert geographic data into Excel, you first convert text into the Geography data type. Then you can use another column to extract certain details relative to that data type, like Total …

You can use sparklines in Excel for Mac to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values.

To insert a column, pick any cell in the table and right-click. In the example shown below for rows, a row will be inserted above row 3. For columns, if you have a cell selected in the table's …

You can arrange your text into columns in a Text Box or shape. You can also specify the spacing (in inches) between the columns. Here's how:

Calculated columns in Excel tables are a fantastic tool for entering formulas efficiently. They allow you to enter a single formula in one cell, and then that formula will automatically expand to the …

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you're done.

To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can …

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.