How Do You Split Cells In Excel 2011 For Mac

Although having checked it out and selected Move Down after pressing the return key, repeatedly pressing the return key on a protected spreadsheet with locked cells the active cell still moves through the locked cell - it doesn't skip it.There is one other thing which might explain the change - which is in laptops the return and enter keys are physically the same. First, to merge any two cells, select the two.In the new version only the tab key will do this with the enter key now being paired with the return key which cannot perform the old function.This - in my opinion - is a huge backward step for Excel.Has anyone else experienced this drawback and does anyone have a solution?If not I believe Microsoft should quickly revert to the old way or at least make the functions of these keys a user selectable optionHi - thanks for taking the trouble to reply.I should have mentioned that I'm using an external (full) keyboard (since the laptop keyboard does not have a 'proper' numeric key pad).Also, I presume in Excel preferences you have selected what to do after the return key is pressed. Excel 2011 (Mac) Excel 2010. Perhaps it is a more customizable merge than SQL. You could press number, enter, number, enter, number, enter, etc etc safe in the knowledge that each time you pressed Enter the active cell would simply skip over the locked cells (with formulas etc) and stop at the next cell waiting for the number/data (whatever) to be entered.Excel 2011 (Mac) Excel 2010. Each time the enter key was pressed the active cell would move to the next cell SKIPPING the locked cells.

What I didn't realise is that I had left the (dimmed) box with Down selected. Let me explain.In Excel preferences I had unchecked the box in the Edit menu which asked if wanted to move the selection after hitting return. I did that - and it got me half way there. This probably explains - but in my view does not excuse - the combining of the Return and Enter keys into the same function leaving the tab key to do what the enter key used to do!It would still be nice if this was user selectableWell, they kept that hidden! Thanks for the tip. The return key is in the same physical location as on the laptop keyboard but the enter key is at the bottom right of the numeric section. Return and enter keys are separate.

How Do You Split Cells In Excel 2011 For Mac