# Appendix A:

# Menus and Keyboard Shortcuts

This appendix is a reference section for BeatWare Sum-It menus and keyboard shortcuts.

# Menus

The main menu of BeatWare Sum-It consists of the following menu types: File, Edit, Format, Data, Chart, and View, and Help. The menu items from each and their keyboard shortcuts (where applicable) are summarized in the sections below:

## File Menu

Menu item | Does this | Keyboard shortcut
New | Opens new worksheet (file). | Cmd+N
Open | Brings up file selection window from which to open existing file. | Cmd+O
Close | Closes a worksheet window. | Cmd+W
Save | Saves a file. With the first Save you name and set the file's directory path; subsequent use of Save saves all work done since previous Save. | Cmd+S
Save As | Names an unnamed file or saves a previously saved file to a different location. | Shift+Cmd+S
Revert | Reverts to previously saved version of worksheet. |
Page Setup | Set options for appearance of printed page. |
Print | Prints the worksheet. | Cmd+P
Quit | Closes the worksheet and exits the application. | Cmd+Q

## Edit Menu

Menu item | Does this | Keyboard shortcut
Undo | Sum-It's Undo feature is unlimited. It undoes the last action one step at a time, each time you select Undo. | Cmd+Z
Redo | Reinstates what has been undone by Undo. | Shift+Cmd+Z
Cut | Cuts selected text and saves it to clipboard. | Cmd+X
Copy | Copies selected text to clipboard. | Cmd+C
Paste | Inserts contents of clipboard. If you paste into another application, copied cells are converted to tab-delimited text that reflects their grid positions in a Sum-It worksheet. | Cmd+V
Paste Special | Provides additional Paste options. Note that you cannot access Paste Special until you cut or copy a cell. | Ctrl+Cmd+V
Paste Function | Pastes pre-defined mathematical, financial, and logical functions into formulas. | Shift+Cmd +V
Select All | Selects the entire worksheet for global formatting changes. | Cmd+A
Clear | Clears value, formulas, and format from active cell or range of cells. |
Insert Column/Row | Inserts a column/row to the left of the one highlighted. |
Delete Column/Row | Deletes highlighted column/row. |

## Format Menu

Menu item | Does this
Font | Brings up font selection pop-up menu.
Style | Brings up style selection pop-up menu.
Size | Brings up font size selection pop-up menu.
Font Color | Brings up font color selection pop-up menu.
Cell Color | Brings up cell color selection pop-up menu.
Align General | Aligns numbers and date/time values to the right in a cell, text and boolean values to the left.
Align Left | Aligns all values to the left in a cell.
Align Center | Aligns all values in the center of a cell.
Align Right | Aligns all values to the right in a cell.
General | Displays the minimum number of digits necessary to approximate the value of the number which fits the cell. If the entire number doesn't fit the cell, Sum-It converts number to Scientific notation.
Currency | Formats a number as currency.
Percentage | Displays a number as a percentage; e.g., 0.5 as 50%.
Fixed | Rounds number to the nearest whole number.
Scientific | Displays a number in scientific notation.
Date/Time | Brings up a dialog that lets you select how to display a date or time entry.
Digits | Shows a dialog that lets you select the number of decimal places to display; the actual number is retained for calculation purposes.
Commas | Inserts commas as separators into numerical values greater than 1000.

## Data Menu

Menu item | Does this | Keyboard shortcut
Fill Down | Fills a selected cell range with the same values or formulas found in the first cell(s) of the column(s); | Cmd+D
Fill Right | Same as above, but fills to the right of the first cell of a row or rows. | Cmd+R
Increment Fill | Brings up a dialog that lets you fill a selection in rows or columns with incrementing or decrementing values. You must supply a start value and either a step value or a last value.You may also increment or decrement dates. |
Sort | Brings up a dialog that lets you sort a selection of cells by row or column. You can define up to 3 key sorting criteria. |
Names | Brings up a dialog that lets you name a cell or range of cells. |
Display Formulas | Toggle switch that lets you display either the result of a formula or the formula itself. |
Recalculate | Recalculates a value | Cmd+=
Go To | Brings up a dialog where you can designate a cell or range of cells, or a named cell to go to. Clicking in the lower-left corner of the Sum-It window to bring up the same dialog. |
Find | Brings up the Find dialog, which lets you search for the value you enter. | Cmd+F
Find Next | Finds the next instance of an entered value or name. | Cmd+G
Replace | Replaces the next instance of an entered value or name with the one specified. |
Replace and Find Next | Replaces the next instance of an entered value or name with the one specified and locates the next matching value or name. | Cmd+L
Replace All | Replaces every instance of an entered value or name with the one specified |

## Chart Menu

Menu item | Does this
Create Chart | Brings up a dialog that lets you select desired type of chart.
Chart Options | Brings up a dialog box that lets you add titles, labels, and legend to charts.
Animate Chart | Brings up a dialog that lets you modify chart values by specific increments for sensitivity analysis.

## View Menu

Menu item | Does this | Keyboard shortcut
Freeze | Freezes a portion of the worksheets from scroling. |
Unfreeze | Unfreezes frozen rows/columns. |
Stack | Stacks multiple open spreadsheets. |
Tile | Tiles screen w/ multiple open spreadsheets. |
Full Screen | Expands worksheet to fill entire screen. | Cmd+/
Show Clipboard | Shows contents of clipboard from previous cut or copy action. |
Settings | Brings up Settings panel with tabs for setting preferences for Fonts, Numbers & Dates, Miscellaneous, and Startup. |

## Help Menu

##

Menu item | Does this
On-line Help | Provides access to on-line HTML documentation.
About | Brings up BeatWare Sum-It splash screen.

# Other Shortcuts

## Icons

Click on the icons to the left of the formula bar to do the following:

Icon | Does this
Checkmark | Enters a formula.
X | Escape from edit mode without entering formula.
Sigma | Sums, or adds, a range of values.

## Miscellaneous

- Click in the box below the icons to highlight the entire worksheet.
- Click in the box in the lower-left corner to bring up the Go To dialog.
- Click in the double-box icon in the yellow tab to zoom the Sum-It window in or out.
- Click, hold, and drag the dotted area in the lower-right corner to resize the Sum-It window.
- Hold Shift key to extend highlighted selection.