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
