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

highlightling row column

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Highlightling a row or column

Highlightling a row or column

ResolvedVersion 2016

Clive has attended:
Excel Intermediate course

Highlightling a row or column

Please first state which training course this forum post is about: Excel VBA Introduction & Intermediate

How do you highlight a row or column in Excel? I work in accounts payable processing invoices. my question - I have 2 monitors and open excel doc with say 5 columns of coding. Then I need to enter manually into SAP these 5 coding lines for invoice cost distribution. but when I click into the left hand monitor (click out of excel) - the column in Excel is no longer highlighted. How do I get it to stay highlighted?

RE: Highlightling a row or column

Hi Clive,

Thank you for the forum question.

You can only have one active window. It means that if you select data in Excel (highlight the data) the moment you click in another window the new window will be the active window and the selection in Excel will not be highlighted anymore.

You can add a fill colour to highlight the data in Excel, then you will keep the data highlighted when you click in another window.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Highlightling a row or column

Please first state which training course this forum post is about: Hi Jens - is there a way of simply right clicking the column letter - for example "D" and for it to automatically colour it in yellow for example?

RE: Highlightling a row or column

Hi Clive,

You can right click "D" and then click Format Cells. Then click the Fill tab and select a colour and click OK.

If you want to automate it you can write a macro.

The code below can do it, but I do not know if you have any VBA macro knowledge.

Sub HighLightSelection()

Selection.Interior.Color=RGB(100,100,100)

End Sub


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 4 Oct 2017: Automatically marked as resolved.

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



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.09 secs.