Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel -

  1. Dec 30, 2009 #1
    Excel - URGENT


    If you want to reference a box in excel, what's the command?

    I thought it was $E5$ but that doesn't work.

    Does anyone know what I'm talking about? I want to reference the box ONLY and drag it down after adding additional boxes in a column.

    Please let me know if there is confusion.
  2. jcsd
  3. Dec 30, 2009 #2
    Re: Excel - URGENT

    Try $E$5
  4. Dec 30, 2009 #3
    Re: Excel - URGENT

    ah thank you!
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Similar Threads - Excel Date
Putting Excel graph into LaTeX Feb 10, 2018
Excel Error Bars Nov 26, 2017
Plotting two matrices in Excel Jan 5, 2017
Excel Plots Labels Jan 5, 2017
How to do this with Excel Jun 28, 2016