Feedback by UserVoice

Dtork

My feedback

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

    We’ll send you updates on this idea

    Dtork supported this idea  · 
  2. 1,087 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks to everyone for the votes and discussion about having undo independently in each workbook. Even though this request has been here for a long time, we are listening and we realize that it can be frustrating if you press Undo while you’re in one workbook and it undoes something in another workbook. We’ve been considering the technical challenges to make Undo work “per workbook”, and want to share some details about it with you.

    The undo process relies on the state of all open workbooks being exactly the same after an “undo” as they were before the undone action was taken. One example of how undo “per workbook” is problematic is with linked workbooks. Let’s say you have WorkbookA, with a formula that refers to WorkbookB, such as =SUMIFS. This formula will give the sum of values in WorkbookB in range A1:A10 that have “Yes” in the…

    Dtork supported this idea  · 
  3. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dtork supported this idea  · 
  4. 47 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Dtork commented  · 

    Kenneth, I think you miss the point of this site. I know tables. I use tables. And I'm well aware of their limitations when it comes to using their references. But when tables are not an option--or when I just want my the intent of my spreadsheets to be clearer and more precise for other users--this is my suggestion to MSFT.

    See that little grey note below the post? The one that says "Dtork shared this idea"? I'm not asking for help, I'm sharing an idea. Cheers.

    An error occurred while saving the comment
    Dtork commented  · 

    True, I can write out those functions (and then conditional formatting immediately translates it to 1048576), but it'd be a whole lot cleaner to use the column letter as a universal reference to the end of the column, in the same way it is when referencing the first and last rows continuously.

    I'm just asking devs to extend the usability a bit. If I needed a workaround, I'd just add ROW()>1 as a condition in my CF formula. Typing INDEX(AA:ROWS(A:A)) for the range application is just as annoying as simply typing the number 1048576 each time and keeping it on a sticky until I have it memorized.

    Dtork shared this idea  · 
  5. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dtork supported this idea  · 
  6. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Dtork commented  · 

    I found this too, really annoying trying to diagnose why in the world only part of my range was returned and the rest had an error, when structured references are supposed to be the answer to mismatched links. Why in the world, in two separate workbooks, do tables need to be in the same row numbers to talk to each other?

    Dtork supported this idea  · 
  7. 11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dtork supported this idea  · 
  8. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Dtork commented  · 

    Or some useful keyboard shortcuts! Even with the Quick Access customizable toolbar, the closest shortcut I can get to Zoom to 100% is a three-step process where I do Alt+[Num], then have to arrow down once to 100%, then hit Enter.

    A quick Zoom to Fit or Zoom to 100% shortcut (or at the very least, as an option in QA toolbar) would be extremely helpful.

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

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Dtork commented  · 

    And maybe I'm missing something, but in Excel I have to know exactly how long my resulting array should be and I need to have that number of cells selected before I create my array formula. If only one cell is selected when I CSE, then I only get one result. If I have X selected, I get X results, but there are a lot of cases where I don't know (or don't care to go back and check) how many rows will be needed, like when I call Google's UNIQUE().

    And then when the Excel CSE formula is improperly edited, a dialogue pops up that I have to cancel out of. Editing array formulas are a pain in the butt, having to resize it and remember to CSE. But in Google? ARRAYFORMULA() returns an error in its first cell if the output is interrupted or improperly edited, alerting you to simple Ctrl+Z and try again.

    Dtork supported this idea  · 
  10. 3,730 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    829 comments  ·  Excel for Mac » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for supporting this suggestion with your votes. It’s unlikely that we’ll be able to bring PowerPivot to Excel for Mac, because it relies on features of the operating system that don’t exist on Mac OS. We’ll keep tracking votes, since we know that the scenarios made possible by PowerPivot are important, even if the solution will need to be something else.

    Dtork supported this idea  · 
  11. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Dtork shared this idea  · 

Feedback and Knowledge Base