Working with columns, rows and sheets

Α sheet can be seen as a large table, therefore it is essential to learn how to add, remove and resize rows and columns. When working with multiple sheets inside a spreadsheet some basic sheet editing commands are also required.

Columns and Rows

Inserting and deleting

To insert or delete rows and columns use the Standard toolbar buttons or the context menu items. To insert or delete a row or column:

1. Click on any cell of the row or column
2. Use one of the following buttons
   • Click the button to insert a row above the current row
   • Click the button to insert a column left to the current column
   • Click the button to delete the current row
   • Click the button to delete the current column

Alternatively you can use the context menu to access the above commands. Right click on a column or row header and choose one of the available commands.

Note that when inserting columns or rows you don't actually add new ones, only the contents are added and the data to adjacent cells are moved. The same applies when you delete columns or rows.

Resizing

You can resize the width of a column or the height of a row with one of the following ways:

a) Dragging

Place the mouse cursor on the edge of a column or row header and when the resize mouse icon appears drag to resize.

b) Using the context menu

In this way you can resize multiple columns or rows at once. Select one or more columns or rows and right click to bring the context menu. Select the Column Width (or Row Height) command to bring the window to set the new size.

Type the value for the column width (or row height).

Optimal column width or row height.

To quickly change the width of a column or height of a row place the mouse cursor on the edge of a column or row header and double click. The width or height will adjust to the optimal size.

Working with sheets

Inserting new sheets

• Click on the Add Sheet icon . This creates and inserts a new sheet after the last sheet in the spreadsheet.

• Or you can use the context menu. Right click on the Sheets Tab and choose the Insert Sheet command.

Moving and copying sheets

You can move or copy sheets within the same spreadsheet by dragging and dropping or using the Move/Copy Sheet dialog. To move or copy a sheet into another spreadsheet file you must use the Move/Copy Sheet dialog. To bring the Move/Copy Sheet dialog right click on a sheet and select the Move/Copy Sheet command from the context menu. In this dialog you can set the following:

• Choose the action type (move or copy)
• The document location (current spreadsheet or another)
• The sheet's new location
• The new name when copying a sheet

Renaming sheets

By default, the name for each new sheet added has the format SheetX, where X is the number of the next sheet to be added. While this works for a small spreadsheet with only a few sheets, it can become difficult to identify sheets when a spreadsheet contains many sheets. You can rename a sheet using one of the following methods:

• Right-click on a sheet tab and select Rename Sheet from the context menu to replace the existing name with a different one.
• Double-click on a sheet tab to open the Rename Sheet dialog.

Sheet names must start with either a letter or a number. Permitted characters are letters, numbers, spaces, and the underscore character. Attempting to rename a sheet with an invalid name will produce an error message.

Delete sheets

Right-click on the sheet tab where you want to delete a sheet and select Delete Sheet from the context menu.