Get your questions ready for the Excel team

Question

Get your questions ready for the Excel team! 
Join our Reddit AMA next Wednesday, Oct 18th at 12:30pm EST. 
&nbsp;
http://msft.social/AJPg4i&nbsp;&nbsp;

geeprasadu · Answer

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

peter panda · Answer

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

sergeibaklan · Answer

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

joseph shigley · Answer

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?

sergeibaklan · Answer

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

Forum Discussion

Get your questions ready for the Excel team

Share

Resources