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. Get Tables working on protected sheets (add rows, sort, filter, etc.)

    I would like to be able to, under the right circumstances, have the ability to add/remove rows of a table which resides on a protected sheet.

    Currently if you protect a sheet you can't insert/delete rows of a table. Even if you unprotect all cells and allow inserting/deleting of rows on sheet protection, it doesn't matter and is completely ignored.

    What I am proposing would have to follow specific rules:

    * Table cells would have to be unprotected
    * Cells below table would have to be unprotected (truly optional † )
    * Insert Rows would have to be specified in…

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

    We’ll send you updates on this idea

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

    Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

  2. Use F4 key to lock reference in a table

    When you create formula with the named range of a table, you can't easily block the reference of your column.

    For instance, if you used the fill-handle to copy to the right, the reference of your column will change :( The only way to avoid that is to write [[column1]:[column1]] for all your reference (very annoying)

    So my suggestion to block the reference of a named range is to use the F4 key.
    Your formula is =SUM(table1[column1]) and after pressing F4 it becomes =SUM(table1[[column1]:[column1]])

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

    We’ll send you updates on this idea

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

    Good suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.

    Best,
    John [MS XL]

  • Don't see your idea?

Feedback and Knowledge Base