In this answer to "Bring back custom keyboard shortcuts" https://excel.uservoice.com/forums/304933-excel-for-mac?query=Bring%20back%20custom%20keyboard%20shortcuts the MS team states I can find the customization option under Tools > Customize Keyboard and links to this article to show how: https://support.office.com/en-us/article/create-a-custom-keyboard-shortcut-for-office-for-mac-6bbeb90e-96d9-4e03-b199-fc026ebdc321?ui=en-US&rs=en-US&ad=US

This is NOT the case. There is no option for Customize Keyboard in the Tools menu in Excel 2016 for MAC. You guys blew it when you removed the ability of a user to create a custom key combo to complete a command.

For example I always used the F1 key to delete cells and rows, which I do a lot. I used Option+click to add rows. Now I have to hunt all over for the tool. When I added these commands to the Qick Access bar at the top via Ribbon customization, the icons are so greyed out that I can't even see them. See attached screens.

I intend to get a refund and use an older version of Excel. The limitations in 2016 make my workload way more tedious.

Don't even get me started on the animated "gliding cells". How stupid. I'm not making a video. I'm doing bookkeeping and invoicing. I don't want my sheets animated.

Keyboard shortcuts remained fairly standard from Excel's earliest days (I started using it with version 2.2a, don't know if they go back further) until Excel 2001 when somethings like, for example command-b was moved to bold text instead of clear text, but those changes were remapped onto the control key for those of us that had been using them for a long time.

Now they have mapped BOTH to bold, and removed the keyboard shortcut for clear altogether. Likewise fill down no longer has a keyboard shortcut.

I was excited to hear that keyboard customization was returning, but neither of these items I use daily are able to be re-added with this "feature"

So let's keep it simple: We need the same keyboard shortcuts that we have been using since Excel 2001 to be available to us in the 64 bit versions of excel.

For now, I continue to use Excel 2011, as everything newer slows me down tremendously.

Hi!

Could you please help me with the following issue related to this post?
I have Excel 2016 in a Mac and previously I was using the following shortcut to select ONLY VISIBLE ROWS from filtered data:

SHIFT + CMD + *

After that I could copy the data and will copy only the visible information and not the hidden information, or I could delete only the visible rows without deleting the hidden ones.

But a month or so ago after an update I cannot longer do that and when I do SHIFT + CMD + * what it does is to select all cells including the headings and it includes the hidden cells.

Do you know if there's a new shortcut to do what I was previously doing? Or another way to do so? Take into account that in Mac there's no "GoTo Special" function available.

Thanks in advance

hi! i want to suggest to you the implementation of a possibility to change excel default settings, e.g. for charts. i’ve talked to your friendly support team about one such example, but they couldn’t help me with something that’s not programmed.

i’m a chemist. like million other natural scientists, students and experts, i work with lots of complex and diverse data, every day. while the modern versions of excel offer many great and even fancy features, customization possibilities have shriveld. the template feature performs badly and really is only useful if applied to the exact same data set-up.
what is good (great even, and - for a mac user - the reason to try my luck with excel rather than numbers) is the possibility to adjust just about anything.
what is bad (and the reason why most of the above mentioned scientists use origin, gnuplot or other, sometimes ridiculously expensive software rather than excel) is that one’s personal preferences on a higher level cannot be introduced to the program. instead each tiny change has to be stupendously adjusted by hand - every time! my personal example from the support-encounter (adding a data label on a curve in a scatter plot (e.g. curve maximum): by default, it will show you the y-value, on the right side of the data point, in the number format of the data set. changing this to my specifications (x-value, above data point, number format with 0 decimal places)) needs 12 extra clicks to change ONE data label. i have done this little task hundreds of times - imagine the amount of time i lost. and there are countless more examples:
- using different source data (e.g. the next column) for a curve will change the curve’s color - why? now i have to chance the format again
- changing the color/format of a set of curves only works by clicking on one after the other (which is impossible, if they are too close together). sometimes i even have to change data values, so i have a place to click at
- applying a template on a new data set leads to ridiculous charts; the template saves for example the axis bounds (so most of my new data ends up tiny or outside the window), but will delete a previously added axis name (so applying a template at any point later than the absolute beginning leads to data loss)

i as a single voice will probably not have an impact on your plans. but i wanted to give you this feedback before giving up and switching to another plotter, which is what pretty much all of my colleagues did. you have a pretty good code base here. now just open it up a little for professional users, and you win back the science community ;)