- Editing Data
- Overwriting and Deleting Data
- Undoing and Redoing Changes
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Cutting, Copying, and Pasting Data
- Flipping Rows and Columns
- Moving Data
- Finding Data
- Replacing Data
- Adding and Viewing Cell Comments
- Editing and Deleting Cell Comments
- Inserting Symbols
- Tracking Changes
- Accepting or Rejecting Tracked Changes
- Checking Spelling
This chapter is from the book
This chapter is from the book
This chapter is from the book
Flipping Rows and Columns
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.
)
)
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.
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).
)