Microsoft Excel 2003 question

Yin · Mar 9, 2009, 12:40 AM

Hey everyone,

Just wondering if anyone knows how to make cells equal their values instead of it being a function.

say for example

A

1

x

2

=a1+1

3

=a2+1

4

=a3+1

5

=a4+1

so i can move them around without the values changing

Thanks all!

Polarman · Mar 9, 2009, 12:48 AM

Not sure what you mean.

Yin · Mar 9, 2009, 06:24 AM

okay i'll try to re word it
letters = columns
numbers = rows

so lets say
A1 = "10"
A2 = "=A1+1"
A3 = "=A2+1"
A4 = "=A3+1"
A5 = "=A4+1"

so what we see is
A1 = 10
A2 = 11
A3 = 12
A4 = 13
A5 = 14

its kinda confusing =/

phanbuey · Mar 9, 2009, 06:40 AM

hrm... it would have to be a function in any case.

Akumos · Mar 11, 2009, 05:57 PM

Or could be a simple formula. have a hidden column of formulaes and link??

Don't think it's possible wihtout a function or formula though... interesting to see what other poeple write.

newtekie1 · Mar 11, 2009, 06:00 PM

The only thing I can think of is having the formula calculate the value, then copy the value, and do a paste special to paste the value into the cell.

Yin · Mar 22, 2009, 10:58 PM

I think it would be easier if you guys look at the file.

Basically you will noticed the dates are all in a formula and I wanna just get my own time table so i know when i'm working

theeldest · Mar 22, 2009, 11:27 PM

Quote:

Originally Posted by Yin

okay i'll try to re word it
letters = columns
numbers = rows

so lets say
A1 = "10"
A2 = "=A1+1"
A3 = "=A2+1"
A4 = "=A3+1"
A5 = "=A4+1"

so what we see is
A1 = 10
A2 = 11
A3 = 12
A4 = 13
A5 = 14

its kinda confusing =/

The way I understand it, you want the values from those cells in different Cells?

So you want:
B1= 10
B2= 11
B3= 12
B4= 13
B5= 14

Is this right?

If so, you want to enter:
B1= "=A1"
B2= "=A2"
B3= "=A3"
B4= "=A4"
B5= "=A5"

The easiest way to do this is click in the cell you want the value to appear in. Hit the equals sign, then click the source cell you want it to mirror. Then hit enter.

Yin · Mar 23, 2009, 02:10 PM

well I don't even know how the excel file really works to be honest, but basically I want to get rid of the other people and move all mine into a nice simple line.

Steevo · Mar 23, 2009, 03:12 PM

"$"

Will maintain a constant across multiple cells.

So if I wanted A1 to be a constant and multiply a range of dependants without changing it you will have to use a "$"sign. When all else fails, use help.

Mar 9, 2009, 12:40 AM	#1
Yin Join Date: Feb 2006 Posts: 505 (0.19/day) Thanks: 68 Thanked 32 Times in 29 Posts System Specs	Microsoft Excel 2003 question Hey everyone, Just wondering if anyone knows how to make cells equal their values instead of it being a function. say for example A 1 x 2 =a1+1 3 =a2+1 4 =a3+1 5 =a4+1 so i can move them around without the values changing Thanks all! __________________

Processor:	Intel i7 920
Motherboard:	ASUS RAMPAGE II Extreme
Cooling:	CM v10
Memory:	Corsair 3 x 2GB TR3X6G1866C9DF
Video Card:	Nvidia XFX 8800GT Stock
Hard Disk:	Seagate ST3500320AS, 2 x Samsung HD103UJ
CRT/LCD Model:	2408WFP
Case:	Corsair 800D
PSU:	Corsair HX750W

Mar 9, 2009, 12:48 AM	#2
Polarman Join Date: Jun 2008 Location: Laval, Qc Posts: 1,575 (0.88/day) Thanks: 41 Thanked 300 Times in 199 Posts System Specs	Not sure what you mean. __________________

System Name:	Polar's Dragon
Processor:	AMD Phenom II 975BE
Motherboard:	MSI 890FXA-GD65 (Bios 18.7)
Cooling:	Zalman CNPS 9700 Led
Memory:	Gskill 4GB DDR3-1333 (8,8,8,21)
Video Card:	MSI HD6870 Hawk
Hard Disk:	WD RE4 500GB
Optical Drive:	Asus DRW-24B1ST
CRT/LCD Model:	Samsung T240 (1920 X1200)
Case:	Silverstone Raven 2
Sound Card:	Realtek ALC892
PSU:	PC Power&Cooling Silencer 750 (Red)
Software:	Windows 7 Home Premium 32Bit + SP1

