Just throwing this out to the Office for Mac community to see if I'm not the only one who gets annoyed by two significant differences in functionality between the PC (Windows) and Mac (OSX / macOS) versions of Excel. First, on all PC versions of Excel, to edit a cell, one just needs to tap F2. On the other hand, in the Mac version of Excel, one has to type Ctrl-U instead? Because tapping F2 initiates a copy operation?
![When i double click on 2011 excel for mac it will not auto adjust 2017 2018 When i double click on 2011 excel for mac it will not auto adjust 2017 2018](/uploads/1/2/5/6/125641186/491328323.png)
![When I Double Click On 2011 Excel For Mac, It Will Not Auto Adjust 2017 When I Double Click On 2011 Excel For Mac, It Will Not Auto Adjust 2017](/uploads/1/2/5/6/125641186/128164612.png)
Nov 28, 2012 - Describes a behavior in which the Wrap Text feature does not adjust row. Versions of Excel, point to Row on the Format menu, and then click. How to drill down into a pivot table. When you double-click that value, Excel builds a new worksheet that contains every row of source data used for that subtotal. In this case, we have 68 entries for sales in Boston for 2012. Get over 200 Excel shortcuts for Windows and Mac in one handy PDF. Video training; Function Guide.
Why something so counterintuitive? The second issue is how the two different applications handle a situation where a cell contains enough information that it results in a higher row height than usual to display all the word-wrapped text. On the PC versions, whenever I do a sort, the row height attribute always follows the non-standard height rows. On the Mac versions, however, the row height attribute stays in place on the sheet, resulting in some odd looking cells in the one column (I then have to select all and then double-click on any row divider to tell Excel to re-fit the row heights). I've observed this difference in functionality in both Office 2008 and 2011, and under all versions of OSX and macOS that I have used since 2008. Re point #2: Your observation about Mac Excel prior to Office 2016 is accurate, but the behavior is different in Excel 2016. The difference may be related to the program having been revised based on Apple's Cocoa-based code as opposed to the prior versions being Carbon-based.
Also, I believe it's now the same as in the 2007 & later versions for Windows but haven't had a chance to test it. The new behavior in Excel 2016 for Mac appears to be dependent on why the row height differs;. If the difference is due to formatting of the data e.g., font size, the row height does adjust based on the content of the row, but. If the row height has been directly modified either by dragging or a row height value setting the rows retain the height to which they were set. Please mark HELPFUL or ANSWERED as appropriate to keep list as clean as possible ☺ Regards, Bob J.