Gerdami Des Betes
My feedback
-
5 votes1 comment · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Gerdami Des Betes supported this idea ·
-
2 votes1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Gerdami Des Betes shared this idea ·
-
3 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Gerdami Des Betes supported this idea ·
-
13 votes2 comments · Excel for Windows (Desktop Application) » Opening and Saving Files · Flag idea as inappropriate… · Admin →
Gerdami Des Betes supported this idea ·
-
30 votes3 comments · Excel for Windows (Desktop Application) » Opening and Saving Files · Flag idea as inappropriate… · Admin →
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 ·
-
19 votes6 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 ·
-
14 votes7 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 ·
-
505 votes101 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
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 ·
-
22 votes7 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 ·
-
24 votes4 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Gerdami Des Betes commented
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. -
351 votes33 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Thanks for your feedback! We’re reviewing your suggestion. Remember, the more votes a suggestion gets, the more likely it is that we’ll do it.
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 ·
-
6 votes1 comment · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
Gerdami Des Betes shared this idea ·
-
14 votes9 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-19997Gerdami Des Betes supported this idea ·
-
58 votesAccepting Votes · 16 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
Gerdami Des Betes supported this idea ·
-
32 votes4 comments · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Admin →
Gerdami Des Betes supported this idea ·
-
1,303 votes959 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
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 !
-
481 votes12 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
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 ·
-
226 votes168 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
Gerdami Des Betes supported this idea ·
-
832 votes133 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
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 ·
-
6 votes
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.aspGerdami Des Betes supported this idea ·
True, Ctrl=Find has a find Next, no Previous.
Strange, because in the VBA editor, it actually exists as "Direction: All, Up, Down".