Penny Arcade Forums› Help / Advice Forum
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

Excel / Google Spreadsheet Question

ZeromusZeromus Registered User regular
edited October 2010 in Help / Advice Forum
Hey guys,

I am ass with making spreadsheets, so I apologize if this seems a little obvious, but I've Googled around and haven't been able to find an answer: is there a way to make it so that the number in a cell is equal to the row number minus 1? For instance, I'm organizing entries for a slideshow and have a column for slide numbers, but since I am inserting new rows of information periodically, the order gets screwed up and I'd rather not have to handle it all manually. Obviously I could just look at the row number and know that the slide number will be one less than that, but for organizational purposes I'd just like to have it written there...

Thanks!

pygsig.png
Zeromus on

Posts

  • wogiwogi Registered User regular
    edited October 2010
    type in this, minus quotes "=ROW()-1"

    wogi on
    http://bit.ly/runshort
    -Current W.I.P.
  • ZeromusZeromus Registered User regular
    edited October 2010
    wogi wrote: »
    type in this, minus quotes "=ROW()-1"

    Perfect, thank you. Do you know if there's a way to paste this into every cell I have selected? Google Spreadsheets seems to want me to do it one by one...

    Zeromus on
    pygsig.png
  • DeebaserDeebaser on my way to work in a suit and a tie Ahhhh...come on fucking guyRegistered User regular
    edited October 2010
    just relabel the rows

    start with A1 = 1
    Then set A2 = A1 + 1

    Deebaser on
  • wogiwogi Registered User regular
    edited October 2010
    Zeromus wrote: »
    wogi wrote: »
    type in this, minus quotes "=ROW()-1"

    Perfect, thank you. Do you know if there's a way to paste this into every cell I have selected? Google Spreadsheets seems to want me to do it one by one...

    Oh, type it in the cell- hit enter. now select the cell again, and click and drag the tiny blue box in the lower right hand corner down to all the cells you want to apply the formula to.

    wogi on
    http://bit.ly/runshort
    -Current W.I.P.
Sign In or Register to comment.
Penny Arcade Forums› Help / Advice Forum