Mar 9, 2009, 06:24 AM	#3
Yin Join Date: Feb 2006 Posts: 505 (0.19/day) Thanks: 68 Thanked 32 Times in 29 Posts System Specs	okay i'll try to re word it letters = columns numbers = rows so lets say A1 = "10" A2 = "=A1+1" A3 = "=A2+1" A4 = "=A3+1" A5 = "=A4+1" so what we see is A1 = 10 A2 = 11 A3 = 12 A4 = 13 A5 = 14 its kinda confusing =/ __________________ Last edited by Yin; Mar 9, 2009 at 06:40 AM.

Mar 9, 2009, 06:40 AM	#4
phanbuey Eligible for custom title Join Date: Nov 2007 Location: Miami Posts: 5,010 (2.48/day) Thanks: 1,484 Thanked 959 Times in 812 Posts System Specs	hrm... it would have to be a function in any case.

System Name:	LoLBoX
Processor:	Core i5 750 at 3.33 Ghz 21x159bclk @1.15v
Motherboard:	Gigabyte H55-ITX
Cooling:	Corsair H50
Memory:	8GB Samsung ECO 4GBx2 - 1590Mhz 8-8-8-21 1T @ 1.4v
Video Card:	EVGA GTX 570 @ 785/1570/2020
Hard Disk:	500GB WD Caviar Black 32MB
Optical Drive:	Slimline +/- DVD-RW
CRT/LCD Model:	22" Viewsonic 1080P LED
Case:	Silverstone SG08
Sound Card:	Yes
PSU:	Silverstone SG08 600W
Software:	Windows 7 64 Bit

Mar 11, 2009, 05:57 PM	#5
Akumos Join Date: Nov 2008 Location: Birmingham, England... Posts: 474 (0.29/day) Thanks: 73 Thanked 27 Times in 22 Posts System Specs	Or could be a simple formula. have a hidden column of formulaes and link?? Don't think it's possible wihtout a function or formula though... interesting to see what other poeple write. __________________

Processor:	Intel Core 2 Quad Q6600 @ 2.8GHz
Motherboard:	Gigabyte X48T-DQ6
Cooling:	Zalman 9500 LED CPU Cooler
Memory:	2x 2GB Corsair DDR3 XMS3 DHX - 1600MH/PC3-12800
Video Card:	Gigabyte HD4870 1GB
Hard Disk:	2x Seagate 320GB Barracuda (RAID 0) 3x 1TB Samsung F3, 140GB WD Maxtor (10,000rpm)
CRT/LCD Model:	2x 20" LG Flatron L204WS
PSU:	Powercool 850W
Software:	Windows 7 Ultimate x64

Mar 11, 2009, 06:00 PM	#6
newtekie1 Semi-Retired Folder Join Date: Nov 2005 Location: Indiana Posts: 17,766 (6.48/day) Thanks: 780 Thanked 5,119 Times in 3,709 Posts System Specs	The only thing I can think of is having the formula calculate the value, then copy the value, and do a paste special to paste the value into the cell. __________________ Rig1: System Specs. Rig2: A8-5600K@4.4GHz / AsRock FM2A75 Pro4 / 8GB Corsair DDR3-1600 9-9-9-24 / HD7560D / Samsung DVD-Burner / 1.5TB WD Green + 3x3TB WD RED in RAID5 Rig3: Athlon X2 4200+ / M4A79 Deluxe / 4GB G.Skill Pi DDR2-800 4-4-4-12 / GT430 / Sony DVD-Burner / 500GB WD Rig4: Phenom II x6 1605T @ 3.6GHz / Asus M5A99X Evo / 8GB PNY DDR3-1600 9-9-9 / GTX470 & GTX470 / Samsung DVD-Burner / 1.5TB Seagate

Processor:	Intel Core i7 875K@4.0GHz(200x20)
Motherboard:	eVGA P55 FTW 200
Cooling:	Thermalright Ultra-120 Extreme w/ Corsair SP120 High Performance Edition
Memory:	8GB Corsair DDR3-1600 7-7-7-20
Video Card:	ASUS GTX 670 4GB DirectCU II @ 1015/3600
Hard Disk:	1TB Seagate 7200.12(OS), 3x 1.5TB Seagate 7200.11 in RAID 5
Optical Drive:	Lite-On Blu-Ray Combo Drive IHES108
CRT/LCD Model:	HP 25" 2509m 1080p LCD
Case:	Lian-Li Lancool Metal Boned K7 w/ Windowed Side Panel
Sound Card:	Onboard is good enough for me
PSU:	Corsair HX850
Software:	Windows 7 x64 Professional

