The last update destroyed the grid lines. Automatic color for grid lines in active sheet is alway white. I have to change it to grey in every document!1 vote
We didn’t make any changes to gridlines, so probably what happened is that they got inadvertently set to white on your machine. To change them to the default (for all new workbooks):
1. Start Excel
2. Go to Excel > Preferences > View > Show in workbook
3. Make sure that “Gridlines” is checked, and that the drop down there is set to “Automatic”
Hope that helps. In the future, a better pace for this type of question is the answers.microsoft.com site (you can post in the Mac Excel area)
I am having issues selecting and highlighting blank cells in a workbook. There is a new feature I believe where if I start to select the data the Cmd + Shift + Arrows works properly and has a bit of an auto stop, so it recognizes where the data ends, however, if I want to select any blank cells beyond that data, it will not move. I have to hand select these cells and use the scroll. There are times where I want to remove formatting in the blank area that has been applied to the blank cells until the end of the workbook, however, I can't auto select all of the cells because it's not a part of data.
(Edited by Dan [MS] on June 16, 2016 - moved from Windows Desktop to Mac area of UserVoice)
I am having issues selecting and highlighting blank cells in a workbook. There is a new feature I believe where if I start to select the data the Cmd + Shift + Arrows works properly and has a bit of an auto stop, so it recognizes where the data ends, however, if I want to select any blank cells beyond that data, it will not move. I have to hand select these cells and use the scroll. There are times where I want to remove formatting in the blank area that has been applied to the blank cells until the…1 vote
To select empty cells, you just want to hold down the shift key as you press arrows. The ctrl key will jump to the next cell with data (or the end of the row/column if there’s no more data there)
Hope that helps. If you’ve got more questions in this space, head on over to the Excel forum at http://answers.microsoft.com where there are experts to help.
I use both the Mac(mainly) and sometimes Windows 10 PC. I would like to use Excel on both machines with one license.5 votes
It would be a lot more efficient if there was a simple Printer icon in the Quick access toolbar of Excel.7 votes
Just click on the dropdown list in the Quick Access toolbar and select Print to make the icon stay in the toolbar.
- In Windows Excell you can search for data in one tab or in all tabs in the workbook.
In Mac Excel the functionality exists to search for the positioned to tab only.
To search all, user will have to select each tab and search on that tab.
If you have 255 tabs, you have to repeat that search 255 times.
That is an inconsistent functionality.
- In Windows Excel, user can utilise keyboard to toggle between several open workbooks. In Mac excel, user cannot do same.
Thanks for posting this suggestion. This request is already supported in Excel for Mac. You can search the workbook and if you click Next/Previous in the search field, it will take you to the sheets where the search result is found. You can also go to Edit > Find > Find…, and choose the option to find “Within” the workbook or the sheet.
With regard to switching between open workbooks, you can press CMD + ` (the key above the TAB key on US keyboard). This switches between windows in Excel.
Steve K [Microsoft Excel]
Excel for Windows allows you to disable this function.
Most users don't need the GetPivotData function and keep forgeting that the behavior of Pivot Table cells is different: you have to erase the function, carefully find out which column and row belong to the cell and manually type them in: Time wasted aplenty plus frustration74 votes
Just as in Excel for Windows, the “Generate GetPivotData” option is a mode that you can turn on or off. It affects the behavior of what happens when you’re creating a formula and you select a cell in a PivotTable to create a reference to it. If you enable the Generate GetPivotData option, it will create a formula that will calculate the value of the PivotTable cell. If you disable the Generate GetPivotData option, it will create a plain reference to the cell.
This option is not a setting for each PivotTable. It is an application setting that you can turn on or off at any time.
To enable/disable the Generate GetPivotData option, select a cell in any PivotTable, then click PivotTable Analyze > Options, and then check or uncheck the option.
In previous versions, you were able to rearrange the order in which series appeared in a chart or graph by reordering them in the "Select Data source" box. There doesn't appear to be a way to change the order of series without just recreating it in a different order.51 votes
This is already supported. In the Change Data Source dialog, you can select the series, and then you can click the up and down arrows to change the order as desired.
Thanks – Steve K [MS Excel]
If I want to select all the rows from a certain row, I can no long use command+shift+ [down arrow] to select rest of the rows. the selection does not move at all. (The purpose is that I want to hide all the rows below a certain row)
The same goes for column selection too.
Can you please tell me how to do it in Excel for mac?24 votes
Please find all the keyboard shortcuts here – https://support.office.com/en-us/article/Keyboard-shortcuts-in-Excel-2016-for-Mac-acf5419e-1f87-444d-962f-4e951a658ccd#bkmk_movescroll
Note that in some cases, a key combination may be used by Mac OS for some purpose and therefore not work as expected in Excel. An example is when you have more than one keyboard input source added to your Mac, and then press CTRL+Space, it may switch input sources rather than selecting the entire column. You can turn off this shortcut in the Keyboard preferences > Shortcuts > Input Sources of your Mac so that the key combination will work as expected in Excel.
Need the ability to turn off Glide/Cell animation.
There is a glitch in the Formula Bar when changing formulas (cursor position off when clicking)
The "transpose" in paste special has been removed.
You can no longer paste from one excel file into the cell of another file with a formula already in there.4 votes
A couple of these items already have other UserVoice ideas to cover them:
For the other items – those are better issues to raise on answers.microsoft.com, since they are bugs rather than new feature ideas.
In the Excel for Mac 2011 version you could link a chart title to a spreadsheet cell. Chart title would update if content of spreadsheet changed. While this still works in existing files you cannot link chart titles in Excel for Mac 2016 to spreadsheet cells. – Pls enable again. Data input field is grayed out…8 votes
This functionality is still supported in Excel for Mac 2016. Please reply back if you continue to have problems.
- Don't see your idea?