Command Reference

The File Menu
N File New 	Create a new document.
O File Open... 	Open an existing document.
File Open Recent 	Open an existing document by selecting it from a combo box of recently used files.
S File Save 	Save the document.
File Save As... 	Save and change the current document to a new name or format. If you want to keep the name and format of the document use Export...
File Reload 	Reloads the document.
File Import... 	Import other documents.
Tables of data are often held in text files with the values in a line being separated by a comma, space, tab or other character, for example 123, 456, 789, abcd, efgh. Such files are commonly called CSV (Comma Separated Values) files, even though the separating character may not be a comma.
If you ask to open a text file it assumes that the file is in CSV format and launches a dialog box that allows you to specify the delimiter (separating character) used by the file, and shows how the data items will be placed into different spreadsheet cells.
Other options in this dialog box let you define the Format of the spreadsheet cells, whether text quote characters should be removed, and whether the first line(s) of the file should be ignored.
File Export... 	Save a document to any supported format. The document does not become the exported file.
File Mail... 	Send the file as an email attachment.
File Create Template From Document... 	Create a template based on this document.
P File Print... 	Print the document.
File Print Preview... 	View the document as it will be printed.
File Document Information 	View or enter information about the document and author.
W File Close 	Close the current document but leave running.
Q File Quit 	Quit .

The Edit Menu
Z Edit Undo 	Undo the last action.
Z Edit Redo 	Redo the last undone action.
X Edit Cut 	Put selected item(s) into the clipboard and remove them from the original location. If you then do a Paste the item(s) will be inserted at the new location.
C Edit Copy 	Copy selected item(s) to the clipboard.
V Edit Paste 	Paste item(s) from the clipboard to the selected cell(s).
Edit Special Paste... 	Special forms of Paste. See the sections Other Paste Modes and Arithmetic using Special Paste for more details.
Edit Paste with Insertion 	Move content of the paste area either to the right or down and paste item(s) from the clipboard to the selected cell(s).
Edit Fill 	Fills up the selected area with the values from the first item-set. All four directions are supported. Note that the term "item-set" describes the first set of values seen in the fill direction. If the fill direction is Left then the first item-set is the last column of the selection.
F Edit Find... 	Find cell containing given text.
F3 Edit Find Next 	Find the next cell containing given text.
F3 Edit Find Previous 	Find the previous cell containing given text.
R Edit Replace... 	Find and replace given text in cell(s).
Edit Clear 	Clear All or Contents, Comment, Conditional Styles, Link or Validity from selected cell(s).
Edit Delete 	Delete Cells, Columns, Rows or Sheet.
F2 Edit Modify Cell 	To modify selected cell in-situ.

The View Menu
View New View 	Open a new instance of with the same document.
View Page Borders 	Toggle marking of printed page borders in the sheet with red lines.
View Zoom 	Increase or decrease the magnification used to display the spreadsheet. Range from 33% to 500%.

The Go Menu
In this menu you find actions to navigate between the sheets of the currently opened spreadsheet and the Goto Cell action to jump to a single cell or to select a range of cells.

The Insert Menu
Insert Comment 	Add or modify a comment.
Insert Function... 	Insert a mathematical function. See the section Formulae for more details.
Insert Series... 	Insert a series. See the section Series for more details.
Insert Link... 	Insert a link into the selected cell. See the section Link Cells for more details.
Insert Special Character... 	Insert a special character into the selected cell.
Insert External Data 	Insert data From Database..., From Text File... or From Clipboard.... See the section Inserting External Data for more details.

The Format Menu
F Format Cell Format... 	Format selected cell(s). See the Spreadsheet Formatting section for more details.
Format Style Manager 	Create, Modify or delete cell format styles.
Format Style 	Apply a style to selected cell(s). To manage styles use Format Style Manager...
Format Create Style From Cell... 	Create a new style from the format of the selected cell. To manage styles use Format Style Manager...
Format AutoFormat... 	Autoformat the selected cells: a dialog let you choose between two proposed formats.
Format Merge Cells 	Merge selected cells.
Format Dissociate Cells 	Dissociate (split apart) previously merged cells.
Format Adjust Row & Column 	Set row and column sizes to show selected cell(s) properly.
Format Row 	Resize, equalize, hide or show row(s).
Format Column 	Resize, equalize, hide or show column(s).
Format Sheet 	Hide, show worksheet or configure advanced sheet properties.
Format Page Layout... 	Format printed page layout.
Format Print Range 	Define or reset the print range.

The Data Menu
Data Sort... 	Sort data in selected cells. See the section Sorting Data for more details.
Data Text to Columns... 	This option attempts to interpret text in the selected cell(s) as CSV data, placing each item into a different cell in the row.
G Data Named Areas... 	Open the Named Areas dialog to select, add, edit and remove named areas. See the section Named Cells and Areas for further details.
Data Consolidate... 	Consolidate data. See the section Consolidating Data for more details.
Data Subtotals... 	Create different kinds of subtotals to a database.
Data Validity... 	Set or modify the error checking criteria and error alert message for selected cell(s). See Validity Checking for more details.
Data Goal Seek... 	Open the Goal Seek dialog box. See Goal Seeking for details.
Data Pivot... 	Open the Pivot Table configuration dialog. See Pivot Table for details.

