Menu options

Menu Fichier
Menu Modifier
Menu Insérer
Menu Format


Menu Fichier

NouveauOpens a new blank workbook.
OuvrirDisplays the Fichier Ouvrir dialog box for you to choose a spreadsheet file to open.
RécentsDisplays a list of the 9 most recently used (i.e. opened or saved) files as a shortcut for opening them.
FermerCloses the current workbook, after prompting you to save any changes.
EnregistrerSaves the current workbook back into the file it was opened from. If this spreadsheet was created with the Fichier Nouveau menu option rather than opened with the Fichier Ouvrir menu option, then you will be asked for a file name to save it under.
Enregistrer SousDisplays the Fichier Enregistrer dialog box for you to choose a name and location for saving the current workbook.
FenêtreDisplays a list of the currently open workbooks and allows you to select a different one as the active workbook.
ImprimerPrints the currently displayed sheet. This option will not be available if your device does not support printing.
QuitterThis shuts down the program, after prompting you to save any changed workbooks.


Menu Modifier

AnnulerThis option undoes the last change you made to the spreadsheet, should you make a mistake or just change your mind. There are currently 16 levels of Undo, that is, the program remembers the last 16 things that you did and can step back through them using this menu option.
CouperThis 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.
CopierThis 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.
CollerThis option takes the contents of the clipboard and puts it into the currently selected cells.
Collage SpécialWhen 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 Coller 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.
Recopier
En basCopies the top row of the selection into the other rows of the selection.
À droiteCopies the left column of the selection into the other columns of the selection.
En hautCopies the bottom row of the selection into the other rows of the selection.
À gaucheCopies the right column of the selection into the other columns of the selection.
SérieDisplays a dialog box that allows you to fill the current selection with a series of numbers or dates.
Effacer
ToutRemoves the contents and formatting of the currently selected cells.
FormatsRemoves only the formatting of the currently selected cells, leaves the contents unchanged.
ContenuRemoves only the contents of the currently selected cells, leaves the formatting unchanged.
CommentairesRemoves any comments associated with the currently selected cells.
SupprimerIf 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) Décaler vers la gauche - delete the selected cells and move the cells on the right of them to the left to take their places, (2) Décaler vers le haut - delete the selected cells and move the cells below them up to take their places, (3) Ligne entière - delete the entire rows that the selection spans, the rows below will be moved up, (4) Colonne entière - delete the entire columns that the selection spans, the columns to the right will be moved left.
Supprimer FeuilleDelete 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.
Déplacer ou copier feuilleAllows you to move or copy the current sheet to a different position in the file.
ChercherAllows 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 Suivant 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 Suivant button will take you to each of the cells that match your request.
AtteindreAllows 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.


Menu Insérer

CellulesIf 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) Décaler vers la droite - the cells to the right of the selection will be moved to the right to make room for the new cells, (2) Décaler vers le bas - the cells below the selection will be moved down to make room for the new cells, (3) Ligne entière - the entire rows that the selection spans will be inserted, (4) Colonne entière - the entire columns that the selection spans will be inserted.
LigneInserts one or more new rows where the selection is.
ColonneInserts one or more new columns where the selection is.
FeuilleInserts a blank worksheet at the end of the spreadsheet file.
Graphique
FeuilleInserts a new chart sheet at the end of the spreadsheet file. If no cells have been selected then the Format Graphique dialog box will be displayed, otherwise a default column chart will be built using the selected data.
ObjetInserts a new chart object on the current worksheet. Drag the pointer across the worksheet to indicate where the chart should be placed. If no cells have been selected then the Format Graphique 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.
FonctionDisplays a dialog box from which you can select a function to be inserted into the current cell formula.
Nom
DefinirDisplays 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.
CommentaireThis 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 Modifier le commentaire, 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 Modifier Effacer Commentaires menu option.
Contrôle
ÉtiquetteInserts a label.
Zone de groupeInserts a group box.
Bouton de commandeInserts a command button.
Case à cocherInserts a check box.
Bouton d'optionInserts an option button.
Zone de listeInserts a list box.
Zone de liste modifiableInserts a combo box.
Barre de défilementInserts a horizontal or vertical scroll bar.
ToupieInserts a spin control.
Object dessin
LigneInserts a line.
RectangleInserts a rectangle.
EllipseInserts an oval.
Zone de texteInserts a text box.


Menu Format

CellulesDisplays 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.
Ligne
HauteurDisplays 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.
Ajustement automatiqueSets 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.
MasquerHides the selected rows.
AfficherUnhides the selected rows. Because you cannot select individual hidden rows, you will have to use the Modifier>Atteindre 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.
Colonne
LargeurDisplays 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.
Ajustement automatiqueSets 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.
MasquerHides the selected columns.
AfficherUnhides the selected columns. Because you cannot select individual hidden columns, you will have to use the Modifier>Atteindre 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.
Largeur StandardDisplays a dialog box showing the default width of the columns on the current sheet, and allows you to change it.
Feuille
RenommerDisplays a dialog box showing the current sheet name, and allows you to change it.
MasquerAllows you to hide the currently displayed sheet.
AfficherAllows you to select a hidden sheet to be displayed.
QuadrillageAllows you to turn the gridlines on and off for the current sheet.
En-têtesAllows 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.
ProtégerAllows 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>Cellules menu option) can be changed.
FormulesAllows you to toggle the display of the cell formulas and cell values for the current sheet.
Couleur de l'ongletAllows you to change the tab color for the current sheet.
FichierAllows you to select whether the Vertical scrollbar, Horizontal scrollbar and Sheet tabs are to be displayed for sheets in the current file.
Programme
Barres d'outilsAllows you to show or hide the tool bars. The tool bar buttons provide short cuts to commonly-used menu options.
Barre de formuleAllows you to show or hide the formula bar. This is the area where formulas are entered and edited.
Barre d'étatAllows you to show or hide the status bar. The status bar shows the current cursor position, and has a menu (activated by double-click) that allows you to select items to be displayed in the status bar, such as the sum of the selected cells.
ConditionnelleAllows you to select alternative formatting for cells depending on conditions.
FigerOn 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 Libérer which allows you to free the rows and columns again.
Données
TrierDisplays a dialog box that allows you to sort the currently selected cells, either by rows or columns, in ascending or descending order.
Filtre
Filtre automatiqueAllows you to filter the spreadsheet rows by specifying selection criteria.
Afficher toutTurns off any active filters.
Filtre élaboréAllows you to filter the spreadsheet rows by specifying more complex criteria.
GrilleAllows 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.
Valeur cibleAllows you to set a cell to a specific value by changing another cell.
GraphiqueOn 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.
ContrôleDisplays a dialog box that allows you to set the attributes of the currently selected Control object.
Object dessinDisplays a dialog box that allows you to set the attributes of the currently selected Drawing object.