when I select a print area, and then go to print - it seems to be the default to have print entire workbook - and I can't seem to change the default, or set up new presets that return automatically, so I just get print the print area selected and set? I used to be able to do this. This slows down my work process considerably and is a massive inconvenience. Who wants print entire workbook as a default? No-one I know. I've tried doing the string as a new preset, but can't get it to return automatically. Printing a selection is now a prolonged and slow process. I used to be able to do this, until quite recently. see screenshot. Can we go back to how it was before this 'upgrade'.

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.

Today at work I encountered this problem while making PDF's of charts for a print publication. The Mac version of Excel is not able to produce proper PDF's! Look at the wonky kerning of the numbers under these charts, and the wobbly dotted lines. Compare them to the perfect kerning in the Excel for Windows 2017 PDF export...!
The same sheet was used for this export. First I thought it was the zoom level of Adobe Acrobat interferring with the pixel mapping of my screen but it is not, the PDFs are just jiggy and messy when exported on a Mac. I hope this feature will see a fix, cause producing PDFs is an important part of my workflow, and I would love to use Excel on my Mac instead of on a virtual windows PC.

I want a refund for my purchase of Office 2019 for Mac. I have been unable to Activate Office for Mac 2019 for 2 days now since I purchased, downloaded and installed the program on my MacBook Pro running Mac OS High Sierra 10.13.2. I have followed the step by step instructions but your activation process does not work. 9 times, I have Clicked the Launchpad icon in the Dock to display all of my apps. I have Clicked  Microsoft Excel to start the activation process. The What's New window has opened automatically. I have clicked Get Started > Sign in. I have entered the email address associated with Office for Mac and clicked Next. Then every time, a new window opens saying “Loading”with a spinning time wheel that never connects. The window continues like this for hours on end. “Loading” with a spinning time wheel. I have paid 149,00 euros on my credit card and want a refund. This is a waste of time and a fraud. You have taken my money and not delivered a product that is usable on my Mac. Refund please or I will contact my credit card company and start filing a formal complaint.

The next version of MacOS will will not allow the editing of UserForms in Excel so I've installed a virtual machine (Parallels) with the current MacOS which I will not update when the new version comes out. I can currently run all of my excel spreadsheets (Excel for Mac 2011) using this (they all run flawlessly) and will be able to update my main OS to the new version.

Actually, I have installed all of my 32 bit applications on the virtual machine.

This a lot cheaper than buying a dedicated Windows computer.

Now I have all the benefits - two computers in one with all the advantages of both.

(I have no form of business association with Parallels.)

When I change existing border settings in cells, rows, or columns the new setting is ignored, and instead, the previous settings are even removed.
I am using Office 2019.
Before when I made changes to border setting, for example replacing a thinner with a thicker line, I just had to select the new line style, click the border I wanted to change and the new line style was set.
Now, when I do the same, the new line style is displayed right after clicking the border I want to change, but when ok'ing back to the form, the border line is entirely gone. No previous and no new border line any longer.
I have to go back and reset the new line style, ok back to see the new setting.

In a previous version of Excel, I could paste a selection of data cells into an image previously pasted on a spreadsheet page. This was usually a column of text used to label electrophoresis bands arranged horizontally on the image. In the previous version, the text would paste independent of the cell background and outline box. This is what I want. I could make the list horizontal by rotating it, and sizing it to fit the columnar data in the image. The text labeled the columns perfectly and clearly. Now that the software has been updated, when I past the column of data from the spreadsheet into the image, it is accompanied by the cell outline and background, which obscures the image behind it, a very unacceptable thing. How can I get the new excel version to behave as the old version did?

How it used to work well:

How it is unacceptable with new version of Excel...:

1) The tick boxes change locations depending on how many items you have selected. If you have one or two tick boxes selected the tick boxes are lower down because the "Equals" rows above have been filled in. If you have 3 or more tick boxes selected then there is just a single blank "Choose One" row. It makes it very difficult to select a bunch of tick boxes because the location of the tick box jumps around. This is new behavior from Excel 2011.

2) The cursor is in "Choose One" empty box rather than in the "Search" box. This is the opposite from Excel 2011. 99% of the time I'd rather jus type something into the search box rather than type something into the Choose One box and then have to use the mouse to "Choose One".

3) The AutoFilter dialog box is too small vertically. Almost every time I do an autofilter I double the size of the dialog.