Index
O
Object data type, 1025
objects
Application, 937
collections, 937–938
Excel object model, 937
methods, 939–940
properties, 938–939
qualified object references, 1012
Range, 940–941
selecting, 78
simplifying references, 1024
Objects option, Go To Special dialog box, 78
OCT2DEC function, 597
octal values, converting to decimal, 597
ODBC connections, connecting to Power Query, 855
.ods file extension, 611
OFFSET function, 316
calculating dynamic range, 536
converting vertical data to horizontal, 604–605
OLAP databases, connecting to Power Query, 855
one-click printing, 173
one-dimensional horizontal arrays, 404–405
one-dimensional vertical arrays, 405
OnKey application event, 1006, 1008–1009
OnTime application event, 1006, 1007–1008
Open As Copy command, 170
Open dialog box, 580
Open workbook event, 1000–1001
OpenDocument Spreadsheet, exporting to, 611
opening
add-ins, 1028
files
vs. importing files, 582–583
unsupported files, 141
workbooks, 154–157
automatically, 157
with external reference formulas, 641–642
Open event, 1000–1001
requiring password, 774–775
Workbook_Open procedure, 1000–1001
operators
in formulas, 208–209
logical, 208–209
omitting in formulas, 429
precedence 209–210, 430–431
reference operators, 234–236
OptionButton ActiveX control, 993
OR function, 302–303
order argument, SERIES function, 513
outliers, statistical, 379–382
outlines
adding data, 635
creating automatically, 632
creating manually, 632–634
displaying levels, 634–635
overview, 627–631
vs. PivotTables, 630–631
preparing data for, 631–632
removing, 635P
padding data, 266
Page Break Preview view, 175, 176–178
page breaks
inserting, 183
Normal view, 175, 176
Page Break Preview view, 175, 176–178
removing, 183
when changing page orientation, 181
Page Layout tab, 10
Page Setup
Background, 185–186, 564
Breaks, 183
Margins, 181–183
Orientation, 181
Print Area, 180
Print Titles, 184
Size, 181
Scale to Fit, 185
Sheet Options
Gridlines, 185
Headings, 185
Themes
Colors, 150–151
Fonts, 149–150
Save Current Theme, 151
Themes, 148–149
Page Layout view, 174, 175–176
Page Setup dialog box
Margins tab, 182
Preview box, 182
print settings, adjusting, 178–180
Sheet tab, 184
page view buttons, 5, 6
parentheses, mismatched, 424–425