Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2016, 01:32 PM
Rudi Rudi is offline How to insert cell links from one worksheet in another by drag down Windows 7 64bit How to insert cell links from one worksheet in another by drag down Office 2010 64bit
Novice
How to insert cell links from one worksheet in another by drag down
 
Join Date: Jan 2012
Posts: 15
Rudi is on a distinguished road
Default How to insert cell links from one worksheet in another by drag down

I have a central worksheet (let’s call it A) into which I enter values. In order to make life easier I would like to copy these values into another worksheet (i.e., B). Therefore, I typed ‘=’ into a cell in Worksheet B to start a function and then clicked on the relevant cell in Worksheet A. So far so good. However, what doesn’t seem to work in this case is the normal procedure to then click and drag the target cell in Worksheet B downwards. Or I should rather say it just copies cell A1 down to all the cells I have dragged it over, rather than, as usually (using Ctrl.), update the cell reference. With that I mean, if the source cell is BlaBlaBla A1 the next cell is then also BlaBlaBla A1 instead of … A2, … A3 etc.

If that is the only way, it will mean that I have to enter the relevant values individually into every target cell. In view of there being over 1200 cells it would be tedious work, indeed. Does anyone know of a way to do this in one fell swoop?

By the way, I have also tried Ctrl. + Alt. but that did not work either.



Many thanks

Rudi
Reply With Quote
  #2  
Old 02-25-2016, 03:01 AM
xor xor is offline How to insert cell links from one worksheet in another by drag down Windows 10 How to insert cell links from one worksheet in another by drag down Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Have you checked that neither the cells in sheet A nor in sheet B are formatted as text?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert editable chart into worksheet Fraser Excel 0 02-20-2014 08:38 PM
How to insert cell links from one worksheet in another by drag down Problems: Insert, Drag and drop table cells masterton Word 7 12-02-2013 12:05 PM
How to insert cell links from one worksheet in another by drag down getting the worksheet name in a cell derohanes Excel 9 02-14-2013 01:29 PM
How to insert cell links from one worksheet in another by drag down can i drag a cell from one page to the other? how? Sunny Excel 3 04-19-2012 11:59 PM
How to insert cell links from one worksheet in another by drag down Insert/Paste Picture into Protected Worksheet udea Excel 1 02-06-2012 07:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft