Cell Formatting
I am trying to take and copy a format in a cell to another cell, but when I
do that it want to change the vaules to include the cell next to it. Example: Cell D5 =A1+B1+C75 when I copy & paste in D6 I get =A2+B2+C76 I want D6 to be =A2+B2+C75 How can I do this? |
Take a look at "The difference between relative and absolute references"
in XL Help: Then try: =A1 + B1 + $C$75 In article , "jmaulsby" wrote: I am trying to take and copy a format in a cell to another cell, but when I do that it want to change the vaules to include the cell next to it. Example: Cell D5 =A1+B1+C75 when I copy & paste in D6 I get =A2+B2+C76 I want D6 to be =A2+B2+C75 |
All times are GMT +1. The time now is 08:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com