Microsoft Office Forums - View Single Post - How to add a fixed value to an entire column?

Thread: How to add a fixed value to an entire column?

View Single Post

Old

12-12-2012, 12:38 PM

GoldenSlumbers GoldenSlumbers is offline

GoldenSlumbers is offline

GoldenSlumbers uses Windows XP

Windows XP GoldenSlumbers uses Office 2003

GoldenSlumbers uses Office 2003

Office 2003

Novice

Join Date: Dec 2012

Posts: 8

GoldenSlumbers is on a distinguished road

Default

If you open a new spread sheet and type 3 in cell A1 and in cell B1 type =sum(A1+3) it will calculate it for you, then it's a case of copying the formulae down the page to replicate it to all the stock.

Reply With Quote