SpreadCE Help

Menu options

File menu
Edit menu
Insert menu
Format menu

File menu

New | Opens a new blank workbook.
Open | Displays the File Open dialog box for you to choose a spreadsheet file to open.
Recent | Displays a list of the 9 most recently used (i.e. opened or saved) files as a shortcut for opening them.
Close | Closes the current workbook, after prompting you to save any changes.
Save | Saves the current workbook back into the file it was opened from. If this spreadsheet was created with the File New menu option rather than opened with the File Open menu option, then you will be asked for a file name to save it under.
Save as | Displays the File Save dialog box for you to choose a name and location for saving the current workbook.
Window | Displays a list of the currently open workbooks and allows you to select a different one as the active workbook.
Exit | This shuts down the program, after prompting you to save any changed workbooks.

Edit menu

Undo | This option undoes the last change you made to the spreadsheet, should you make a mistake or just change your mind. There are currently 10 levels of Undo, that is, the program remembers the last 10 things that you did and can step back through them using this menu option.
Cut | This option removes the contents of the currently selected cells and places them on the clipboard, so that you can paste them somewhere else. Only one selection can be stored on the clipboard at a time, so this will replace whatever was previously on the clipboard.
Copy | This option copies the contents of the currently selected cells and places them on the clipboard, so that you can paste them somewhere else. Only one selection can be stored on the clipboard at a time, so this will replace whatever was previously on the clipboard.
Paste | This option takes the contents of the clipboard and puts it into the currently selected cells.
Paste Special | When cells are cut or copied to the clipboard, the program stores not only what is displayed in the cell, but also the formula that is in the cell and the formatting. The Paste menu option will paste all of this information into the target cells, but this menu option allows you to paste just some of that information. A dialog box is displayed for you to choose what is pasted.

Fill

Down | Copies the top row of the selection into the other rows of the selection.
Right | Copies the left column of the selection into the other columns of the selection.
Up | Copies the bottom row of the selection into the other rows of the selection.
Left | Copies the right column of the selection into the other columns of the selection.
Series | Displays a dialog box that allows you to fill the current selection with a series of numbers or dates.

Clear

All | Removes the contents and formatting of the currently selected cells.
Formats | Removes only the formatting of the currently selected cells, leaves the contents unchanged.
Contents | Removes only the contents of the currently selected cells, leaves the formatting unchanged.
Comments | Removes any comments associated with the currently selected cells.

Delete | If entire rows or columns have been selected then this menu option will delete the selected rows or columns. Otherwise (that is, one or more cells have been selected) a dialog box will be displayed containing 4 options: (1) Shift cells left - delete the selected cells and move the cells on the right of them to the left to take their places, (2) Shift cells up - delete the selected cells and move the cells below them up to take their places, (3) Entire row - delete the entire rows that the selection spans, the rows below will be moved up, (4) Entire column - delete the entire columns that the selection spans, the columns to the right will be moved left.
Delete Sheet | Delete the currently displayed worksheet, chart or macro sheet. If there is only one worksheet in your spreadsheet file, you will not be allowed to delete it.
Find | Allows you to look for cells that contain specified things. This menu option displays a dialog box asking you 4 things: (1) the text that you want to search for, (2) whether to look for it in the formulas (what was typed into the cells) or in the values (what is displayed in the cells), (3) whether the search is to be case-sensitive (whether you want upper and lower case letters to be treated as different), and (4) whether to find cells that are equal to the text that you typed or just contain the text that you typed. Entering these and pressing OK will move the cursor to the first cell after the current cursor position that matches your request. The dialog box stays on the screen until it is cancelled, so repeated pressing of the Find next button will take you to each of the cells that match your request.
Goto | Allows you to move directly to another part of the worksheet. This menu option displays a dialog box that asks you for a cell reference. Entering the reference and pressing OK will move the cursor to the specified cell.

Insert menu

Cells | If entire rows or columns have been selected then this menu option will insert the selected rows or columns. Otherwise (that is, one or more cells have been selected) a dialog box will be displayed containing 4 options: (1) Shift cells right - the cells to the right of the selection will be moved to the right to make room for the new cells, (2) Shift cells down - the cells below the selection will be moved down to make room for the new cells, (3) Entire row - the entire rows that the selection spans will be inserted, (4) Entire column - the entire columns that the selection spans will be inserted.
Rows | Inserts one or more new rows where the selection is.
Columns | Inserts one or more new columns where the selection is.
Worksheet | Inserts a blank worksheet at the end of the spreadsheet file.
Chart | Inserts a new chart at the end of the spreadsheet file. If no cells have been selected then the Format Chart dialog box will be displayed, otherwise a default column chart will be built using the selected data.
Macro | Inserts a blank macro sheet at the end of the spreadsheet file. Macro sheets are used for storing custom (user-defined) functions and commands.
Function | Displays a dialog box from which you can select a function to be inserted into the current cell formula.

