This tutorial is for Excel 2011 on Macs. For Excel 2010 for PCs, go here. If you would like to request additional content, please email the Empirical Reasoning Lab. Want to use the same data as the tutorial? Some of the exercises use data from the New York City Census Tracts. The TRANSPOSE function converts a vertical range of cells to a horizontal range of cells, or a horizontal range of cells to a vertical range of cells. Use it to 'flip' a range of cells from one orientation to another. When array is transposed, the first row of array is used as the first column of the new array, the second row of array is used as the second column of the new array, the third row of array is used as the third column of the new array, and so on. You must enter the TRANSPOSE function as an array formula that contains same number of cells as array, using Control + Shift + Enter. The new array must occupy the same number of rows as the source array has columns, and the same number of columns as the source array has rows. For a one-off conversion, you can use paste special > transpose. Here's a tip that eliminates the need to rekey data. Suppose you've entered your data with three column headings running across Row 1 and four row headings running down Column A, like the ones shown in Figure A. Figure A After working with the data for a while, you decide you'd rather have the current set of row labels (months) running across the columns. Whatever you do, don't even think about rekeying the data. You'll find the best solution on the Paste Special menu. Start by selecting and copying your entire data range. Click on a new location in your sheet, then go to Edit| Paste Special and select the Transpose check box, as shown in Figure B. How to modify bin width for a histogram in excel mac. From the Add-Ins category, select 'Excel Add-Ins,' which display in the Manage box. Click OK, and Excel will transpose the column and row labels and data, as shown in Figure C. Figure B Figure C Note.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |