Auto Highlight Active Cell's Row in Excel
Learn how to automatically highlight the active cell's row in MS Excel.
Download the practice workbook file from below article link.
learnexcelandsheets.com/autom...
Learn how to automatically highlight the active cell's row in MS Excel.
Download the practice workbook file from below article link.
learnexcelandsheets.com/autom...
Пікірлер: 13
Great yar
Awesome...simple way to understand...ty
@spreadsheet_power
Ай бұрын
Glad it helped!
Very useful, thank you🙏
@spreadsheet_power
4 ай бұрын
welcome
"application.ScreenUpdating=true" is very important. Most other videos on this use "Target.Calculate", but this fails to let you add or insert lines to your table.
Very useful tip
@spreadsheet_power
4 ай бұрын
Thank you 🙏
Any way I can enable this permanently in all excel files?
Well it’s quite cool to practice excel skill but I’m wondering who would anyone use that instead of just using native excel solution. You can highlight the whole row by clicking on the row number. Additionally this solution uses VBA so it will not even work on excel cloud. Don’t get me wrong, it’s good exercise but overall kind of useless in my pov.
@spreadsheet_power
4 ай бұрын
This is automatic highlighting, the major use of this is to easily figure out the selected row in big data. Its useful in meetings and presentation, when there is big data and you have to switch between rows frequently to explain the things. Anyway, thanks for the comment🙏🙂
@ukaszwisniewski6366
4 ай бұрын
@@spreadsheet_powerI cannot imagine situation when I show excel table during the meeting. As CX manager I work with data each day and I doubt that any manager would present a table with data or spreadsheet in from of other stakeholders. In such meeting we present charts, results, etc which are self explanatory and highlighting anything is not needed. If anyone need to highlight data during presentation it means the presentation is poor. Taking all into account I still cannot find justification or good use case for it.
@charlesbradford6738
19 күн бұрын
It is useful when comparing your data to another list etc. For example, you can go down row by row by hitting the down arrow, like when comparing to a bank statement. You can't do that your way: the down arrow would only highlite the next row first cell. This makes it easy to read a table without needing alternating shaded bands.