| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LINECOLOUR CHANGE IN EXCEL WORKSHEET?
how to change entire linecolour in a MS Excel work sheet at a time?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
LINECOLOUR CHANGE IN EXCEL WORKSHEET?
Do you mean "row" color?
Select the row header at left and use the color picker. Or do you mean "gridlines"? ToolsOptionsViewGridline Color Gord Dibben MS Excel MVP On Sat, 15 May 2010 14:21:01 -0700, khanal wrote: how to change entire linecolour in a MS Excel work sheet at a time? |
|
#3
|
|||
|
|||
Quote:
step 1: shift + space bar (short cut to select entire row step 2: right click step 3: format cells step 4: go to fill and give the required color If you want to change the entire column, then Step 1: cltr + space bar follow steps 2 to step 4 as above. all the best
__________________
Thanks Bala |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
LINECOLOUR CHANGE IN EXCEL WORKSHEET?
OR if you mean border color for a selection...check out the 'Border' tab from
menu FormatCells -- Jacob (MVP - Excel) "Gord Dibben" wrote: Do you mean "row" color? Select the row header at left and use the color picker. Or do you mean "gridlines"? ToolsOptionsViewGridline Color Gord Dibben MS Excel MVP On Sat, 15 May 2010 14:21:01 -0700, khanal wrote: how to change entire linecolour in a MS Excel work sheet at a time? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO CHANGE THE ICON OF AN EXCEL WORKSHEET FILE? | Excel Discussion (Misc queries) | |||
| Excel VBA Target Worksheet change | Excel Discussion (Misc queries) | |||
| How do I change the tab order in an Excel worksheet? | Excel Worksheet Functions | |||
| Why does excel change my hyperlinks when I copy a worksheet? | New Users to Excel | |||
| How do i get the excel worksheet to automatically add or change c. | Excel Discussion (Misc queries) | |||
Linear Mode
