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.

How can we improve Excel for Windows (Desktop Application)?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Be able to turn off auto-conversion of fractions and words into dates

    When I import data in the format of a fraction #/#, excel automatically converts this into a date. This is unnecessary and should not be a default operation. At least, there should be a simple way to undo this.

    I work with biological data, and there are gene names like "Oct1", and these get converted into dates, causing errors in data analysis.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Hi,
    You can do this already in Excel today – there are two ways:

    1. You can type an apostrophe before the data you enter → ’Oct1, and Excel will then not interpret that as a date (it will interpret it as Text).

    2. If you format the cell as Text before typing the value in the cell, Excel will not interpret it as a date.

    Hope that helps,
    Dan [MS]

  2. Center Wrapped Text Without Left Offset that Occurs Now

    When you Wrap Text in a cell in excel and center, the text is distinctly further to the left whether or not there is any wrapping occurring, not centered as it would be if you manually spit the text into two cells and used the built-in centering.

    Make wrapped text center without the offset.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    This is already supported.

    After you wrap text in a cell, click on the “Align Center” button, and the text will align in the middle of the cell

    Cheers,
    Dan [MS]

  3. need new workbook copy protection

    We need a higher level of workbook and worksheet protection perhaps set to the user ids own computer and allowed devices. This way excel documents with hidden formulas, code etc can be shared to people outside that network without worrying about special details (secrets) getting into the wrong hands. Currently workbook passwords can be unlocked with code, etc.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    There are two ways to get strong encryption and protection of Excel files:

    1. DRM (Click on File > Info > Protect Workbook > Restrict Access) can be used to only allow certain users to access a file.

    2. Workbook Protection (Click on File > Info > Protect Workbook > Encrypt with Password) can be used to encrypt a file. When set, only users with the password can open the file to see the contents.

    Cheers,
    Dan [MS]

  4. colour cells

    Be able to calculate the occurrences of cells with coloured background.

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Amy,

    This is already possible in Excel today.

    1. Press Ctrl+F to open the find dialog.
    2. Click “Advanced”
    3. Click on the “Format” button and select the format (cell colour) you want to count
    4. Click Find All

    The find dialog will list the count of occurrences of that formatting that you selected.

    Cheers,
    Dan [MS]

  5. Ctrl+Tab to switch between worksheets

    Just as we use Alt+Tab to switch between two workbooks, let Ctrl+Tab switch between two worksheets in a workbook.

    65 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Thanks for the feedback folks. Good news – Ctrl+ page up/down already does this. Ctrl+tab will switch between active books. So I’m going to close this one out under the assumption that people weren’t familiar with the existing shortcuts.

    Cheers,
    John [MS XL]

  6. Ability to both freeze colums AND rows at the same time

    Ability to both freeze colums AND rows at the same time would be fantastic. Also, not just the top row or first colum, I want to be able to choose from where the freeze panes starts.

    When scrolling down, the frozen colums can roll up. But when sliding sideways, the colum remains put and the frozen rows slide along. Can't be that hard, to do?

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Shanna,

    This is already supported. To freeze both rows and columns in Excel 2016, do the following:

    1. Put your cell selection in the cell below the row you want “frozen” and to the right of the last column you want “frozen” (said another way – put it in the first cell that you want to be able to scroll either direction – C5 for instance)
    2. On the View Ribbon, choose Freeze Panes > Freeze Panes.

    That should do it.

    Cheers,
    Dan [MS]

  7. Bring back the Split Box

    You used to have a split box above/to the side of the scroll bars. This went in 2013 for some reason - there was no justification:
    https://support.office.com/en-us/article/Discontinued-features-and-changed-functionality-in-Excel-2013-c417e377-26c6-4f43-be6d-16718dd75ffa#__toc342560933

    Please can we have this back?

    9 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    While the split control is no longer above the scroll bars, it is still available in Excel. To add it to your Ribbon or QAT, you can:

    1. Start Excel
    2. File > Options > Customize (QAT or Ribbon)
    3. Choose commands from “All Commands”
    4. Find the “Split Window” command
    5. Add it to your QAT (or to the ribbon).

    Hope that helps!

    Dan [MS]

  8. "Ctrl+O" should open the Open File dialog box not the Recent File pane

    "Ctrl+O" has been an incredibly useful keyboard shortcut for two decades. Changing its functionality and moving the old functionality to Alt, F, O, O is a huge detraction from the functionality of Excel.

    I open 10 to 20 files a day. of those, only 3 tend to be files which were recently opened. When I open those, the Recent File pane is nice. When I open the other 17, the recent file pane is just wasting my time.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Kevin,

    You can get Ctrl+O to open the dialog box and not the backstage by going to File > Options > Save > Save workbooks > Don’t show the Backstage when opening or saving files.

    Check that box, and you’ll see the behavior you want.

    Personally, since I like the backstage for some things, I’ve gotten used to using Ctrl+F12 to jump directly to the Open dialog, and F12 to jump directly to Save – so that’s another option for you.

    Cheers,
    Dan [MS]

  9. Merge Cells - Allow User to Change the Default Merge Cells Format

    Instead of always merging AND centering, I would rather it maintain the formatting of the original cell that contains the data. More often than not, if the original cell is formatted as left justified prior to merging then I want it left justified after the merge as well.

    If this isn't possible, then at least allow me to change what it defaults to in the home excel options as well as give me more standard options to choose from. Or allow me to create my own combinations of merge and format combinations to default to.

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Hi jf,

    We’ve got this in Excel today! :-)

    Instead of hitting “Merge & Center” on the ribbon, click the drop down arrow beside it and choose “Merge Cells.”

    Cheers,
    Dan [MS]

  10. spell check

    As ms word is having spell check function, i suggest you to add the same to MS Excel

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  11. Allow single spreadsheet to be opened in multiple windows

    My suggestion is to allow a single workbook to be opened in multiple windows. For example, I have a spreadsheet with two tabs. Formulas on one tab reference cells on a the other tab. If I were able to open each tab simultaneously in its own window, I would be able to much more easily and quickly edit and troubleshoot a spreadsheet. This would be especially useful if one were using two or more monitors.

    3 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    already supported  ·  0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  12. Add the BANG function for statistics Please

    The ! (pronounced BANG) function is useful in statistics. If for example I
    have 5! it means 5*4*3*2*1. When calculating odds it is a slick way of making calculations less complex.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Allow a value from the data be added as a label within a chart in Excel

    When creating a chart in Excel, allow user to be able to add as a "text box" anywhere in the chart a value from a calculation of the data anywhere within the file.

    6 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  14. transfer pinned programs and documents pinned to programs when upgrading MS Office

    automatically transfer the pinned programs and the documents pinned to programs when upgrading MS Office

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    Pinned documents are based on the account you log in to Office with, so as long as you log in with the same account, they should “transfer” between Office versions.

    Cheers,
    Dan [MS]

  15. Allow more than 1 instance in Excel 2016

    Can you please bring back the ability to open more than 1 instance of Excel? Currently when I have a macro running, I am unable to utilize Excel because of this new setup. In the older versions of Excel, it was nice to be able to choose how many instances you wanted to open.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    This is already supported. To start a new Excel instance, press Windows+R (Run), then type “Excel /x” without quotes.

    You’ll get a new process that will be isolated from other Excel instances.

    Cheers,
    Dan [MS]

  16. Hello, i have a need to round values up in the example "roundup say 6.2 or 6.3 to 7"

    Is there a way to round up any fraction of a positive integer to the next positive integer - e,g, 6.1 to 7?

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Be able to pastspecial the content (basically the code) of a specific Cell without entering in the cell and select/copy the line

    For example if the content in Cell A1=SUM(B1:C1), you should be to paste this content: "=SUM(B1:C1)" where you want, for example in Cell A5, without locking cells. It could be useful when we have to copy and paste formulas from a workbook to another one (without the problem of REF)

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Hi Simone,

    You can do this in Excel already today. Instead of copying the entire cell (by selecting the cell in the grid), double click on the cell to enter edit mode, select the formula, and copy it.

    Paste that into the destination and it won’t adjust.

    Cheers,
    Dan [MS]

  18. please make a way for test boxes to snap to the grid

    please make a way for test boxes to snap to the grid

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  19. 1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    This is possible in Excel already today. To quickly export to PDF, click on File > Export > Create PDF.

    You can also add this to your QAT by:
    1. On the QAT, click the drop down, choose More Commands
    2. Find the item called “Save As Other Formats (with the arrow to the right)” in the list of “All Commands”
    3. Click Add >>; then OK.

    Now you’ll have a drop down on your QAT where you can choose PDF.

    Hope that helps,
    Dan [MS]

  20. Be able to select rows and columns and simply click DO NO SORT

    It is a massive ball ache sorting when it should not be this aggravating. Maybe I'm being stupid and there is a simple solution already, but I can't find it online and I can't figure it out myself.
    My annoyance is that I generally need to sort when I have multiple rows with text for headers, and some boxes need merging.

    I'll explain because some people say "do not merge", but this isn't always helpful.
    Current excel spreadsheet I'm working on.
    I included a picture of my spreadsheet so you can see. I want those top 3 rows to never…

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    You can achieve what you’re asking for by inserting a blank row between rows 3 and 4 (where you don’t want any sorting to happen above the blank row).

    You can then make the row height very small (1px or so) so it doesn’t take up room on your sheet.

    Then, when you sort the content in your table, it won’t sort the headers.

    Hope that helps,
    Dan [MS]

← Previous 1 3 4 5 6
  • Don't see your idea?

Feedback and Knowledge Base