Name

Define | Displays a dialog box showing the names that have been defined for references in this spreadsheet file. It allows you to add new names, change the references of existing names, or to delete names that are no longer required.

Comment | This option allows you to add a comment to the currently selected cell. If there is already a comment attached to the cell, then this option will be changed to Edit comment, and the existing comment will be displayed for you to change. You can press the Escape key to leave without entering or changing the comment, or you can click outside the comment box to save the changes. When a cell contains a comment, there will be a comment indicator in the top-right corner of the cell. To display a comment you can either use this menu option, or you can click and hold the pointer on the cell for 1/2 a second, the comment will be displayed until you move or release the pointer. To remove a comment from a cell, use the Edit Clear Comments menu option.

Control

Label | Inserts a label.
Group box | Inserts a group box.
Command button | Inserts a command button.
Check box | Inserts a check box.
Option button | Inserts an option button.
List box | Inserts a list box.
Combo box | Inserts a combo box.
Scroll bar | Inserts a horizontal or vertical scroll bar.
Spin control | Inserts a spin control.

Drawing

Line | Inserts a line.
Rectangle | Inserts a rectangle.
Oval | Inserts an oval.
Text box | Inserts a text box.

Format menu

Cells | Displays a dialog box that allows you to change the way that the contents of the selected cells are displayed. You can change the way that numbers, amounts of money, dates, times and text are formatted. You can change the colour of the text, the pattern and colour of the cell background, and the type and colour of the cell borders.

Row

Height | Displays a dialog box showing the current height of the selected rows in points (the unit of measurement used for text), and allows you to change it. You can also change the row height by dragging the separator between the row numbers.
AutoFit | Sets the row height to the largest required for the values displayed in the row. You can also autofit a row by double-clicking on the separator below the row number.
Hide | Hides the selected rows.
Unhide | Unhides the selected rows. Because you cannot select individual hidden rows, you will have to use the Edit Goto menu option to move the cursor to the required row, or select all the rows from the one above the hidden rows to the one below, before using this option.

Column

Width | Displays a dialog box showing the current width of the selected columns in characters, and allows you to change it. You can also change the column width by dragging the separator between the column headings.
AutoFit | Sets the column width to the largest required for the values displayed in the selected cells. You can also autofit a column by double-clicking on the separator to the right of the column heading.
Hide | Hides the selected columns.
Unhide | Unhides the selected columns. Because you cannot select individual hidden columns, you will have to use the Edit Goto menu option to move the cursor to the required column, or select all the columns from the one to the left of the hidden columns to the one to the right, before using this option.
Standard Width | Displays a dialog box showing the default width of the columns on the current sheet, and allows you to change it.

Sheet

Rename | Displays a dialog box showing the current sheet name, and allows you to change it.
Gridlines | Allows you to turn the gridlines on and off for the current sheet.
Headings | Allows you to turn the row and column headings on and off for the current sheet.
Zoom | Allows you to set the zoom level for the current sheet.
Protect | Allows you to turn protection on and off for the current sheet. When protection is on, only cells that are not locked (set by using the Format Cells menu option) can be changed.
Formulas | Allows you to toggle the display of the cell formulas and cell values for the current sheet.

Chart | On a chart sheet, this displays a dialog box that allows you to change the type of the chart, the data that is used, and the way in which the chart is formatted.
Freeze | On a worksheet, this allows you to fix the currently displayed row and/or column headings so that they will not move when the sheet is scrolled. When you use this option, the rows above the cursor cell and the columns to the left of it will be fixed. For example, if you want the top row to stay the same when you page down through the sheet, move the cursor to cell A2 and then use this menu option, the row above cell A2, which is row 1, will stay displayed when you page through the sheet, and as there are no columns to the left of cell A2, no columns will be fixed. When this option has been used, the menu option changes to 'Unfreeze' which allows you to free the rows and columns again.

Data

Sort | Displays a dialog box that allows you to sort the currently selected cells, either by rows or columns, in ascending or descending order.
AutoFilter | Allows you to filter the spreadsheet rows by specifying selection criteria.
Form | Allows you to display, update and search a table of data one record at a time.
Validation | Allows you to restrict the range of values that can be entered into a cell, or display a drop-down list to choose a value from, and display input and error messages.

Control | Displays a dialog box that allows you to set the attributes of the currently selected Control object.
Drawing | Displays a dialog box that allows you to set the attributes of the currently selected Drawing object.