Feedback by UserVoice

# Roy

1. ## Correct the =Days360 formula

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Roy supported this idea  ·
An error occurred while saving the comment
Roy commented  ·

A little more detail: if you give a date like 2-March-17 for the end date, one for which you completely"pass over" February, it DOES give 30 days for February, then adds 2 more for the time in March for a result of 32. So it is adding 30 for the 28 day month, then the 2 for the two days in March.

So apparently it is not "kicking in" until you reach a date more than one month away from the start date. Then a date in February simply counts actual days until the date, rather than recognizing the user sees it as a different month and expects exactly 30.

Hopefully MS can see the ease of fixing it now!

In the meantime (which... might be forever...) one could force it to the end of the month with EOMONTH(), add 1, and calculate. So any time at all in February would yield the expected 30.

2. ## Fix how Excel handles arrays it produces internally while evaluating a formula so error results are not yielded.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Roy shared this idea  ·
3. ## Triangle Number Formula

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Roy supported this idea  ·
An error occurred while saving the comment
Roy commented  ·

The formula is just a sum of a sequence formula. So it is the number of items ("n" let's say) divided by 2 and that multiplied by the sum of the first number in the sequence ("1" for triangular numbers) and the last one (the number of items ("n" as I called it above) or better name: the number you want the triangular number for (still "n")):

Triangular number = (n/2) * (1 + n)

So in Excel, let's say you put the number you want a triangular number for into cell A1. Your formular would then be:

=( A1 / 2 ) * ( 1 + A1)

Hope that helps. My bet is they won't ever add this one because it would be a fairly rarely useful function, fairly specialized in its uses.

However, if they added a broader function, maybe called SEQUENCE() or SUMSEQUENCE(), some variation that, it might be useful to a lot more purposes and would completely fit your needs as well.

It could have three arguments (inputs): the ending number, the sequence's starting number (so the sequence could begin at any old number instead of at "1" — broader appeal, more chance of it happening), and the difference between each number in the sequence (so you could sum up sequences like 3,6,9,12... not just 3,4,5,6 type sequences). Broader appeal. And it could be set so if the 2nd and 3rd arguments are not there, it starts at "1" and goes up by "1" so for your use, you'd just have to give it the number you want a triangular number for.

The broader the appeal, the more likely you might be to get it! Good luck!

4. ## new function merge vlookup & helookup

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Roy supported this idea  ·
An error occurred while saving the comment
Roy commented  ·

True...

Why did they ever get separated I wonder??? Add an argument to it with "h" or "v" as the options and if it is "h" the row/column argument is treated as a row and it's evaluated like HLOOKUP() does; if it is "v" then it's a VLOOKUP approach (row/column argument is treated as a column being referenced) on Excel's part.

One nicety of that would be that the "h" or "v" argument could be dynamic, if that'd ever be of use, where now it can't really be because it is part of the function name, not an argument inside it. Probably not everyday use there... but still, a nicety.

5. ## Assign a macro inside a cell

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Roy supported this idea  ·
An error occurred while saving the comment
Roy commented  ·

Yeah, something that directly addresses it regardless of how the user interacts.

By that last, I mean you can, of course, set a macro to run if a cell is clicked on or changed (OnClick method, or something similarly named). But what if the user arrows his way there, or uses the automatic movement on pressing Enter feature? I don't believe the above fires on that kind of navigation. And maybe there are other ways (Ctrl-G for instance) to get to a cell.

Something that "sits" on the cell, like a comment does, and fires off if that cell becomes the current selection regardless of how it did: just firing on the cell attaining that status, not on any navigation to it... that'd solve all the issues. Be nice to have.

6. ## Mark specific cells

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Roy supported this idea  ·
An error occurred while saving the comment
Roy commented  ·

Yeah, gotta say it would be nice. I've always had to use workarounds like coloring (Lord... ok... "filling") the cells for input light yellow, but then the printing... (Sigh...)

Yeah, "proper practice" and all... but people (bosses especially) don't seem to like going from the page they see the nice output on to a different one to enter some data, then back to see it, then go back to enter or change data. So they don't do it and don't care to be lectured on how "they are wrong."

I even tried setting up Ranges that cycle between data entry cells (though be sure to put the cell you want landed on first when they Ctrl-G (go to) LAST in the Range — weird Windows issue it seems — or the landing spot will be the last cell in the set of cells you put in the Range.

But same thing: they always want to add a bit, then see the current values, then go back to adding. Even when that's useless! And hated being dropped back on the Range's landing cell and having to cycle back and forth with Enter for further addng or changing. And the moment they mouse or hit an arrow key...

Data entry boxes that float above the output page...

It's got to be solvable at the program level. Maybe a new type of conditional formatting, one that you set and it marks the data entry cells, but only to the monitor (intercepting the data stream headed to a monitor, but does not intercept anything going to a printer). Something...

7. ## Drop-down list for col_index_num argument in VLOOKUP

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Roy supported this idea  ·
8. ## Set a range as "Absolute" values

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Roy supported this idea  ·
An error occurred while saving the comment
Roy commented  ·

The source basis of the problem is Excel produces arrays as the "interior" functions' outputs to the outer functions and the outer functions often cannot make use of material in array format, or sometimes they could if it were typed in that way, but not when presented as interior function outputs into them(!)...

The interior function's output clearly is the array we can make seen, but with something slightly extra, or missing, so it cannot be interpreted by the function receiving it.

So =SUM(ABS(A1:A4)) yields the #VALUE! error because "ABS(A1:A4)" gives an output of (literally) " {7;15;6;3} " and SUM() cannot handle that when presented with it from evaluating the ABS() function.

BUT if you typed " =SUM({7;15;6;3}) it properly yields "31" as its result, not "#VALUE!".

What we really need is either for Excel to dress that up (it clearly is presenting something slightly different than the above when IT evaluates the ABS() function here and needs to clean that up) or it should give us a function that takes (in this case, but of course ANY function's array-ish output) ABS() (clearly not just the array, but a wee bit more) and cleans it to the typed version before presentment further outwards.

I think I'll add that thought as a separate suggestion since this affect a HUGE number of situations and I have never found a workaround, just rewriting, usually with different functions, of formulas or using the Ctrl-Shift-Enter array approach with its attendant oddities/hassles.

That way this one would be solved (better!) or at least amenable to a fix by wrapping it in an extra function (like we do with TRIM() and so on) without the Excel programmers having to address it ad hoc function by function leading to either "it's too beastly to attempt so too bad dudes" or new issues.

9. ## Be able to embed an OpenType font in workbook/exported PDF

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Roy supported this idea  ·
10. ## Scroll to last tab in workbook

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Roy supported this idea  ·

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Roy supported this idea  ·
12. ## Unhide multiple worksheets at once

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

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

thanx,
Prash
Program Manager Excel

An error occurred while saving the comment
Roy commented  ·

It's so tantalizingly close too. All the architecture is there, or literally almost all. A selection box is available with the hidden sheets listed... IF ONLY we could select more than one at a time... it seems like such simple code to add.

A teeny, tiny piece of code... and standard stuff too, where the current code flouts usual practice of:

1. Double-click on a single one to instantly act on it ignoring all others, or
2. Ctrl-click on individual items to make out a selection list one by one, inside the box, or
3. Shift-click to select several contiguous choices

so someone had to not only decide to do it against the norm, but to do the work of carefully coding to do so instead of copying and pasting standard selection code. (Sigh...)

Roy supported this idea  ·
13. ## Declined vs locked suggestions

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Roy supported this idea  ·
14. ## Two-way cell connections

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Roy shared this idea  ·
15. ## Create small "drill down" displaced ranges for quick sums, subtracions, etc

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

An error occurred while saving the comment
Roy commented  ·

I like it. I'd like it to work perhaps as a format option, turn it on and give it a range elsewhere in the spreadsheet, and when one clicks on the cell, a floating window pops up showing just the range: just the range, not its own Ribbon, et al., and not as a current style Pane, just a floating window showing the range and its contents, functioning as a little scratchpad as it were.

That way one COULD keep detail in a separate section of the spreadsheet dedicated to proper structure and storage of the detail while at the same time maintaining ease of use for all (not least, bosses who are flat not interested in moving past the "light user" stage).

No hunting about for the particular source of the result in the cell. Just clock on it and the range in question pops up as a floating window above the current sheet, trapped in that spreadsheet of course, not an independent window, and not forced to obscure any bit of the rest of the current sheet the user wishes to see because he can move the scratchpad window about. Oh, and it would stay on top until closed, obviously. And I think closed on purpose with its "X" button, not (being fancy) automatically by clicking a cell other than its result cell.

And it could even simply be just a wee scrap of spreadsheet to do off-the-cuff writing and calculating. I will ask: how many times have your users (bosses, not-a-boss-but-still-a-dufus, etc.) done just that, writing in their own calculations, even overwriting other things to do their own scratch work ("Typing over that cell didn't change the part I cared about so..."), and in so doing broken the spreadsheet, saved it, maybe even a few times in different places, and then come complaining to you? Even if not structuring things while still offering easy inspection of what makes up a result shown to the user, just wanting a scratchpad, this would be quite useful on its own, and rather invaluable in building proper structure and data handling into a spreadsheet that is going to be used by people who simply aren't going to know spreadsheets or value the idea that they have to hunt around and so on.

Roy supported this idea  ·
16. ## Blank Sudoku Template

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

An error occurred while saving the comment
Roy commented  ·

Here's what it sounds like you're asking for.

By the way, if you don't fill in the book afterward, in a year, it would be like a whole new book... free too.

(I'm hoping commenters can attach files somewhere along the way here. If not, this will look fairly stupid. If that happens, just open a blank spreadsheet, change your View to "Page Layout" so you can work with inches, set row and columns, nine that is, to, say, 0.5". The select the upper left 3x3 and format borders using the default line and clicking the "Inside" button in the dialogue, then the really heavy black border and clicking the "Outside" button in the dialogue. Then copy that 3x3 block and paste to the middle and right 3x3's to its right, then copy the whole 3x9 upper tier and paste to the middle and bottom 3x9 tiers and you are set. The sheet has nothing but formatting so when finished, you can just highlight (select) the whole thing and clear it to be ready for the next one.)

17. ## Ability to reference the end of the column or row regardless of the starting position

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

An error occurred while saving the comment
Roy commented  ·

Yep, cleaner indeed. And therefore easier to use and easier to understand, especially for others.

Always nice to see someone offer up workarounds to help in the meantime, but of course, since the whole point of this site is to suggest things it'd be nice to see in the (hopefully near) future, no workaround can substitute for the desire to see Excel offer something directly and cleanly.

On Excel's side, acting on this suggestion would be one way to "future-ize" the program. Using this feature, a formula works when the number of rows or columns, or even pages, is increased. It also makes it work cross platform if Excel wrote a version for, say, phones, that differed from desktop or tablets, and did not offer the same maximum number of rows or columns. Instead of being broken, it would work on and on.

And if Excel would like to be a familiar and useful interface to everything (toasters, refrigerators, table saws, hot tubs, kids' toys, etc.), it would be extremely likely it would need to offer limited row/column extent versions. So...

But again, the whole point of the site is to not have to give in to three decades of workarounds piled on workarounds, all archaic and none transparent, but rather to express present/future needs and desires to do things directly.

Roy supported this idea  ·
18. ## Let Find and Replace always start in the first inputbox

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

An error occurred while saving the comment
Roy commented  ·

Interesting. I usually use Alt-E-E and get what I talk about below. Oddly, I use Ctrl-F for Find, but never really shifted back over to Ctrl-H for Replace.

Bummed to find out they changed it... could mean the start of wholesale changes to shortcuts which, however much needed, would be aggravating... but seemed part of a plan (I'm cynical, yes) when the Ribbon menu system took over and they began hiding all the keyboard shortcut hints, so it wasn't unexpected.

But I tried it for old times' sake and it still works. Yay. But here's the whole reason to make this post: Using Ctrl-H, I get the proper insertion point indicator in the proper place, NOT the absence of it that I complained about below. Checking, Alt-E-E still gives me nothing there, Ctrl-H does. Did these people write two different routines for the two different shortcuts? They don't just point into the same code and run? Either that's crazy or at the least the set of old Ctrl-? shortcuts are burned deeply into Excel and we won't lose those, maybe, as easily to a wholesale reassignment project. So Yay, maybe.

Still need this though, gotta have it pop up ready to work, not ready for more key presses before one can start the work one brought it up for. I mean c'mon folks, I just REPLACED what on the "Find What" line... how likely is it my next plan is to do it again after I rid myself of all of them? I wonder though... no, whether I use Alt-E-E or Ctrl-H, it still comes up in the "Replace with" box each succeeding time until I quit Excel and start over.

Still need this.

An error occurred while saving the comment
Roy commented  ·

Yeah, no doubt. Obnoxious, that. How likely is it I want to do the exact same F&R again?

I also find it obnoxious that for years now, at least since moving on from Excel 97, that first time I bring up the F&R box, the cursor really is in the Find entry box, but it does not show up, no slim little vertical "blinking cursor" line. Nothing. If I hit Tab|Shift-Tab to move it and return it there, the cursor shows up like a proud little boy. WHY can't it show there to begin with?

Roy supported this idea  ·
19. ## Quit changing my data

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

An error occurred while saving the comment
Roy commented  ·

Yeah, workarounds exist. Entering into cells formatted as text which can then be examined formulaically for value and separately for precision from the user's simple single input is another way one might approach it.

But it's so basic to many of the usage silos for Excel, that it sure would be nice to have it natively, especially if Excel chose a standard and enforced it programmatically.

An error occurred while saving the comment
Roy commented  ·

Actually, it DID change the "data value" both in its purpose as data and therefore its utility and in the sense of it's now garbage.

Perhaps there could be a "Precision" number format in which one enters "10.00" and its representation stays either that directly, or perhaps, by analogy to scientific notation in Excel, could be represented as "10P+2" (or no "+" as it is not truly needed except for readability perhaps). It would keep the original precision stored and available to use too so one could utilize the precision directly instead of indirectly by deriving it from the store value.

That precision is critical to the calculations (i.e.: the data analysis that is the basic purpose of Excel) in which the entries are used. Seems like it would be so simple to add in as well.

And the idea that Excel has no internal facility for doing such... isn't the very purpose of this site to suggest things that Excel could have added to its "internal facilities"?

Roy supported this idea  ·