Forum Discussion
100WattWalrus
Dec 07, 2016Copper Contributor
BUG — In Excel 2016 for Mac, can't change column width or row height on groups of tabs
In Excel 2016 for Mac (Office 365), if you SHIFT-click or CMD-click on multiple tabs to select more than one at once, any changes you make when sheets are “grouped” like that shouldaffect every sheet in the “group.” But while you can enter content into cells and change their formatting (text color and alignment, cell color, category) and have those changes appear on all the tabs in the group, when you change the width of a column or height of a row, the change happens only on the sheet where you make the change.
Here's a video in which I demo the bug: https://youtu.be/xy80PAdAVgI
(for some reason this video apparently won't play in Safari, but works fine in Chrome, go figure)
Here are the steps to reproduce:
1) Open a new Excel spreadsheet and give it 3 sheets (the third is a control)
2) Select Sheet1 and Sheet2 in a group
3) Type anything in any cell in Sheet1
RESULT: Whatever you typed in that cell appears in the same cell on Sheet2
4) Make sure you still have Sheet1 and Sheet2 grouped, then…
5) In the same cell on Sheet1 as before, change the cell color, change the text to a number, make it bold, then change the Category/format to Currency
RESULT: All those changes appear on both Sheet1 and Sheet2
6) Make sure you still have Sheet1 and Sheet2 grouped, then…
7) On Sheet1, change the width of a column, and change the height of a row
RESULT: These column- and row-size changes appear only on Sheet1. Sheet2 is unaffected.
- Freya Hoppe
Microsoft
Hi, thanks so much for looping me in. Can you please post this over on Answers.Microsoft.com? That's our Support forum. We have agents there who can help troubleshoot. Also, other people can "me-too" it if they experience the same issue.
Before you post, can you please check for updates and then see if the problem persists in the latest release? When you post, can you please include the exact version and build number?
Thank you!!!
Freya
- Olaf HubelFormer Employee
Adding Freya Hoppe as FYI.
Submitting bugs is best done at https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac
That is where we provide support, this forum is for discussions.
But Freya Hoppe is the right person to alert about this. So you should be good.
Thanks for the feedback.
Olaf