Working with cells, rows and columns

A spreadsheet is made up of cells in rows (1, 2, 3) and columns (A, B, C). Every cell has an address: B5 is the cell in column B, row 5. In Euro-Office, you simply open xlsx files from Excel and ods files from LibreOffice in your browser.

The parts of the screen

• Name Box (1): the address of the selected cell. Type an address here such as F2 or a range such as A1:F17 and press Enter to jump straight there.
• Formula bar (2): the contents of the cell. If the cell contains a formula, you'll see the formula here and the result in the cell itself.
• Sheets (3): the tabs of the workbook at the bottom. Use the plus icon to create a new sheet. See Managing sheets.

Typing and editing data

• Click a cell and type. Press Enter to move to the cell below, or Tab to move to the cell on the right.
• Want to edit a cell without retyping everything? Double-click the cell or press F2.
• Press Delete to clear a cell.
• Drag the small square in the bottom right corner of a cell to fill in the content. Type "January" and drag it across, and Euro-Office automatically fills in February, March and so on.

Selecting

• Click a column letter or row number to select the entire column or row.
• Drag with your mouse, or hold down Shift and use the arrow keys, to select a range.
• Hold down Ctrl to select cells that aren't next to each other.
• Press Ctrl + A to select everything.

Inserting or deleting rows and columns

On the Home tab, click Insert cells (1) and choose Entire row or Entire column. Use the button next to it to delete cells, rows or columns. Quicker way: right-click a row number or column letter and choose Insert or Delete.

Width and height

Drag the line between two column letters to make a column wider. Double-click that line and the column will become exactly as wide as the longest piece of text. Use Format on the Home tab to set the row height and column width precisely.

Tip: does a long piece of text not fit in a cell? Click Wrap text on the Home tab (or tick Wrap text in the panel on the right), and the text will continue onto multiple lines within the cell. Use Merge Center to turn a few cells into one wide cell, handy for a title.