ArisaAnsar
asked on
Need Help with Excel (Row Highlighting)
Hi,
I have an Excel file with over 9000+ rows. Is there a way when I click in a specific row to update, the entire row is temporary highlighted in another color to let me quickly see all cells that need updating?
The spreadsheet have over 40 columns so highlighting the row, will make it easier to ensure I am updating the correct cells.
I have an Excel file with over 9000+ rows. Is there a way when I click in a specific row to update, the entire row is temporary highlighted in another color to let me quickly see all cells that need updating?
The spreadsheet have over 40 columns so highlighting the row, will make it easier to ensure I am updating the correct cells.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ryan - this is very helpful as it allowed me to highlight the row and still continue to use the "Control F" feature.
byundt - for some reason, I couldn't use the "Control F" to search the spreadsheet for specific accounts but I loved how it highlighted both the row and column.
byundt - for some reason, I couldn't use the "Control F" to search the spreadsheet for specific accounts but I loved how it highlighted both the row and column.
@Roy
Useful stuffs too, thanks for sharing = )
Useful stuffs too, thanks for sharing = )
I've used the first one for years.
The only issue with using Styles is that sometimes if a row contains different Styles then they can be over-written.
The only issue with using Styles is that sometimes if a row contains different Styles then they can be over-written.
Open in new window