Feedback by UserVoice

 

Gerdami Des Betes

← Welcome to Excel’s Suggestion Box!

My feedback

  1. 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  · 

  2. 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  · 

  3. 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  · 

  4. Remove unused styles

    18 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  · 

  5. New *IFs function to accept any aggregating 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

    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  · 

  6. Improve the Conditional Formatting Manager

    356 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

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

    Thanks for the suggestion Levi! We’ll be taking a look at this along with some other asks around conditional formatting. It’s a big help to see the things with the most votes, particularly within areas like formatting. So please keep the votes coming for things you want us to do sooner!

    Thanks,
    John [MS XL]

    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  · 

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

    20 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  · 

  8. Opening two workbooks with same name

    23 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) » 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.

  9. Make it easier to find external links

    317 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

    35 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  · 

  10. 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

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

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

    11 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) » 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  · 

  12. Allow >31 characters in a sheet name

    43 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  ·  15 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes supported this idea  · 

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

    31 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  · 

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

    1,252 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

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

    Thanks for all of the votes – the team has definitely taken notice of the activity around this issue. We moved to SDI as a result of customer requests, but it looks like we’ve got work to do to really nail the use cases people care about. From a read over the comments, I see a number of cases that we will want to investigate further as we think through MDI vs SDI. We’ll get someone from the team to take a deeper look, and we may reach out to some of you for more clarification as we go. Thanks again for all the voting and passion here!

    John, Excel

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

    Please don't shout !

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

    460 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  · 

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

    212 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

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

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

    730 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

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

    Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

    Thanks,
    John [MS XL]

    Gerdami Des Betes supported this idea  · 

  18. 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  · 

  19. Enhance Name Manager (or replace it with JKP's!)

    15 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) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes supported this idea  · 

  20. Preserve text colour when using Find/Replace

    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) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes supported this idea  · 
← Previous 1

Feedback and Knowledge Base

(thinking…)