General discussion

Locked

Highlight row or column

By Shanghai Sam ·
On Excell 200; I work with large spread sheet (several columns displaied at a time)
I wonder if there is an option to highlight the full row as we scan down one particular cell at the time,this is to give better look of data shown on other columns from one side to the other of the screen.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Highlight row or column

by nikki96 In reply to Highlight row or column

Not sure I understand...
You can highlight the row/column by clicking on the number/letter at the left/top of the screen instead of on an individual cell.

Nikki

Collapse -

Highlight row or column

by Don Christner In reply to Highlight row or column

If I understand what you're asking, you want to be able to scan down a column but see data several columns over from the one you are scanning. If the columns you want to see are not next to each other, temporarily hide the columns that are in the way. Select the columns to hide then select format|column|hide.

Don

Collapse -

Highlight row or column

by jacmari In reply to Highlight row or column

Hello...

I hope that this answers your question. I would recommend doing a Window -> Freeze Panes which would allow one side of the spreadsheet to freeze, while you are able to scroll it against the other columns or rows.

For example, you click in cell C4. Do a Window -> Freeze Panes... then columns A and B, and Rows 1-3 remain still. You are able to scroll the rest of the document.

Have a good one!

Collapse -

Highlight row or column

by DKlippert In reply to Highlight row or column

Try this.
Right click the Sheet tab and choose View Code. Paste the following code in the Visual Basic Editor:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = 0
ActiveCell.EntireRow.Interior.ColorIndex= 35
End Sub

If you would like a different color look at:

www.geocities.com/davemcritchie/excel/colors.htm

It's called Event code. You'll find more information at:

www.geocities.com/davemcritchie/excel/event.htm

Back to Software Forum
4 total posts (Page 1 of 1)  

Software Forums