This appendix is a reference section for BeatWare Sum-It menus and keyboard
shortcuts.
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:
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 |
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. |
|
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. |
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 |
|
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. |
|