Excel problem

Forums: Computers
Email this Topic • Print this Page

Does any one know how to copy and paste if formulas without updating the cell reference

cheers

Type: Discussion • Score: 1 • Views: 627 • Replies: 2

No top replies

add $ signs around the values to keep them constant, ie:

=$A$6

that should stop the cell reference changing when you copy/paste.

0 Replies

cheers bruv

0 Replies

Clone of Micosoft Office - Question by Advocate

Do You Turn Off Your Computer at Night? - Discussion by Phoenix32890

The "Death" of the Computer Mouse - Discussion by Phoenix32890

Windows 10... - Discussion by Region Philbis

Surface Pro 3: What do you think? - Question by neologist

Windows 8 tips thread - Discussion by Wilso

GOOGLE CHROME - Question by Setanta

.Net and Firefox... - Discussion by gungasnake

Hacking a computer and remote access - Discussion by trying2learn

▲ ▼