• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

What is ShortCut Key for selecting empty column until last row of adjacent column

PP3321

PP3321

Active Member
I need to select empty column until the last row of adjacent column.

If I use
CTL + SHIFT + DOWN

Then it will select entire column.

Is there anyway to achieve this using ShortCut?


screenshot.png
 
Hi,

If your data is in Table, Ctrl+Shift+Down Arrow will work the way you want.

If not, I am not sure about the selection, but if you want to fill down till the adjacent column's last cell, type anything in first cell (B2 in your case), and place mouse cursor over the cell, you will see + sign at bottom right. Double click it to fill down.

Regards,
 
You must log in or register to reply here.
Back
Top