System Name:	WAZAAM!
Processor:	Intel i5-2500k - 4.4GHz @ 1.3v
Motherboard:	ASUS Maximus IV Extreme-Z (z68)
Cooling:	HSF:: Noctua NH-D14 \|\| CASE:: 2x Intake: Noctua NF-P12-1300 \| 2x Exhaust: Noctua NF-S12B
Memory:	G.Skill RipJaws 16GB (4x4GB) @ 1866MHz \| 10-10-10-28-2T @ 1.35v
Video Card:	Crossfire: 2x MSI Frozr III 6950 2GB - Unlocked from 1408 to 1536 shaders - 850/1300
Hard Disk:	Intel 20GB 311 (SRT cache) \| OCZ 120GB Agility 3 (apps) \| 4x Ultrastar 2TB in RAID10 (2.0 TiB Boot)
Optical Drive:	Gearhead DVD burner
CRT/LCD Model:	3x1 Eyefinity \| Three Dell U2412m - 24" e-IPS 1920x1200
Case:	Antec P183 - Custom Interior Paint Job
Sound Card:	Onboard - Bose Companion 2 Speakers
PSU:	CORSAIR Professional Series HX850
Software:	Windows 7 Ultimate x64
Benchmarks:	Server -- Athlon II 240 -- 2x4GB G.Skill 1866MHz DDR3 -- 320GB AAKS OS HDD -- 4x 2TB Samsung F4

Mar 23, 2009, 02:10 PM	#9
Yin Join Date: Feb 2006 Posts: 505 (0.19/day) Thanks: 68 Thanked 32 Times in 29 Posts System Specs	well I don't even know how the excel file really works to be honest, but basically I want to get rid of the other people and move all mine into a nice simple line. __________________

Mar 23, 2009, 03:12 PM	#10
Steevo Eligible for custom title Join Date: Nov 2005 Posts: 5,567 (2.02/day) Thanks: 238 Thanked 979 Times in 729 Posts System Specs	"$" Will maintain a constant across multiple cells. So if I wanted A1 to be a constant and multiply a range of dependants without changing it you will have to use a "$"sign. When all else fails, use help. __________________ “it would have been perfect....its got trains and the line"tech your kids not to do what iv done"(or similar) because i had obviously done something to warrent 2 e-thugs to come 4000miles out of their way and kill me.” -Solaris17 “yeah i failed. i noticed the "coming soon" part after i posted.” -Mussels “people are just stupid.” -W1zzard Yes I am evil, yes you can have some.

System Name:	MoFo
Processor:	AMD PhenomII 1100T @ 3.7Ghz/4.1Ghz Turbo
Motherboard:	Asus M3A32-MVP Deluxe 2202 BIOS
Cooling:	Swiftec 655 pump, Apogee GT, MCW60-R GPU, MCR360mm Rad, 1/2 loop.
Memory:	G-Skill 1200Mhz 5.5.5.15 2T
Video Card:	HD5870 1Gb HIS custom BIOS watercooled & VRM-R4
Hard Disk:	2 Agility 3 SSD RAID 0 on highpoint 640, 2 3TB RAID 0, 1 2TB and one failing 750Gb
Optical Drive:	Lite-On DL DVD
CRT/LCD Model:	Asus 1920X1200 60Hz 25.5" LCD, 46" 1080P Toshiba LCD
Case:	Rosewill R6A34-BK modded (thanks to MKmods)
Sound Card:	On Board
PSU:	750W PC Power & Cooling modded (thanks to MKmods)
Software:	Vista X64 Ultimate/Win 7 Ultimate
Benchmarks:	780 MBps read on HDD's 1052 core on 5870.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Advice on ram I can buy.	Drethstoff	Motherboards & Memory	11	Sep 26, 2008 09:51 PM
Office 2003 Service Pack Three Released	Jimmy 2004	News	16	Sep 19, 2007 03:27 AM
Violate the laws of physics:Windows Vista DRM	SpoonMuffin	General Software	43	Jan 19, 2007 02:46 AM