The Tools Menu
Tools Spelling... 	Check spelling of words in the worksheet.
Tools Custom Lists... 	View or amend the special series of words recognized by . These list can be used to insert special series into the worksheet.
Tools Protect Sheet... 	 Protect the sheet with a password. A dialog pops up prompting you for a password. Unchecking this option will prompt you for the password in order to unprotect the sheet. Protecting a sheet means protecting all cells in the sheet. In a protected sheet, the cells cannot be reformatted or overwritten.
Tools Protect Document... 	 Protect the whole document with a password. A dialog pops up prompting you for a password. Unchecking this option will prompt you for the password in order to unprotect the document. In a protected document you cannot rename or remove a sheet. Document protection does not mean that each individual sheet is protected.
F9 Tools Recalculate Sheet 	Recalculate formulae in the current sheet.
F9 Tools Recalculate Document 	Recalculate all sheets.
Tools Execute Script File... 	Execute the chosen external script in . supports scripting in JavaScript, Python and Ruby. Default examples of the scripts can be found in the Tools Scripts submenu.
Tools Scripts 	Here you can execute the script to export or import data in various formats, save your log into file, use Orca speech for accessibility, debug Python and Ruby scripts or add functions to display stock or weather condition values. You can even use some R functions (RPy module should be installed).
Tools Script Manager... 	Opens the Scripts Manager dialog to execute, load, unload, install, uninstall and get more scripts.
Tools Function Optimizer... 	Opens the Function Optimizer dialog where you can choose an objective function cell, optimization target (Maximize, Minimize or enter the Value) and a set of decision parameter cells.

The Settings Menu
Settings Toolbars Shown 	Show or hide the toolbars: File, Edit, Navigation, Font, Format and Color/Border.
Settings Status Bar 	Show or hide the Status Bar. The Status Bar shows additional information for selected items and instant calculations of the selected cells.
Settings Tab Bar 	Show or hide the Tab Bar. All Sheets of the current Document can be accessed through the Tab Bar.
Settings Configure Shortcuts... 	Configure the keyboard shortcuts used by . See the section on configuring shortcuts for more details.
Settings Configure Toolbars... 	Configure the toolbars. The section on configuring toolbars has more information.
Settings Themes 	Choose the color theme for window. You can choose one of the predefined color schemes or select Configuration... to open color selection module.
Settings Active Author Profile 	Configure the author profile for the current document. You can choose one of the profiles defined using configuration window, Default Author Profile as defined by data or blank Anonymous profile which can ensure your privacy.
Settings Configure Notifications... 	Configure notification system. There are no actions that you can be notified in the current version of .
Settings Configure ... 	General configuration. See the section on configuration for more details.

The Help Menu

The Right Mouse Button Menu
This section describes the items in the pop up menu obtained by right clicking on a selected cell or cells, row(s) or column(s).
F Cell Format... 	Format selected cell(s). See the Spreadsheet Formatting section for more details.
X Cut 	Put selected item(s) into the clipboard. If you then do a Paste the item(s) will be moved from the original location to the new one.
C Copy 	Copy selected item(s) into the clipboard.
V Paste 	Paste item(s) from the clipboard to the selected cells.
Special Paste... 	Special forms of Paste. See the sections Other Paste Modes and Arithmetic using Special Paste for more details.
Paste with Insertion 	Paste from the clipboard to the selected cell(s), moving the previous cell(s) to make room.
All 	Delete contents of selected cell(s).
Adjust Row & Column 	Change size of row and column to display selected cell(s) completely.
Default 	Set default formats for selected cell(s).
Area Name... 	Name selected area. See the section Named Areas for more details.
Resize Row... 	Change height of selected row.
Adjust Row 	Change height of selected row to display cell(s) completely.
Resize Column... 	Change width of selected column.
Adjust Column 	Change width of selected column to display cell(s) completely.
Insert Cells... 	Insert new cell(s) at selected location, moving existing cell(s) to make room.
Delete Cells... 	Remove selected cell(s), moving other cell(s) to occupy the space left by the removed cell(s).
Insert Rows 	Insert new row(s) above selected row(s).
Delete Rows 	Delete selected row(s).
Hide Rows 	Hides selected row(s).
Show Rows 	Shows selected row(s). In order to show hidden rows you need to select a range of rows that includes the hidden rows.
Insert Columns 	Insert new column(s) at left of selected column(s).
Delete Columns 	Delete selected column(s).
Hide Columns 	Hides selected column(s).
Show Columns 	Shows selected column(s). In order to show hidden columns you need to select a range of columns that includes the hidden columns.
Comment... 	Add or modify a comment to the selected cell.
Selection List... 	Lets you select and paste text from any cell of the current selection of cells into the selected cell.

Other Shortcuts
This section describes those shortcut keys used for operations that do not appear in any of the menus.
H 	Toggle the display of the dockers.
Arrow keys 	If the selected cell is occupied then move the cell cursor to the start or end of the occupied block in the current row or column. If the selected cell is not occupied then move the cell cursor to the start or end of the block of unoccupied cells in the current row or column.
Arrow keys 	If the selected cell is occupied then select all occupied cells to the start or end of that block of occupied cells in the current row or column. If the selected cell is not occupied then select all unoccupied cells to the start or end of that block of unoccupied cells in the current row or column.
Page Down 	Move the cell cursor 10 cells down.
Page Up 	Move the cell cursor 10 cells up.
Page Down 	Move to the next sheet.
Page Up 	Move to the previous sheet.
F4 	Change cell reference between normal and absolute reference types.