In Excel on a PC, I believe if you have a set of data and want to select all the cells in the same row from where the cursor is to the last cell below a set of data, you could use Ctrl - Shift - ←. On a Mac (Excel 2011) this selects all the cells until the end of the entire row. 
Excel for Office 365 for Mac, Excel 2019 for Mac, Excel 2016 for Mac Excel for Mac 2011 Formula results are shown in worksheet cells, while formulas are visible in the formula bar only so that they won’t appear when you print. I have a file created in Excel 2003 on a PC at work. I have now converted to a Mac and I am using Parallels to run Windows. I have a file with 45 tabs in 2003 Excel that I use two times a month for tax paying purposes. I have wanted to use it in my mac 2011 excel but when I open the file the. It is a fact that 'sizing' (like column.
I have the new 2013 MacBook Pro. I have purchased Microsoft Office for Mac, which is what I'm using when I say 'Mac Excel' I am a power excel user in PC Excel but am having a hard time in Mac's excel, as many of the Mac excel shortcuts don't work. For instance, to edit active cell, in Windows its an easy 'F2' shortcut, in Mac excel, ^+U (shift +U) isn't working. In fact, none of the shortcuts (with the exception of the most basic like cut and paste (Ctrl+C, Ctrl+V in Windows) are working. I switched my command button to be my control button, since I'm so used to the PC keyboard layout, but I always press Mac's CONTROL when a shortcut indicates to use the squigly square COMMAND button. I just don't understand why the most basic shortcut like ^+U to edit an active cell isn't working in my Mac excel. So frustrating!
Thank you for any tips on how to fix the Mac excel problem with Mac shortcuts not working. I have just done a little experimenting and I think I have some idea of why you're having a problem. I opened up Mac Excel 2011 and selected a cell. I pressed Control-U and I was able to edit it.
I also pressed F2 and I was again able to edit it. So I'm starting to think that there is a configuration problem somewhere on your Mac. On Control-U: I am wondering if this no longer works on your Mac because you remapped Command to Control. Because in Mac Excel, Command-U (apply underline formatting) and Control-U (edit selected cell) are two different features, so if you remapped Command to Control at the system level, Excel now behaves such that all Command-modifier shortcuts are now Control. Therefore, Command-U (underline text) is now Control-U, and whatever was Control-U before (edit active cell) is disabled since a shortcut can only mean one thing at a time.
That's my theory on why Control-U stopped working for you: You told the Command-U feature (underline text) to replace the former Control-U feature (edit active cell). One possible way to fix this is that because remapping Command to Control eliminates access to Control key shortcuts, you could also remap Control to Command so that you can regain access to shortcuts that need the Control key like Control-U. Basically you would be swapping the two keys. (I think that would work, anyway) But ultimately my recommendation is that if you bought a Mac intending to commit to the Mac.then really commit to the Mac.