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 -
2 votes1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
-
3 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
-
13 votes2 comments · Excel for Windows (Desktop Application) » Opening and Saving Files · Flag idea as inappropriate… · Admin →
-
31 votes4 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.
-
19 votes6 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Why not simply add the RemoveStyles button available from https://archive.codeplex.com/?p=removestyles ?
-
14 votes7 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Yes, I was about to ask for MINIFS and MAXIFS.
-
381 votes70 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
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 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!
-
22 votes7 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment 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)
-
23 votes3 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment An error occurred while saving the comment 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. -
338 votes35 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 Wow, it is already under review ... since 24 September 2015!
An error occurred while saving the comment I have been using the utility by Bill Manville who commented below. Thank you Bill.
-
6 votes0 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
-
12 votes8 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment 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 -
54 votesAccepting Votes · 15 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
-
32 votes4 comments · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Admin →
-
1,276 votes997 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 Please don't shout !
-
474 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] -
220 votes169 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
-
811 votes145 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
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] -
6 votes
An error occurred while saving the comment 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
True, Ctrl=Find has a find Next, no Previous.
Strange, because in the VBA editor, it actually exists as "Direction: All, Up, Down".