Feedback by UserVoice

Excel for Windows (Desktop Application)

Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

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. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.


  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Be able to use CSV as live datasource / database

    There are several users editing a CSV file (it's easier, no license required, etc). I want to have a spreadsheet which will automatically load the CSV when I start Excell, populate the spreadsheet and update all the formulas. I will not change the CSV format, and it would be better to not re-import the CSV everytime. For example: all employees enter the time start and time end in the CSV. At the end ot the week, I start my spreadsheet and without any additional click, I see how much do I have to pay.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    Here are the steps to get an automatic refresh from the csv file:
    •From a blank workbook select “From Text” in the “Get External Data” section of the Data tab
    •Use the Text Import Wizard to set how your csv file will be imported.
    •After you select Finish to exit the Import Wizard, a dialog box titled Import Text will come up.
    •Select the Properties button on this dialog box.
    •An External Data Range Properties box will come up.
    •In the Refresh Control section of the box, you should uncheck the “Prompt for file name on refresh” selection, set the frequency of refresh in minutes, and make sure there will be a refresh when you open the workbook.

    You can return to the Properties box anytime by either right-clicking on the imported data in the worksheet or selecting “Connections” from the Data tab.

    Cheers,
    Dan [MS]

  2. Allow text font attribuates (bold, italics, underlines, superscipt, etc.) to be changed by Ctrl+... when editing graph title, axis labels, e

    When editing a cell contents, a graph title, graph axis, etc., it would save time if we could change the font attributes of the selected text (bold, italics, etc.) by a Ctrl+... key combination, instead of going through popup menu > Font > dialog > OK button.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  3. money in excel - Add Credit Karma Savings

    Connecting Credit Karma Savings #moneyinexcel

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Hi, 

    Thank you for taking the time to send this feature request! I agree that adding Credit Karma Savings institution would be useful. I’ll share your feedback with the rest of the Money in Excel team and notate this ticket to update you when we have more information about this issue. 

    Please feel free to reach out again with more feedback or if we can provide additional assistance. 

    Thank you for using Money in Excel! 

    Best,

    Prakhar Garg
    The Microsoft team

  4. Don't autocorrect if you can't override (idiotic functionality keeps changing EHR to HER, but you can't undo like in Word or Outlook).

    Get smart like iOS on your autocorrect. If you a user deletes/overrides your autocorrection right away, leave it alone. The way the feature is implemented in Excel leaves the user no choice but to turn it off.

    Try it. Type EHR (as in Electronic Health Record) into a cell (with our without the leading single quote and watch it autocorrect to HER when you hit return or select another cell. Undo does not work (like it does in Word or Outlook).

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

    We have good news to share. In the January 2019 release of Excel for both Mac and Windows, this issue has been resolved. Once you install the update, Excel will allow you to override any autocorrection simply by going back and typing over the correction. For example, if you type “HSA” into cell A1, Excel will autocorrect it to “HAS”. If you go back and type “HSA” again in the same place, Excel will not correct it again. It will still autocorrect “HSA” if you type it into a different location, or if another autocorrection happens before you change “HAS” back to “HSA”. To summarize, Excel will no longer make the same autocorrection 2 times consecutively.

    This fix is included in Excel for Mac if you have version 16.20 or greater, and Excel for Windows if you have version 16.0.11126 or greater.

  5. removing sexist algorithms

    Please can you allow "Mrs. and Mr." to be written in excel without excel autocorrecting to "Mrs. And Mr." because the traditional rules state that the man is first. I am writing letters to donors and I always put the donor in the first position and the associated donor in the second. Excel only auto capitalizes the "and" when it is in the Mrs. and Mr. position. This is a pain that it was written into the algorithm. And sexist. Thanks.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

    We have good news to share. In the January 2019 release of Excel for both Mac and Windows, this issue has been resolved. Once you install the update, Excel will allow you to override any autocorrection simply by going back and typing over the correction. For example, if you type “Mrs. and Mr.” into cell A1, Excel will autocorrect it to “Mrs. And Mr.”. If you go back and type “and” again in the same place, Excel will not correct it again. It will still autocorrect “Mrs. And” if you type it into a different location, or if another autocorrection happens before you change “And” back to “and”. To summarize, Excel will no longer make the same autocorrection 2 times consecutively.

    This fix is included in Excel for Mac if you have version 16.20 or greater, and Excel for Windows if you have version 16.0.11126 or greater.

  6. Stop Auto correcting certain words

    Just as in Word when you type: i.e ihs, it will auto correct to "his" but it will place a little grey bar under that word that has a pull down menu allowing an option "Stop automatically correcting this word." Excel does not have that feature, must enter auto correct menu and use the exception menu to place it on the list. Change Excel to have same options as Word.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

    We have good news to share. In the January 2019 release of Excel for both Mac and Windows, this issue has been greatly improved. Once you install the update, Excel will allow you to override any autocorrection simply by going back and typing over the correction. For example, if you type “HSA” into cell A1, Excel will autocorrect it to “HAS”. If you go back and type “HSA” again in the same place, Excel will not correct it again. It will still autocorrect “HSA” if you type it into a different location, or if another autocorrection happens before you change “HAS” back to “HSA”. To summarize, Excel will no longer make the same autocorrection 2 times consecutively.

    This fix is included in Excel for Mac if you have version 16.20 or greater, and Excel for Windows if you…

  7. stupid speling correction

    hey hey hey ! what is this ! i am trying to type a name list (teh) excel change back (the) and keep changing and changing u think u fking god know what i want is it ! i HAVE NO TIME FOR TIS ****.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →

    We have good news to share. In the January 2019 release of Excel for both Mac and Windows, this issue has been resolved. Once you install the update, Excel will allow you to override any autocorrection simply by going back and typing over the correction. For example, if you type “HSA” into cell A1, Excel will autocorrect it to “HAS”. If you go back and type “HSA” again in the same place, Excel will not correct it again. It will still autocorrect “HSA” if you type it into a different location, or if another autocorrection happens before you change “HAS” back to “HSA”. To summarize, Excel will no longer make the same autocorrection 2 times consecutively.

    This fix is included in Excel for Mac if you have version 16.20 or greater, and Excel for Windows if you have version 16.0.11126 or greater.

  8. Found an error in Excel 2016 help documentation

    The results column in the help window for the index function just mirrors the formula. Looks like it's because there's an apostrophe before the formula. Not sure where to report this. Looks like it's the same for 2013 too.

    Screen shot can be found here: http://answers.microsoft.com/en-us/office/forum/office_2016-excel/found-an-error-in-excel-2016-help-documentation/410a27a3-0b3b-41c7-a99c-8fc2ff323542?tm=1472245876517

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the heads up. We’ve updated the topic, so the changes should go through shortly.

    (And thanks Smitty for making the update!)

    Cheers,
    Dan [MS]

  9. error in support page

    in the support page: https://support.office.com/it-it/article/Rilevare-gli-errori-nelle-formule-3a8acca5-1d61-4702-80e0-99a36a2822c1?ui=it-IT&rs=it-IT&ad=IT there's an error.

    in particular at the point:
    Excel visualizza questo errore quando un valore non è disponibile per una funzione o una formula.

    Se si usa una funzione come CERCA.VERT, il valore cercato ha una corrispondenza nell'intervallo di ricerca? Nella maggior parte dei casi non è così.

    Provare a usare SE.ERRORE per eliminare l'errore #N/D. In questo caso si può usare:

    =SE.ERRORE(CERCA.VERT(D2;$D$6:$E$8;2;VERO),0)

    the correct formula is:

    =SE.ERRORE(CERCA.VERT(D2;$D$6:$E$8;2;VERO);0)

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    We’re fixing this now, will likely take several days to propagate out to the internets.

    Cheers,
    Dan [MS]

  10. Allow me to submit missing Polygons in 3D Maps

    Allow me to submit missing polygons from the page that mentions it so I can get them fixed faster. 3D maps is no good if it won't show the polygons for a territory.

    https://1drv.ms/i/s!AjApVpgq6WQ0h6JwzoqyAzQ4XbnuKQ

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    You can submit feedback through the “Send a Smile” mechanism. Click on the smiley face in the upper right corner of Excel.

    Thanks,
    Scott [MSFT]

  11. Kill nested IFs

    What about a function like =ELSEIF([if1]; [then1]; [elseif2]; [then2]; [elseif3]; [then3]; ...)

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Give our new IFS and SWITCH functions a go – they are exactly what you’re looking for.

    Cheers,
    Dan [MS]

  12. Fix the 'Apply Names' bug that corrupts formulas or crashes Excel

    As already reported in

    http://answers.microsoft.com/en-us/office/forum/office2013release-excel/when-will-the-apply-names-bug-in-excel-be-fixed/0eb23d54-fbf0-4c64-8bad-cf52bc32547f?auth=1

    The Apply Names command loses parts of formulas and in certain cases Excel will crash.

    This bug is in Excel 2010 and 2013 and 2016, not in Excel 2007 or 2003.
    To reproduce this, follow these steps.

    Enter 2 in B1 and 3 in B2
    Enter =B1 in A4
    Enter =B2 in A5

    Give $B$1 the name "value1"
    Give $B$2 the name "value
    2"

    Enter the formulas below starting in B4, and then click Names > Apply Names and select both names.

    =B2/B1
    =$B$2/$B$1
    =$B$2/B1
    =B2/$B$1

    In B4 The expected result is…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    I just read through the answers.microsoft.com post that you linked to, and it appears that this is fixed in Excel 2016 build 16.0.6568.2025.

    Also, we’d like to try to keep this uservoice site for new feature ideas, rather than for bug fixes (which answers.microsoft.com is targeted at.)

    Cheers,
    Dan [MS]

  13. When filtering allow boxes on right of filter values to auto unselect all & select value

    When you are filtering a worksheet, when hitting the drop down value we get a (Select all) and a check box for each data value. Rather than having to unselect all and scroll to the items you want to check to display allow a checkbox to the right of the values to simulate the unselect all and check current item. Then continue checking items as usual if needed. Very helpful on larger data filtering.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    Unselecting all items in the filter dialog/drop down can be done with the “(Select All)” item that is checked by default — if you uncheck that, then it will unselect all of the items in the list and you can continue to select just the items you want to filter on.

    Hope that helps,
    Dan [MS]

  14. Duplicate sheet option.

    We are unable to see the duplicate sheet option like in Google Drive.
    We have the option to Delete, Rename, Hide and Unhide but not this function. We are having to used copy and paste and entered the colors every time as this is done in a weekly basic.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    You can duplicate a sheet in Windows Excel by right clicking on the sheet tab and choosing “Move or Copy…” In the dialog that pops up, select the “Create a copy” checkbox, and you should be good to go.

    Cheers,
    Dan [MS]

  15. Ribbon appearance customization

    Add way to customize the appearance of the Ribbon such as the way it looked in previous versions, tweaking/modifying them, or creating ribbon themes from scratch.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Cory,

    You can customize the ribbon under File > Options > Customize Ribbon. There, you can create new Ribbons, new Chunks for existing Ribbons, etc.

    Hope that helps,
    Dan [MS]

  16. Treemap Chart for Excel. Block size proportional by size of company within group; labels set by another column; hoverable msg.

    Wall Street Journal used to have a map of the market also called sector maps. You get there after entering the Wsj web site as follows: markets to market data to us stocks (arrow down) to market data center on right which shows stock data and sector maps. The idea, for example, is taking an industry segment for a period of time listed by company, size of company, and percent change of stock price that day. Table is treemap with blocks in proportion to size of company, each block colored by continuum based on percentage change in stock price, and…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    We recently provided a Treemap chart type as part of the Excel 2016 release. Please give that a try and let us know if it addresses your needs.

    Thanks,
    Scott [MSFT]

  17. Unhiding Column A should no longer be a usability nightmare

    Unintuitive tricks are required to unhide column A once it's been hidden. Why not provide a hover click-target that offers to reveal column A if the mouse pointer lingers up in the left edge of the header of column B? In fact, why not use such a widget to allow any hidden columns to be revealed? If I leave my mouse pointer in the column header row adjacent to a hidden column, that is what I want to do.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    We now make this much easier with Excel 2016 – there’s a special hit target if column A is hidden.

    Cheers,
    Dan [MS]

  18. Absolute Reference Shortcut

    Really simple. Pretty much in all my data analysis involves absolute references and relative references. For a formula I enter, I have to go through and manually type in the $ symbols to lock those references, which can be cumbersome when I have 15 or so references to take care of. What I suggest is a shortcut key e.g. ctrl + click/alt + click where by clicking the cell in the formula using this combination will convert it to an absolute reference.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Great news, we have this in Excel already. as you are authoring a formula, when you select a cell/range, you can press F4 to toggle the “absolute-ness” of the reference.

    cheers,
    dan [MS]

  19. Enable Excel PowerView to connect to Multidimensional SSAS cubes

    Currently Excel PowerView can only connect to a Tabular or PowerPivot model. We need the ability to connect to multidimensional cubes as well. There's a large number of customers who could leverage existing MD cubes.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  20. Grouping Dates in PivotTables

    When using a PivotTable where one of the fields is a date in either the rows or columns, Excel treats each day as its own row or column. It would be very useful to be able to group the dates and have Excel summarize the data by month, quarter, or year in the PivotTable.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Bernie,

    Kenneth’s comment (that you can do this by selecting and then grouping dates) is right on.

    Further, in Excel 2016 and later, when you create a Pivot with a Date field, Excel will automatically group for you. In that case, if you want to go back to the previous behavior, you can by following the instructions here:

    https://support.office.com/en-us/article/Turn-off-time-grouping-in-PivotTables-in-Excel-2016-for-Windows-6be5afed-348c-4db2-9f87-5ac262d67b3f?ui=en-US&rs=en-US&ad=US

    Cheers
    Dan [MS]

  • Don't see your idea?

Feedback and Knowledge Base