How to Use Sheet To Go on the BlackBerry PlayBook

The BlackBerry PlayBook’s spreadsheet app (with an unfortunate name that sounds like the description of a wanderer in search of a bed) works with XLS or XLSX files, and has most full spreadsheet functionality. It certainly works well for basic calculations and display of tables; it isn’t as adept as a desktop or laptop version when dealing with multiple-page spreadsheets.

To open the spreadsheet app, go to the PlayBook’s home screen and tap the Sheet To Go icon. The first screen lists recent documents, which is a shortcut to files you’ve worked with previously.

Use spreadsheets for two purposes: for numerical tracking of things like expenses and income, and as a handy tool to maintain sortable lists and tables.

image0.jpg

Here are some special Sheet To Go commands:

  • Create a new spreadsheet. Tap New Document from the opening screen.

  • Open an existing spreadsheet. Tap Browse and then tap one of the displayed spreadsheets. If you have an attached BlackBerry smartphone, you can browse for compatible spreadsheets stored in that device’s flash memory.

  • Save a spreadsheet. Swipe down from the top bezel. Tap the Save icon. Tap Save As to give your work a new name. The file is ordinarily stored on your PlayBook. If you have a BlackBerry smartphone linked to your tablet, you can tap Save To and have the new file stored in the phone’s flash memory.

  • Change the font for text or data. Tap the F icon and make selections; see the options listed in the previous section about Word To Go.

    image1.jpg
  • Change number formatting. Tap the quick format icon, which looks like an F with wings. For an example. Here you can choose amongst the following styles for a cell:

    • Number treats the contents as a number.

    • Time treats the contents as a time of day.

    • Percentage treats the contents as a percentage.

    • Text treats the contents as text, even if it has digits (important if a column holds product IDs, flight numbers, or the like).

    • Currency treats the contents as currency.

    • Date treats the contents as a date.

  • Hide a column or row. Tap the letter (for the column) or the number (for a row) you want to hide. Then tap the closed-eye icon. To reveal a hidden column or row, tap the open-eye icon in the bar at the top of the sheet.

  • Delete a column or row. Tap the letter (for the column) or the number (for a row) you want to delete. Then tap the delete icon.

  • Clear the contents of a single cell. Tap on a cell to highlight it; it will be marked within a box with two blue circles at opposite corners. Then tap the delete icon.

  • Change the font, size, color, or fill color for a font style to a row, column, or cell. Tap the letter (for the column), the number (for a row), or an individual cell to highlight. Then tap the F icon to display the Cell Formatting box and choose options there.

  • Wrap the contents of a single cell or all cells in a row or column. Tap the letter (for the column), the number (for a row), or an individual cell to highlight. Then tap the F icon to display the Cell Formatting box. Tap the Word Wrap check box.

  • Apply a font style to a row, column, or cell. Tap the letter (for the column), the number (for a row), or an individual cell to apply a highlight. Then tap the B icon for boldface, the I icon for italics, or the U icon to apply underline. You can also combine two or more of these attributes.

The Help screen for Sheet To Go lays out most of the basics.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com