Feedback by UserVoice

Thomas K

My feedback

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    It's not that good of an example because Sort is already in the right click menu as standard.

  4. 1 vote
    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 K commented  · 
  5. 1 vote
    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 K commented  · 

    Have you looked in Excel options > Formulas > Calculation options
    In the general settings.

  6. 1 vote
    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 K commented  · 

    What is wrong with white on white?

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

    We’ll send you updates on this idea

    Thomas K supported this idea  · 
  8. 1 vote
    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 K commented  · 

    It is in formulas - formula editing group and called "show formulas".....

  9. 831 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 K commented  · 

    How come MS has not done this yet :-(

    Thomas K supported this idea  · 
  10. 51 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    @Kenneth, not everyone works with table formatted data all the time.
    I agree that one should consider the input data also when building worksheets, but it is not always possible to do that.
    Sumifs are mostly interesting when looking at vertical data, sometimes an approach with sum/indirect/adress are relevant when looking at summing data that are 'horizontal' or when data is not stored systematicly.

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

    It would be easier with a choosecell formula.

    If you do not know 'address' and 'indirect', then these can help you achive what you want in the mean time.
    =SUM(INDIRECT(ADDRESS(E4;D4;4)))

    An error occurred while saving the comment
    Thomas K commented  · 

    Is this in VBA or in the spreadsheet?
    In vba you have as an example: range("A1").activate
    This can of cause be rewritten to use variables and other range definitions.

    What is an use example for choosecell?

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

    We’ll send you updates on this idea

    Thomas K supported this idea  · 
  13. 2 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 K commented  · 

    In the newest version of excel office 365 can combine the formula Count with the brand new formula Unique.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Thomas K supported this idea  · 
  16. 6 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 K commented  · 

    What is 'inquire'?

  17. 1 vote
    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 K commented  · 

    That does not really make sence, because you need the template to define text and insertion fields.

    In a way, you can do it. Using VBA from excel calling word could be an option.

  18. 1 vote
    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 K commented  · 

    Good idea, but you can add the 'quick' button yourself via customizing the ribbon.

  19. 1 vote
    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 K commented  · 

    You can enlarge the 'formula bar' so it shows several lines instead of just the one that is standard. That way you get your "window".

  20. 1 vote
    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 K commented  · 

    build a formula where you use & when referencing the cell for first and last name

    ='first name' & 'lastname'

Feedback and Knowledge Base