Get your questions ready for the Excel team

[Olaf Hubel]

Get your questions ready for the Excel team!

Join our Reddit AMA next Wednesday, Oct 18th at 12:30pm EST.

http://msft.social/AJPg4i  

[#2]

how to convert json file into excel format can u help me

[#3]

How to set PivotTable default layout options file - options - data? where？

[#4]

"Edit Default Layout" button here (Data Options section)

[#5]

I have color coded cells on my spreadsheet to designate different types of activity. Is there a way to count the number of cells that are, say, colored blue?

[#6]

Hi Joseph,

That's using VBA, see the example here https://support.microsoft.com/en-us/help/2815384/count-the-number-of-cells-with-specific-cell-color-...