Feedback by UserVoice

 

Gerdami Des Betes

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Ctrl+F should have "Find previous" button

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Gerdami Des Betes commented  · 

    True, Ctrl=Find has a find Next, no Previous.
    Strange, because in the VBA editor, it actually exists as "Direction: All, Up, Down".

    Gerdami Des Betes supported this idea  · 

  2. Introduce #N/F as a new ERROR.TYPE besides #/A

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes shared this idea  · 

  3. MAXIFS should return #N/A upon no match

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes supported this idea  · 

  4. Show Recently Used Folders as the Default for Save As Function

    13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Excel for Windows (Desktop Application) » Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes supported this idea  · 

  5. Open multiple files with the same file name

    30 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  Excel for Windows (Desktop Application) » Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
    not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thanks for your suggestion! Unfortunately we will not be able to address this in the near future. We’ll keep tracking the voting.

    The reason you can’t have 2 workbooks open with the same name is due to the way that linked workbooks are managed. If you have multiple workbooks open and you create a link between them, Excel shows the filename of the linked file. If there are 2 workbooks with the same name, then the formula would be ambiguous. You can read more about how Excel manages external links here – https://support.microsoft.com/en-us/help/328440/description-of-link-management-and-storage-in-excel.

    Gerdami Des Betes supported this idea  · 

  6. Remove unused styles

    19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    6 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Gerdami Des Betes commented  · 

    Why not simply add the RemoveStyles button available from https://archive.codeplex.com/?p=removestyles ?

    Gerdami Des Betes supported this idea  · 

  7. New *IFs function to accept any aggregating function

    14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    7 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Gerdami Des Betes commented  · 

    Yes, I was about to ask for MINIFS and MAXIFS.

    Gerdami Des Betes supported this idea  · 

  8. Improve the Conditional Formatting Manager

    505 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    101 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thanks for your support of this suggestion and all the great ideas in the comments. We have at least one improvement planned (resizing the dialogs – see link in the description), and we’re looking at some additional improvements.

    If you have specific ideas that aren’t already listed, please add them in a comment.

    Steve [Microsoft Excel]

    An error occurred while saving the comment
    Gerdami Des Betes commented  · 

    While I welcomed predefined conditional formatting rules with Excel 2010, I found that the original version was easier to manage.

    On the web you can find articles about "conditional formatting nightmare", such as

    http://blog.contextures.com/archives/2012/06/21/excel-2010-conditional-formatting-nightmare/

    Just another example: if you want to grey #N/As, intuitively you may try "cell value = #N/A": it does not work. You have to use a formula such as "=ISNA(cell)".

    Please make it simple to use!

    Gerdami Des Betes supported this idea  · 

  9. Support inline variables in formulas (similar to PowerPivot)

    22 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    7 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Gerdami Des Betes commented  · 

    Or something like this

    =VAR(X=expression, Y=expression [, ...]), IF(evaluation of combination of X and Y, value_if_true_perhaps_based_on_X , value_if_false_perhaps_based_on_Y)

    Gerdami Des Betes supported this idea  · 

  10. Opening two workbooks with same name

    24 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    4 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Gerdami Des Betes commented  · 

    Duplicate idea of https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/19995313-opening-two-workbooks-with-same-name

    Gerdami Des Betes supported this idea  · 
    An error occurred while saving the comment
    Gerdami Des Betes commented  · 

    I fully support this idea.
    I regularly download same files from same statistical office and I need to open them at the same time to see the changes. For now, I have to rename the new files.

  11. Make it easier to find external links

    351 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    33 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Gerdami Des Betes commented  · 

    Wow, it is already under review ... since 24 September 2015!

    An error occurred while saving the comment
    Gerdami Des Betes commented  · 

    I have been using the utility by Bill Manville who commented below. Thank you Bill.

    Gerdami Des Betes supported this idea  · 

  12. Find and replace in selected cells - not Within workbook

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes shared this idea  · 

  13. Add a step or staircase chart to Type Of Charts

    14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    9 comments  ·  Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Gerdami Des Betes commented  · 

    Step charts are useful to display
    - changes in the Federal Reserve's monetary policy
    - snowfalls overnight
    - ...

    On step charts workarounds, see
    - Michel Gerday's post at http://www.excelforum.com/excel-charting-and-pivots/513287-dynamic-step-chart-using-range-names.html
    - https://www.pcreview.co.uk/threads/dynamic-step-chart-using-range-names.2397135/ (same as above)
    - Jon Peltier's HowTo at https://peltiertech.com/Excel/ChartsHowTo/StepChart.html
    - Minda Treacy's post at https://www.myonlinetraininghub.com/excel-step-charts
    - Michel Gerday's further comment at https://www.myonlinetraininghub.com/excel-step-charts#comment-19997

    Gerdami Des Betes supported this idea  · 

  14. Allow >31 characters in a sheet name

    58 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    Accepting Votes  ·  16 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes supported this idea  · 

  15. Remove the 255 character limit in Excel object model functions

    32 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    4 comments  ·  Excel for Windows (Desktop Application) » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes supported this idea  · 

  16. Restore MDI file handling (open all files in one window); Kill SDI (each spreadsheet opens in a seperate window)

    1,303 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    959 comments  ·  Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
    not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thanks for the support and the detailed discussion around this suggestion. We understand that there are some advantages and disadvantages with both MDI (multi-document interface) and SDI (single-document interface), and we currently do not have plans to revert to MDI. We do want to improve the experience with SDI so you can get your work done efficiently, and this post has helped toward that goal.

    Some of the specific issues mentioned are addressed as follows:
    – Stability: This has been a focus over the past several years, and the monthly releases in 2020 have been among the most reliable ever in terms of avoiding crashes.
    - Screen space – while it won’t get all the space back, you can minimize the ribbon to save some space. It only shows when needed.
    - Navigation between workbooks: you can use CTRL+F6, SHIFT+CTRL+F6, CTRL+TAB or SHIFT+CTRL+TAB to switch to the next workbook. …

    An error occurred while saving the comment
    Gerdami Des Betes commented  · 

    Please don't shout !

  17. Add ability to collapse field areas in PivotTable Field and Area Side by Side view

    481 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    12 comments  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  Ashvini Sharma (Lead Program Manager, Microsoft) responded

    Hi Ken,

    Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

    thanks
    ash [MS XL]

    Gerdami Des Betes supported this idea  · 

  18. Put the color back in the Quick Access icons. The 2016 icon are impossible to decipher.

    226 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    168 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes supported this idea  · 

  19. Give us a proper NULL() worksheet function.

    832 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    133 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thanks for your support for this suggestion. As some of the comments have concluded, there are a few complex technical issues and considerations that have delayed this from being implemented.

    We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future.

    One of the primary reasons for this request was to have a better way to handle formula cells in line charts, and this can be accomplished using the option to show #N/A as an empty cell. You can use the NA() function in your formulas as appropriate, and choose the option to “Show cells with #N/A as an empty cell”. To find the option for your chart, go to the Select Data dialog for the chart, and click the Hidden and Empty Cells button.

    We know there are other scenarios where a proper NULL()…

    Gerdami Des Betes supported this idea  · 

  20. Make search and replace work in textboxes

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Excel for Windows (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Gerdami Des Betes commented  · 

    i.e. find and replace in objects, such as shapes, wordArt, smartArt, chart titles, axis titles, ...
    See also MVP Jan-Karel Pieterse's Flexfind add-in at
    http://www.jkp-ads.com/officemarketplaceff-en.asp

    Gerdami Des Betes supported this idea  · 
← Previous 1

Feedback and Knowledge Base

(thinking…)