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

Dik,
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?
Hey there!  :)
You can use the Format Painter - select the cell that has the initial 
formula, and then hit the Format Painter button and highlight the 
portion of the column that you want to change.
It works the same way in Excel.
						--- Adam
adam.alsop@juno.com
___
* UniQWK v4.2 * The Windows Mail Reader
 
--- LoraBBS-OS/2 v2.40pl59+
---------------
* Origin: Miles Enterprises * 33.6k * 805-264-0200 * (1:2004/102.0)

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™.