|
|
The following tables describe the commands available on the Spreadsheet Editor menu bar and provide a brief description of each command.
File menu
|
Command
|
Access key
|
Description
|
|
New
|
Ctrl + N
|
Creates a new file loading a new empty workbook.
|
|
Open
|
Ctrl + O
|
Opens a workbook file from disk. Files can be opened in the following formats: Excel© 2007-2010 Open XML Workbook (*.xlsx), Excel© Worbook 97-2003 (*.xls), Microsoft Excel© Microsoft Excel© 97-2003 Workbook template file (*.xlt), Microsoft Excel© Macro Enabled Workbook (*.xlsm), Unicode text files (*.txt) and Comma Delimited Files (*.csv).
|
|
Close
|
|
Closes the Spreadsheet Editor.
|
|
Save
|
Ctrl + S
|
Saves the current workbook. Files can be saved in the following formats: Excel© 2007-2010 Open XML Workbook (*.xlsx), Excel© Worbook 97-2003 (*.xls), Microsoft Excel© Microsoft Excel© 97-2003 Workbook template file (*.xlt), Unicode text files (*.txt) and Comma Delimited Files (*.csv).
|
|
Save As..
|
|
Saves the current workbook with an alternate name. Files can be saved in the following formats: Excel© 2007-2010 Open XML Workbook (*.xlsx), Excel© Worbook 97-2003 (*.xls), Microsoft Excel© Microsoft Excel© 97-2003 Workbook template file (*.xlt), Unicode text files (*.txt) and Comma Delimited Files (*.csv).
|
|
Page Setup...
|
|
Opens the Workbook Explorer where the page orientation, scaling, margins, header, footer and sheet options can be set.
|
|
Print Area > Set Print Area
|
|
Set the worksheet range to be considered when printing.
|
|
Print Area > Clear Print Area
|
|
Clears the worksheet range print area defined.
|
|
Print Area > Set Print Title Rows
|
|
Set the rows that will be printed in each page.
|
|
Print Area > Clear Print Title Rows
|
|
Clears the rows set to be printed in each page.
|
|
Print Area > Set Print Title Columns
|
|
Set the columns that will be printed in each page.
|
|
Print Area > Clear Print Title Columns
|
|
Clears the columns set to be printed in each page.
|
|
Print Preview > Sheet...
|
|
Displays the print preview dialog with the contents of the current worksheet.
|
|
Print Preview > Workbook...
|
|
Displays the print preview dialog with the contents of the current workbook.
|
|
Print Preview > Selection...
|
|
Displays the print preview dialog with the contests of the current selected range.
|
|
Print > Sheet...
|
Ctrl + P
|
Displays the printer settings dialog box to print the current worksheet.
|
|
Print > Workbook...
|
|
Displays the printer settings dialog box to print the current workbook.
|
|
Print > Selection...
|
|
Displays the printer settings dialog box to print the current selected range.
|
|
Exit
|
|
Closes the spreadsheet application.
|
Edit menu
|
Command
|
Access key
|
Description
|
|
Undo
|
|
Undo last action.
|
|
Redo
|
|
Redo last action undone.
|
|
Cut
|
|
Cuts the current worksheet selection to the clipboard.
|
|
Copy
|
|
Copies the current selection to the clipboard.
|
|
Paste
|
|
Pastes the contents of the clipboard to the current worksheet selection.
|
|
Paste Especial...
|
|
Pastes the values, formulas, formats, comments, column widths and cell validation, with options to perform cell operations (None, Add, Subtract, Multiply, Divide), skip blank cells and transpose cells.
|
|
Fill > Down
|
Ctrl + D
|
Data in the top or leftmost cell is copied down to fill the range.
|
|
Fill > Right
|
Ctrl + R
|
Data in the top or leftmost cell is copied right to fill the range.
|
|
Fill > Up
|
|
Data in the top or leftmost cell is copied up to fill the range.
|
|
Fill > Left
|
|
Data in the top or leftmost cell is copied left to fill the range.
|
|
Fill > Data Series...
|
|
Fills down or across the selected range with values calculated from existing cell values.The type of fill can be auto (when the remaining values are proposed to best fit the set of existing values), chronological (completes the missing days, weeks, months, years), linear or growth trend. A step increment or decrement and a stop value can be specified.
|
|
Clear > All
|
|
Clears cell contents, formats and comments.
|
|
Clear > Contents
|
Del
|
Clears cell contents.
|
|
Clear > Formats
|
|
Clears cell formats.
|
|
Clear > Comments
|
|
Clears cell comments.
|
|
Copy Sheet
|
|
Inserts a new worksheet with a copy of the current worksheet contents. The new worksheet name is a combination of the name of the original worksheet with and incrementing index value between parentheses.
|
|
Delete Sheet
|
|
Deletes the current sheet
|
|
Delete Cells...
|
|
Deletes cells shifting cells left or up to fill the void or deleting entire rows or columns.
|
|
Find...
|
Ctrl + F
|
Displays the find and replace dialog box with the option to search within the current worksheet, workbook or all the workbooks and look in cell formula or values searching by rows or columns matching text case and entire cells only. Resulting matches are displayed at the bottom of the dialog box. Selecting the 'Find Next' button will search cell values one by one, and selecting the button 'Find All' will search all matching values at once.
|
|
Replace...
|
Ctrl + H
|
Displays the find and replace dialog box with the option to search within the current worksheet, workbook or all the workbooks and look in cell formula or values searching by rows or columns matching text case and entire cells only. Resulting matches to be replaced are displayed at the bottom of the dialog box. Selecting the 'Replace' button will replace matching cell values one by one, and selecting the button 'Replace All' will replace all matching values at once with the new value.
|
|
Go To...
|
Ctrl + G
|
Displays the 'Go To' dialog box where a cell range address/defined named range can be specified or a recent navigation address/defined name can be selected. Selecting the 'Go To' button will display the corresponding worksheet and selected range address.
|
View menu
|
Command
|
Access key
|
Description
|
|
Workbook Explorer
|
F6
|
Displays the Workbook Explorer where settings for the existing workbooks and corresponding worksheets and defined names can be specified.
|
|
Range Explorer
|
|
Displays the Range Explorer where settings for the current range selection can be specified, such as number and conditional formats, text alignment, font, cell borders and interior color, protection, hyperlinks and validation rules.
|
|
Chart Explorer
|
|
Displays the Chart Explorer where settings for the current selected chart elements can be specified.
|
|
Shape Explorer
|
|
Displays the Shape Explorer where setting for the current selected shape can be specified.
|
|
Toolbars > Standard
|
|
Shows or hides the Spreadsheet Editor Toolbar.
|
|
Formula Bar
|
|
Shows or hides the formula bar where the current selected cell formula, address or defined name is displayed.
|
|
Status Bar
|
|
Shows or hides the status bar at the bottom of the Spreadsheet Editor, where status messages are displayed .
|
|
Zoom...
|
|
Displays the Workbook Explorer with the current selected worksheet zoom view setting options. Values between 25 and 400% can be specified.
|
Insert menu
|
Command
|
Access key
|
Description
|
|
Cells...
|
|
Inserts cells shifting cells down or right or inserting entire rows or columns.
|
|
Rows
|
|
Inserts new rows shifting selected rows down.
|
|
Columns
|
|
Inserts new columns shifting selected columns right.
|
|
Worksheet
|
|
Inserts a new worksheet shifting worksheet tabs to the right. The default name for the new worksheet will be a combination of the prefix 'Sheet' and the next available integer number.
|
|
Chart
|
|
Inserts a chart object. Double clicking on the chart or right clicking and selecting 'Chart Explorer' from the context menu the chart type and settings can be modified.
|
|
Page Break
|
|
Inserts an horizontal page break at the top and a vertical page break to the left of the selected cell range. Page breaks will be honored when printing to define the extension of pages.
|
|
Remove Page Break
|
|
Removes the horizontal page break at the top and the vertical page break to the left of the selected cell range.
|
|
Defined Name > Sheet..
|
|
Creates a defined name for the range selected in the current worksheet. The default name is the selected range address but it can be changed to a more meaningful name.
|
|
Defined Name > Workbook
|
|
Creates a defined name for the selected range in the active workbook. The default name is the selected range address but it can be changed to a more meaningful name. Workbook defined names are saved in the active workbook instead of the current worksheet.
|
|
Comment
|
|
Displays a text box where you can enter a comment that will be saved in the current selected cell. A red triangle will be displayed in the upper right corner of the selected cell afterward. Hovering over this triangle will display the comment saved in the cell. To permanently display a comment right click on the cell and select 'Show comments' from the context menu.
|
|
Picture...
|
|
Inserts a picture from file in the current selected range. Picture file format can be Windows Metafile (*.emf, *.wmf), Portable Network Graphics (*.png), Windows Bitmap (*.bmp, *.dib, *.rle), Graphic Interchange Format (*.gif)
|
|
Shape > Line
|
|
Inserts a line shape. Endpoints can be dragged to change position. Double clicking on the line will display the Shape Explorer, where line settings like color, transparency, dash style and protection can be changed.
|
|
Shape > Auto Shape...
|
|
Displays the 'Insert Autoshape' dialog box where basic shapes, arrows and flowchart symbols can be selected to be inserted. Double clicking on the shape will display the Shape Explorer, where line settings like color, transparency, dash style and protection can be changed.
|
|
Hyperlink
|
Ctrl + K
|
Displays the Range Explorer where options to insert a cell hyperlink to a web or file address, an existing file or an address in the active workbook can be set. The enter key must be pressed for the changes to be applied.
|
Format menu
|
Command
|
Access key
|
Description
|
|
Cells...
|
Ctrl + 1
|
Displays the Range Explorer where settings for the current selected range can be changed. Settings that can be modified are number and conditional formats, text alignment, font, cell borders and interior color, protection, hyperlinks and validation rules.
|
|
Row > Height
|
|
Displays the Row Height dialog box where height for the current row can be specified.
|
|
Row > Autofit
|
|
Selected row height will be modified to wrap the extents of the largest cell content.
|
|
Row > Hide
|
|
Selected rows will be hidden (height equal to zero).
|
|
Row > Unhide
|
|
Shows the hidden rows in a selected range.
|
|
Column > Width
|
|
Displays the Column Width dialog box, where with for the selected columns can be set.
|
|
Column > Autofit
|
|
Automatically adjusts the column width to accommodate the size of the largest text string or value.
|
|
Column > Hide
|
|
Hides the selected columns (does not delete them from the current worksheet, sets width equal to zero).
|
|
Column > Unhide
|
|
Shows the hidden columns in the range selection.
|
|
Column > Standard Width
|
|
Displays the Column Width dialog box which allows you to define a default width for the selected columns.
|
|
Sheet > Rename
|
|
Displays the Workbook Explorer with the current sheet name node selected and ready to be edited.
|
|
Sheet > Hide
|
|
Hides the current selected sheet.
|
|
Sheet > Unhide
|
|
Shows the Workbook Explorer where the sheet node can be selected. Unchecking the 'Hide sheet' option shows the corresponding sheet.
|
|
Conditional...
|
|
Displays the Range Explorer where conditional formats for the selected cells can be set. Cell value or expression can be selected as type comparisons, an operator (e.g.: equal, greater than, less than) and a maximum/minimum value can be specified. Font size/style/color, border color/line style, and cell interior fill color can be specified to be displayed if the conditions are met. The enter key must be pressed for the conditional format to be applied.
|
Tools menu
|
Command
|
Access key
|
Description
|
|
Protection > Sheet...
|
|
Displays the Workbook Explorer where the current worksheet node is selected. Checking the 'Protect sheet contents' will mark the selected worksheet locked cells as protected. An optional password to unprotect the sheet can be saved. Locked cells can not be edited if the corresponding worksheet is protected. Cells marked as unlocked before the worksheet is protected can be edited after the protection is applied. By default all worksheet cells are marked as locked.
|
|
Protection > Workbook...
|
|
Displays the Workbook Explorer where the active workbook node is selected. Checking the 'Protect workbook structure' option will disable the insert, copy, delete, rename, copy and hide worksheet commands. A password can be specified to unprotect the workbook structure. Checking the 'File password' a password to open the file can be specified. When opening the workbook file the exact password must be typed, otherwise the file will not be opened.
|
|
Calculation options...
|
|
Displays the Workbook Explorer where the Workbook Set node is selected. Calculation mode can be set as automatic (whenever a cell value is modified all values all recalculated), semi automatic (calculation only when a modified cell value affects other cell values) or manual (only when the calculation command is issued pressing the F9 key). For cell formulas that iterate and don't converge in an exact solution, the maximum number of iterations allowed and a maximum change value to stop the iteration can be specified.
|
|
Workbook options...
|
|
Displays the Workbook Explorer where the active workbook node is selected. Settings for calculation options (precision as displayed, save link values), window options (show or hide worksheet tabs, horizontal and vertical scroll bar), protection options (protect workbook structure, set a workbook file access password) and shape options (display/hide shapes or show a placeholder) can be specified.
|
|
Sheet options...
|
|
Displays the Workbook Explorer where the selected worksheet node is selected. Settings for window options (show formulas instead of values, zero for null values, show outline group symbols, row and column headers and gridlines, specify zoom view percentage and gridlines color), protection options (protect sheet contents, hide sheet) and tab color can be specified.
|
|
Options...
|
|
Displays the Options dialog box. The maximum number of recent files to be displayed in the most recent used files list, the maximum number of undos allowed, the default number of sheets and font style and size in a new workbook, and a path to load all valid workbook files found can be specified.
|
Data menu
|
Command
|
Access key
|
Description
|
|
Sort...
|
|
Displays the Sort dialog box where options to sort the selected range values can be set. Sorted values can be top to bottom (vertical direction) or left to right (horizontal). Text case can be taken into account when sorting. Sort keys can be added specifying the corresponding row/column to be sorted, sort order (ascending or descending) and if data will be sorted as text or as numbers. The maximum number of keys that can be defined corresponds to the number of columns (vertical sort direction) or the number of rows (horizontal sort direction).
|
|
Filter > Filter
|
|
Filters selected range columns values. Sort/filter symbols are inserted in each cell of the first range row, which are considered to be the headers for each column of data. Filters can be added specifying operators (e.g.: equal, less than, more than), corresponding values and logical operators (and, or). Values can also be filtered by selecting or deselecting them from the list shown. Values can also be filtered by cell and font color. Values that don't meet the filter criteria will not be displayed when the filter is applied. Values can also be sorted in ascending/descending order or defining custom sort keys.
|
|
Filter > Clear
|
|
Removes the filter applied in the selected cell data column.
|
|
Filter > Apply
|
|
Applies the filter specified in the selected cell data column.
|
|
Validation...
|
|
Displays the Range Explorer with the Validation node selected. Validation criteria can be defined selecting a value type (e.g: whole number, decimal, list), an operator (e.g: equal, greater than, between) and specifying corresponding values. Formula based validation criteria can defined selecting the value type Custom from the list and typing the formula to be applied. An input message to be displayed when the cell is selected can be defined and an error message to be displayed when the value entered in the cell doesn't meet the validation criteria can also be specified.
|
|
Goal Seek...
|
|
Displays the Goal Seek dialog box where a target value, target cell and change cell address can be specified. The target cell is the cell that has a formula referencing other cells(e.g. SUM, AVERAGE, etc.). The target value is the value that the formula must return. The change cell must be an address of a cell referenced by the formula whose value will be changed so the formula returns the target value required.
|
|
Outline > Group
|
|
Using outline grouping you can group rows or columns to collapse or show selecting the corresponding outline buttons. This is useful, for example, if you want to display only summary results and hide detail rows.
|
|
Outline > Ungroup
|
|
Removes outline grouping from selected rows or columns.
|
|
Outline > Clear
|
|
Removes all outline groups.
|
|
Outline > Settings...
|
|
Displays the Workbook Explorer with the Outline node of the current worksheet selected where the position of summary rows and columns can be specified. The options are 'Summary rows bellow detail rows' and 'Summary columns to the right of the detail column'. This options place the outline group collapsing/expanding button above or bellow the detail rows or to the right or left of the detail columns.
|
Windows menu
|
Command
|
Access key
|
Description
|
|
New Window
|
|
Creates a new workbook window.
|
|
Cascade
|
|
Arranges existing workbook windows in a staggered position.
|
|
Tile Vertical
|
|
Arranges existing workbook windows one to the right of the other.
|
|
Tile Horizontal
|
|
Arranges existing workbook windows one bellow the other.
|
|
Arrange Icons
|
|
Arranges collapsed workbook window icons at the bottom of the main container window.
|
|
Split
|
|
Splits the active workbook window vertically to the left and horizontally at the top of the selected cell range. The maximum number of resulting windows after splitting is four.
|
|
Remove Split
|
|
Removes split windows.
|
|
Freeze Panes
|
|
Fixes the rows above and columns to the left of the selected range. Fixed rows and columns can not be scrolled.
|
|
|