Crosshair Highlight In Excel - How To Highlight Row And Column Of Active Cell -Excel Tips and Tricks

Learn how to crosshair highlight in excel, essentially, how to highlight row and column of active cell

Here's how to achieve a crosshair cell highlighting effect where both row and column is highlighted where the cell is selected. This video will demonstrate how to quickly crosshair highlight active cell in Excel? Using excel to highlight active row and column conditional formatting is what I will be doing.

Here are the steps outlined in the video.

Highlight Selected Row
1) Ctrl + A
2) Home -- Style -- Conditional Formatting
3) New Rule
4) Select "Use a formula to determine which cells to format".
5) =ROW()=CELL("ROW")
6) Format
7) Fill tab.
8) Select blue colour.
9) OK
10) OK

Highlight Selected Column
1) Ctrl + A (if dataset is not selected already)
2) Home -- Style -- Conditional Formatting
3) Manage Rules...
4) New Rule...
5) Select "Use a formula to determine which cells to format".
6) =COLUMN()=CELL("COL")
7) Format
8) Fill tab.
9) Select blue colour.
10) OK
11) OK

Animation
1) Right-click sheet. View Code.
2) Select Worksheet
3) Enter these in Worksheet_SelectionChange()
Target.Calculate
4) Ctrl+S to save
5) Close Code Editor

Here are the past videos of how to create a crosshair highlight in Excel.

🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗
Crosshair Highlight In Excel - How To Highlight Row And Column Of Active Cell -Excel Tips and Tricks

Crosshair Highlight With Intersecting Cell As Different Color - In Excel

How to crosshair highlight enabled and disable in Excel - Excel Tips and Tricks

How to Enable and Disable Crosshair Highlight for Rows or Columns in Excel - Excel Tips and Tricks

Crosshair highlight in Google Sheet - Excel Tips and Tricks

Crosshair Highlight With User Selected DropDown List in Excel - Excel Tips and Tricks

Crosshair Highlight With User Selected DropDown List in Excel - Excel Tips and Tricks - DETAIL EXPLANATION

Crosshair Highlight Entire Whole Workbook In Excel - Excel Tips and Tricks

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

[bhaggoporiksha]

Time management got much easier with your Excel tips & tricks. God bless you.

[ArupDattaAD]

Man, you are a lifesaver. It relieved my headache.

[franciskapungwe]

This is the best. Thank you for making my work easier.

[misterwill]

🤯Whaaaat?!?! 😮 I love this. I can’t wait to try it. You do an awesome job of explaining and showing the steps instead of clicking a bunch of stuff leaving the audience guessing 👏🏾

[cinetube]

So much helpful than other YouTubers ... *KEEP IT UP AND Go Ahead* 👍🏻

[kaosisoakam]

Nice job. Thank you sir for this. Can you do it in a way where by the selected column as well as the selected row will be highlighted but the selected cell will not be in the same colour as the selected column and selected row

[vishalpawarvp]

Its very nyc when we see big summary view

I just want to know is this works on Google sheets

[quangan]

I have 2 Workbooks open at the same time. When I interact with one, the other one is acting, too. Is there a way to confine the highlighting to the workbook im working with?

[MubbashirAthhar]

Hi, i tried it. Worked fine. But how do I save it to open in next session.

[rajadey]

=ROW()=CELL(*ROW")
(*ROW")
IS IT 👉* OR 👉"
SIR INFRONT THE ROW STAR OR DOUBLE INVERTER COMMA
PLZ REPLY

[shivamtiwari]

How to highlight row having special word

[FrozenHero]

I tried this - and it didn't work. A search revealed a there is a bit of VBA code required.

[eng.abdullahalfuraiji]

My worksheet became too slow on my MacBook