by East Hill on May 31st, 2008

East Hill

Question

Help answer this question below.

On Excel, is there a way to have the entire row/column highlight when you click on a cell, instead of just the row number on the l.h. side and the column letter on the top?

  • Like
  • Report

Answers. 6 helpful answers below.

  • by firecircle on October 5th, 2008

    firecircle

    This solution will colour the entire row and column of the selected cell. Beware - it will remove all other cell shading, however, conditional formatting still works.

    > Press ALT-F11 to open the VBA editor.
    > Double click at the right on "ThisWorkbook"
    > Paste in the following code, and exit, that's it.

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

    If Not OldCell Is Nothing Then
    OldCell.EntireRow.Interior.ColorIndex = xlColorIndexNone
    OldCell.EntireColumn.Interior.ColorIndex = xlColorIndexNone
    End If

    Target.EntireRow.Interior.ColorIndex = 6
    Target.EntireColumn.Interior.ColorIndex = 6

    Set OldCell = Target

    End Sub

    -----
    microsoft.com also has a solution:
    http://office.microsoft.com/en-us/excel/HA011366231033.aspx, but it will wipe out conditional formatting.

    • Like
    • Report

    2 comments | Post one | Permalink

  • by SpreadsheetsDirect on July 8th, 2008

    SpreadsheetsDirect

    If you press ctrl & space together it will highlight the column, shift & space will do a row.

    • Like
    • Report

    1 comment | Post one | Permalink

  • by Babycakes Deux on May 31st, 2008

    Babycakes Deux

    If you click on the gray letter at the top of the column or on the gray number to the left of the row, it will highlight the entire row or column. +5

    • Like
    • Report

    2 comments | Post one | Permalink

  • by tortiecat on May 31st, 2008

    tortiecat

    When you put the cursor on the cell at the top or on the left-hand side, it should turn into a black arrow. When you click, the entire column or row should be highlighted.

    • Like
    • Report

    1 comment | Post one | Permalink

  • by Anonymous on August 4th, 2009

    Anonymous

    re: firecircle & Cyanotic Wasp 's answers...

    Works great, thanks!

    Bit of a problem, though. If you try to copy a cell, when you click on the cell you want to paste to, it loses the "copy". Any suggestions?

    No comments. Post one | Permalink

  • by SpreadsheetsDirect on July 9th, 2008

    SpreadsheetsDirect

    Have you tried freezing panes (Windows - Freeze Panes)? It will keep whatever you freeze on screen while you move down the file e.g. if you select cell D2 and freeze panes columns A, B & C and row 1 will remain when you scroll down.

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

You're reading On Excel, is there a way to have the entire row/column highlight when you click on a cell, instead of just the row number on the l.h. side and the column letter on the top?

Follow us on Facebook!

Related Ads

ANSWERBAG BUZZ

Excel 2007 cursor highlight entire row
Excel column row light
Windows excel how to highlight entire row as you scroll
Is there a way in excel to have the current cell you are only highlight the row when you are in it
Excel highlight whole column