ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to highlight an Excel row by clicking on a cell (https://www.excelbanter.com/excel-worksheet-functions/44465-how-highlight-excel-row-clicking-cell.html)

Marikay

How to highlight an Excel row by clicking on a cell
 
Used to be there was a way to set it up in Excel so that when you clicked on
a cell in a row, the entire row would be highlighted. This was very useful
for working with long rows of data. Just highlighting the row by clicking
before the first cell in the row doesn't offer the same advantage. Anybody
remember how to make that highlighting happen? A Cell/row format or a mouse
feature? Thanks.

Max

Maybe you mean Chip's RowLiner:
http://www.cpearson.com/excel/RowLiner.htm

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Marikay" wrote in message
...
Used to be there was a way to set it up in Excel so that when you clicked

on
a cell in a row, the entire row would be highlighted. This was very

useful
for working with long rows of data. Just highlighting the row by clicking
before the first cell in the row doesn't offer the same advantage.

Anybody
remember how to make that highlighting happen? A Cell/row format or a

mouse
feature? Thanks.





All times are GMT +1. The time now is 12:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com