It is normal to add the date to a spreadsheet. Widen other columns to show data as needed. Select with the left mouse button and drag the double-headed arrow to the right to widen column C. (The pointer will change to a double-headed arrow.) Place the mouse pointer on the line between columns C and D in the column header.

To correct this so that the entire word is visible in the column: Press the Enter key on the keyboard or select the next cell in the list with the mouse.Īfter entering the data you will probably find that several words, such as Deduction, are too wide for a cell. Type the corresponding data into the selected cell. Select the cell indicated by the cell reference provided. To follow this tutorial, enter the data exactly as shown above into a blank spreadsheet using the following steps: Press the ENTER key on the keyboard or click on another cell with the mouse. Select on the cell where you want the data to go.

Number formatting – percent and currencyĮntering data into a spreadsheet is always a three-step process.

Adding a Date Function and a Range Name.

Instructions in this article applies to OpenOffice Calc v.

How to add column in openoffice excel