Creating a New Spreadsheet

When you launch OpenOffice Calc, you are dropped into a new spreadsheet automatically, and you can begin entering data. Or you can open an existing spreadsheet (New • Open) to begin working.

A spreadsheet contains cells organized in rows and columns. To begin entering data into your spreadsheet, simply click in a cell. A black outline appears around the selected cell. Enter data, either text or numbers. When you are finished, simply click in another cell or press ENTER on the keyboard. You can also use the arrow keys or the TAB key to move to the next cell. This process is much like entering data into a word processor except that, in this case, each piece of data is entered into one cell at a time.

-a su

m

a*

^B^TT

ru

f/Am

u f r »IUL'UB f ^»» (Tt/i » •

Jr

J»u

» X

eJ - + if *

a

I—.

3

[J-T] * 1 II

1» * »

m m

•» * i> a a

* *

a

'< M W

p*

d

= 11W0

m

^

c

1 r

0

it

.

7

X

i

H 1

h 1 q

i

1

10

Siiihuinl

ru

on

11

«r

•-i

141

in

IBS

in

rxm

L.

y

ii

ll

m

TO

!S

:x

e-c

111

IM

7M

fJO

ISO BO

ok

013 1

Yx

illlhAVt

KB

rin

«

151

iron

4li

117 7«

or

01» I

IS

ue

4*.

¡(6

'CO

>co

»4)

)W

417»

ay

01»

14

SlilWMCl

>70

K'f

<4?

417

i*

;3n

130

15

JIM:

¿mj

■LK2

¿¿M

■»1

a»i

¿Uli

&E

i»4

¿414

212920

It

17

Dvtoita

la?

nra

111

;MT

:m

1741 70

'{Dil 1

j'

19

Xtwjtr

I«»

711 742

V*

mt

1711 ¡1«

lilt

1001 1301

14291« 1262 10

07!

010 012

:o

in*

IV*

nil

9M

4HJ

m

li»Jt

1(84

Mitt

OS.'

021

;i

"«ail»a

K

OH

i:

ill

w

13

153

13«;

Till

JB

7900

a 41

031

o

«S7

i»«

i r

I i&r

5441

T*:

'Ml

CIS 70

SB

-

¿4

ri voces

A

SS

K7

IZ'7

IH7

77? Tit

'-A

%

W?

KS

7K

IS

5ZP

-.7

2J6

ca

IGC

411

aii

ana

MOO

¿W«

1* J

¿4M

14»

16.1

1«!

Uli

M2I

»

TIEE

»

D

136

0

4a

1i9

;n

hi

so

n

34

89

(1

Id

0

ii)

u

ir

2

5

»

o

It

0 •

16

4

11

4

4

M

0

111

0

447

1 1»

m

7i

»

it

4'

K

ruTit j

1 1 nt* I

I 11116

1 »5.4 1

roll

1 191 1

1 11711 1

IS.1

14>H 1

I 12156 |

lim I

„Li-

Si

■WIL

1' kibMiAlMiSAlMd/

—ILL

_1

Staa

Kl/I

Ultl

loot*

ill»

it.

U'.'MI

_J

Figure 5.15: Entering Data into Your Spreadsheet

Tip To highlight a table area, click the upper left cell of the desired area and hold down the mouse button. Then drag the mouse pointer to the bottom right cell and release. Deleting or Moving Data

Since your spreadsheet is likely structured with formulas, deleting or moving data can be a bit more complex than it is in a word processor.

To delete data in an individual cell, simply use the BACKSPACE key to delete each character or number desired. To move data in one cell, right- click within the cell. Select Cut or Copy, depending on which action you want. In the new cell, right- click again, but this time select Paste.

You also can delete or move all data contained in a row or cell. Use the Delete Cells option on the Edit menu, or simply right- click on the data and select Delete from the menu that pops up. This option allows you to specify what should happen to the deleted row—for instance, move rows up or shift columns.

Figure 5.16: Delete Cells Dialog Box

Was this article helpful?

0 0

Post a comment