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

Chapter 3. Working with Cells, Rows, and... > Transposing Column and Row Informati...

Transposing Column and Row Information

We already took a quick look at the Paste Special dialog box when we copied cell formatting from one cell to another. The Paste Special dialog box also provides you with the option of transposing column and row information. For example, let's say you set up several column headings for a spreadsheet, but then decide that they should have been row headings. Well, rather than copying them one at a time from a column to a row, you can transpose all the information in the spreadsheet from the columns to the rows (or vice versa).

For example, let's say we want to transpose column headings to row headings. Figure 3.20 shows a set of column headings (Months) and the row headings that will result once we transpose the column headings to their new position.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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