Become a TFP Supporter Pool Math Forum Rules Pool School
Results 1 to 5 of 5

Thread: Excel spreadsheet problem

  1. Back To Top    #1
    meatloaf's Avatar
    Join Date
    Feb 2008
    Location
    Gilbert AZ
    Posts
    373

    Excel spreadsheet problem

    I made a spreadsheet that I need to copy and paste to another spreadsheet. The problem is when I copy and paste the spreadsheet to where I want it, the cell information is correct but the cell formulas don't carry over to the new sheet.
    How can I correct this?
    Thanks
    My pool is a 10,500 gallon (420 Sq Ft ) kidney shape. A hand made sheer decent waterfeature. STA-RITE HRPB30, Sand filter 30" 98 GPM,
    1 HP Maxi-Glas 2 pump, BBB Method, Taylor K-2005 test kit, 50 Watt 12V low-voltage pond light illuminates the pool at night for a nice soft glow.
    250 gallon stand-alone hot tub. Got it FREE!

  2. Back To Top    #2

    Join Date
    Apr 2008
    Location
    Sugar Land, TX (suburb of Houston)
    Posts
    31

    Re: Excel spreadsheet problem

    To make a cell reference absolute (in other words, it does not change relative to another cell - it references cell A1, etc) either
    1) hit F4 after selecting a cell
    2) highlight an existing cell reference and press F4.

    You can tell when a cell reference is absolute when it has a "$" before each column letter and row number ($A$1)

    Hopefully that helps.
    18K (I think) gal gunite pool, Pentair FNS DE Filter, Polaris 280 cleaner, TF-100 Test Kit

  3. Back To Top    #3
    MikeInTN's Avatar
    Join Date
    May 2007
    Location
    Middle Tennessee
    Posts
    1,335

    Re: Excel spreadsheet problem

    Instead of cutting and pasting the sheet (or chopping and glueing as a friend used to say), pull up the spreadsheet you want to copy, and then click on "Edit" and then "Move or copy sheet". You'll bring up a dialog box that will allow you to either move the existing sheet to another workbook, or make a copy of the existing sheet and keep it in the existing workbook or move it to another workbook. If you keep it in the existing book, you might want to rename the copied sheet, as it will keep the name as the existing sheet, plus a "(2)" i.e. "tfp" and "tfp(2)". The new sheet should have kept the existing formulae from the existing sheet.

    Mike
    24' x 52" AGP - approx 13,500 gallons
    Pentair Optiflo 1 hp/2sp pump w/ Swimpro Voyager 150 sq ft cartridge filter
    Intex 8110 SWCG
    "Fear the Schnauz!"

  4. Back To Top    #4
    meatloaf's Avatar
    Join Date
    Feb 2008
    Location
    Gilbert AZ
    Posts
    373

    Re: Excel spreadsheet problem

    I've got it to work, Thanks
    My pool is a 10,500 gallon (420 Sq Ft ) kidney shape. A hand made sheer decent waterfeature. STA-RITE HRPB30, Sand filter 30" 98 GPM,
    1 HP Maxi-Glas 2 pump, BBB Method, Taylor K-2005 test kit, 50 Watt 12V low-voltage pond light illuminates the pool at night for a nice soft glow.
    250 gallon stand-alone hot tub. Got it FREE!

  5. Back To Top    #5
    H2O_Keeper's Avatar
    Join Date
    Nov 2008
    Location
    SW Indiana
    Posts
    140

    Re: Excel spreadsheet problem

    I realize you already got it but when you right click after doing a "Copy" and instead of doing a "Paste" do a "Paste Special" this gives you all kinds of options on how you want to use the pasted data. Thought this tip may help others.
    21K Gal, IG, Vinyl, Bleach-Borax-Baking Soda, 3/4HP Hayward pump, Hayward sand filter, 200,000BTU Heater, TF100 Testkit
    "All that we are arises with our thoughts." - Buddha
    “When fate hands you a lemon, make lemonade.” - Dale Carnegie

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •