incorrect result on sum

We have the transpose function that allows us to swap data from rows to columns, or vice versa … how about a function that allows us to swap data between two different rows, or two different columns. For example, if I have data in A1:A10 and I have data in B1:B10, I could highlight both sets of data, and by choosing this new function, I could swap the data, whereas A becomes B and B becomes A.

Spreadsheet Compare for Mac Excel

Can the weight of the grid lines be chance? the weight of the grid lines make them lighter than the input in the cells

Add customize color option to excel for mac to change color themes to set it as default

This option has been already realised in excel 2013 but not for Mac

Lastest version comments are irritating, they pop up as I roll over the cell. Sometimes I cannot see the cell I am looking for because there are so many comments popping up. Previous version I had to be on the cell to see the comment which is much less confusing.

The 'Tell me what you want to do" label (along with the Share and Comments buttons) takes up so much horizontal space that it hides most Ribbon tabs when the window is a narrow size. Understanding that not all spreadsheets are displayed full-screen all the time, it would be great if this label collapsed down to something much smaller when the window size is narrow. (Other ribbon controls could also be made more useable for narrow windows by following the lead of how Windows Excel displays its ribbon controls on narrow windows).

Merci de me dire quand user forms pour mac urgent
cordialement

Excel 16.23 for Mac no longer has a functional Solver. Trying to use it results in Alert:

Sorry, Excel can't open two workbooks with the same name at the same time.

Works on PC and lower versions. What to do?

When I create a hyperlink to a Word file, I want to be able to add a bookmark and let the link open die Word file directly to the bookmark. In Office for Windows you can do this by adding #Bookmarkname to the hyperlink in Excel. In Office for Mac this doesn't work.

make a button for making lower case letters into uppercase letters

It would be good if Excel in Office 2019 did spelling check. Any idea why it doesn't!!!!!

In Excel version 16.17, when you click on "Save as" it adds "Copy of" to the filename. In all previous versions, it never did this. Please remove the "Copy of" in the next release of Excel for MAC.

Another new glitch. Having created a formatted graph to my liking, I expect that copying the graph and changing only the cell addresses for the data (in Select Data) for a new graph, will not change the formatting. But no, the line and marker formats change. What a pain. Annoying but OK to re-format if only 1 graph but I am preparing a report with more than 30 graphs. What a time waste.

Please make same function excel for mac and window users so that we could be easy to use and command or shortcut key also be same.

PivotTable and PivotChart Wizard works well on Windows. It is important to analyze data. I am sure most us our missing it

This morning, as I was reading through the news on my Mac, Excel began to start itself randomly. I thought it might be time for an update, so I downloaded and install 2, but it still starts itself repeatedly. Quitting the program does not help, it just starts back up. The only way I can stop this is to minimize the window and park it in the Dock.