Feedback by UserVoice

# Ute Simon

1. ## With Map Charts, Please Add Leader Lines So That You Can See the Data Labels In Small Geographic Areas

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
2. ## Allow conditional formatting for spilled array formulas

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon shared this idea  ·
3. ## Knowing the dimensions of a spilled array

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

An error occurred while saving the comment
Ute Simon commented  ·

COUNT, ROWS and COLUMNS work for spilled arrays. Just reference the start cell of the array as A1# (with the #). These wil show you the total number of cells resp. number of columns or number of rows.

4. ## Dynamic Arrays, Spill range format

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
5. ## Named spilled arrays

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
6. ## Allow UNIQUE() to operate on a rectangular range, returning all unique values

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
7. ## Add a Split dynamic array function

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
8. ## Perform Calculations (Sum, Count, If, etc.) Based on Cell Color

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
9. ## Color cell to sum number cell

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
10. ## Add formulas for most common colors. SO =COLOR(E6) would return name of color for cell E6. Then we can write IF based on colors.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
11. ## sum by color

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
12. ## Please allow us to write formulas based on colors

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
13. ## Conditional formulas based on Cell Colors

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
14. ## Add ability to use countifs with colored cells

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
15. ## Tables should default to "My table has headers" being ticked

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
16. ## Stop Excel from changing large "numbers" (actually text values) to scientific notation.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Thanks very much for your votes. And to those who took the time to fill in the survey, thank you! This is a brief update to let y’all know that we’ve started work on this feature request.

- Urmi [Msft]

Ute Simon supported this idea  ·
17. ## Link the min and max values of a chart axis to cell value

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
18. ## Update Linked Pictures (formerly called the Camera tool)

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
19. ## Add Center Across Selection to the Merge & Center Drop-down

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Ute Simon supported this idea  ·
20. ## Add ability to collapse field areas in PivotTable Field and Area Side by Side view

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Hi Ken,

Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

thanks
ash [MS XL]

Ute Simon supported this idea  ·
← Previous 1