holding command to select non consecutive files then adding shift with command still down to highlight a range whilst keeping the original non consecutive files highlighted. This creates another line within the cell. Finally have the solution - use the alt key to the left of the space bar (and not the one on the right) while simultaneously pressing the Enter key. Interestingly the selection technique i want works in mozilla thunderbird under mac os x. Re: alt-enter (cell line breaks) is not working in Excel 365. I have read numerous forums all saying just use shift or whatever but its not quite what is required. I made a video screen capture to explain what i mean cause its either hard to explain or not available at all on Mac or no one can answer. When you try to do this in finder on OS X it just highlights everything from the first file to the last and will include anything that wasn't selected before hand in between. Then if you add the shift key holding it with control also you can select a consecutive range of files whilst keeping the previous non consecutive files highlighted. In windows you can hold control while clicking to select multiple files consecutive or not. But if you are a bit clever, you should realize by now that there are a few limitations to the tricks that we’ve used.
Up till now, we have used three methods to count the number of unique values in Excel.
I have been hunting for an answer for this problem for a while now and i have recently made the full switch to mac (have used before) and would really like to find out how to do this. Limitations of the Formulas and Alternative Option. I don't think this question is fully answered or correctly explained.