Excel spreadsheet row numbers

Discussion in 'iPad Help' started by candirisk, Jun 21, 2011.

  1. candirisk

    candirisk iPF Noob

    Joined:
    Jun 17, 2011
    Messages:
    7
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    On the excel spreadsheets that I have imported onto my iPad, there are no row numbers. Any idea how to ensure that row numbers do appear?
     
  2. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,248
    Thanks Received:
    2,462
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +3,007 / 1
    It does seem a little weird not to see them all the time, but I suppose the only time you really need them is when you are editing a formula, and they will appear when you are in the formula editor.

    Double tap on a cell, then choose the = sign from editor choices. Columns and rows will be labeled.

    I looked for another way, and was almost certain there was because I'd seen them before, but in retrospect I'm guessing it was when I was editing formulas, which would be the only time I really cared.

    If you need a numbered row you can create a header row and auto-fill it. Enter the first couple numbers with the right interval (1,2 / 1,3 / 1, 1.25 / etc) tap to select the first cell, drag to select all the cells with data, tap and hold for the popup menu, choose fill, then drag the result to fill all the remaining cells. Works with dates too.
     

Share This Page

Search tags for this page
how do i put a how to store a spreadsheet on my ipad
,
how to add lines in excel on ipad
,
how to enter rows in ipad numbers
,

how to insert row on ipad excel

,

how to insert rows in excel on ipad

,
how to number rows in excel for apple
,
how to show row numbers on spreadsheet mac
,
insert column
,

ipad numbers row numbers

,

numbers ipad show row numbers