how to make columns into rows in excel for mac

Make Columns Into Rows In Excel Professional Presentations And

The cell you select becomes the top, left corner of whatever youre copying.

You can select those cells again, and delete them if you want.

Shes been a senior technical writer, worked as a programmer, and has even run her own multi-location business.

Since we launched in 2006, our articles have been read more than 1 billion times.

You can also select the column letter on the frame before you choose the Insert command.

If you dont know whats out in the hinterlands of the worksheet, you cant be sure how the insertion will impact stuff (especially formulas) in the other unseen areas.

He is the author of all editions of Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference.

Adding rows and columns is almost as easy as pressing a button.

Alternatively, click the Ribbons Home tab; in the Cells group, choose InsertInsert Cells.

A small dialog asks you which way to push the existing cells.

Alternatively, click the Ribbons Home tab; in the Cells group, choose InsertInsert Rows.

Your new, blank row(s) push(es) the current row and the rows beneath down one (or more) row(s).

Alternatively, click the Ribbons Home tab; in the Cells group, choose InsertInsert Columns.

Your new, blank column(s) push(es) the current column and columns one (or more) column(s) to the right.

Alternatively, click the Ribbons Home tab; in the Cells group, choose DeleteDelete Cells.

Alternatively, click the Ribbons Home tab; in the Cells group, choose DeleteDelete Rows.

Your selected row vanishes, and the rows beneath move up one row.

Alternatively, click the Ribbons Home tab; in the Cells group, choose DeleteDelete Columns.

Make Columns Into Rows In Excel Professional Presentations And

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

How To Make Columns Into Rows In Excel For Mac