Forum Discussion
How to Select Non-Consecutive Columns in Excel Using Keyboard Only
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,
virtuoso
If that's the only error please remove apostrophes here
=IF(V11<15000/12,0,
IF(V11<30000/12, "(V10-(15000/12))*2.5%",
IF(V11<45000/12, "((V10-(30000/12))*10%)+(375/12)",
IF(V11<60000/12, ((V11-(45000/12))*15%)+(1875/12),
IF(V11<200000/12, ((V11-(60000/12))*20%)+(4125/12),
IF(V11<400000/12, ((V11-(200000/12))*22.5%)+(32125/12),
IF(V11<600000/12, "((V10-(400000/12))*25%)+(77125/12)",
IF(V11<700000/12, "((V10-(400000/12))*25%)+(77500/12)",
IF(V11<800000/12, ((V11-(400000/12))*25%)+(79750/12),
IF(V11<900000/12, ((V11-(400000/12))*25%)+(82000/12),
IF(V11<1000000/12,((V11-(400000/12))*25%)+(85000/12),
IF(V11>1000000/12,((V11-(400000/12))*25%)+(90000/12),0
))))))))))))