1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

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:
    15,935
    Thanks Received:
    1,807
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,913 / 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
,
excel ipad insert row
,
how do allter rows in spredsheet in ipad
,
how do i put a how to store a spreadsheet on my ipad
,
how do you restore a number to a row in excel for mac
,
how to add lines in excel on ipad
,
how to enter rows in ipad numbers
,
how to fill columns and rows with numbers 1-100000 in micexcel
,
how to insert a row in apples numbers for 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 make all one row on 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 numbers row numbers