Notes and Comments: the Dutch ribbon menu now shows both under the same name of 'Opmerkingen' (the former name for the 'old' comment. The main ribbon menu item 'Controleren' (Control) now has two sub-blocks both named 'Opmerkingen', the 1rst has 5 optional choices and gives the new 'Notes', the 2nd has one option and gives the 'old' comments. Suggest to give them different names, and in addition to bring back the right-click option to directly insert a comment into a cell (most users will only need that and not the more complicated Notes option as they have no need for it).

Add the ability to create "layers" of formatting. This would work like such:
* Each sheet would have formatting layers, starting with the "default" normal formatting.
* A user could add a formatting layer to a sheet. This new layer can contain unique formatting that does not interfere with other layers.
* Layers would have the ability to be turned on/off.
* On: Formatting is visible
* Off: Formatting is hidden
* A single layer is "active" at any time, the active layer is where formatting changes are applied to.
* Layers have a "stack" order/precedence, like clear plastic sheets stacked on-top covering each other. You would only see the formatting in a cell from the "most-on-top".

This would allow users to keep track of one set of data, either with conditional formatting or manual formatting, in different contexts without interfering with or over-writing other contexts.

I have an xlsm file on a local folder, synchronized with Onedrive business. It seems that quite often (sometimes twice a day) it may brake a file, so it cannot be saved (Excel doen't responce for infinite time).

At the same time autosaving file, placed in a folder synchronized with OD, takes more than 10 seconds, according to the message in Title of Excel window. So it's almost impossible to catch a moment when a file cannot be saved - I cannot wait every time to the end of saving process.

So it would be great to save a file in the local folder (which takes a fraction of second), making sure that it is not broken, and then synchronize it with Onedrive.

A basic, but sophisticated, feature that seems to be seldom discussed is that of 3-D cells with layered functionality. This could lead to some incredible improvements in effective, simplified worksheet design. The functionality would not be unlike the 'Conditional Formatting' features as they apply to formatting of cells. It would also extend beyond what can be done with 'Data Validation'. For example:

A user enters a number in a cell and the corresponding weekday name is displayed rather than the number, enter an employee name and their phone number is displayed, enter square feet and the cell displays the result in acreage, put in a dollar value and a calculated percentage or message is displayed.

In other words, a single cell could contain a formula, the input, and the result all in the same cell. The user could assign the cell to display either the result, data, or formula as desired. Hovering over the cell might also displayed the underlying un-displayed contents of the cell.

In some cases the user may want to see these items displayed in separate cells, but in other cases, such as when dealing with conversions, for example, the user may want the input to be in a standard unit, but displayed in another unit of measure.

The implications of this feature would be limitless. Many will find unique, useful implementations of this feature in their industry as they ponder the possibilities.

PROBLEM: We often have tables (not always defined as a formal table range) that include horizontally merged cells within a row. On occasion, we need to delete a block of cells from the center of the table where the merged rows span over the cells being deleted. This operation cannot be performed because we cannot specifically select the block of cells we want to delete.

GLITCH: When a block selection includes horizontally merged cells, the selection is forced to expand to included the full width of any merged cells included in the range. This, in turn, forces a widened selection that includes cells in the selection, to the left and right, that we do not want to edit or delete.

RAMIFICATIONS: We cannot physically select the desired block of cells, therefore, we cannot edit or delete the desired cells. This is an insane frustration, evidenced by the may questions on the internet regarding this behavior. Ironically, the user can properly delete complete rows or columns that intersect a range of merged cells

SOLUTION: When a range selection is made treat all cells within a merged range as individual cells so the user can select single rows or columns that extend through the merged cell. This would suffice in most cases, but obviously could become complicated when the user changes the width of columns for rows outside the merged group because the merged cells widths then may not match the width of surrounding cells. This is a problem for another day, since the width of merged cells should also change similar to the surrounding cells when included in the selection, but they do not. On this count, there should also be a feature that allows the user to subdivide a merge cell into individual cells that match the width (or height) of the surrounding cells when surrounding cells are edited.

PROBLEM: We continually face a problem with sorting tables (Excel and Word) if we employ two or more rows for the column headings in the table.

DISCUSSION: First, it is not uncommon for tables to have headings of two or more rows. Often the first row includes labels that group the sub-labels in the second row and so on. However, we cannot create such headings because they disrupt the sort feature used with tables. Second, the visual or printed headings may not be conducive to the sort feature.

As such, the user often has to use workarounds where multi-row column headings must lie outside of the table in order to not 'disrupt' the sort feature. The downside is that the column label headers no longer respond to the modifications made within the table, such as table moves or columns size adjustments.

Apparently, Word and Excel tables can only sort by a one row header, and the user has no way to instruct the program which of the header rows include the unique column headings. Furthermore, the column headings have to be unique, which often conflicts with the user's desired visual implementation of column headings. For example, the headings may have two sections visually designated in row 1, with the same subsection labels used for both sections shown in row 2. As such, neither row includes truly unique labels for each column; something necessary for a sort operation.

SOLUTION: In our opinion, the best solution would be to allow users to create multiple row column headings, but then allow the user to designate which row contains the unique column headings for a sort operation. This way the user can have the visual headings that they want printed at the top of the table and the top of split pages, but also include a hidden row with unique names used only in the sort operation.
Perhaps we have overlooked some other features, so would appreciate anyone's suggestions in this regard.