Feedback by UserVoice

Thomas Widmer

My feedback

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

    We’ll send you updates on this idea

    Thomas Widmer supported this idea  · 
  2. 14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thomas Widmer supported this idea  · 
  3. 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
    Thomas Widmer commented  · 

    I agree. The workaround is simple, but the obvious first guess when using the function is just to add the else result as last option.

    BTW. Thanks for providing the function in the first place. I have been longing for it.

    Thomas Widmer supported this idea  · 
  4. 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
    Thomas Widmer commented  · 

    This would be really great because I could use it fix my biggest excel peeve: E.g. I have a format on Column =$A:$A, when I paste some Data I suddenly have =$A$1:$A$148;$A$150:$A$1048576 even though I want to keep =$A:$A.

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

    We’ll send you updates on this idea

    Thanks for supporting this feature. We won’t be able to in the near future, but we understand that it would be a nice improvement. Even though it seems like a straightforward idea, it is quite complex since named ranges can be dynamic, meaning that the range is calculated when the workbook is calculated.

    We’ll continue tracking votes for this suggestion.

    An error occurred while saving the comment
    Thomas Widmer commented  · 

    This would be really great because I could use it fix my biggest excel peeve: E.g. I have a format on Column =$A:$A, when I paste some Data I suddenly have =$A$1:$A$148;$A$150:$A$1048576 even though I want to keep =$A:$A.

    Thomas Widmer supported this idea  · 

Feedback and Knowledge Base