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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:40 AM.