Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel vba training - colour coding

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba training - Colour Coding

excel vba training - Colour Coding

ResolvedVersion Standard

Mark has attended:
Excel Introduction course

Colour Coding

how would you colour code data?
for example 1 row red second row blue?

RE: Colour Coding

You can format each row in the colour you want. Then you could use the Format Painter to copy only the format to the rows below. Or you could do it maunally

ie:
Format 1st row red
Format 2nd Row blue
Select both rows
Select Format Painter
Click on next set of rows.
Repeat


Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.25 secs.