In Excel 2013, when you click on Find and Replace, the dialog box that is opened don't let you click on the Find What text box for the 1st time (the cursor mouse isn't showed). You can enter the text you want to find, but you can't click there.

Bring back solid support for SAVING in dBase (DBF) format. The old DBF save format by Excel failed in many areas. However, following some simple, basic guidelines (e.g. set column width equal to the largest data in that column, set column headers according to simple guidelines, etc.),

I could MANUALLY get it to work well every time. Why Excel could not programmatically do what I could do manually was always beyond me. Even worse, why that TOOK OUT the ability to save in DBF format is a show stopper. :-(

STOP!

I would like to see more font control, or manipulation, in Excel as we see in Microsoft.

Add Median Value to Pivot Tables in Excel 2013

today, My excel 2016 32bit lost some new 6 functions like "ifs" & "switch" & "maxifs" after upgrade from v16.0.6568.2025 to v16.0.6868.2048, what is happen ?

During the time used version 16.0.6568.2025 of excel2016 , the all functions are fine, such as [textjoin, concat, ifs, switch, maxifs, minifs],
anyone can help me?

Excel 2016 would make ooxml more attractive if it included an image of the new chart types.

Word and Powerpoint include this image of new chart types (e.g. word/media/image1.png) , but Excel does not. This means that implementers of ooxml interpreters have to interpret the new chart data, styles, etc. right away.

When clicking on "Data Labels" in the Power View Map, can we get the numbers instead of the State names or abbreviations?

In the review tab there is a button to Share your workbook. Unfortunately it does not work if you have a table in the workbook (there is an FYI if you hoover over the button). Question: why does this not work for workbooks with tables? I use tables all the time and most of my files are used by several people.

After creating a 1d or 2d listbox in a userform, I would like to be able to format the background or foreground color of each item; or change the text color and bold it base on some criteria. Essentially; treat the listbox items as if each item row and column like a cell in excel. Highlight a whole row or column if possible, or bold the line.

It is well known that the macro recorder does not produce code that anyone should ever write themselves. For example, this recorded macro...

Sheets("Sheet1").Select
Range("A1").Select
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste

...can be simplified to this...

Sheets("Sheet1").Range("A1").Copy Sheets("Sheet2").Range("A1")

Since selection-ridden code is longer than necessary and inefficient while running, and since people rarely need their selections to be tracked, I feel that the macro recorder should skip selections entirely.

Of course, if the selection triggers an event, such as Worksheet_Change, then the event handler (if any) can be called directly instead.

In Internet Explorer Alt+Enter for a new line is already a short cut to make the window full screen which can't be disabled. This is very annoying. Please fix.

May I suggest that those cells involving formulas be defaulted to the General format instead of being formatted as numbers with only 2 decimals and with a comma. Because I think it wouldn’t be as much accurate to have to automatically see only 2 decimal places in producing values from formulas.

When you try to explain how the VLOOKUP formula works to users the last argument asks for either True or False. However, when you use the MATCH formula the last argument asks for -1, 0 or 1.

Can we align the logic? Also, 99% of the time people are looking for an exact match so can you please make that the default when omitted?

COUNTIFS can do exactly what COUNTIF does and more. The only disadvantages are writing the extra "S" and possibly a negligible hit in performance due to COUNTIFS using variable-length argument lists. My suggestion is to make COUNTIF work like COUNTIFS and make COUNTIFS a compatibility function.

I can't say the same for SUMIF and AVERAGEIF, since these functions allow the omission of their last argument, which can be a nice perk over their -IFS counterparts on the (very) rare occasion.

Formula accuracy degrades when referencing letters. When a formula reference several columns (say A through D:D) the formula breaks consistency in different places once in the double letters or further. I believe due to faults in text search ability.

It would be nice to have a chance to add a picture describing better ideas posted on this forum.
There is a sentence that pictures says more than 1000 words and often ideas may be misunderstood if there in a chance to draw the idea. .