In Windows 10 there seems to be a feature, still under development called Windows Sets. https://www.howtogeek.com/352109/how-to-use-sets-in-windows-10-to-organize-apps-into-tabs/
While MS pulled this feature from the latest public builds of Windows 10, it looks like it’s not dead, but sleeping, due to make a comeback once issues have been ironed out. https://www.theinquirer.net/inquirer/news/3081852/windows-10-sets-coming-back-rumour

If this is the case then it would be the perfect way to bring make MDI like functionality to Excel for those users who miss it. Certainly from a Excel custom Application perspective MDI windows worked very well.

It would be great to have a setting in a future version of Excel such that by default Excel would tab all the Windows together that made up each process. This would nearly give the effect of an MDI application, as the key issue for some Excel Applications is determining which Excel Windows belong to which Excel process.

Hi

See screenshot. I'm in a cell with the value 26 112. I want to know if this is casual wages or PAYE and it's not obvious, I have to strain my eye a bit and make sure I follow the cells correctly. Same thing if I want to see other numbers in the same column as the 26 112. If I want to see a number that's15 rows up on the same column, if there's a lot of data, it's really difficult to follow.

So, it would be great if you had a view that highlights all info in the row and column your cursor is in - like the screenshot, maybe a light colour background change, just to help put numbers in context - my yellow highlight is too bright, light grey will be fine

This will save time of thousands of accountants worldwide!

We like to open the main Excel window in the same position on our desktop each time. The only way we can do this is to assure that the last closed window was in the desired location when closed. This is because new windows open in the same size and position as the last closed window.

The problem arises when you open multiple worksheets, which automatically arrange themselves or are moved by the user to other temporary locations. Closing any of these windows last sets a new undesired default for the next session of Excel.

Another problem is that t user cannot open Excel in the last saved size and position if the last resized window triggered the Windows snap feature. While the snap feature is wonderful for quickly organizing temporary windows at full, half, and quarter screen sizes, it interferes with other screen sizing operations.

The reason this happens is because the auto-size snap option triggers whenever any window border extends to the very bottom of the screen, which forces that window setting to be a temporary setting, not saved as the last size and position. While the auto features are great for half and quarter screen arrangements, it prevents centered windows from being save as a default.

For example, if you resize an Excel window to be full screen height, but narrower than the screen, then this window will not be saved at the last desired size and position. One reason for desiring such a configuration, would be to leave an exposed area of desktop on the left of a window for quickly accessing other frequently used icons or tools on the desktop.

Why not let the user save a preferred size and position for their primary Excel window? It might also include an option to apply this configuration to either to the first opened Excel window or even all new opened worksheets without auto-tiling. This would let the user customize a consistent behavior for opening Excel windows that would be more intuitive to their work environment and habits.

Protected and hidden content in an excel file is visible when opening in a smartphone (iPhone 5s), ipad 2

Steps 1: Excel file was created with few columns hidden and worksheet was protected.

Step 2: File was sent through email

Step 3: File was open through the email, in a smart phone and also in ipad.

Output: The file showed the hidden content. Luckily, the file was verified before sending to public.

Hidden content doesn't fully work with all devices.

It works perfect where microsoft office is installed. If microsoft office ios not there in any device the system somehow gets the data and displays even though the info is hidden. This doesn't protect the way it should be.