Office 2011 for Mac: Insert and Delete Excel Cells, Rows, Columns

Cells, rows, and columns in Excel 2011 for Mac work just like a table in Word or PowerPoint, but have many more capabilities. Adding rows and columns is almost as easy as pressing a button:

  • Inserting a cell: Select a cell (or multiple cells) and then choose Insert→Cells from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Insert→Insert Cells. A small dialog asks you which way to push the existing cells.

  • Inserting a row: Select a cell (or multiple cells row-wise) and then choose Insert→Rows from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Insert→Insert Rows. Your new, blank row(s) push(es) the current row and the rows beneath down one (or more) row(s).

  • Inserting a column: Select a cell or multiple cells column-wise and then choose Insert→Columns from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Insert→Insert Columns. Your new, blank column(s) push(es) the current column and columns one (or more) column(s) to the right.

You can delete cells, rows, or columns in the following ways:

  • Deleting a cell: Select a cell and then choose Edit→Delete from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Delete→Delete Cells. A small dialog asks you which way to move the existing cells.

  • Deleting a row: Select a row number and then choose Edit→Delete from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Delete→Delete Rows. Your selected row vanishes, and the rows beneath move up one row.

  • Deleting a column: Select a column letter and then choose Edit→Delete from the menu bar. Alternatively, click the Ribbon’s Home tab; in the Cells group, choose Delete→Delete Columns. Your column disappears, and columns to the right move one to the left.

blog comments powered by Disqus
Advertisement

Inside Dummies.com