excel for mac view rows and columns headers

Excel View Rows And Columns Headers Mac Productivity Tutorial

But, sometimes its not until after you start entering your data that you wish you had structured the spreadsheet differently.

You may have entered column headers that would work better as row headers or vice versa.

How to transpose columns and rows Lets say youve entered column headers for your spreadsheet.

You decide you want to convert those columns into rows.

Select the rows for the columns that you want to transpose.

You can do this by either clicking the first one and dragging through the rest or clicking the first one, holding down the Shift key, and then clicking the last one.

Note: If you try to select the columns and then continue with the steps below to copy and paste them, youll likely end up with an error message saying that the copy area and paste area arent the same size.

This is why you need to select the rows for the columns as shown above.

Copy the rows. You can do this by either clicking Edit from the menu and selecting Copy or using Command C on your keyboard.

Go to and click the cell where you want to paste your data.

If you would like to apply additional formatting at that time, you can select Paste Special from the Paste menu instead.

This will open a window where you can select your formatting options.

Then, click the Transpose checkbox when you finish and hit OK.

When you complete the steps above, your columns (and your data if you selected it as well) will turn into rows.

And, if you want to turn rows into columns, just follow the same process.

How to transpose a group of cells If you just have a single group of cells that you want to convert, rather than rows and columns, its just as simple.

Select the exact cells as you did with the rows in Step 1 above and then continue the same process to copy and paste them.

So, if you begin creating a sheet and realize you want to make some formatting changes like these, its easy to do.

Just be sure to save a copy of your original workbook and double-check your work so that you dont mistakenly lose any data.

Excel View Rows And Columns Headers Mac Productivity Tutorial

Do you need help with other Excel features or would you like to see a tutorial on something specific Let us know Tagged: Excel How to Mac Productivity Tutorial MORE FROM iDB How to convert a Numbers file to Excel on Mac and iOS How to customize the Quick Access Toolbar in Word and Excel on Mac How to create drop-down lists in Excel on Mac Newsletter Get updates directly into your inbox.

Home Apps Tutorials Jailbreak News Jailbreak Tweaks Downloads Wallpapers Accessories Deals Podcasts Write for iDB Contact Us.

Excel For Mac View Rows And Columns Headers