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 …

Hold down CONTROL, click the selected cells, then on the pop-up menu, click Insert. On the Insert menu, select whether to shift the selected cells down or to the right of the newly inserted …

To add a row by pasting, paste your data in the leftmost cell below the last table row. To add a column by pasting, paste your data to the right of the table's rightmost column. If the data you …

Explains that you receive a "Cannot shift objects off sheet" error message when you hide columns in Excel. You can change the position property of the object to "Move and size with cells."

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.

Insert a new column into the table. You can do this by typing in the column immediately to the right of the table, and Excel will automatically extend the table for you.

Sometimes, the following message prevents you from inserting or hiding columns or rows in a worksheet. If you see this message, refer to the following table for possible solutions.

In Excel, you can paste a specific aspect of the copied data like its formatting or value using the Paste Special options. After you've copied the data, press Ctrl+Alt+V, or Alt+E+S to open the …

The Subtotal command will appear grayed out if you are working with an Excel table. To add subtotals in a table, you must first convert the table to a normal range of data, and then add …

You can use AutoSum to quickly sum a column or row or numbers. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter (Windows) or Return …