ExcelBanter - LINECOLOUR CHANGE IN EXCEL WORKSHEET?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - LINECOLOUR CHANGE IN EXCEL WORKSHEET? (https://www.excelbanter.com/excel-worksheet-functions/263859-linecolour-change-excel-worksheet.html)

khanal

LINECOLOUR CHANGE IN EXCEL WORKSHEET?

how to change entire linecolour in a MS Excel work sheet at a time?

Gord Dibben

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?

bala_vb

Quote:

Originally Posted by khanal (Post 953948)

how to change entire linecolour in a MS Excel work sheet at a time?

If want to change the entire row color, then

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

Jacob Skaria

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?

.

All times are GMT +1. The time now is 04:07 PM.