How to add a fixed value to an entire column?

		Microsoft Office Forums > Microsoft Excel > Excel
How to add a fixed value to an entire column?

FAQ

Thread Tools

Display Modes

12-12-2012, 12:38 PM

GoldenSlumbers GoldenSlumbers is offline

Windows XP How to add a fixed value to an entire column?

Office 2003

Novice

Join Date: Dec 2012

Posts: 8

GoldenSlumbers is on a distinguished road

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatically enter date into a column and make that column read only	Mr Davo	Excel	1	10-29-2012 01:07 AM
How to use fixed duration, fixed work and have resources/units leveled automatically?	Joeb	Project	3	06-25-2012 04:18 PM
free slack changes when i paste from fixed cost to cost1 column	ketanco	Project	5	02-03-2012 06:17 AM
NETWORKDAYS calculation for entire column	Salient	Excel	0	07-11-2011 03:58 PM
Formula not getting copied to entire column	theacegary	Excel	1	11-29-2010 02:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:09 AM.