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