• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Editing Worksheets > Flipping Rows and Columns

Flipping Rows and Columns

Select the range you want to transpose.

Click the Copy button on the Standard toolbar.

Click the first cell in which you want to paste the range.

INTRODUCTION

Transposing (flipping rows and columns) is a special copy feature you might need to use if you want to change the layout of your worksheet. For example, suppose your worksheet is set up with quarters in rows and divisions in columns, but that your boss prefers the opposite: quarters in columns and divisions in rows. In a case such as this one, you can flip the worksheet.


CAUTION

You cannot transpose a range of cells onto the original range selection. You must first transpose the range and then move the range.




Open the Edit menu and choose Paste Special to open the Paste Special dialog box.

Click the Transpose check box to mark it.

Click OK.

The range is transposed (or flipped).

TIP

Using the Paste Special dialog box

Notice that the Paste Special dialog box enables you to paste all different types of formulas, values, formats, and so on. Practice using this dialog box and see the different types of results that you get.


TIP

Eliminating the original data

To eliminate the original data that you transposed, you must delete it. Refer to the task “Overwriting and Deleting Data” earlier in this part for more information.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint