Excel spreadsheet row numbers

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

  1. candirisk
    Offline

    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
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,842
    Thanks Received:
    2,233
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,665 / 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
apple numbers insert row not working
,
how do allter rows in spredsheet in ipad
,
how do i put a how to store a spreadsheet on my ipad
,
how to add a line in excel spreadsheet on ipad
,
how to add lines in excel on ipad
,
how to enter rows in ipad numbers
,
how to insert a line in excel spreadsheet on ipad
,
how to insert a row in excel on an ipad
,
how to insert cell in excel ipad
,
how to insert row in excel ipad
,

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 a row in excel for ipad
,
insert column
,
ipad excel insert row
,

ipad numbers row numbers

,

numbers ipad show row numbers

,
show row numbers in excel 2011 for mac