User Guide

coloring
data ranges ...........205
spreadsheet tabs ..........206
colors
adding .............205
changing text ...........203
column width
adjusting ............201
changing ............199
changing default ..........199
increasing ............200
restoring default ..........200
columns
adding .............167
CrossTab reports ..........235
deleting ...........167-168
delimiters ...........223,225
filling .............186
hiding .............201
inserting ...........167-168
joining cells ...........203
navigating ............163
parsing ...........223,225
QuickFill ............186
resizing ............198
restricting ..........167-168
revealing ............201
selecting ............165
setting number of ..........182
totaling ............187
totaling subtotals in .........189
totaling using QuickSum ........188
totaling values in ..........187
transposing ..........197-198
combining
cells .............203
combining files
mathematical operations ........223
comments
displaying ............173
compatibility settings
accessing ............170
changing ............170
file type ............170
Menu Bar ............170
notebook size ...........170
content
editing .............193
replacing ............193
replacing cell ...........192
Control Menu
commands ............163
converting
page breaks ..........209-210
copied cells
linking .............198
copying
cell formatting ...........201
to spreadsheet groups .........196
types of data ...........197
copyright symbol ...........182
creating
charts .............231
charts automatically .........231
CrossTab reports.........233-234
scenario groups ..........217
scenarios ............217
cross tabulation ...........233
CrossTab report data
refreshing ............236
updating ............236
CrossTab report data fields
aligning ............235
CrossTab reports ...........234
adjusting appearance .........236
building ............234
formatting ............235
naming .............235
refreshing ............236
currency
international settings ........170,172
current dates
entering ...........184-185
customizing
appearance of CrossTab reports ......236
parse settings ...........224
SpeedFormat ...........201
start options ..........181-182
cutting
cells .............198
D
data
changing ............192
comparisons ...........233
copying ............195
CrossTab reports ..........233
finding and replacing .........193
linking .............219
manipulating ...........234
overwriting ...........192
protecting ............191
repeated ............186
searching and replacing ........193
summarizing (CrossTab reports) ......233
unprotecting ...........191
zooming ............176
Index: Quattro Pro 10 239