What I would like to see in Excel 2016

[Taul]

I'd like to see

• conditional formatting revert back to the basic three options (such as in Excel 2003)
• pivot tables revert back to Excel 2003
• simpler data connections (so more users can do this easier,though it is OK for me as is) for queries & pivot tables
• simpler queries and database-like functionality - so users wouldn't need formulas for things like INDEX/MATCH or multiple lookups, and also users could avoid array formulas. Array formulas IMO are the biggest mess in Excel ATM
• database like reporting. So from a query or table in Excel one could go straight to an Access type report. This did exist ~20 years ago but was removed
• menu structure revert to Excel 2003 style
• print preview revert to Excel 2003
• removal of merged cells functionality!
• data forms like Access forms with their simple, powerful & handy built-in filtering, sorting, etc

Or from another perspective, revert Excel back to Excel 2003 specifications & leave it there (including lower row & column limits), develop Access (wizards or whatever it takes) so that it is easier for spreadsheet users to transition to databases.

While you're at it, remove the ribbon

 

[Peter_SSs]

I'd like to see

• print preview revert to Excel 2003

For this one, just pop the 'Print Preview Full Screen' icon/command onto your Quick Access Toolbar.

 

[Fazza]

For this one, just pop the 'Print Preview Full Screen' icon/command onto your Quick Access Toolbar.

Thank you, Peter. I don't yet know/use Quick Access Toolbar. Or other toolbars. Just keyboard shortcuts - as much as possible anyway. I'll investigate the Quick Access Toolbar.

 

[mfexcel]

For this, I will use "Clear Filter From..." to show all.

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.

 

[mfexcel]

Didn't know that. It's really good to know it. Thanks.

For this one, just pop the 'Print Preview Full Screen' icon/command onto your Quick Access Toolbar.

 

[Peter_SSs]

Thank you, Peter. I don't yet know/use Quick Access Toolbar. Or other toolbars. Just keyboard shortcuts - as much as possible anyway. I'll investigate the Quick Access Toolbar.

If you want to use a keyboard shortcut (I'm more a mouse user as my keyboard skills are poor) then add the command to the QAT as I described & move it high in the list (in the top 9 is best for frequently used items), say to position 3 on the QAT. The keyboard shortcut then will be Alt-3.

If you have more than 9 items on the QAT then they will be assigned slightly longer shortcuts (eg Alt-0C), but in a pattern. To see the keystrokes that go with the Alt, just press the Alt key and look at the QAT.

 

[Peter_SSs]

For this, I will use "Clear Filter From..." to show all.

Thanks, yes, I eventually tweaked to that.

 

[DocAElstein]

Wot I would like to see:
. An extra argument option in the Advanced Filter, (argument:- unique) , that is to say instead of just Unique an additional UniqueWithoutHeadings
. It catches a lot of people out that this Method applied to a Column of data filters starting at the second row, and simply copies the first row a s a heading to the filtered data column. ( http://www.mrexcel.com/forum/excel-...d-filter-unique-values-only.html?#post3920344 ). If you did not know that (as I did not yesterday!) you could think the copied heading is just a filtered unique piece of data!! Of course as a beginner I may be wrong and there is such an optional argument? – anyone knows about that?)
Alan

 

[gsistek]

-The ability to resize the 'Evaluate Formula' window.
-The ability to more easily determine formats of conditionally formatted cells (especially via VBA)

 

[RoryA]

-The ability to more easily determine formats of conditionally formatted cells (especially via VBA)

That's already here with the DisplayFormat introduced in 2010.