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

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel compatibility
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#large dataset processing
#financial modeling with spreadsheets
#interactive charts
#data set
#selection frame