SpreadCE Help


Menu options
File menu
Edit menu
Insert menu
Format menu


File menu

NewOpens a new blank workbook.
OpenDisplays the File Open dialog box for you to choose a spreadsheet file to open.
RecentDisplays a list of the 9 most recently used (i.e. opened or saved) files as a shortcut for opening them.
CloseCloses the current workbook, after prompting you to save any changes.
SaveSaves 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 asDisplays the File Save dialog box for you to choose a name and location for saving the current workbook.
WindowDisplays a list of the currently open workbooks and allows you to select a different one as the active workbook.
ExitThis shuts down the program, after prompting you to save any changed workbooks.



Edit menu

UndoThis 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.
CutThis 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.
CopyThis 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.
PasteThis option takes the contents of the clipboard and puts it into the currently selected cells.
Paste SpecialWhen 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
DownCopies the top row of the selection into the other rows of the selection.
RightCopies the left column of the selection into the other columns of the selection.
UpCopies the bottom row of the selection into the other rows of the selection.
LeftCopies the right column of the selection into the other columns of the selection.
SeriesDisplays a dialog box that allows you to fill the current selection with a series of numbers or dates.

Clear
AllRemoves the contents and formatting of the currently selected cells.
FormatsRemoves only the formatting of the currently selected cells, leaves the contents unchanged.
ContentsRemoves only the contents of the currently selected cells, leaves the formatting unchanged.
CommentsRemoves any comments associated with the currently selected cells.

DeleteIf 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 SheetDelete 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.
FindAllows 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.
GotoAllows 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

CellsIf 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.
RowsInserts one or more new rows where the selection is.
ColumnsInserts one or more new columns where the selection is.
WorksheetInserts a blank worksheet at the end of the spreadsheet file.
ChartInserts 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.
MacroInserts a blank macro sheet at the end of the spreadsheet file. Macro sheets are used for storing custom (user-defined) functions and commands.
FunctionDisplays a dialog box from which you can select a function to be inserted into the current cell formula.
Name
DefineDisplays 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.

CommentThis 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
LabelInserts a label.
Group boxInserts a group box.
Command buttonInserts a command button.
Check boxInserts a check box.
Option buttonInserts an option button.
List boxInserts a list box.
Combo boxInserts a combo box.
Scroll barInserts a horizontal or vertical scroll bar.
Spin controlInserts a spin control.

Drawing
LineInserts a line.
RectangleInserts a rectangle.
OvalInserts an oval.
Text boxInserts a text box.


Format menu

CellsDisplays 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
HeightDisplays 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.
AutoFitSets 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.
HideHides the selected rows.
UnhideUnhides 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
WidthDisplays 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.
AutoFitSets 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.
HideHides the selected columns.
UnhideUnhides 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 WidthDisplays a dialog box showing the default width of the columns on the current sheet, and allows you to change it.

Sheet
RenameDisplays a dialog box showing the current sheet name, and allows you to change it.
GridlinesAllows you to turn the gridlines on and off for the current sheet.
HeadingsAllows you to turn the row and column headings on and off for the current sheet.
ZoomAllows you to set the zoom level for the current sheet.
ProtectAllows 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.
FormulasAllows you to toggle the display of the cell formulas and cell values for the current sheet.

ChartOn 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.
FreezeOn 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
SortDisplays a dialog box that allows you to sort the currently selected cells, either by rows or columns, in ascending or descending order.
AutoFilterAllows you to filter the spreadsheet rows by specifying selection criteria.
FormAllows you to display, update and search a table of data one record at a time.
ValidationAllows 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.

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