How do you hold a cell constant when copying a formula?

**stevenlcohen** · 03-12-2011, 09:04 AM

I know this is simple but I seem to remember putting some symbol in front of the cell so it doesn't point to a different cell as you copy the formula. Thanks

**jeffreybrown** · 03-12-2011, 09:07 AM

Hello & Welcome to the Board,

Highlight the cell and toggle the F4 button

http://office.microsoft.com/en-us/ex...003064048.aspx

**davesexcel** · 03-12-2011, 09:07 AM

Try the Dollar sign
=$A$1

**stevenlcohen** · 03-12-2011, 09:20 AM

thanks so much...

Thread: How do you hold a cell constant when copying a formula?

Thread Tools

Display

How do you hold a cell constant when copying a formula?

Re: How do you hold a cell constant when copying a formula?

Re: How do you hold a cell constant when copying a formula?

Re: How do you hold a cell constant when copying a formula?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions