TIP: Click on subject to list as thread! ANSI
echo: ms_word
to: ADAM ALSOP
from: DIK COATES
date: 1997-04-25 06:50:00
subject: Info Needed

>>>> QUOTING Adam Alsop to Dik Coates <<<<
 DC>In cell G5, for example, I want to be able to add two values B5+D5
 DC>and in cell K5 I want divide G5/H5.  This is easy enough, but, I
 DC>want to be able to do this for G6, G7... G30, etc.
 DC>Is there an easy way copy the formula and have it have it do
 DC>calculations relative to a position?
 AA> Hey there!  :)
Howdy, Adam...
 AA> You can use the Format Painter - select the cell that has the initial 
 AA> formula, and then hit the Format Painter button and highlight the 
 AA> portion of the column that you want to change.
Thanks... will give it a try... didn't know anything about the 'Format 
Painter'
Regards Dik
... Python of Borg - And now for something completely futile.  
___ Blue Wave/QWK v2.12
--- Maximus 3.01
---------------
* Origin: StarLab! In Orbit, Lindsay, Ont. (705) 328-2954 (1:253/232)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.