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?
by 
East Hill
ANSWERS: 6
-
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.
-
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
-
If you press ctrl & space together it will highlight the column, shift & space will do a row.
-
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.
-
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.
-
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?
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC