Software
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.
by nikki96
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
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
by jacmari
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!
by dklippert
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:
This discussion is closed to new replies.
Sort by Trending