How To Add In Openoffice Spreadsheet

Download Article

The term spreadsheet was derived from a big piece of paper that accountants used for business finances. The accountant would spread information like costs, payments, taxes, income, etc out on a single, big, oversized sheet of paper to get a complete fiscal overview.

Spreadsheets today have more and more uses. Some examples are:

Spreadsheets act like a calculator by automatically doing calculations.
Spreadsheets are used for tracking personal investments, budgeting, invoices, inventory tracking, statistical analysis, numerical modeling, accost books, telephone books, printing labels, etc.
Spreadsheets are used in near every profession to calculate, graph, analyze and store information.
Spreadsheets are used for What-if calculations. Alter one number in a spreadsheet and all the calculations in a large spreadsheet volition re-calculate, will automatically change.

With this wiki learn how to use OpenOffice Calc to larn your style effectually this powerful (and free) software.^[1]

The following four Calc Toolbars appear at the top of all Calc screens.

ane
Examine the Main Menu Toolbar.
- The first toolbar is the Main Carte toolbar that gives you admission to many of the basic commands used in Calc.
two
Expect at the Function Toolbar.
- The 2nd toolbar downwardly is the Office Toolbar. The Office Toolbar contains icons (pictures) to provide quick admission to commands similar New, Open, Impress, Copy, Paste, etc. When you lot place your mouse cursor over any of the elements of a toolbar, the name of the element appears on your screen.
- Motility your cursor over the icon . (The give-and-take "New" appears. Clicking on opens a new spreadsheet.)
three
Check out the Formatting Toolbar.
- The third toolbar down is the Formatting Toolbar. The Formatting Toolbar has icons plus driblet-down menus that allow you lot to select a font, font colour, alignments, number formats, border options and background colors.
4
See what the Formula Toolbar can practice.
- The fourth toolbar down is the Formula Toolbar. The Formula Toolbar contains the Proper noun Box driblet-downwardly menu and a long white box called the Input Line.
- Notation: If your Toolbars wait different, it is considering these toolbars are in 800x600 screen resolution and the last eight icons are not shown merely are bachelor by clicking on the on the far right of the toolbar.

The residue of the window contains the spreadsheet. The spreadsheet is divided into rows that take a number at the left of each row and divided into columns with letters at the meridian of each column.

1
Learn the definition of a jail cell in spreadsheets.
- A cell is the cardinal element of a worksheet. This is where things are added and where things are seen. A cell address in a spreadsheet identifies the location of the cell in the spreadsheet. A cell address is a combination of the column letter and the row number of a cell, such as A2 or B16.etc. When identifying a prison cell by its address, the column letter is always listed first followed by the row number. The prison cell accost of the example below is A5.
2
Enter Information.
1. Click on the A1 jail cell (The cell at the very summit left of the spreadsheet).
2. Notice the heavy black border effectually the A1 cell. The heavy black edge indicates that A1 is the active prison cell. (A is at the top of the get-go column and 1 is on the kickoff row. Both are highlighted. The highlighting as well indicates that A1 is the active cell.)
3. Type Hello Globe and press Enter.
  - The agile jail cell is now A2. (The words "Hello Globe" are in A1.)
4. When you type something in a cell and printing Enter, what you typed is seen in that cell and the jail cell below becomes the next active prison cell.
3
Delete Data.
1. Click on A1 again.
2. Press the Delete fundamental or right click the prison cell and select delete contents. (The "Delete Contents" window appears.)
3. Bank check the Delete all box then click OK. ("Hullo Globe" is deleted from A1)
4
Format Data
1. Split Thousands, 2 Decimal Places, Red Negative Numbers. Click cell A1. > Type the number -9999.129 > Printing Enter. (The cursor moves to cell A2)
2. Correct-click cell A1. (A small menu appears) > click Format cells. (The "Format cells" window appears)
3. Click Numbers tab. Under "Category", click on Number. Under "Format", click on -one,234.12. Click In the small box before "Negative numbers red". (A check-mark appears in the box) > Click OK. (The number '-9,999.13" appears in prison cell A1.
4. Align Left, Click Alignment tab. In the "Horizontal" pull-downwards menu, select Left. Click OK. (the numbers move to the left edge of the prison cell.)

Advert

Add New Question

Question

How practice I add sheets to my spreadsheet document?

Right click at the existing sheet and and so select "Insert Sheet." Choose before or later on the electric current sheet, proper noun the sheet, and then click "OK."
Question

When I become to print the spreadsheet, the lines are non on the page. What do I demand to do to add the lines on the page?

Afterward y'all've hit "Print," become to "Page Setup," click the "Sheet" tab, then click the "Gridlines" checkbox under "Print."
Question

How tin can I edit text in a spreadsheet cell?

Either double click on the cell you desire to edit text in and start typing, or unmarried click on the cell and type in the formula bar above the cavalcade letters.

Come across more answers

Ask a Question

200 characters left

Include your e-mail address to get a message when this question is answered.

Submit

Advertising

There are two means to select next rows or columns:
- Click on the row or column header and elevate information technology to select adjacent rows or columns;
- Or, select the first row or column and then the last row or column by pressing shift.

Thanks for submitting a tip for review!