techPowerUp! Forums Microsoft Excel 2003 question
 techPowerUp! Register FAQ Social Groups Search Today's Posts Mark Forums Read

 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 exampleA1x2=a1+13=a2+14=a3+15=a4+1so i can move them around without the values changing Thanks all! __________________
 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. __________________
 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.
 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. __________________
 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
 The Following User Says Thank You to newtekie1 For This Useful Post:
Mar 22, 2009, 10:58 PM   #7
Yin

Join Date: Feb 2006
Posts: 505 (0.19/day)
Thanks: 68
Thanked 32 Times in 29 Posts

System Specs

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
Attached Files
 2009 MARCH-APRIL.xls (74.5 KB, 84 views)
__________________

Mar 22, 2009, 11:27 PM   #8
theeldest

Join Date: Feb 2006
Location: Austin, TX
Posts: 611 (0.23/day)
Thanks: 38
Thanked 139 Times in 100 Posts

System Specs

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.

 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.”“yeah i failed. i noticed the "coming soon" part after i posted.” “people are just stupid.” Yes I am evil, yes you can have some.

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

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Hardware     General Hardware     Graphics Cards         NVIDIA         AMD / ATI     Overclocking & Cooling     Motherboards & Memory     System Builder's Advice     Cases, Modding & Electronics     Storage     Networking & Security     Project Logs     Audio, Video & Home Theater     Official Vendor Support & Information Forums         be quiet!         NZXT         Thermaltake Software     Games     Linux / BSD / Mac OS X     General Software     Programming & Webmastering Other     General Nonsense     Science & Technology     Folding@Home     World Community Grid (WCG)     Buy/Sell/Trade/Giveaway Forum     Hot Deals     techPowerUp! Club Forum www.techpowerup.com     Comments & Feedback     Reviews     Articles     News         TPU Frontpage Polls     Case Mod Gallery     Contests Our Software     GPU-Z         GPU-Z Test Builds         GPU-Z Translations     ATITool         ATITool Beta Area         ATITool Bug Reports     RBE     RealTemp

 Similar Threads Thread Thread Starter Forum Replies Last Post Drethstoff Motherboards & Memory 11 Sep 26, 2008 09:51 PM Jimmy 2004 News 16 Sep 19, 2007 03:27 AM SpoonMuffin General Software 43 Jan 19, 2007 02:46 AM

All times are GMT. The time now is 04:37 PM.

 -- Default Style -- Lightweight Contact Us - techPowerUp! - Archive - Top