How to Select Non-Consecutive Columns in Excel Using Keyboard Only

Copper Contributor

Hello everyone,

I hope you're all doing well. I have a question about selecting non-contiguous columns in Microsoft Excel using only the keyboard. I've come across the following article on the Microsoft support page: Select cell contents in Excel.

In this article, they explain various methods for selecting cells, but it seems that most of them involve using a mouse or a similar pointing device. I'm specifically interested in selecting non-consecutive columns solely using keyboard shortcuts.

I'd appreciate it if anyone could share their insights or if you've come across a method for doing this using only the keyboard. If you could also refer to any relevant sections in the provided article or suggest alternative approaches, it would be very helpful.

Thank you in advance for your assistance!

Best regards,


1 Reply
best response confirmed by virtuoso (Copper Contributor)


That's with F8 and Shift+F8, please check here How to Select Non-adjacent cells in Excel? (4 Easy Ways) - Trump Excel

If to select not ranges but entire grid columns press Ctrl+Space on each step