# Copying % formula

Solved/Closed
Related:

- Copying % formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Credit summation formula - Guide

## 1 response

rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766

Apr 6, 2010 at 09:58 AM

Apr 6, 2010 at 09:58 AM

To keep address of a cell constant you need to use $

$A$1 is absolute to A1 always

$A1 is absolute column A but row will change

A$1 is absolute row 1, but column would change

$A$1 is absolute to A1 always

$A1 is absolute column A but row will change

A$1 is absolute row 1, but column would change

Apr 6, 2010 at 10:57 AM