ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can I turn off the auto-select in Functions? (https://www.excelbanter.com/excel-worksheet-functions/149677-can-i-turn-off-auto-select-functions.html)

slb1170

Can I turn off the auto-select in Functions?
 
I am conducting statistical analysis using a Data Analysis add-in.

Within one worksheet are several sets of data. When I run the same stat
analysis function more than once, for the second and subsequent times, Excel
automatically selects the last range of data that I performed that function
on. I have to scroll to the new set that I'm working with - even though I
was there in the first place. Can I turn this off?


All times are GMT +1. The time now is 02:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com