• Document: Used to open, create, save or print a ".xlsx" file.
  
  You can:
  • Create a new workbook.
  • Open an existing workbook.
  • Save (or save as) a workbook.
  • Print a workbook. The current worksheet is previewed.
• Clipboard: Used to manage the clipboard (copy/paste).
  
• Font: Used to manage the font of current text.
  
  You can:
  • manage the font name and size.
  • manage the formatting characteristics of font: Bold, Italic, Underlined, Strikeout, Superscript, Subscript.
  • manage the font color: text color and highlighting color.
  • manage the cell borders.
  • manage the background color of cell.
• Alignment: Used to manage the alignment of different elements:
  
  • : Used to manage the vertical alignment of text in the cell.
  • : Used to manage the text rotation in the cell.
  • Automatic line wrap: used to manage the line wrap when the text exceeds the width specified for the cell.
  • : Used to manage the horizontal alignment of text in the cell.
  • Merge and center: Used to merge cells and to center the merge result.
• Number: Used to manage the selection characteristics:
  
  • Style to apply: standard, short date, currency, time, ...
  • display the currency unit,
  • display a percentage,
  • use the thousand separator,
  • add or remove a decimal.
• Styles: Used to display a range of cells in array format.
  
• Cells: Used to insert, delete or erase cells.
  
  You can:
  • insert cells, rows, columns or worksheets.
    
  • delete cells, rows, columns or worksheets.
    
  • erase everything, the formatting only or the content only.
    
• Edit: Used to perform searches and replacements, and to sort data.
  

Performing a Find/Replace

1. On the "Home" pane, in the "Edit" group, click "Find" (or press Ctrl + F).
2. In the window that appears, specify:
   
   • the searched word, value or expression,
   • the search options: case sensitive, in all the worksheets, in the formulas.
3. Validate the search:
   • "Find" highlights the corresponding elements and selects the first one.
     
     "Next" is used to highlight the next element that matches the search.
   • "Find all" displays the list of cells that match the search.
     
     Selecting a result in the search window is used to select this result in the worksheet.

1. On the "Home" pane, in the "Edit" group, click "Replace" (or press Ctrl + H).
2. In the window that appears, specify:
   
   • the searched word, value or expression,
   • the search options: case sensitive, in all the worksheets, in the formulas.
   • the replacement text.
3. Validate the search.
   • "Find" selects the corresponding elements and highlights the first one. "Next" is used to highlight the next element that matches the search.
   • "Find all" displays the list of cells that match the search.
4. "Replace" is used to perform the replacement in the selected result.
5. "Replace all" replaces all the results found.

• insert an image.
• encrypt a file.
• Versions 25 and later
  manage comments.
  New in version 25
  manage comments.
  manage comments.

• Library: This group proposes libraries of formulas, grouped by theme.
• Defined names: This group allows you to manage the names given to the different cells.

Formula library

• Select the range of cells to be added.
• Click "Automatic sum": the sum is automatically calculated in the last empty cell of the selection.

• Position yourself on an empty cell.
• Click on the desired library to view the different formulas available.
• Select the formula to use. The formula appears in the cell and the formula bar.
• Complete the formula by clicking on the cells that must be taken into account.

Using defined names

1. Select the cell.
2. Click "Define a name".
3. In the window that appears, specify:
   
   • The name of the cell.
   • The scope of the name, i.e. in which elements this name can be used (sheet or workbook).
   • The cell description.
4. Validate.

1. Click "Name manager".
2. The window that appears shows the different named cells of the current document with their characteristics.
   
   You can:
   • Create a named cell.
   • Modify a named cell.
   • Delete a named cell.

• "Layout": xlsx file layout management.
• "Worksheet options": management of current sheet layout options:
  • Display and print the grid (or not).
  • Display and print the headers (or not).

• Know the page format and customize it if necessary ( "Margins" option):
  
• Modify the page orientation. The "Orientation" option allows you to switch from Portrait to Landscape mode.
  
• Configure scaling.
  

• Display: management of the formula bar, headers and grid.
• Zoom: zoom management to display the xlsx file in the Spreadsheet control.
• Freeze panes: management of a display with panes (useful for xlsx files displaying a large amount of data).