Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-30-2014, 09:28 AM
PStark PStark is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Dec 2014
Posts: 8
PStark is on a distinguished road
Default Is there a way to change how Excel auto selects where it pulls data?

What I want to do is when I pull the fill bar down the rows Excel grabs the cell in another sheet in the adjacent column but same row. I am trying to set up some formulas and when I try to auto-complete the formulas the locations where Excel pulls the data changes. I tried making the sheets match but then it is not easy to read for half of the sheets. I tried to copy and transpose after I got the formulas right, but the cell formulas changed. Is this possible or do I need to just manually go through every cell? Thank you
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data Faldinio Word VBA 7 10-19-2014 06:03 AM
Cannot select single characters. Word selects paragraphs or parts of sentences. TMinnich Word 2 10-25-2013 09:38 AM
Deleting Lines Pulls Back Next Page SQLUSA Word 5 12-18-2012 03:53 PM
Language settings change on auto Deliriumdive Word 2 06-20-2012 04:22 PM
Auto Change Date in Word Document??? dssxxxx Word 2 01-06-2011 05:50 AM


All times are GMT -7. The time now is 08:07 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft