Forum Discussion

JOE GUERRA's avatar
JOE GUERRA
Copper Contributor
Oct 23, 2017

excel fill cells

Hi, not sure what is happening.  I've got 3 sheets open and I select a cell in the 2 or 3 sheet to fill in with color, and use the ribbon but it fills a cell on the first sheet.  It worked for me in excel 2010, not doing what I expect in 2016.

 

Any clues?

Thanks,

Joe

 

 

excel

1 Reply

Sort By
  • Yury Tokarev's avatar
    Yury Tokarev
    Steel Contributor
    Oct 24, 2017

    Hi Joe,

     

    Filling cells/ranges with colour will apply on selected sheets only. You can select all three sheets, then fill in a range on one sheet to see it replicated on the other selected sheets. Please be careful, because any action on one sheet will override content/formulas in the other selected sheets.

     

    Yury  

Resources