Deleting cells and moving columns in Excel for Mac When I use Excel (Windows) 2010 at work, I can highlight a series of cells and press delete and all the data from the highlighted cells is removed.
See solution in other versions of Excel:. Question: In Microsoft Excel 2011 for Mac, I have a spreadsheet that has frozen panes. How do I unfreeze the panes?
Answer: Freezing panes could hide rows or columns, or cause the column headings to always be visible even after scrolling. To unfreeze panes, open your Excel spreadsheet. Select the Layout tab from the toolbar at the top of the screen and click on the Freeze Panes button. Then click on the Unfreeze option in the popup menu. Now when you move around in your spreadsheet, columns and rows should display as normal.
Hi, I'm working with a report from a web-based application that I cannot export into Excel. I can copy and paste the text, but when I do that all the text that is listed in columns horizontally ends up being listed in the first column of my Excel file vertically. What I want to do is select, say for example, the first 8 or so items in the list vertically and have them move to the first 8 horizontal cells. Is there an easy way to do this short of copy and paste? This is something I may need to do on a regular basis and need a quick and easy way to change the way this info is coming into Excel.
![]()
The text is not tab or comma delimited so using the Text to Column command will not work. Thanks for any help Beth Jim Gordon MVP 20/1/2008, 13:03 น. Hi Beth, I'm not entirely sure which of these two solutions might work for you. Solution #1 Click on the letter A of the column header and that should select the entire column. Then use Data Text to Columns. Solution #2 Select the pasted range and use Edit Copy, then switch to a different location or other sheet and use Edit Paste Special Transpose.Jim Quoting from 'bphillips', in article, on DATE: - Jim Gordon Mac MVP MVPs are not Microsoft Employees MVP info [email protected] 8/2/2008, 8:38 น.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |