What I would like to see in Excel 2016

[theBardd]

Turn off 'Show items deleted from the data source' in sliders by default. Stupid setting!

Turn off Autoifit column widths on update in pivots. Stupid setting!

 

[Darren Bartrup]

Find and Replace only in cell references.
Sometimes dragging a formula over just won't give you the cell references you need, and sometimes there's a mismatch of absolute and relative references in a formula.

I want to be able to update the reference to column C to column M without my COUNTIF turning to a MOUNTIF (queue the double-entendre).

 

[RoryA]

They could just add regex support to the Find/Replace operation.

 

[AusSteelMan]

I would like to see a change to AutoFilter. I would like to see the choices "(Select All)" and "(Blanks)" either

a) Fixed, readily accessible, in the top section like "Text Filters", "Filter by Color" etc, or

b) (2nd choice) Listed at both the top and bottom of the scroll section.

I hate scrolling all the way to the bottom to take the tick off blanks, only to find there are no blanks.
Similarly, if I'm at or near the bottom of the scroll section and decide I want to show all, I'd like to be able to do so without a lot of scrolling first.

Absolutely Peter! Although it may not seem a big deal, as soon as you have a large data set scrolling all the way to the bottom to tick blanks (after foregting to untick All at the top!) just uses lots of time when repeating this task all-day.

Cheers,
Darren

 

[AusSteelMan]

A native MAXIF(s) woudl be handy as well
But then who woudl ask this question anymore...

Seconded

 

[kylefoley76]

I would like to see a vba editor that alphabetizes the declarations. I sometimes have 100 declarations and I cannot find them in the vba locals windows because there are so many of them.

 

[mfexcel]

Would be great if there is a NETWORKHOURS function.

 

[Scott Huish]

.FindAll in VBA that would return a collection you could either loop through or apply the same action to all at once.

Sub test()
Dim c As Range
Set c = Range("C:C").FindAll("findthis")
c.Copy Range("E:E")
End Sub

That would be awesome.

 

[Peter_SSs]

.FindAll in VBA ...

I'm agreeing with you too, just like I did with Rick earlier.

 

[J.Ty.]

1. Make arrays first-class citizens. At the moment I can produce an array formula which creates and handles array values, I can type {1;...;5} into a formula or make it an assigned name, but I cannot simply store such an array in a cell in a way which makes it accessible later. This would tremendously increase the power of Excel, and it is almost there.

2. Improve the formula editor in Data Validation, Conditional Formatting, etc. The present one is ridiculous.

3. Introduce sorting, duplicate removal, filtering and Text-to-Columns as array formulas, very much like Google spreadsheet does to the first three.

4. Improve data tables to let them serve as User Defined Functions, without the need to use VBA. LibreOffice is presently better than Excel in this respect.


J.Ty.