Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-14-2022, 12:39 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Way to drag/change all referred cells at once? Windows 7 64bit Way to drag/change all referred cells at once? Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

It would help if we could work on the sheet. Pictures are not a great help
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #2  
Old 03-14-2022, 10:45 AM
Steve Kunkel Steve Kunkel is offline Way to drag/change all referred cells at once? Windows 10 Way to drag/change all referred cells at once? Office 2019
Advanced Beginner
Way to drag/change all referred cells at once?
 
Join Date: May 2019
Location: Seattle area
Posts: 81
Steve Kunkel is on a distinguished road
Default

The actual workbook has confidential info, but here is a simplified mockup...
Also I did a quickie screencast of myself click-n-dragging the colored boxes one at a time. Original Question was: Is there a way to drag all 4 at once?


https://www.screencast.com/t/iXaYaPwLyyke
Attached Files
File Type: xlsx Example of multiple references.xlsx (9.0 KB, 9 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Numbered List - Auto Update para numbers that are referred to in later paragraphs. RobEd Word 10 10-24-2019 12:59 PM
How Do You Drag & Drop Cells in Excel 2010? juliansdad Excel 4 12-05-2013 01:15 AM
Way to drag/change all referred cells at once? Problems: Insert, Drag and drop table cells masterton Word 7 12-02-2013 12:05 PM
Change values in cells based on criteria SaneMan Excel Programming 2 02-02-2012 07:58 AM
Automatically change the value of one cell so that two other cells become equal matthew544 Excel 5 09-18-2011 08:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:40 PM.


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