shading cells that are not consecutive

  • Thread starter Thread starter ram1000
  • Start date Start date
R

ram1000

Is it possbile to shade cells B10-16 and D14-8 and F2 and etc and forma
them as a group?


Thank yo
 
Use Ctrl to select all the rages you want selected then do th
formatting you wish.

Either that or choose one cell and do the formatting the way you want
Then copy it and select the other cells and go to edit: paste special
formats
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: cell shading (not conditional formatting) 1
Cond. Formatting, Mod(Row) and cell conditions 2
Conditional Formatting 4
Is there a non-printing shading? 1
shade one cell that will shade multiple cells 1
Can you shade one cell 2 different colors? 1
Real-time sorting 11
Drop Down Shading 3

Back
Top