It would be very helpful to have the ability to edit custom controls using VBA (such as in Project with method SetCustomUI(CustomUIXML)). Sometimes it is necessary to add or remove controls (nut just show and hide).
Thanks!

Ctrl-x offers only one paste option
Ctrl-V enables multiple pasteoptions
Please also makes for Crtl-x the same Paste Options available.

Setting an image as Background automatically tiles it across the entire workbook. Would be nice to have the option to not tile it and have the image appear only once in the top left corner.

VLOOKUP already support table names (if formatted as tables) column name... simply, make VLOOKUP accept not only a column INDEX but also a column NAME, e.g.

VLOOKUP(A1, [Orders], [OrderDate], false)

SUM is in the Maths & Trig category

but

AVERAGE, COUNT, MIN and MAX are in the Statistical category

My suggestion is to move these functions to the Maths & Trig category.

Here are some reasons why:
1 - The AGGREGATE and SUBTOTAL functions are in the Maths & Trig category
2 - There is a dedicated Maths & Trig drop-down on the FORMULAS tab so they can be found easily

Instead of =LEFT(CELL("filename"),FIND("[",CELL("filename"))-1) return path of current worksheet.

Also: Make arguments universal between different language packs

Add Excel REPL - code and see results in place:

1. modify/create sheets


2. modify/create charts


3. import/export data


4. integration with macros


5. html output window


6. widgets

Until Excel 2003 the Pivot Table Wizard asked the user if he/she would like to keep the new pivot table independent from the others (separated data cache). This allowed i.e. to create different groupings on the same field. Starting from Excel 2007 this option has disappeared from the pivot creation gui interface. Please re-add it.

It would be great if there was some way for preferences to save a setting to specify printing individual worksheets as either single- or double-sided.

Selecting All Sheets & Editing/Formatting First Sheet Then All Selected Sheets Copying The Format Which We Are Formatting In First Sheet

Since Excel 10, the precision of placed objects like lines on charts has deteriorated. For example, drawing a 45 degree line on a chart from one corner to the other is very imprecise because it seems the cursor has trouble picking up the correct pixel in the chart axes corner. Sometimes the chart has to be resized to nail the placement down.

Make scatterplot data plot points into objects that can be selected with the mouse in order to remove them from a regression or move them to another series.

When you create a macro and send the workbook to other users, unless they have their settings such that they can run a macro, you need to give them special instructions so that the macro runs.
Surely, there must be a way to send a workbook with a macro in it to someone without having to tell them to change their security settings which often causes them to think they're doing something to put them at risk.

Please give users ability to turn off animations when cell is selected. This is annoying and there is no way to turn this off.

STDEVIFS formula similar to AVERAGEIFS. Thanks

Currently the regression output only includes the label for the X range. It would be helpful if the Y-range label would also be included.

For some unknown reason, excel chart always flips my data so that the first data point is at the bottom of the y axis. As a result, I always have to select 'reverse order' so that the data appears in the order that I type it. Annoying, but not a major problem. However, the x-axis title is now always at the top, and there is no option to select 'high' to place it at the bottom of the chart.

When you go to the "move or copy" tab icon, it would be easier if that drop down list included the highlights that I've added to each tab.

Black borders are ugly and take attention away from the data in tables. I would like to be able to switch the default border color to gray, but I can’t do that either at the workbook or the sheet level. This means that I have to manually change the border color or paste formatting every time I add borders.

I’ve tried setting preferences in the Workbook and Worksheet templates in the XLStart folder, but the border preference does not stick.

This is not to be confused with the default gridline color, which can be set in the Advanced Excel option.