O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with Rows and Columns

In this section, you'll learn how to insert and delete rows, columns, and cells; change the width of columns and the height of rows; and hide rows or columns when you don't need to see them.

Inserting and Deleting Rows, Columns, and Cells

When laying out your worksheets, you'll often need to insert or delete entire columns or rows. Sometimes you may also need to delete a block of cells without deleting an entire column or row.

Inserting Columns and Rows

The easiest way to insert a column or row is to Ctrl+click or right-click the heading of the existing column or row before which you want to insert the new one and then click Insert on the context menu.

To insert more than one column or row, select the same number ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required