App called numbers

Discussion in 'iPad 2 Forum' started by Momzoo, Oct 11, 2013.

  1. Momzoo
    Offline

    Momzoo iPF Novice

    Joined:
    Nov 3, 2011
    Messages:
    23
    Thanks Received:
    0
    Trophy Points:
    1
    Location:
    Granby, Qc Canada
    Ratings:
    +0 / 0
    I just bought the numbers app I am trying to widen the cells, cannot find out how. Can I change the font color? Also how can I give a name to my spreadsheet. Like September 2013 trip . I do not see anywhere where I can do the things I have just mentioned.

    I would like to do these 3 things hope someone can help me out. Thank youneversomuch.
  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,827
    Thanks Received:
    2,225
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,651 / 1
    If you tap the wrench icon, then Help, you'll find a manual of sorts you can go through to help you get familiarized with Numbers. You can read pretty much the same thing here in Safari: Apple - Support - iOS Apps - Numbers

    To answer you current questions:

    Widen cells: When you have a cell selected in the sheet you should see grey bars to the left and above the table. Tap the gray bar above the column you want to widen. The entire column will be boxed in blue. The top will have a thicker tab with a little drag handle symbol to the right. Drag this symbol left or right to change the size of the column. If you drag in the middle of the column instead you can change it's order.

    Font Color: Select the cell or cells. You can also select the column or row using the above method. Tap the brush icon and choose the Cells tab in the controls. The Text Options will let you change the font, size and color of text for the selected cells.

    Change the spreadsheet name: You need to be in the document view, where you see all you documents as thumbnails. Tap the name of the spreadsheet (under the thumbnail) and you be prompted to rename it. You can also rename the tabs in the open document. Double tap it and the cursor appears in the name of the tab, allowing you to edit it.
    Last edited: Oct 11, 2013
  3. Momzoo
    Offline

    Momzoo iPF Novice

    Joined:
    Nov 3, 2011
    Messages:
    23
    Thanks Received:
    0
    Trophy Points:
    1
    Location:
    Granby, Qc Canada
    Ratings:
    +0 / 0
    You have been most helpful. Thank you very much. One more little question for you and I will be done. Now that I have made my spreadsheet as I like, I sent it to my PC so I could print it and nothing works, is it because I do not have Numbers on my PC? Is there a way that I can print it? thank you again
  4. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,827
    Thanks Received:
    2,225
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,651 / 1
    If all you want to do is print, then use the PDF option when sending the spreadsheet.

    If you need to actually edit and print in Excel or an Excel compatible app use the Excel export option. The Numbers option is only compatible with itself on iOS and the Mac OS X version.
  5. Momzoo
    Offline

    Momzoo iPF Novice

    Joined:
    Nov 3, 2011
    Messages:
    23
    Thanks Received:
    0
    Trophy Points:
    1
    Location:
    Granby, Qc Canada
    Ratings:
    +0 / 0
    When I try to print it in PDF it is very small how can I print it to fill a sheet of paper. if that is possible
  6. giradman
    Offline

    giradman iPad Super Guru

    Joined:
    Apr 26, 2011
    Messages:
    3,531
    Thanks Received:
    866
    Trophy Points:
    113
    Location:
    North Carolina
    Ratings:
    +938 / 0
    Hi Momzoo - when you select the 'Share and Print' option, a number of choices are offered, one is to email the spreadsheet in one of three formats as discussed previously, while the other is 'Print' - in the latter, a blue 'Print Preview' page appears and at the bottom choices include portrait vs. landscape format, a slider for size adjustment, and an auto fit selection. However, to print from this preview page a wireless (i.e. Wi-Fi) connection to an 'Air Print' printer is needed. You might want to tells us whether you have a wireless printing option vs. emailing the spreadsheet to you and then printing it from your computer? Good luck - Dave :)
    • Like Like x 1
  7. Momzoo
    Offline

    Momzoo iPF Novice

    Joined:
    Nov 3, 2011
    Messages:
    23
    Thanks Received:
    0
    Trophy Points:
    1
    Location:
    Granby, Qc Canada
    Ratings:
    +0 / 0
    Hi Dave, I am emailing the spreadsheet to myself and then printing it from my computer. So I understand now that I must have new wireless printer. Emailing to my laptop does not seem to work at all. Thank you for all of your help, Rae
  8. giradman
    Offline

    giradman iPad Super Guru

    Joined:
    Apr 26, 2011
    Messages:
    3,531
    Thanks Received:
    866
    Trophy Points:
    113
    Location:
    North Carolina
    Ratings:
    +938 / 0
    Hi Rae - well if you are in the market for a new printer (we bought a new Canon MF Inkjet w/ Air Print built-in in the spring) which allows wireless printing w/ both on the same Wi-Fi network; there are also apps that can be put onto your computer attached to an older printer that can mimic Air Print (check HERE if not familiar w/ this Apple technology) - some more information about non-Air Print printers HERE - I used FingerPrint‚Äč on my old PC to print to my aged Canon printer before getting a new iMac & printer; so a number of options - good luck & let us know your solution(s) - Dave :)
    • Like Like x 1
  9. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,827
    Thanks Received:
    2,225
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,651 / 1
    Hm, the PDF auto-sizes to what it thinks will look best.

    You can try resizing your table in Numbers.

    By using the pinch gesture you can zoom in-out of your spreadsheet. Try zooming out a bit. Tap the table so the boarders appear. Tap the big dot that appears at the top left of the table. The table should now have some blue dots (drag handles) around the edges. Drag the dot at the bottom right to make the table larger.

    This enlarges everything, cell sizes, fonts, etc.

    Now try to share the PDF again and see if that helps.


    The print options is actually a good choice. You don't have to buy a new printer. You could get either FingerPrint or Printopia (Mac OS X Only) and install it on your home computer. This allows your computer to pretend to be an AirPrint printer, giving you the ability to print to any printer that the computer can use. As a bonus you can also print to folders.

    The second could be important in you case. The Print output of the iPad is PDF; however, unlike the PDF share option you get some control over how the table is positioned and sized when you print. Not a lot of control, but enough to at least make sure it's big enough before you waste paper.

    From and older post:


    Edit: I should have finished reading Giradman's posts. He already told you most of this.
    Last edited: Oct 13, 2013
    • Like Like x 1
  10. giradman
    Offline

    giradman iPad Super Guru

    Joined:
    Apr 26, 2011
    Messages:
    3,531
    Thanks Received:
    866
    Trophy Points:
    113
    Location:
    North Carolina
    Ratings:
    +938 / 0
    Hi TP - thanks for the additional information - have not given the email choices a try yet but should certainly work. However, out of curiosity since I'm no longer using FingerPrint, made a visit to the Collobos Website HERE - and the app seems to have been phased out there - they are offering a new product called Presto - problem seems to be a $2 monthly rate fee rather than just a 'one time' purchase - a little irritating for a home user - Dave :)
    Last edited: Oct 13, 2013
    • Like Like x 1
  11. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,827
    Thanks Received:
    2,225
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,651 / 1
    Well darn. There's still AirPrint Activator I suppose. It doesn't have any of the nice extras, but should work for basic printing. Here's a more up-to-date set of instructions for it: Install AirPrint for Windows The Easy WayJaxov

    I'll have to keep an eye out to see if anyone's taken the space Collobos left open.

    Printopia is still in business, though they've added a more expensive enterprise solution as well as the original app. But, it only works on OS X.

    Thanks for catching that. I've been saying I needed to update my information on the state of iOS printing, and this shows my how very far behind I've fallen. *sigh*
  12. Momzoo
    Offline

    Momzoo iPF Novice

    Joined:
    Nov 3, 2011
    Messages:
    23
    Thanks Received:
    0
    Trophy Points:
    1
    Location:
    Granby, Qc Canada
    Ratings:
    +0 / 0
    You can try resizing your table in Numbers.

    By using the pinch gesture you can zoom in-out of your spreadsheet. Try zooming out a bit. Tap the table so the boarders appear. Tap the big dot that appears at the top left of the table. The table should now have some blue dots (drag handles) around the edges. Drag the dot at the bottom right to make the table larger.

    This enlarges everything, cell sizes, fonts, etc. I must be blind or dumb but this tap the table for blue dot to appear does not happen with me. I do see the whole spreadsheet boxed in like when you want to make changes, but when I try to drag the bottom right it does not drag. it does mot move.
  13. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,827
    Thanks Received:
    2,225
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,651 / 1
    When you've tapped something on the table and the two gray bars appear above and to the left, at the top left next to them should be a big gray dot. Tap that. This selects the entire table and the smaller blue dot drag handles will appear in the usual paces.


    image-2004026058.jpg

    You can also drag that big gray dot to reposition the table.
  14. Momzoo
    Offline

    Momzoo iPF Novice

    Joined:
    Nov 3, 2011
    Messages:
    23
    Thanks Received:
    0
    Trophy Points:
    1
    Location:
    Granby, Qc Canada
    Ratings:
    +0 / 0
    I want to thank all of you for helping me out with my project. Everything is just fine, I was able to print the excel spreadsheet exactly the way I wanted. It was a lot of work for me but with your help I succeeded. I want to know if it is possible to make a template of this spreadsheet now that I have all my margins, spacing and font and font colors and all that jazz done I do not want to lose this. This spreadsheet is a Travelling Expenses xls. I live in Quebec Canada, and every fall we drive down to Pompano Beach FL for the winter so this sheet is very handy for me. Thank you all once again, you are the greatest forum ever!
  15. giradman
    Offline

    giradman iPad Super Guru

    Joined:
    Apr 26, 2011
    Messages:
    3,531
    Thanks Received:
    866
    Trophy Points:
    113
    Location:
    North Carolina
    Ratings:
    +938 / 0
    Hi Rae - well, I'm not sure that you can save this as a template but you certainly can email or export the spreadsheet (SS): 1) Bring up your spreadsheets, press Edit (right upper corner), then select the SS desired - next hit the box w/ the arrow (left upper corner) and choose an option; or 2) Open the SS, press the 'Wrench' and select 'Email Spreadsheet' - either way you have a copy.

    BTW, wife & I have been to Quebec 3-4 times, mainly the city and near environs (it's a BIG province for those who do not know!) - now, that is quite a DRIVE! We have visited FL annually for decades (and in the past twice a year when my wife's parents lived in Delray Beach) - now we do a yearly spring trip - last year to Naples on the West coast - Dave :)
  16. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,827
    Thanks Received:
    2,225
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,651 / 1
    It's not possible to create a true template in the iWorks apps, but you can get pretty close. I went through all the options I could think of in post #6 of the following thread. I'm a bit too lazy to retype it.

    http://www.ipadforums.net/iwork-forum/23552-changing-pages-font.html
  17. Momzoo
    Offline

    Momzoo iPF Novice

    Joined:
    Nov 3, 2011
    Messages:
    23
    Thanks Received:
    0
    Trophy Points:
    1
    Location:
    Granby, Qc Canada
    Ratings:
    +0 / 0
    I know it is quite a drive but we are in no hurry so we sleep 3 nights on our way down to Florida. We have been doing this for the past 10 years and always enjoy it. It is a long way but worth every mile to be able to spend 5 months in warm weather compared to our cold Canadian winters and snow. Happy to hear you have been to Quebec City it is a beautiful city.:eek: Rae
  18. Momzoo
    Offline

    Momzoo iPF Novice

    Joined:
    Nov 3, 2011
    Messages:
    23
    Thanks Received:
    0
    Trophy Points:
    1
    Location:
    Granby, Qc Canada
    Ratings:
    +0 / 0
    Thank you for all your help I now have a template in I tunes. I will try to open an account WEBDAV so I will not lose these templates. I will let you know how I make out. Thank you again.:eek: Rae
  19. giradman
    Offline

    giradman iPad Super Guru

    Joined:
    Apr 26, 2011
    Messages:
    3,531
    Thanks Received:
    866
    Trophy Points:
    113
    Location:
    North Carolina
    Ratings:
    +938 / 0
    Hi Rae - love Quebec City - we've made many visits to Canada over the years but always go in the summer months (i.e. July or August) - last one a few years ago was actually to Quebec. BTW if you overnight in North Carolina or adjacent states, let me know if want to do a day of sightseeing - we've travelled the area extensively - enjoy your next trip to sunny FL! Dave :)
  20. Momzoo
    Offline

    Momzoo iPF Novice

    Joined:
    Nov 3, 2011
    Messages:
    23
    Thanks Received:
    0
    Trophy Points:
    1
    Location:
    Granby, Qc Canada
    Ratings:
    +0 / 0
    I just knew it would not be that easy for me. I now have a BOX ACCOUNT but cannot see the navigation page on the IPAD I created a folder and I see it on the left side of but do not know how to retrieve files to put in that folder. I still do not have a navigation page.Help again if that is possible.

Share This Page

Search tags for this page

ap called numberd

,

how do you zoom in apple's app called numbers

,

mac apps called numbers

,

need instructions on app called numbers