Identifying Cursors in Excel in Office 2011 for Mac
Office 2011 for Mac: Using the Custom Lists Feature in Excel
Excel for Mac 2011 Worksheets: How to Drag a Series of Typing

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
Using Excel’s Common Interface in Office 2011 for Mac
Opening the Excel Workbook Gallery in Office 2011 for Mac
Choosing Excel File Formats in Office 2011 for Mac
Signing Up for and Managing SkyDrive in Office 2011 for Mac
Office 2011 for Mac: How to Insert a SmartArt Graphic
Advertisement

Inside Dummies.com