If you want to rotate your data frequently to view it from different angles, consider creating a PivotTable so you can quickly pivot your data by dragging fields from the Rows area to the Columns area (or vice versa) in the PivotTable Field List. MS Excel allows recurrent selections via VBA programming or conditional formatting. Holding down Ctrl and handpicking cells is not an option for large spreadsheets with thousands of rows. You can convert the table to a range first by using the Convert to Range button on the Table tab, or you can use the TRANSPOSE function to rotate the rows and columns. Sometimes you may need to make a recurrent selection shade alternate rows, or every other column, or a custom pattern, etc. If your data is in an Excel table, the Transpose feature won’t be available. It will convert the Column to Rows and will show the data as we want. Choose the option Transpose, as shown below. Verify these formulas use absolute references-if they don’t, you can switch between relative and absolute references before you rotate the data. Click on the Paste option under the Clipboard section. If your data includes formulas, Excel automatically updates them to match the new placement. ![]() The data you copied will overwrite any data that’s already there.Īfter rotating the data successfully, you can delete the original data. Pick a spot in the worksheet that has enough room to paste your data. Select the cell(s) with the formula and move the cursor over the little block. Select the first cell where you want to paste the data, and on the Home tab, click the arrow next to Paste, and then click Transpose. Using the Cut command or CONTROL+X won’t work. ![]() ![]() ![]() Note: Make sure you copy the data to do this.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |