beautypg.com

Formatting options – HP Prime Graphing Calculator User Manual

Page 210

background image

206

Spreadsheet

Formatting options

The formatting options appear
when you tap

. They

apply to whatever is currently
selected: a cell, block, column,
row, or the entire spreadsheet.
The options are:

Name

:

displays an input

form for you to give a name to whatever is selected

Number Format

: Auto, Standard, Fixed, Scientific, or

Engineering. See “Home settings” on page 30 for more details.

Font Size

: Auto or from 10 to 22 point

Color

: color for the content (text, number, etc.) in the

selected cells; the gray-dotted option represents Auto

Fill

: background color that fills the selected cells; the gray-

dotted option represents Auto

Align

: horizontal alignment—Auto, Left, Center, Right

Align

: vertical alignment—Auto, Top, Center, Bottom

Column

: displays an input form for you to specify the

required width of the selected columns; only available if
you have selected the entire spreadsheet or one or more
entire columns.
You can also change the width of a selected column with
an open or closed horizontal pinch gesture.

Row

: displays an input form for you to specify the required

height of the selected rows; only available if you have selected the
entire spreadsheet or one or more entire rows.
You can also change the height of a selected row with an
open or closed vertical pinch gesture.

show “

: show quote marks around strings in the body of

the spreadsheet—Auto, Yes, No

Textbook

: display formulas in textbook format—Auto, Yes, No

Caching

: turn this option on to speed up calculations in

spreadsheets with many formulas; only available if you
have selected the entire spreadsheet