Feedback by UserVoice

Kenneth Barber

My feedback

  1. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    You mean Evaluate Formula, not Formula Editor.

  2. 147 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    77 votes in <24 hours. That must be a new record.

  3. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    That would save my life right about now.

  4. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    I think that your first point should be "add an option to change the default calculation...". I, for one, usually use SUM and not AVERAGE.

  5. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 
  6. 42 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    The thicker borders are missing too. I'm guessing that it's because the thicker borders make the row/column resize, which I guess isn't desirable for conditional formatting.

  7. 0 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    Jeremiah, try messing with the settings shown in the link below. The link below is for graphs, but slicers also have this option.
    http://www.extendoffice.com/documents/excel/1823-excel-prevent-chart-resizing.html

  8. 399 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  9. 48 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Interesting idea. Thanks for the feedback. We’ll definitely consider this in our next round of planning. In the mean time, please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

    Kenneth Barber commented  · 

    Hi James,

    That was exactly what I was looking for! Is this a feature that came out after about May/June 2015 or was it there the whole time and I just missed it?

    Also, can you please mark this post as completed?

    Thanks for your help!

    Kenneth

    Kenneth Barber shared this idea  · 
  10. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    In what case is such a feature much better than the longer way of making a random number column using the RAND function and sorting by that?

  11. 91 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Great suggestion – CSV hasn’t been an area we’ve been looking into recently, but we’ll reconsider. It looks like this is starting to get some votes fairly quickly. If you like the idea, then please keep the votes coming! That’s the best way to help get this onto our engineering schedule.

    Thanks,
    John [MS XL]

    Kenneth Barber commented  · 

    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9153712-excel-bothering

    This post mentions the idea of changing the export format of dates in CSV files.

  12. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    This would of course force you to edit long formulas through the formula bar. When the formula starts covering cells that I want to click, I usually click near the cell and use the arrow keys to navigate.

  13. 2,151 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks everyone for all of the passion about this suggestion! The number of votes has increased greatly in the last couple months and we’re taking notice! We’ve got a bunch of other Excel endpoints behaving this way already and we’re evaluating getting it done in the Windows versions sooner based on the number of votes it gets – so keep the votes coming!

    Eric Patterson (Program Manager – MSFT)

    Kenneth Barber commented  · 

    Duplicate of:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9769824-have-excel-scroll-better-when-there-are-large-cell

    Also, the jumping of multiple lines at a time when using the scroll wheel is due to your mouse setting, not Excel. Go to Control Panel, Mouse, Wheel tab and change the settings there.

  14. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    I'm guessing that you have formulas that look like this:
    VLOOKUP(,A2:D4234,,)
    SUMIF(A2:A4234,,D2:D4234)

    So when you sort, the endpoints of those ranges get moved. Even though people say that it's "bad practice", use whole-column references instead.
    VLOOKUP(,A:D,,)
    SUMIF(A:A,,D:D)

    If you don't like that idea, try putting your data into a table (Insert tab, Table). Then your formulas can reference the table column rather than the sheet column.

    Does that help or am I totally off?

  15. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the feedback. We’ll consider this in our planning for a future release. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

    Kenneth Barber commented  · 

    So basically the linked picture should know which cells it is capturing so then it can spell check on those cells too.

    How bad is your clients' spelling that this is actually an issue? :P

  16. 8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    I can see the Excel team opting to make the "feet and inches" a format so then CONVERT doesn't have to be changed to handle strings.

  17. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    You can already kind of do that. Have a table with 2 columns: your custom order values and the order that they should appear in (1, 2, 3, ...). In the table with all of your data, make a new column and look up these custom order numbers and then sort that new column.

  18. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    Yeah, if you search for the VLOOKUP posts, you'll see the same complaint for VLOOKUP.

  19. 15 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    Your post goes nicely with this one:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/8803093-add-a-countdistinct-unique-etc-function

    COUNTDISTINCT is supposed to count only the first occurrences of values, while your COUNTUNIQUE function counts only values at occur once.

    Nice array formula BTW. I get how it works, but I'd never think of it myself.

  20. 11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    I agree with the idea of having different ways of indicating selection.

    To easily find where you were, just press opposing arrow keys (e.g. left and right) repeatedly so that the flashing makes the area stick out.

Feedback and Knowledge Base