Highlightling a row or column

Resolved · Medium Priority · Version 2016

Mon 25 Sep 2017, 15:37 Delegate Clive said...

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?

Tue 26 Sep 2017, 09:41 Trainer Jens said...

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

Wed 27 Sep 2017, 15:19 Delegate Clive said...

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?

Wed 27 Sep 2017, 20:35 Trainer Jens said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Closing all your workbooks Quickly

Hold the SHIFT key down and using the mouse click on the file menu, it will now now CLOSE ALL rather than close. This closes all workbooks down but still leaves the application open.

View all Excel hints and tips