1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to move selection without moving selected data?

I'm working with a very large data set (>50,000 values), and need an efficient way to index and create charts from a selected range. What works is CTRL+F for the name of a well (B2 shown here) which then allows me to select all cells named B2. What I want to be able to do now is to move the selection frame over to just select those 724 cells but ONLY in columns D&E. Excel lets me select B through E via Shift+Arrows. How can I only move the selection pane without moving/pasting data over? TIA.

https://preview.redd.it/b4vlmr4s4vug1.png?width=2879&format=png&auto=webp&s=6fbe5539eef3ebbe820569a09c95959ab45e71ff

https://preview.redd.it/5bii8s4s4vug1.png?width=2874&format=png&auto=webp&s=ec70f1611e884ffc812eabfdc73843e284eb32e1

https://preview.redd.it/glq2ur4s4vug1.png?width=2878&format=png&auto=webp&s=990755d70452fb92246c7e9ed6d1fb5c973e397b

submitted by /u/OnewhoSortsNew
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article