Forum Discussion

FastTrack-F1's avatar
FastTrack-F1
Tin Contributor
Nov 04, 2022

Highlight active row/column in Excel

Hello,

 

for the Excel desktop app there are different ways to highlight an active row/column.

 

In Excel Online I sometimes really struggle to see the active cell, especially in meetings when presented by projector.

 

Is there any way to get these settings changed in Excel Online?

 

Thanks 

Excel for web

7 Replies

      • NikolinoDE's avatar
        NikolinoDE
        Platinum Contributor
        Nov 07, 2022

        FastTrack-F1 

        Another try...my link :))

        Highlight active row and column without VBA

         

        Actually, the VBA code should also work, but it has to be integrated into the workbook in advance from a subscription or desktop version, since you cannot create VBA code with online Excel.

        However, you can open and edit the macro-enabled workbook in Excel for web.

        Work with VBA macros in Excel for the web

         

        Example VBA code input: Press ALT + F11 key combination to open VBA.

        Then select ThisWorkbook in the left project explorer,

        double click it to open the module,

        and copy and paste the following VBA code into the blank module:

         

        Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)

Static xLastRng As Range

On Error Resume Next

Target.Interior.ColorIndex = 6

xLastRng.Interior.ColorIndex = xlColorIndexNone

Set xLastRng = Target

End Sub

         

         

        Add. Infos:

        Show or hide gridlines on a worksheet