I have a question unrelated to this video. Let's say I were to select Cells B2 B3 B5 B6, is there a way to select the exact Rows from a different Column e.g D2 D3 D5 D6 without selecting manually? I mean repeat my selections from Column B to Column D.
What you could do is use the name box in Excel to specify all those cells and they will be selected automatically once you press enter. Hope this helps.
I have a question unrelated to this video. Let's say I were to select Cells B2 B3 B5 B6, is there a way to select the exact Rows from a different Column e.g D2 D3 D5 D6 without selecting manually? I mean repeat my selections from Column B to Column D.
What you could do is use the name box in Excel to specify all those cells and they will be selected automatically once you press enter. Hope this helps.
@@DataSMECamp Thank you for answering. Hope I can make it work
You're welcome! Feel free to comment on any videos with anymore questions you may have, and I will do my best to respond as soon as possible