Feedback by UserVoice

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. 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. LEAVE THE **** NUMLOCK ON

    LEAVE THE **** NUMLOCK ON

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Ticket #12395436 - Excel arabic

    Hi, we experience an issue with MS Excel and the arabic language pack: User does right click on desktop and selects new Excel Workbook. New Workbook opens and first column A is on the right of the sheet and title of the sheet is arabic. If user just starts excel and creates a new workbook within excel all is working as expected, only if user selects new workbook from right click to desktop this happens. We installed the arabic language pack and this seems to affect the default template of excel.

    The same issue is already reported for Office2007 and…

    26 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  3. Allow navigating from sheet to sheet and landing in the same cell.

    Move from sheet to sheet in a workbook so that one ends up in the same cell in each sheet. In LOTUS 123 it was [SHIFT}{ALT}{PAGEUP} OR {PAGEDOWN}.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  4. Be able to use user-defined Power Query functions in Excel formulas

    Power Query has a few advantages over VBA for creating user-defined functions for use in Excel formulas:

    • Power Query produces shorter code that is faster and easier to write. This is largely thanks to Power Query native supporting tables, lists, and records; having many built-in functions to work with these data types; and supporting first-class functions and higher-order functions, which eliminates repetitive code and grants the programmer more expressive power than VBA.

    • The Power Query GUI produces code that is closer to ideal than the VBA code that the Macro Recorder produces. Power Query also shows your recorded…

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Not everything has to be a video in help!!!!!!!!!!!!!

    Improve Help. Go back to the old way!!!!!!!
    Not everything has to be a video!!!!!!!!

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  6. Microsoft Query - Some functions are not translated correctly

    There are two functions in Microsoft Query:

    "Cancel and Return to Microsoft Excel" and
    "Return Data to Microsoft Excel"

    It would be nice if these two functions were translated into the respective language.

    For example: In the German language package, these functions are in English.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  7. Toggle Relative/Absolute for Structured References

    When referencing a table column, it's cumbersome to add the additional square brackets and repeat the column name to make the reference absolute.

    It'd be great if the F4 shortcut could also work in this, so toggling
    tablename[ColName] --> tablename[[ColName]:[ColName]] --> tablename[ColName], or, when referencing the same row from within the table,
    @[ColName] --> [@[ColName]:[ColName]] --> @[ColName]

    Many thanks,

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. I want to be able to place a plus sign (+) in front of a positive number

    The plus sign is meant to amplify the positive value. So far, I have only found this formatting for negative numbers.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  9. Protecting Sheets / Workbooks with Password - can't see password

    When protecting sheets / worksheets with a password, there is no "eye" icon to display the password so you can verify that you've typed it in correctly. It would be great to have this function to help reduce errors and reduce the risk of locking yourself out of a file.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  10. restore previous versions

    excel or all microsoft applications should store previous saved documents so you can recover an older version thats been saved previously, I had a scenario where I edited a spreadsheet, saved and closed, the following day I found I had made many errors and was unable to undo and did not have any old documents saved, there should be an option to select which saved file you desire with a time and date stamp

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  11. Named conditional formatting rules

    Named conditional formatting rules - If you could name your rules they would be easier to identify. Also, it would be nice if you could right click a cell and have a choice to add it to a named conditional formatting rule. Excel would need to be intelligent enough to be able to add the cell or group of cells to the rule correctly.

    14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  12. Intelligent options for data labels in charts

    We need better options for formatting and positioning data labels in charts.

    *better positioning options, including above left, below left, above right, below right, etc.

    *ability to specify offset (distance from data point), both horizontal and vertical

    *ability to nudge data labels with keyboard arrows

    *better number formats (see https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/14817276-intelligent-number-formatting-in-chart-axes)

    *ability to display label for min or max data point, for first data point, for last data point, for every other data point, etc.

    *Tickbox option for all the data labels to match data color or some such (match the font of the data label to the line color,…

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  13. Directions from 0 to 2pi 1)atan(x,y) 2)atan(E,N) and from -pi to +pi 3)atan2(x,y)

    1)atan(x,y)=pi-pi/2(1+sgn(x))(1-sgn(y^2))-pi/4(2+sgn(x))sgn(y)

                   -sign(x*y)*atan((abs(x)-abs(y))/(abs(x)+abs(y)))  when x=x2-x1 ,y=y2-y1
    

    2)atan(E,N)=pi-pi/2(1+sgn(N))(1-sgn(E^2))-pi/4(2+sgn(N))sgn(E)

                    -sgn(N*E)*atan((abs(N)-abs(E))/(abs(N)+abs(E))) when N=N2-N1 ,E=E2-E1
    

    3)atan2(x,y)=pi/2(1-sgn(x))(1-sgn(y^2))+pi/4(2-sgn(x))sgn(y)

                     -sgn(x*y)*atan((abs(x)-abs(y))/(abs(x)+abs(y)))  when  x=x2-x1 ,y=y2-y1
    

    The above fuctions give the directions in the 4 quadrans for all the pairs of dx and dy.

    For dx=dy=0 the result is indefinite .

    87 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    15 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  14. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  15. Enable Pivot tables to automatically refresh after a query table or list object has updated - this is how Excel used to function until 2016

    Until Excel 2016 (I believe), Pivot Tables automatically updated after a query table had refreshed. With the removal of this functionality many of our workbooks have been affected after our move from Office 2010 to office 365.

    Can we please get this functionality back - not only did we use to rely on it, but in terms of a calculation chain, it makes perfect sense.

    See also:
    https://answers.microsoft.com/en-us/msoffice/forum/msofficeexcel-msoother-mso_o365b/excel-pivot-table-automatic-update/57ccd7dc-9ff7-4e5c-b892-ab18084b2738?messageId=7aafcff3-32c4-4883-a3e8-92b39831ad0f

    Thank you

    Richard

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  16. HEY DICKSUCKERS AT MICROSOFT(IE MOST OF THE COMPANY)- STOP SHIFTING THE EXCEL VIEW WHEN WORKING IN EXCEL APPLICTIONS. FUCK_YOU.

    HEY DICKSUCKERS AT MICROSOFT(IE MOST OF THE COMPANY)- STOP SHIFTING THE EXCEL VIEW WHEN WORKING IN EXCEL APPLICTIONS. FUCK_YOU.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  17. HEY FUCKFACES AT MICROSOFT- FUCK_YOUR_GODDMAN FEATURE THE TAKES THE CURSOR TO THE TOP OR BOTTOM COLUM/ROW WHEN ACCIDENTLY CLICKING ON THE CE

    HEY FUCKFACES AT MICROSOFT- YOUR GODDMAN FEATURE THE TAKES THE CURSOR TO THE TOP OR BOTTOM COLUM/ROW WHEN ACCIDENTLY CLICKING ON THE CELL BORDER. DO YOU KNOW HOW * ANNOYING IT IS TO HAVE THE ACTIVE CELL 10,000 CELLS AWAY FROM WHERER YOU INTENDED TO BEGIN TYPING THE NEXT INPUT? ** YOUYOUDICKLESSWEASELPIECESOFSHIT.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  18. I FUCKING_HATE_YOU_MICROSOFT

    I FUCKINGHATEYOU_MICROSOFT

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. KEYBOARD SHORTCUT TO INSERT A ROW OR COLUMN

    A KEYBOARD SHORTCUT TO INSERT A ROW BENEATH THE SELECTED ROW OR TO THE RIGHT OF THE SELECTED COLUMN

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. STOP_JIGGLING_THE_FUCKING_SCREEN_WHEN_SCROLLING. FUCK_YOU_MICROSOFT.

    STOPJIGGLINGTHEFUCKINGSCREENWHENSCROLLING. FUCKYOUMICROSOFT.

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base