Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to add shading to more than one column at a time?
I am trying to add shading to every other row. I thought if I held CTRL and
clicked on the the columns then I could add shading to the columns all at once but this is not working. Any help is appreciated. |
#2
|
|||
|
|||
I can't understand why this isn't working for you. You do use ctrl held whilst clicking on all the rows you need, you can let go of ctrl if you need to scroll down, though make sure you're holding it before clicking another row. Once you have all rows selected, right click on any of the highlighted cells and format as you would. -- Faz ------------------------------------------------------------------------ Faz's Profile: http://www.excelforum.com/member.php...o&userid=27830 View this thread: http://www.excelforum.com/showthread...hreadid=475770 |
#3
|
|||
|
|||
Hi,
You are correct. Click the first of the columns you wish to shade, hold control and select the other columns one by one. With all required columns selected, right click the mouse and select Format Cells, Patterns, select the colour to shade with and click OK. Ewan. "sweeps" wrote: I am trying to add shading to every other row. I thought if I held CTRL and clicked on the the columns then I could add shading to the columns all at once but this is not working. Any help is appreciated. |
#4
|
|||
|
|||
Sorry, I thought you were trying to shade columns - the technique works for
rows too by holding ctrl. Follow the same instructions but replace 'column' with row. "ewan7279" wrote: Hi, You are correct. Click the first of the columns you wish to shade, hold control and select the other columns one by one. With all required columns selected, right click the mouse and select Format Cells, Patterns, select the colour to shade with and click OK. Ewan. "sweeps" wrote: I am trying to add shading to every other row. I thought if I held CTRL and clicked on the the columns then I could add shading to the columns all at once but this is not working. Any help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Auto Skipping and protected cells | Excel Discussion (Misc queries) |