Excel for Windows (Desktop Application)
Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve.
Take a look at the feedback that we are currently working on and what feedback we have already completed.
-
Sorting and calculation in Myanmar fonts
I used a lot of Myanmar text in Excel and other office applications. Myanmar fonts are coded from U1000 to U109F in Unicode system. My major concern is I cannot sort the cells with Myanmar text properly. And calculation formula doesn't work with Myanmar digits. I checked with Thai language and sorting and calculation are working well. Could you please improve these functions for Myanmar language as well?
1 vote -
Add the "Change Case" tool like Word 2016 & earlier has.
I would love it if excel 2016 had the "Change Case" tool like Word 2016 does under the font section of the Home Tab
1 vote -
Paste to Non-Contiguous Cells
When I hold the [CTRL] key I can load the clipboard by selecting cells in non-contiguous areas.
It would be nice to be able to paste to non-contiguous cells also.1 vote -
when I copy and paste the whole column with some hidden rows in between, I want the excel can copy the same columns with the hidden rows too
when I copy and paste the whole column with some hidden rows in between, I want the excel can copy the same columns with the hidden rows too.
1 vote -
Single Ribbon for multiple workbooks open at same time
I often have multiple workbooks open on the same screen. On 2010 and before, this was no problem as I had macros with keyboard shortcuts to have the books assume the top or bottom half. In later versions, Excel addressed this with multiple windows. The idea is great but could be executed better. The main problem is multiple ribbons showing for multiple workbooks. If I'm working on a single monitor and want details on the top and bottom half, about 1/3 of the space is taken up by the ribbon. Of course, I can collapse the ribbon but it takes…
1 vote -
PLEASE ADD WEBSERVICE FUNCTION FOR EXCEL ON MAC
WEBSERVICE FUNCTION IS A MAJOR MISSING FUNCTION ON EXCEL FOR THE MAC
1 vote -
More functions to work with 3-D references
Far too few formulae work with 3-D references. I don't see why CHOOSE or INDEX shouldn't when SMALL and LARGE do...
Surely anyone with 3D data tables spread across tabs has to use indirect() to reference data from separate tabs, which is volatile. It makes manual calculation mode a given, as it's volatile. (Please correct me if I'm wrong)
In theory, INDEX MATCH should work, but neither of these 2 do:
=INDEX('Sheet1:Sheet12'!A1, 3)
=MATCH("lookup value",'Sheet1:Sheet12'!A1)
Could they be made to? It'd be logical.
For a second I thought ADDRESS(1,1,1,1,"Sheet2") was my answer, but it only works if it's INDIRECT(ADDRESS(1,1,1,1,"Sheet2")), so…
1 vote -
Non volatile lookup across tabs
Far too few formulae work with 3-D references. I don't see why CHOOSE or INDEX shouldn't when SMALL and LARGE do...
Surely anyone with 3D data tables spread across tabs has to use indirect() to reference data from separate tabs, which is volatile. It makes manual calculation mode a given, as it's volatile. (Please correct me if I'm wrong)
In theory, INDEX MATCH should work, but neither of these 2 do:
=INDEX('Sheet1:Sheet12'!A1, 3)
=MATCH("lookup value",'Sheet1:Sheet12'!A1)
Could they be made to? It'd be logical.
For a second I thought ADDRESS(1,1,1,1,"Sheet2") was my answer, but it only works if it's INDIRECT(ADDRESS(1,1,1,1,"Sheet2")), so…
1 vote -
Move or Copy Tab Function
Instead of having the (move to end) function at the bottom of the list, either move it to the top, or perhaps create a check box for this function and place I under the existing Create a Copy check box
1 vote -
auto international scheduling for the rotational staff
I want a template that if i enter an offs for the a employee it should automatically calculate that when should be his next off and which employee should replace him. and who else can get the off.
like for example if employee A is working i put his 4 offs in a cell so it should show me what will be his next off and how can employee B can replace him
1 vote -
Execution error
when you scroll the mouse button over the grouping filter at the top or bottom, Excel hangs and shuts down by restarting the application.
1 vote -
Stop changing the way to use it!
Stop changing it all the time. I can't find how to add in a line the format auto erased. I used to be able to click on a grid icon after highlighting the two or more spaces I needed to add lines back in, and now I can't find that function at all. It's buried somewhere in all the new stuff I don't use. Please tell me how to put this line back in via my email below.
Also, delete the erase function for lines when cutting text to move elsewhere. Leave the line there. That's a bug.
1 vote -
Office Open XML format - Excel 2016 64-bit bug
The file properties issue is partly fixed (for Word files) on the Office 64-bit version build 16.0.8518.1000 or 16.0.8530.1000 or 16.0.8431.2079. For Excel 2016 (64-bit) the file properties bug is still not fixed for the file formats .xlsx .xlsb and .xlsm. You will get an interface error 0x80004002, see screenshot.
1 vote -
Version number Forms3 not fully visible in VBA (bug)
If you go to <Help> -> <Info> in VBA the Forms3 version buildnumber is not complete, see screenshot below.
The last digit '6' is missing in this case, see screenshot 1. It should be: 'Forms3: 16.0.7571.7046'
The Info box form should be stretched a bit on the right-side, so that the last digit is visible, see screenshot 2.1 vote -
Recording macro gives Run-time error '9' Subscript out of range when it is runned (bug in recording macro)
I want to copy an existing sheet, rename it, and make the tab color of the new sheet "No Color". I've recorded a macro to do this, but when I run it, it errors. Run-time error '9' Subscript out of range. Debug highlights this line: .ColorIndex = xlAutomatic
The macro runs fine when this line is changed manually to:
.ColorIndex = xlColorIndexNoneThis bug exists in all Excel versions.
1 vote -
Bug Fix Needed: Data Labels - Value From Cells - Text Not Updating
When using the new Value From Cells option for data labels in an XY Scatter chart, if the range you select for the Value From Cells contains any BLANK cells and then you save the file and close the file ... when you re-open the file and try to edit the blank cells to add data labels to the chart, the data labels remain blank. Normally, you can edit the cells to edit the data label text and the data label text updates immediately.
Current Work-Around: (1) Go to Format Data Labels (2) Click on the Reset Label Text button…
1 vote -
Set a more complete default.
Unless I am missing something, I am limited to what I can set as a default from one workbook to the next. Most of my work involves similar formatting. I would like to be able to set the default to include not only font and margin, but also cell size and positioning ... but why stop there. I should really be able to set any desired feature as a default for all subsequent workbooks (if I so chose) and personalize from there.
1 vote -
alternating ranges used in various formulae (ie to sum every third row =SUM( alt( 3, a1:a100) )
It would be nice to have a simple way to express ranges that miss out a regular arrangement of irrelevant cells between the start and end point of the range.
e.g. rather than having to manually enter
(a5,a10,a15,a20,a25,a30,a35,a40,a45,a50)
instead i could use ALT(5,a5:a50)
VERY USEFUL where data for relevant calculation is interspersed with titles or cumulative totals or whatever
modified ranges (or bespoke arrays) expressed in this way could then be used within all sorts of other formulae
e.g
index(ALT(2,a1:g1),match(b1,alt(3,d2:d14,0))
rather than
index((a1,c1,e1,g1,i1,k1,m1,o1,q1),match(b1,(d2,d5,d8,d11,d14),0))
which would not only save time and effort, but also allow some new things to be achieved…
1 vote -
Filtering
I work extensively in Excel, and run across a couple of things that I believe would be better served if they were rearranged.
1) Filters:
A. My primary idea for this is to move the “Blanks” check box to the top of the list. I often wish to filter only the blanks, and find it a little aggravating to have to scroll to the bottom of the list to select this.
B. The ability to filter non-adjacent columns.
C. The ability to create a custom filter that could include multiple columns of data simultaneously.
2 votes -
Position exact coordinate of a text box.
In the Excel we need to position a text box but there is exact coordinate of box postioning. Add in a feature so that exact position put in.
1 vote
- Don't see your idea?