Calc Guide

grids in charts 78
guides while moving 403
H
headers and footers 115
Hide/Show button 135
hiding and showing data 63
HTML compatibility 399
hyperlinks
absolute 303
creating 304
Ctrl-click to activate 394
editing 306
relative 303
removing 306
I
illumination of 3D chart 89
image map 151
images
adding 130
context menu 142
cropping 140
embedding 133
inserting from file 130
inserting from the clipboard 134
inserting from the Gallery 134
linking 132
modifying 136
resizing 141
rotating 142
informational functions 463
input settings options 401
insert mode 15
Insert Picture dialog 131
inserting
columns and rows 30
sheets 32
interest rates 435
intersection operator 188
K
keyboard data entry 42
keyboard keys
navigating within spreadsheets 24
keyboard shortcuts
arrow keys 425
assigning 416
cell formatting 426
customizing 417
DataPilot 427
function keys 425
introduction 423
loading from a file 419
navigation 423
resetting to default values 419
saving to a file 419
selection 423
L
layout settings
format 115
page layout 114
table alignment 115
legend of chart 78
line charts 99
linking to external data
External Data dialog 307
find required range 310
Navigator 308
load Basic code to edit 398
load/save options 396
logical functions 462
M
macro recorder 341
macro security options 395
macros 420
macros
accessing cells directly 353
arguments 351
arguments in functions 352
as Calc functions 345
introduction 341
organizing 345
recording 341
sorting data 354
main window, description 11
manual line breaks 54
margins 114
mathematical functions 430
mean value lines 83
menu bar 11
menu font, customizing 410
menus
adding commands 413
creating 412
customizing 410
modifying 412
modifying entries 414
merging documents 335
Microsoft Excel 21
494 OpenOffice.org 3.x Calc Guide