:Base qp11en.hlp>main
:Title Quattro Pro Help
:Tab Corel Knowledge Base=cdrhlp110.dll
:Index PerfectFit Help=pfit11en.hlp
:Index Functions Help=qp11fnen.hlp
:Index Corel Support Help=corelts.hlp
:Index Writing Tools Help=wt11cmen.hlp
:Index TextArt Help=wpta11en.hlp
:Index Scrapbook Help=scrpbken.hlp
:Link qp11en.hlp
:Link pfit11en.hlp
:Link qp11fnen.hlp
:Link corelts.hlp
:Link wt11cmen.hlp
:Link wpta11en.hlp
:Link scrpbken.hlp
1 Showcase Quattro Pro=qp_1
1 Welcome to Quattro Pro
1 Welcome to Quattro Pro=Welcome to Quattro Pro>main
2 About Corel Corporation
2 About Corel Corporation=About Corel Corporation>main
3 To access the Corel Web site=To access the Corel Web site>proc4
2 Using Quattro Pro documentation
2 Using Quattro Pro documentation=Using Quattro Pro documentation>main
3 To follow documentation conventions=To follow documentation conventions>proc4
3 To access online Help=To access online Help>proc4
3 To access additional Help resources=To access additional Help resources>proc4
3 To print online Help topics=To print online Help topics>proc4
3 To access context-sensitive Help=To access contextsensitive Help>proc4
3 To view program and system information=To view program and system information>proc4
2 What's new in Quattro Pro
2 What's new in Quattro Pro=Whats new in Quattro Pro>main
3 To install ZIM SMS Office=To install ZIM SMS Office>proc4
2 What's different in Quattro Pro
2 What's different in Quattro Pro=Whats different in Quattro Pro>main
:include corelts.cnt
1 Getting started
1 Getting started=Getting started>main
2 Components of a notebook
2 Components of a notebook=Components of a notebook>main
3 Outline of notebook components=Outline of notebook components>proc4
2 Working with Quattro Pro Experts
2 Working with Quattro Pro Experts=Working with Quattro Pro Experts>main
3 To access an Expert from a toolbar=To access an Expert from a toolbar>proc4
3 To access an Expert from a menu=To access an Expert from a menu>proc4
2 Working with toolbars
2 Working with toolbars=Working with toolbars>main
3 To create a toolbar=To create a toolbar>proc4
3 To edit a toolbar=To edit a toolbar>proc4
3 To display a toolbar=To display a toolbar>proc4
3 To move a toolbar=To move a toolbar>proc4
3 To rename a toolbar=To rename a toolbar>proc4
3 To delete a toolbar=To delete a toolbar>proc4
3 To reset a toolbar=To reset a toolbar>proc4
3 To display a graphic or text on a toolbar button=To display a graphic or text on a toolbar button>proc4
3 To display text under all toolbar buttons=To display text under all toolbar buttons>proc4
3 To add a toolbar button that launches an application or document=To add a toolbar button that launches an application or document>proc4
3 To add a toolbar button that plays a macro=To add a toolbar button that plays a macro>proc4
2 Working with the application bar
2 Working with the application bar=Working with the application bar>main
3 To customize the application bar=To customize the application bar>proc4
3 To change the position of the application bar=To change the position of the application bar>proc4
3 To change the height of the application bar=To change the height of the application bar>proc4
3 To use the QuickCell feature=To use the QuickCell feature>proc4
2 Navigating in spreadsheets and notebooks
2 Navigating in spreadsheets and notebooks=Navigating in spreadsheets and notebooks>main
3 To navigate in a spreadsheet=To navigate in a spreadsheet>proc4
3 To automatically scroll through a spreadsheet=To automatically scroll through a spreadsheet>proc4
3 To go to the Objects sheet=To go to the Objects sheet>proc4
3 To cycle through open notebooks=To cycle through open notebooks>proc4
3 To access menu options using the keyboard=To access menu options using the keyboard>proc4
3 To access dialog box options using the keyboard=To access dialog box options using the keyboard>proc4
3 To go to a specific cell in a notebook=To go to a specific cell in a notebook>proc4
3 To browse to specific data in a notebook=To browse to specific data in a notebook>proc4
2 Selecting cells, rows, and columns
2 Selecting cells, rows, and columns=Selecting cells rows and columns>main
3 To set the selector to move when you press Enter=To set the selector to move when you press Enter>proc4
3 To select noncontiguous cells=To select noncontiguous cells>proc4
3 To select a 3-D block of cells=To select a 3D block of cells>proc4
3 To change 3-D spreadsheet range syntax=To change 3D spreadsheet range syntax>proc4
3 To select cells from a dialog box=To select cells from a dialog box>proc4
3 To quickly select data on a spreadsheet=To quickly select data on a spreadsheet>proc4
3 To quickly move to a corner of a block of cells=To quickly move to a corner of a block of cells>proc4
3 To select a row or column=To select a row or column>proc4
3 To select multiple spreadsheets=To select multiple spreadsheets>proc4
3 To lock titles on a spreadsheet=To lock titles on a spreadsheet>proc4
3 To repeat column titles on each spreadsheet of a printed notebook=To repeat column titles on each spreadsheet of a printed notebook>proc4
2 Inserting and deleting cells, rows, and columns
2 Inserting and deleting cells, rows, and columns=Inserting and deleting cells rows and columns>main
3 To insert a cell=To insert a cell>proc4
3 To insert a row=To insert a row>proc4
3 To insert a column=To insert a column>proc4
3 To copy and insert data and cells=To copy and insert data and cells>proc4
3 To delete a cell=To delete a cell>proc4
3 To delete a row or a column=To delete a row or a column>proc4
3 To restrict the addition of rows and columns=To restrict the addition of rows and columns>proc4
2 Adding, deleting, moving, and copying spreadsheets
2 Adding, deleting, moving, and copying spreadsheets=Adding deleting moving and copying spreadsheets>main
3 To insert a spreadsheet=To insert a spreadsheet>proc4
3 To insert multiple spreadsheets=To insert multiple spreadsheets>proc4
3 To delete a spreadsheet=To delete a spreadsheet>proc4
3 To delete multiple spreadsheets=To delete multiple spreadsheets>proc4
3 To move a spreadsheet=To move a spreadsheet>proc4
3 To copy a spreadsheet=To copy a spreadsheet>proc4
2 Naming spreadsheets
2 Naming spreadsheets=Naming spreadsheets>main
3 To rename a spreadsheet=To rename a spreadsheet>proc4
3 To rename a spreadsheet using Microsoft Excel conventions=To rename a spreadsheet using Microsoft Excel conventions>proc4
2 Specifying Quattro Pro settings
2 Specifying Quattro Pro settings=Specifying Quattro Pro settings>main
3 To change application settings=To change application settings>proc4
3 To change the properties of an item=To change the properties of an item>proc4
3 To view statistics on a notebook=To view statistics on a notebook>proc4
3 To record summary information about a notebook=To record summary information about a notebook>proc4
3 To change compatibility options=To change compatibility options>proc4
3 To change the default file save type=To change the default file save type>proc4
3 To change the default file open type=To change the default file open type>proc4
3 To change the notebook size=To change the notebook size>proc4
3 To change the currency symbol=To change the currency symbol>proc4
3 To change punctuation settings=To change punctuation settings>proc4
3 To change available date formats=To change available date formats>proc4
3 To change available time formats=To change available time formats>proc4
3 To convert LICS characters=To convert LICS characters>proc4
3 To change the default language=To change the default language>proc4
2 Displaying, arranging, resizing, and hiding windows
2 Displaying, arranging, resizing, and hiding windows=Displaying arranging resizing and hiding windows>main
3 To select a notebook window=To select a notebook window>proc4
3 To arrange notebook windows=To arrange notebook windows>proc4
3 To hide a notebook window=To hide a notebook window>proc4
3 To select a notebook view=To select a notebook view>proc4
3 To display formulas instead of formula results=To display formulas instead of formula results>proc4
3 To display spreadsheet comments=To display spreadsheet comments>proc4
3 To display a new view of a notebook window=To display a new view of a notebook window>proc4
3 To split a window into two panes=To split a window into two panes>proc4
3 To synchronize window panes=To synchronize window panes>proc4
3 To resize window panes=To resize window panes>proc4
2 Zooming data and hiding and displaying screen components
2 Zooming data and hiding and displaying screen components=Zooming data and hiding and displaying screen components>main
3 To zoom a notebook=To zoom a notebook>proc4
3 To zoom data to fit on the screen=To zoom data to fit on the screen>proc4
3 To hide notebook features=To hide notebook features>proc4
3 To hide parts of the screen=To hide parts of the screen>proc4
3 To hide borders on a spreadsheet=To hide borders on a spreadsheet>proc4
3 To hide grid lines on a spreadsheet=To hide grid lines on a spreadsheet>proc4
2 Customizing menus
2 Customizing menus=Customizing menus>main
3 To customize a menu=To customize a menu>proc4
3 To change the access key on a menu item=To change the access key on a menu item>proc4
3 To make the user interface transparent=To make the user interface transparent>proc4
2 Customizing keyboards
2 Customizing keyboards=Customizing keyboards>main
3 To assign a shortcut key to a command=To assign a shortcut key to a command>proc4
3 To print a list of shortcut keys=To print a list of shortcut keys>proc4
3 To export a list of shortcut keys to a text file=To export a list of shortcut keys to a text file>proc4
3 To restore all keyboard assignments to their original settings=To restore all keyboard assignments to their original settings>proc4
2 Saving a notebook group
2 Saving a notebook group=Saving a notebook group>main
3 To save a notebook group=To save a notebook group>proc4
3 To restore a notebook group=To restore a notebook group>proc4
2 Setting multiple workspaces
2 Setting multiple workspaces=Setting multiple workspaces>main
3 To create a workspace=To create a workspace>proc4
3 To choose a workspace=To choose a workspace>proc4
3 To delete a workspace=To delete a workspace>proc4
3 To import a workspace=To import a workspace>proc4
3 To export a workspace=To export a workspace>proc4
2 Saving and closing notebooks
2 Saving and closing notebooks=Saving and closing notebooks>main
3 To save a notebook=To save a notebook>proc4
3 To save a notebook with a new filename=To save a notebook with a new filename>proc4
3 To save a notebook with a password=To save a notebook with a password>proc4
3 To specify a default filename extension=To specify a default filename extension>proc4
3 To specify a default folder=To specify a default folder>proc4
3 To back up your notebooks automatically=To back up your notebooks automatically>proc4
3 To extract part of a notebook=To extract part of a notebook>proc4
3 To close a notebook=To close a notebook>proc4
3 To exit Quattro Pro=To exit Quattro Pro>proc4
2 Reference: Getting started
2 Reference: Getting started=Reference Getting started>main
3 Mode and status indicators=Mode and status indicators>proc4
3 Corel Application Recovery Manager=Corel Application Recovery Manager>proc4
2 Using Accessibility features
2 Using Accessibility features=Using Accessibility features>main
3 Accessing Quattro Pro documentation in ASCII text format=Accessing Quattro Pro documentation in ASCII text format>proc4
3 Customizing keyboards, toolbars, and menus=Customizing keyboards toolbars and menus>proc4
3 Modifying display and navigational features=Modifying display and navigational features>proc4
3 Entering and correcting data=Entering and correcting data>proc4
3 Changing text size and appearance=Changing text size and appearance>proc4
3 To change the font size in a Help topic=To change the font size in a Help topic>proc4
3 To change Help text hyperlink colors=To change Help text hyperlink colors>proc4
1 Moving between Microsoft Excel and Quattro Pro
1 Moving between Microsoft Excel and Quattro Pro=Moving between Microsoft Excel and Quattro Pro>main
2 Opening and saving Microsoft Excel workbooks in Quattro Pro
2 Opening and saving Microsoft Excel workbooks in Quattro Pro=Opening and saving Microsoft Excel workbooks in Quattro Pro>main
3 To open a Microsoft Excel workbook in Quattro Pro=To open a Microsoft Excel workbook in Quattro Pro>proc4
3 To save a Microsoft Excel workbook as a Quattro Pro notebook=To save a Microsoft Excel workbook as a Quattro Pro notebook>proc4
3 To fix invalid spreadsheet names=To fix invalid spreadsheet names>proc4
3 To save a Quattro Pro notebook as a Microsoft Excel file=To save a Quattro Pro notebook as a Microsoft Excel file>proc4
2 Working with Microsoft Excel 97 menus and tabs in Quattro Pro
2 Working with Microsoft Excel 97 menus and tabs in Quattro Pro=Working with Microsoft Excel 97 menus and tabs in Quattro Pro>main
3 To use Microsoft Excel 97 menus and tabs in Quattro Pro=To use Microsoft Excel 97 menus and tabs in Quattro Pro>proc4
3 To switch to the Microsoft Excel naming convention for spreadsheet tabs=To switch to the Microsoft Excel naming convention for spreadsheet tabs>proc4
2 Reference: Moving between Microsoft Excel and Quattro Pro
2 Reference: Moving between Microsoft Excel and Quattro Pro=Reference Moving between Microsoft Excel and Quattro Pro>main
3 Microsoft Excel features and Quattro Pro equivalents=Microsoft Excel features and Quattro Pro equivalents>proc4
3 Microsoft Excel spreadsheet data imported by Quattro Pro=Microsoft Excel spreadsheet data imported by Quattro Pro>proc4
3 Microsoft Excel cell attributes and styles imported by Quattro Pro=Microsoft Excel cell attributes and styles imported by Quattro Pro>proc4
3 Microsoft Excel print options, windows, and charts imported by Quattro Pro=Microsoft Excel print options windows and charts imported by Quattro Pro>proc4
3 Spreadsheet objects transferred between Microsoft Excel and Quattro Pro=Spreadsheet objects transferred between Microsoft Excel and Quattro Pro>proc4
3 Microsoft Excel formulas and functions imported by Quattro Pro=Microsoft Excel formulas and functions imported by Quattro Pro>proc4
3 Microsoft Excel analysis tools not imported by Quattro Pro=Microsoft Excel analysis tools not imported by Quattro Pro>proc4
3 Microsoft Excel functions supported by Quattro Pro=Microsoft Excel functions supported by Quattro Pro>proc4
3 Microsoft Excel functions not supported by Quattro Pro=Microsoft Excel functions not supported by Quattro Pro>proc4
1 Moving between Lotus 1-2-3 and Quattro Pro
1 Moving between Lotus 1-2-3 and Quattro Pro=Moving between Lotus 123 and Quattro Pro>main
2 Opening and saving Lotus 1-2-3 files in Quattro Pro
2 Opening and saving Lotus 1-2-3 files in Quattro Pro=Opening and saving Lotus 123 files in Quattro Pro>main
3 To open a Lotus 1-2-3 file in Quattro Pro=To open a Lotus 123 file in Quattro Pro>proc4
3 To save a Lotus 1-2-3 file as a Quattro Pro notebook=To save a Lotus 123 file as a Quattro Pro notebook>proc4
3 To use the Lotus 1-2-3 menu in Quattro Pro=To use the Lotus 123 menu in Quattro Pro>proc4
2 Reference: Moving between Lotus 1-2-3 and Quattro Pro
2 Reference: Moving between Lotus 1-2-3 and Quattro Pro=Reference Moving between Lotus 123 and Quattro Pro>main
3 Lotus 1-2-3 file formats supported by Quattro Pro=Lotus 123 file formats supported by Quattro Pro>proc4
3 Lotus 1-2-3 for DOS menu items and Quattro Pro equivalents=Lotus 123 for DOS menu items and Quattro Pro equivalents>proc4
3 Lotus 1-2-3 features and Quattro Pro equivalents=Lotus 123 features and Quattro Pro equivalents>proc4
3 Lotus 1-2-3 97/9 spreadsheet attributes imported by Quattro Pro=Lotus 123 979 spreadsheet attributes imported by Quattro Pro>proc4
3 Cell attributes and styles imported and exported between Quattro Pro and Lotus 1-2-3=Cell attributes and styles imported and exported between Quattro Pro and Lotus 123>proc4
3 Print options, windows, and navigation tools imported and exported between Quattro Pro and Lotus 1-2-3=Print options windows and navigation tools imported and exported between Quattro Pro and Lotus 123>proc4
3 Objects imported and exported between Quattro Pro and Lotus 1-2-3=Objects imported and exported between Quattro Pro and Lotus 123>proc4
3 Formulas and functions imported and exported between Quattro Pro and Lotus 1-2-3=Formulas and functions imported and exported between Quattro Pro and Lotus 123>proc4
3 Lotus 1-2-3 spreadsheet functions supported by Quattro Pro=Lotus 123 spreadsheet functions supported by Quattro Pro>proc4
3 File management features imported and exported between Quattro Pro and Lotus 1-2-3=File management features imported and exported between Quattro Pro and Lotus 123>proc4
3 WYSIWYG/Impress options supported by Quattro Pro=WYSIWYGImpress options supported by Quattro Pro>proc4
3 Allways options supported by Quattro Pro=Allways options supported by Quattro Pro>proc4
1 Working with project templates
1 Working with project templates=Working with project templates>main
2 Creating projects using templates
2 Creating projects using templates=Creating projects using templates>main
3 To display a list of previous projects=To display a list of previous projects>proc4
3 To display project templates when Quattro Pro opens=To display project templates when Quattro Pro opens>proc4
3 To copy templates from previous versions of WordPerfect and Quattro Pro=To copy templates from previous versions of WordPerfect and Quattro Pro>proc4
3 To add a project to the Favorites folder=To add a project to the Favorites folder>proc4
3 To change a project description=To change a project description>proc4
2 Working with project template categories
2 Working with project template categories=Working with project template categories>main
3 To create a project template category=To create a project template category>proc4
3 To rename a project template category=To rename a project template category>proc4
3 To delete a project template category=To delete a project template category>proc4
3 To add a project to a project template category=To add a project to a project template category>proc4
3 To add a document or executable file to a project template category=To add a document or executable file to a project template category>proc4
3 To move a project to another project template category=To move a project to another project template category>proc4
1 Creating spreadsheets
1 Creating spreadsheets=Creating spreadsheets>main
2 Creating and opening notebooks
2 Creating and opening notebooks=Creating and opening notebooks>main
3 To create a notebook=To create a notebook>proc4
3 To create a notebook using a project template=To create a notebook using a project template>proc4
3 To open a notebook=To open a notebook>proc4
3 To open a specific notebook when starting Quattro Pro=To open a specific notebook when starting Quattro Pro>proc4
2 Entering labels and special characters
2 Entering labels and special characters=Entering labels and special characters>main
3 To create a label=To create a label>proc4
3 To create a label from a value=To create a label from a value>proc4
3 To insert special characters and symbols=To insert special characters and symbols>proc4
3 To repeat a character=To repeat a character>proc4
3 To repeat a series of characters in a pattern=To repeat a series of characters in a pattern>proc4
2 Entering values
2 Entering values=Entering values>main
3 To enter a number=To enter a number>proc4
3 To enter fractions=To enter fractions>proc4
3 To enter a date or time=To enter a date or time>proc4
3 To enter the current date=To enter the current date>proc4
3 To enter a date using the spreadsheet DATE function=To enter a date using the spreadsheet DATE function>proc4
2 Filling cells and spreadsheet tabs automatically
2 Filling cells and spreadsheet tabs automatically=Filling cells and spreadsheet tabs automatically>main
3 To automatically insert repeated data=To automatically insert repeated data>proc4
3 To fill empty cells automatically=To fill empty cells automatically>proc4
3 To fill cells automatically using seed values=To fill cells automatically using seed values>proc4
3 To fill spreadsheet tabs automatically=To fill spreadsheet tabs automatically>proc4
2 Creating a series to fill cells
2 Creating a series to fill cells=Creating a series to fill cells>main
3 To create a QuickFill formula series=To create a QuickFill formula series>proc4
3 To create a QuickFill list series=To create a QuickFill list series>proc4
3 To modify a QuickFill series=To modify a QuickFill series>proc4
3 To rename a QuickFill series=To rename a QuickFill series>proc4
3 To delete a QuickFill series=To delete a QuickFill series>proc4
3 To add elements from a cell to a QuickFill series=To add elements from a cell to a QuickFill series>proc4
3 To create a custom series to fill cells=To create a custom series to fill cells>proc4
2 Restricting and annotating cell data
2 Restricting and annotating cell data=Restricting and annotating cell data>main
3 To restrict cells=To restrict cells>proc4
3 To add a cell comment=To add a cell comment>proc4
3 To view all cell comments on a spreadsheet=To view all cell comments on a spreadsheet>proc4
3 To change cell comment attributes=To change cell comment attributes>proc4
2 Creating simple equations
2 Creating simple equations=Creating simple equations>main
3 To do simple math in cells=To do simple math in cells>proc4
3 To total values in a column=To total values in a column>proc4
3 To have Quattro Pro identify the forward slash (/) as a division sign=To have Quattro Pro identify the forward slash  as a division sign>proc4
2 Calculating data in rows and columns
2 Calculating data in rows and columns=Calculating data in rows and columns>main
3 To calculate data in a single row or column=To calculate data in a single row or column>proc4
3 To perform a calculation on each item in a row or column=To perform a calculation on each item in a row or column>proc4
3 To calculate data in two rows or columns=To calculate data in two rows or columns>proc4
2 Performing running calculations
2 Performing running calculations=Performing running calculations>main
3 To perform preset calculations=To perform preset calculations>proc4
3 To total cells=To total cells>proc4
3 To total all cells on multiple spreadsheets=To total all cells on multiple spreadsheets>proc4
3 To total subtotals in a column=To total subtotals in a column>proc4
3 To use Calc As-You-Go=To use Calc AsYouGo>proc4
3 To disable Calc As-You-Go=To disable Calc AsYouGo>proc4
2 Reference: Creating spreadsheets
2 Reference: Creating spreadsheets=Reference Creating spreadsheets>main
3 Default date and time formats=Default date and time formats>proc4
3 Entering dates=Entering dates>proc4
3 QuickFill seed values=QuickFill seed values>proc4
1 Editing and formatting spreadsheets
1 Editing and formatting spreadsheets=Editing and formatting spreadsheets>main
2 Checking spelling
2 Checking spelling=Checking spelling>main
3 To check spelling=To check spelling>proc4
3 To add words to the list of commonly misspelled words=To add words to the list of commonly misspelled words>proc4
3 To delete words from the list of commonly misspelled words=To delete words from the list of commonly misspelled words>proc4
3 To disable automatic replacement of commonly misspelled words=To disable automatic replacement of commonly misspelled words>proc4
2 Protecting data
2 Protecting data=Protecting data>main
3 To protect all spreadsheet cells=To protect all spreadsheet cells>proc4
3 To unlock a cell in a protected spreadsheet=To unlock a cell in a protected spreadsheet>proc4
3 To protect all spreadsheet objects=To protect all spreadsheet objects>proc4
2 Editing cell content
2 Editing cell content=Editing cell content>main
3 To overwrite data=To overwrite data>proc4
3 To replace the entire content of a cell=To replace the entire content of a cell>proc4
3 To edit the content and formatting of a cell=To edit the content and formatting of a cell>proc4
3 To modify part of a cell's content=To modify part of a cells content>proc4
3 To clear values in a range of cells without clearing formulas=To clear values in a range of cells without clearing formulas>proc4
3 To find and replace data=To find and replace data>proc4
2 Undoing actions
2 Undoing actions=Undoing actions>main
3 To undo one action=To undo one action>proc4
3 To undo multiple actions=To undo multiple actions>proc4
3 To redo an action=To redo an action>proc4
3 To redo multiple actions=To redo multiple actions>proc4
3 To set the undo and redo level=To set the undo and redo level>proc4
2 Editing grouped data
2 Editing grouped data=Editing grouped data>main
3 To create a spreadsheet group=To create a spreadsheet group>proc4
3 To enable or disable Group mode=To enable or disable Group mode>proc4
3 To copy data to spreadsheets in a group=To copy data to spreadsheets in a group>proc4
3 To delete a spreadsheet group=To delete a spreadsheet group>proc4
2 Moving selected cells by dragging
2 Moving selected cells by dragging=Moving selected cells by dragging>main
3 To move cells by dragging=To move cells by dragging>proc4
3 To move cells to another spreadsheet by dragging=To move cells to another spreadsheet by dragging>proc4
3 To move cells to another notebook by dragging=To move cells to another notebook by dragging>proc4
3 To change the delay time for the Drag and Drop arrow =To change the delay time for the Drag and Drop arrow >proc4
2 Moving cells, rows, and columns
2 Moving cells, rows, and columns=Moving cells rows and columns>main
3 To copy cells=To copy cells>proc4
3 To move cells=To move cells>proc4
3 To copy cells to a specified location=To copy cells to a specified location>proc4
3 To copy specific types of data, cell properties and cell comments in a cell selection=To copy specific types of data cell properties and cell comments in a cell selection>proc4
3 To transpose columns to rows=To transpose columns to rows>proc4
2 Resizing rows and columns
2 Resizing rows and columns=Resizing rows and columns>main
3 To change row height=To change row height>proc4
3 To change column width=To change column width>proc4
3 To change the active spreadsheet default column width=To change the active spreadsheet default column width>proc4
3 To increase the column width while typing values=To increase the column width while typing values>proc4
3 To restore the active cell default column width=To restore the active cell default column width>proc4
3 To restore the active cell default row height=To restore the active cell default row height>proc4
2 Resizing rows and columns to fit a specific cell
2 Resizing rows and columns to fit a specific cell=Resizing rows and columns to fit a specific cell>main
3 To increase the column width to fit the longest entry=To increase the column width to fit the longest entry>proc4
3 To increase the row height to fit the tallest entry=To increase the row height to fit the tallest entry>proc4
3 To adjust the column width and row height simultaneously=To adjust the column width and row height simultaneously>proc4
2 Hiding rows and columns
2 Hiding rows and columns=Hiding rows and columns>main
3 To hide rows or columns=To hide rows or columns>proc4
3 To reveal hidden columns=To reveal hidden columns>proc4
2 Using formatting tools to format a spreadsheet
2 Using formatting tools to format a spreadsheet=Using formatting tools to format a spreadsheet>main
3 To copy cell formatting=To copy cell formatting>proc4
3 To apply a predesigned format=To apply a predesigned format>proc4
3 To add a format to the predesigned format list=To add a format to the predesigned format list>proc4
2 Wrapping text
2 Wrapping text=Wrapping text>main
3 To wrap text within a cell=To wrap text within a cell>proc4
3 To enter short lines of text in one cell=To enter short lines of text in one cell>proc4
3 To redistribute text over multiple rows or columns=To redistribute text over multiple rows or columns>proc4
2 Joining cells
2 Joining cells=Joining cells>main
3 To join cells=To join cells>proc4
2 Changing text font and appearance
2 Changing text font and appearance=Changing text font and appearance>main
3 To change text font and style=To change text font and style>proc4
3 To change text appearance=To change text appearance>proc4
3 To set text to superscript or subscript=To set text to superscript or subscript>proc4
2 Working with fills, patterns, and borders
2 Working with fills, patterns, and borders=Working with fills patterns and borders>main
3 To fill the cell background=To fill the cell background>proc4
3 To add color to a range of data=To add color to a range of data>proc4
3 To color-code a spreadsheet tab=To colorcode a spreadsheet tab>proc4
3 To add a border to cells=To add a border to cells>proc4
3 To add a line for totals and grand totals=To add a line for totals and grand totals>proc4
2 Changing colors in the notebook palette
2 Changing colors in the notebook palette=Changing colors in the notebook palette>main
3 To define a new color for the notebook palette=To define a new color for the notebook palette>proc4
3 To reset the default palette=To reset the default palette>proc4
2 Aligning data
2 Aligning data=Aligning data>main
3 To align data in a cell=To align data in a cell>proc4
3 To set the default alignment of all labels=To set the default alignment of all labels>proc4
3 To center text across multiple cells=To center text across multiple cells>proc4
3 To rotate text=To rotate text>proc4
2 Working with numeric formats
2 Working with numeric formats=Working with numeric formats>main
3 To change the numeric format of a cell=To change the numeric format of a cell>proc4
3 To hide zeros on a spreadsheet=To hide zeros on a spreadsheet>proc4
3 To change the number of decimal places in a value=To change the number of decimal places in a value>proc4
3 To format dates and times=To format dates and times>proc4
3 To change the default date format=To change the default date format>proc4
3 To change the short date style=To change the short date style>proc4
2 Creating custom formats
2 Creating custom formats=Creating custom formats>main
3 To create a custom format=To create a custom format>proc4
3 To apply a custom format=To apply a custom format>proc4
3 To edit a custom format=To edit a custom format>proc4
3 To set a condition for a custom format=To set a condition for a custom format>proc4
3 To delete a format statement=To delete a format statement>proc4
2 Creating a bar format
2 Creating a bar format=Creating a bar format>main
3 To apply a bar format to numeric values=To apply a bar format to numeric values>proc4
3 To change the color of a bar format=To change the color of a bar format>proc4
3 To change the range limit of a bar format=To change the range limit of a bar format>proc4
2 Working with page breaks
2 Working with page breaks=Working with page breaks>main
3 To view page breaks=To view page breaks>proc4
3 To find page breaks=To find page breaks>proc4
3 To insert hard page breaks=To insert hard page breaks>proc4
3 To convert soft page breaks to hard page breaks=To convert soft page breaks to hard page breaks>proc4
3 To convert hard page breaks to soft page breaks=To convert hard page breaks to soft page breaks>proc4
3 To delete hard page breaks=To delete hard page breaks>proc4
2 Creating headers and footers
2 Creating headers and footers=Creating headers and footers>main
3 To add a header or footer=To add a header or footer>proc4
3 To link the contents of a cell to a header or footer=To link the contents of a cell to a header or footer>proc4
3 To adjust the space above or below a header or footer=To adjust the space above or below a header or footer>proc4
3 To edit a header or footer=To edit a header or footer>proc4
3 To edit the font and font attributes in a header or footer=To edit the font and font attributes in a header or footer>proc4
2 Customizing margins
2 Customizing margins=Customizing margins>main
3 To display all margins on a page=To display all margins on a page>proc4
3 To change margin settings=To change margin settings>proc4
2 Working with styles
2 Working with styles=Working with styles>main
3 To define a new style=To define a new style>proc4
3 To apply a predefined style=To apply a predefined style>proc4
3 To copy a style to another notebook=To copy a style to another notebook>proc4
3 To copy style settings from a cell or style=To copy style settings from a cell or style>proc4
2 Reference: Editing and formatting a spreadsheet
2 Reference: Editing and formatting a spreadsheet=Reference Editing and formatting a spreadsheet>main
3 Styles available in Quattro Pro=Styles available in Quattro Pro>proc4
3 Numeric format codes=Numeric format codes>proc4
3 Date format codes=Date format codes>proc4
3 Time format codes=Time format codes>proc4
3 Header and footer codes=Header and footer codes>proc4
1 Organizing and manipulating data
1 Organizing and manipulating data=Organizing and manipulating data>main
2 Sorting data
2 Sorting data=Sorting data>main
3 To sort data=To sort data>proc4
3 To sort data automatically=To sort data automatically>proc4
3 To reuse previous sort settings=To reuse previous sort settings>proc4
3 To preserve the original sort order=To preserve the original sort order>proc4
2 Filtering data
2 Filtering data=Filtering data>main
3 To filter data=To filter data>proc4
3 To apply the Custom filter=To apply the Custom filter>proc4
3 To undo a filter=To undo a filter>proc4
3 To remove the QuickFilter button=To remove the QuickFilter button>proc4
3 To apply the Top 10 filter=To apply the Top 10 filter>proc4
2 Consolidating data
2 Consolidating data=Consolidating data>main
3 To perform consolidations=To perform consolidations>proc4
3 To edit a consolidation setting=To edit a consolidation setting>proc4
3 To add source cells=To add source cells>proc4
3 To remove source cells=To remove source cells>proc4
3 To reuse a consolidation setting=To reuse a consolidation setting>proc4
3 To delete a consolidation setting=To delete a consolidation setting>proc4
2 Working with outlines
2 Working with outlines=Working with outlines>main
3 To create an outline automatically=To create an outline automatically>proc4
3 To create a group outline manually =To create a group outline manually >proc4
3 To position outline summary cells=To position outline summary cells>proc4
3 To separate outline cells=To separate outline cells>proc4
3 To remove all outline groups from the current sheet=To remove all outline groups from the current sheet>proc4
3 To expand or collapse an outline group=To expand or collapse an outline group>proc4
3 To subtotal an outline group=To subtotal an outline group>proc4
1 Analyzing data
1 Analyzing data=Analyzing data>main
2 Using statistical analysis tools
2 Using statistical analysis tools=Using statistical analysis tools>main
3 To use an analysis tool=To use an analysis tool>proc4
2 Creating frequency distribution tables
2 Creating frequency distribution tables=Creating frequency distribution tables>main
3 To create a frequency distribution table=To create a frequency distribution table>proc4
2 Performing regression analysis
2 Performing regression analysis=Performing regression analysis>main
3 To perform regression analysis=To perform regression analysis>proc4
2 Performing matrix operations
2 Performing matrix operations=Performing matrix operations>main
3 To multiply two matrices=To multiply two matrices>proc4
3 To invert a matrix=To invert a matrix>proc4
2 Creating scenarios
2 Creating scenarios=Creating scenarios>main
3 To create a scenario=To create a scenario>proc4
3 To create a scenario group=To create a scenario group>proc4
3 To display a scenario=To display a scenario>proc4
2 Managing scenarios
2 Managing scenarios=Managing scenarios>main
3 To save scenario edits=To save scenario edits>proc4
3 To rename a scenario group=To rename a scenario group>proc4
3 To highlight cells=To highlight cells>proc4
3 To delete scenarios=To delete scenarios>proc4
3 To delete a scenario group=To delete a scenario group>proc4
2 Creating one-variable What-If tables
2 Creating one-variable What-If tables=Creating onevariable WhatIf tables>main
3 To create a one-variable What-If table=To create a onevariable WhatIf table>proc4
3 To use a one-variable table with a notebook database=To use a onevariable table with a notebook database>proc4
2 Creating two-variable What-If tables
2 Creating two-variable What-If tables=Creating twovariable WhatIf tables>main
3 To create a two-variable What-If table=To create a twovariable WhatIf table>proc4
3 To use a two-variable table with a notebook database=To use a twovariable table with a notebook database>proc4
2 Using goal seeking
2 Using goal seeking=Using goal seeking>main
3 To perform goal seeking=To perform goal seeking>proc4
2 Finding optimum solutions for linear and nonlinear problems
2 Finding optimum solutions for linear and nonlinear problems=Finding optimum solutions for linear and nonlinear problems>main
3 To solve a problem=To solve a problem>proc4
3 To specify the Optimizer options=To specify the Optimizer options>proc4
3 To add an Optimizer constraint=To add an Optimizer constraint>proc4
3 To save an Optimizer model=To save an Optimizer model>proc4
3 To reuse an Optimizer model=To reuse an Optimizer model>proc4
3 To produce an Optimizer report=To produce an Optimizer report>proc4
2 Reference: Analyzing data
2 Reference: Analyzing data=Reference Analyzing data>main
3 Interpreting an amortization table=Interpreting an amortization table>proc4
3 Interpreting a mortgage refinancing table=Interpreting a mortgage refinancing table>proc4
3 Understanding regression output cells=Understanding regression output cells>proc4
3 Specifying the Optimizer tool options=Specifying the Optimizer tool options>proc4
1 Summarizing data using CrossTab reports
1 Summarizing data using CrossTab reports=Summarizing data using CrossTab reports>main
2 Creating CrossTab reports
2 Creating CrossTab reports=Creating CrossTab reports>main
3 To build a CrossTab report=To build a CrossTab report>proc4
3 To connect multiple spreadsheets to produce a CrossTab report=To connect multiple spreadsheets to produce a CrossTab report>proc4
2 Creating CrossTab reports using OLAP data sources
2 Creating CrossTab reports using OLAP data sources=Creating CrossTab reports using OLAP data sources>main
3 To select an OLAP data source for a CrossTab report=To select an OLAP data source for a CrossTab report>proc4
3 To import OLAP CrossTab reports=To import OLAP CrossTab reports>proc4
2 Naming CrossTab reports
2 Naming CrossTab reports=Naming CrossTab reports>main
3 To name a CrossTab report=To name a CrossTab report>proc4
2 Formatting CrossTab reports
2 Formatting CrossTab reports=Formatting CrossTab reports>main
3 To align data fields in a CrossTab report=To align data fields in a CrossTab report>proc4
3 To show column summaries in a CrossTab report=To show column summaries in a CrossTab report>proc4
3 To customize the appearance of a CrossTab report=To customize the appearance of a CrossTab report>proc4
2 Updating and refreshing CrossTab report data
2 Updating and refreshing CrossTab report data=Updating and refreshing CrossTab report data>main
3 To update CrossTab report data=To update CrossTab report data>proc4
3 To refresh a CrossTab report=To refresh a CrossTab report>proc4
2 Sorting and filtering CrossTab report data
2 Sorting and filtering CrossTab report data=Sorting and filtering CrossTab report data>main
3 To sort CrossTab report data=To sort CrossTab report data>proc4
3 To filter CrossTab report data=To filter CrossTab report data>proc4
2 Moving and deleting CrossTab reports
2 Moving and deleting CrossTab reports=Moving and deleting CrossTab reports>main
3 To move a CrossTab report=To move a CrossTab report>proc4
3 To delete a CrossTab report=To delete a CrossTab report>proc4
2 Customizing CrossTab report fields
2 Customizing CrossTab report fields=Customizing CrossTab report fields>main
3 To change a field name in a CrossTab report=To change a field name in a CrossTab report>proc4
3 To change the position of a field in a CrossTab report=To change the position of a field in a CrossTab report>proc4
2 Hiding field items and details
2 Hiding field items and details=Hiding field items and details>main
3 To hide field items in a CrossTab report=To hide field items in a CrossTab report>proc4
3 To hide the details of a CrossTab report field=To hide the details of a CrossTab report field>proc4
3 To show the details of a CrossTab report field=To show the details of a CrossTab report field>proc4
2 Calculating field summaries in CrossTab reports
2 Calculating field summaries in CrossTab reports=Calculating field summaries in CrossTab reports>main
3 To calculate a field summary in a CrossTab report=To calculate a field summary in a CrossTab report>proc4
2 Performing field data comparisons in CrossTab reports
2 Performing field data comparisons in CrossTab reports=Performing field data comparisons in CrossTab reports>main
3 To compare field data in CrossTab reports=To compare field data in CrossTab reports>proc4
2 Expanding, filtering, and removing OLAP CrossTab report field elements
2 Expanding, filtering, and removing OLAP CrossTab report field elements=Expanding filtering and removing OLAP CrossTab report field elements>main
3 To expand an OLAP CrossTab report field element=To expand an OLAP CrossTab report field element>proc4
3 To collapse OLAP CrossTab report field elements=To collapse OLAP CrossTab report field elements>proc4
3 To filter OLAP CrossTab report field elements=To filter OLAP CrossTab report field elements>proc4
3 To remove an OLAP CrossTab report element=To remove an OLAP CrossTab report element>proc4
2 Making static copies of CrossTab reports
2 Making static copies of CrossTab reports=Making static copies of CrossTab reports>main
3 To make a static copy of a CrossTab report=To make a static copy of a CrossTab report>proc4
2 Expanding CrossTab reports
2 Expanding CrossTab reports=Expanding CrossTab reports>main
3 To expand a CrossTab report=To expand a CrossTab report>proc4
1 Using databases
1 Using databases=Using databases>main
2 Creating notebook databases
2 Creating notebook databases=Creating notebook databases>main
3 To create a notebook database=To create a notebook database>proc4
3 To add a notebook database record=To add a notebook database record>proc4
3 To navigate in a notebook database=To navigate in a notebook database>proc4
3 To search for a record in a notebook database=To search for a record in a notebook database>proc4
3 To edit a notebook database record=To edit a notebook database record>proc4
3 To delete a notebook database record=To delete a notebook database record>proc4
2 Preparing notebook database search queries
2 Preparing notebook database search queries=Preparing notebook database search queries>main
3 To create a criteria table for a notebook database=To create a criteria table for a notebook database>proc4
3 To set up an AND query in a criteria table=To set up an AND query in a criteria table>proc4
3 To set up an OR query in a criteria table=To set up an OR query in a criteria table>proc4
3 To set up an AND and OR query in a criteria table=To set up an AND and OR query in a criteria table>proc4
3 To set up a search formula in a criteria table=To set up a search formula in a criteria table>proc4
3 To set up wildcards in a criteria table=To set up wildcards in a criteria table>proc4
3 To create search output cells for a notebook database=To create search output cells for a notebook database>proc4
2 Querying notebook databases
2 Querying notebook databases=Querying notebook databases>main
3 To highlight specific records in a notebook database=To highlight specific records in a notebook database>proc4
3 To copy notebook database records to output cells=To copy notebook database records to output cells>proc4
3 To delete specific records from a notebook database=To delete specific records from a notebook database>proc4
2 Querying external databases
2 Querying external databases=Querying external databases>main
3 To query external databases=To query external databases>proc4
3 To use Query By Example=To use Query By Example>proc4
3 To assign aliases for private and working directories=To assign aliases for private and working directories>proc4
2 Importing data from external databases
2 Importing data from external databases=Importing data from external databases>main
3 To insert an external database into Quattro Pro=To insert an external database into Quattro Pro>proc4
3 To link to an external database table=To link to an external database table>proc4
3 To import an external database table=To import an external database table>proc4
3 To set import options for external database tables=To set import options for external database tables>proc4
3 To join external database tables=To join external database tables>proc4
3 To filter an external database table=To filter an external database table>proc4
3 To open a password-protected table=To open a passwordprotected table>proc4
2 Reference: Using databases
2 Reference: Using databases=Reference Using databases>main
3 Rules for entering database cells in Quattro Pro=Rules for entering database cells in Quattro Pro>proc4
3 Example of a notebook database query=Example of a notebook database query>proc4
3 Operators and symbols available in a search formula=Operators and symbols available in a search formula>proc4
3 Wildcards available in a criteria table=Wildcards available in a criteria table>proc4
1 Adding charts to spreadsheets
2 Presenting spreadsheet data in a chart
2 Presenting spreadsheet data in a chart=Presenting spreadsheet data in a chart>main
3 Creating charts
3 Creating charts=Creating charts>main
4 To create a chart automatically=To create a chart automatically>proc4
4 To create a chart by using the Chart Expert=To create a chart by using the Chart Expert>proc4
3 Adding titles to charts
3 Adding titles to charts=Adding titles to charts>main
4 To add a title=To add a title>proc4
3 Adding linked data to charts
3 Adding linked data to charts=Adding linked data to charts>main
4 To add linked data to a chart=To add linked data to a chart>proc4
3 Reference: Presenting spreadsheet data in a chart
3 Reference: Presenting spreadsheet data in a chart=Reference Presenting spreadsheet data in a chart>main
4 Plotting chart data=Plotting chart data>proc4
4 Setting up chart axes=Setting up chart axes>proc4
4 Area charts=Area charts>proc4
4 Bar charts=Bar charts>proc4
4 Bubble charts=Bubble charts>proc4
4 Gantt charts=Gantt charts>proc4
4 High/Low charts=HighLow charts>proc4
4 Histograms=Histograms>proc4
4 Line charts=Line charts>proc4
4 Mixed charts=Mixed charts>proc4
4 Pie charts=Pie charts>proc4
4 Radar charts=Radar charts>proc4
4 Scatter charts=Scatter charts>proc4
4 Surface charts=Surface charts>proc4
2 Working with chart series
2 Working with chart series=Working with chart series>main
3 Changing chart data
3 Changing chart data=Changing chart data>main
4 To add a series=To add a series>proc4
4 To remove a series=To remove a series>proc4
4 To change the data range of a series=To change the data range of a series>proc4
4 To change the data range of a series in an XY or XYX chart=To change the data range of a series in an XY or XYX chart>proc4
4 To change the data range of a series in a bubble chart=To change the data range of a series in a bubble chart>proc4
4 To change the data range of a series in a High\Low chart=To change the data range of a series in a HighLow chart>proc4
3 Changing chart data order
3 Changing chart data order=Changing chart data order>main
4 To plot chart series by row or column=To plot chart series by row or column>proc4
4 To reverse the order of the chart series=To reverse the order of the chart series>proc4
3 Plotting a series on a secondary y-axis
3 Plotting a series on a secondary y-axis=Plotting a series on a secondary yaxis>main
4 To add a secondary y-axis to a chart=To add a secondary yaxis to a chart>proc4
4 To plot a series on a secondary y-axis=To plot a series on a secondary yaxis>proc4
3 Changing bar chart options
3 Changing bar chart options=Changing bar chart options>main
4 To change the riser style=To change the riser style>proc4
3 Changing line chart options
3 Changing line chart options=Changing line chart options>main
4 To display markers=To display markers>proc4
3 Changing pie chart options
3 Changing pie chart options=Changing pie chart options>main
4 To detach a pie slice=To detach a pie slice>proc4
4 To change the tilt of a pie chart=To change the tilt of a pie chart>proc4
4 To change the linked slice in a pie of a pie chart=To change the linked slice in a pie of a pie chart>proc4
3 Changing high/low chart options
3 Changing high/low chart options=Changing highlow chart options>main
4 To change the high/low series type=To change the highlow series type>proc4
3 Changing series fill and border style
3 Changing series fill and border style=Changing series fill and border style>main
4 To apply a pattern fill to a chart series=To apply a pattern fill to a chart series>proc4
4 To apply a gradient fill to a chart series=To apply a gradient fill to a chart series>proc4
4 To apply a texture fill to a chart series=To apply a texture fill to a chart series>proc4
4 To apply a picture fill to a chart series=To apply a picture fill to a chart series>proc4
4 To modify the gradient fill properties of a chart series=To modify the gradient fill properties of a chart series>proc4
4 To modify the picture fill properties of a chart series=To modify the picture fill properties of a chart series>proc4
4 To modify the chart series border style=To modify the chart series border style>proc4
3 Changing the fill and border style of data points
3 Changing the fill and border style of data points=Changing the fill and border style of data points>main
4 To apply a pattern fill to a data point=To apply a pattern fill to a data point>proc4
4 To apply a gradient fill to a data point=To apply a gradient fill to a data point>proc4
4 To apply a texture fill to a data point=To apply a texture fill to a data point>proc4
4 To apply a picture fill to a data point=To apply a picture fill to a data point>proc4
4 To modify the gradient fill properties of a data point=To modify the gradient fill properties of a data point>proc4
4 To modify the picture fill properties of a data point=To modify the picture fill properties of a data point>proc4
4 To change the data point border style=To change the data point border style>proc4
3 Replacing chart series with riser models
3 Replacing chart series with riser models=Replacing chart series with riser models>main
4 To replace a series with a model=To replace a series with a model>proc4
3 Applying transparency and glow to a chart series
3 Applying transparency and glow to a chart series=Applying transparency and glow to a chart series>main
4 To make a series transparent=To make a series transparent>proc4
4 To add a glow to a series=To add a glow to a series>proc4
4 To specify the position of the glow=To specify the position of the glow>proc4
3 Displaying data labels
3 Displaying data labels=Displaying data labels>main
4 To display data labels=To display data labels>proc4
4 To display data labels for a pie chart=To display data labels for a pie chart>proc4
4 To specify the source of the data labels=To specify the source of the data labels>proc4
4 To specify the position of the data labels=To specify the position of the data labels>proc4
2 Working with chart text
2 Working with chart text=Working with chart text>main
3 Selecting text
3 Selecting text=Selecting text>main
4 To select text=To select text>proc4
4 To select text items in the Text properties dialog box=To select text items in the Text properties dialog box>proc4
3 Changing font appearance
3 Changing font appearance=Changing font appearance>main
4 To change the chart font=To change the chart font>proc4
4 To change the font size=To change the font size>proc4
4 To make text superscript or subscript=To make text superscript or subscript>proc4
4 To add a shadow to text=To add a shadow to text>proc4
3 Applying fills to text
3 Applying fills to text=Applying fills to text>main
4 To apply a pattern fill to text=To apply a pattern fill to text>proc4
4 To apply a gradient fill to text=To apply a gradient fill to text>proc4
4 To apply a texture fill to text=To apply a texture fill to text>proc4
4 To apply a picture fill to text=To apply a picture fill to text>proc4
4 To modify the gradient fill properties of text=To modify the gradient fill properties of text>proc4
4 To modify the picture fill properties of text=To modify the picture fill properties of text>proc4
3 Positioning, rotating, and moving text
3 Positioning, rotating, and moving text=Positioning rotating and moving text>main
4 To align chart text within a text box=To align chart text within a text box>proc4
4 To change text orientation=To change text orientation>proc4
4 To rotate chart text=To rotate chart text>proc4
4 To move chart text=To move chart text>proc4
3 Adding boxes to text
3 Adding boxes to text=Adding boxes to text>main
4 To add a box to text=To add a box to text>proc4
4 To add a border to a text box=To add a border to a text box>proc4
4 To add a shadow to a text box=To add a shadow to a text box>proc4
3 Adding fills to text boxes
3 Adding fills to text boxes=Adding fills to text boxes>main
4 To apply a pattern fill to a text box=To apply a pattern fill to a text box>proc4
4 To apply a gradient fill to a text box=To apply a gradient fill to a text box>proc4
4 To apply a texture fill to a text box=To apply a texture fill to a text box>proc4
4 To apply a picture fill=To apply a picture fill>proc4
4 To modify the gradient fill properties of a text box=To modify the gradient fill properties of a text box>proc4
4 To modify the picture fill properties of a text box=To modify the picture fill properties of a text box>proc4
3 Setting the numeric format for chart text
3 Setting the numeric format for chart text=Setting the numeric format for chart text>main
4 To set the numeric format for chart text=To set the numeric format for chart text>proc4
3 Editing chart text
3 Editing chart text=Editing chart text>main
4 To edit chart text=To edit chart text>proc4
2 Formatting the x and y axes
2 Formatting the x and y axes=Formatting the x and y axes>main
3 Displaying and positioning axes labels
3 Displaying and positioning axes labels=Displaying and positioning axes labels>main
4 To display axis labels=To display axis labels>proc4
4 To hide axis labels=To hide axis labels>proc4
4 To specify the position of x-axis labels=To specify the position of xaxis labels>proc4
4 To specify the position of y-axis labels=To specify the position of yaxis labels>proc4
4 To position x-axis labels on multiple rows=To position xaxis labels on multiple rows>proc4
4 To skip x-axis labels=To skip xaxis labels>proc4
3 Displaying and formatting gridlines
3 Displaying and formatting gridlines=Displaying and formatting gridlines>main
4 To display a major gridline=To display a major gridline>proc4
4 To display a minor gridline=To display a minor gridline>proc4
4 To display a 3-D chart gridline=To display a 3D chart gridline>proc4
4 To change the major gridline color=To change the major gridline color>proc4
4 To change the minor gridline color=To change the minor gridline color>proc4
4 To change the gridline border style=To change the gridline border style>proc4
3 Specifying scale properties
3 Specifying scale properties=Specifying scale properties>main
4 To specify the scale type=To specify the scale type>proc4
4 To specify the scale values=To specify the scale values>proc4
4 To restore the default scale values=To restore the default scale values>proc4
2 Working with 3-D charts
2 Working with 3-D charts=Working with 3D charts>main
3 Changing the viewing angle of 3-D charts
3 Changing the viewing angle of 3-D charts=Changing the viewing angle of 3D charts>main
4 To apply a preset viewing angle to a 3-D chart=To apply a preset viewing angle to a 3D chart>proc4
4 To rotate a 3-D chart=To rotate a 3D chart>proc4
4 To pan a 3-D chart=To pan a 3D chart>proc4
4 To move a 3-D chart=To move a 3D chart>proc4
4 To change the length of a 3-D chart wall=To change the length of a 3D chart wall>proc4
4 To change the thickness of a 3-D chart wall=To change the thickness of a 3D chart wall>proc4
3 Managing viewing angles
3 Managing viewing angles=Managing viewing angles>main
4 To save a viewing angle=To save a viewing angle>proc4
4 To rename a viewing angle=To rename a viewing angle>proc4
4 To delete a viewing angle=To delete a viewing angle>proc4
3 Changing the fill and border of 3-D chart walls
3 Changing the fill and border of 3-D chart walls=Changing the fill and border of 3D chart walls>main
4 To apply a pattern fill to a 3-D chart wall=To apply a pattern fill to a 3D chart wall>proc4
4 To apply a gradient fill to a 3-D chart wall=To apply a gradient fill to a 3D chart wall>proc4
4 To apply a texture fill to a 3-D chart wall=To apply a texture fill to a 3D chart wall>proc4
4 To apply a picture fill to a 3-D chart wall=To apply a picture fill to a 3D chart wall>proc4
4 To modify the gradient fill properties of a 3-D chart wall=To modify the gradient fill properties of a 3D chart wall>proc4
4 To modify the picture fill properties of a 3-D chart wall=To modify the picture fill properties of a 3D chart wall>proc4
2 Editing charts
2 Editing charts=Editing charts>main
3 Selecting chart items
3 Selecting chart items=Selecting chart items>main
4 To select chart items=To select chart items>proc4
3 Changing chart types
3 Changing chart types=Changing chart types>main
4 To change the chart type=To change the chart type>proc4
4 To specify the default chart=To specify the default chart>proc4
3 Changing legend labels and position
3 Changing legend labels and position=Changing legend labels and position>main
4 To add legend and x-axis labels to a series=To add legend and xaxis labels to a series>proc4
4 To change the position of a legend=To change the position of a legend>proc4
3 Changing legend boxes and borders
3 Changing legend boxes and borders=Changing legend boxes and borders>main
4 To change a legend box=To change a legend box>proc4
4 To change a legend border=To change a legend border>proc4
4 To add a shadow to a legend box=To add a shadow to a legend box>proc4
3 Applying fills to legend boxes
3 Applying fills to legend boxes=Applying fills to legend boxes>main
4 To apply a pattern fill to a legend box=To apply a pattern fill to a legend box>proc4
4 To apply a gradient fill to a legend box=To apply a gradient fill to a legend box>proc4
4 To apply a texture fill to a legend box=To apply a texture fill to a legend box>proc4
4 To apply a picture fill to a legend box=To apply a picture fill to a legend box>proc4
4 To modify the gradient fill properties of a legend box=To modify the gradient fill properties of a legend box>proc4
4 To edit the picture fill properties of a legend box=To edit the picture fill properties of a legend box>proc4
3 Changing the fill and border of chart frames
3 Changing the fill and border of chart frames=Changing the fill and border of chart frames>main
4 To apply a pattern fill to a chart frame=To apply a pattern fill to a chart frame>proc4
4 To apply a gradient fill to a chart frame=To apply a gradient fill to a chart frame>proc4
4 To apply a texture fill to a chart frame=To apply a texture fill to a chart frame>proc4
4 To apply a picture fill to a chart frame=To apply a picture fill to a chart frame>proc4
4 To modify the gradient fill properties of a chart frame=To modify the gradient fill properties of a chart frame>proc4
4 To modify the picture fill properties of a chart frame=To modify the picture fill properties of a chart frame>proc4
4 To change the border of the chart frame=To change the border of the chart frame>proc4
3 Changing the background fill
3 Changing the background fill=Changing the background fill>main
4 To apply a pattern fill to a chart background=To apply a pattern fill to a chart background>proc4
4 To apply a gradient fill to a chart background=To apply a gradient fill to a chart background>proc4
4 To apply a texture fill to a chart background=To apply a texture fill to a chart background>proc4
4 To apply a picture fill to a chart background=To apply a picture fill to a chart background>proc4
4 To modify the gradient fill properties of a chart background=To modify the gradient fill properties of a chart background>proc4
4 To modify the picture fill properties of a chart background=To modify the picture fill properties of a chart background>proc4
3 Applying advanced rendering to charts
3 Applying advanced rendering to charts=Applying advanced rendering to charts>main
4 To apply advanced rendering to a chart=To apply advanced rendering to a chart>proc4
4 To remove advanced rendering from a chart=To remove advanced rendering from a chart>proc4
3 Changing chart lighting
3 Changing chart lighting=Changing chart lighting>main
4 To apply a preset light combination=To apply a preset light combination>proc4
4 To choose a light color=To choose a light color>proc4
4 To adjust the light angle=To adjust the light angle>proc4
4 To adjust the light properties=To adjust the light properties>proc4
3 Moving, resizing, and deleting charts
3 Moving, resizing, and deleting charts=Moving resizing and deleting charts>main
4 To move a chart=To move a chart>proc4
4 To resize a chart=To resize a chart>proc4
4 To delete a chart=To delete a chart>proc4
3 Saving and retrieving chart templates
3 Saving and retrieving chart templates=Saving and retrieving chart templates>main
4 To save a chart template=To save a chart template>proc4
4 To retrieve a chart template=To retrieve a chart template>proc4
2 Analyzing chart data
2 Analyzing chart data=Analyzing chart data>main
3 Plotting trendlines
3 Plotting trendlines=Plotting trendlines>main
4 To plot a trendline=To plot a trendline>proc4
4 To specify trendline display options=To specify trendline display options>proc4
3 Plotting error bars
3 Plotting error bars=Plotting error bars>main
4 To plot Y-direction error bars=To plot Ydirection error bars>proc4
4 To plot X-direction error bars=To plot Xdirection error bars>proc4
4 To delete Y-direction error bars=To delete Ydirection error bars>proc4
4 To delete X-direction error bars=To delete Xdirection error bars>proc4
3 Reference: Analyzing chart data
3 Reference: Analyzing chart data=Reference Analyzing chart data>main
4 Moving average=Moving average>proc4
4 Aggregation=Aggregation>proc4
4 Linear fit=Linear fit>proc4
4 Exponential fit=Exponential fit>proc4
4 Standard deviation=Standard deviation>proc4
4 Common log fit=Common log fit>proc4
4 Natural log fit=Natural log fit>proc4
4 Polynomial=Polynomial>proc4
4 Calculating error amounts=Calculating error amounts>proc4
1 Adding graphics to spreadsheets
1 Adding graphics to spreadsheets=Adding graphics to spreadsheets>main
2 Drawing shapes and lines
2 Drawing shapes and lines=Drawing shapes and lines>main
3 To display the Drawing tools toolbar=To display the Drawing tools toolbar>proc4
3 To draw a line=To draw a line>proc4
3 To draw a polyline or polycurve=To draw a polyline or polycurve>proc4
3 To draw a shape=To draw a shape>proc4
2 Creating text box graphics
2 Creating text box graphics=Creating text box graphics>main
3 To create a text box=To create a text box>proc4
3 To link a label cell to a text box=To link a label cell to a text box>proc4
3 To add bullets to a text box=To add bullets to a text box>proc4
3 To customize a text box border or box type=To customize a text box border or box type>proc4
3 To convert text in a text box to 3-D=To convert text in a text box to 3D>proc4
3 To create a text box with a transparent box border=To create a text box with a transparent box border>proc4
2 Arranging graphics
2 Arranging graphics=Arranging graphics>main
3 To select multiple graphics=To select multiple graphics>proc4
3 To move a graphic=To move a graphic>proc4
3 To move or size a text box=To move or size a text box>proc4
3 To group graphics=To group graphics>proc4
3 To align multiple graphics=To align multiple graphics>proc4
3 To position multiple graphics=To position multiple graphics>proc4
3 To adjust spacing between multiple graphics=To adjust spacing between multiple graphics>proc4
3 To arrange graphic layers=To arrange graphic layers>proc4
2 Viewing graphics
2 Viewing graphics=Viewing graphics>main
3 To change the aspect ratio of a graphic in a floating graphics window=To change the aspect ratio of a graphic in a floating graphics window>proc4
3 To view a graphic in an enlarged floating graphics window=To view a graphic in an enlarged floating graphics window>proc4
3 To display a full-screen view of a floating graphics window=To display a fullscreen view of a floating graphics window>proc4
2 Managing and sharing graphics
2 Managing and sharing graphics=Managing and sharing graphics>main
3 To delete a shape or line on a spreadsheet=To delete a shape or line on a spreadsheet>proc4
3 To delete a floating graphic window=To delete a floating graphic window>proc4
3 To export a floating graphics window to file.=To export a floating graphics window to file>proc4
3 To import graphics in other formats=To import graphics in other formats>proc4
3 To add an Internet graphic to a spreadsheet=To add an Internet graphic to a spreadsheet>proc4
3 To paste a Quattro Pro image into Microsoft Paint=To paste a Quattro Pro image into Microsoft Paint>proc4
2 Changing the properties of a shape
2 Changing the properties of a shape=Changing the properties of a shape>main
3 To change the border style of a shape=To change the border style of a shape>proc4
3 To add a shadow to the border of a shape=To add a shadow to the border of a shape>proc4
3 To fill a shape=To fill a shape>proc4
3 To modify texture settings of a texture-filled shape=To modify texture settings of a texturefilled shape>proc4
3 To modify the picture settings of a bitmap image in a shape=To modify the picture settings of a bitmap image in a shape>proc4
3 To make a shape transparent=To make a shape transparent>proc4
2 Working in the draw picture window
2 Working in the draw picture window=Working in the draw picture window>main
3 To open the draw picture window=To open the draw picture window>proc4
3 To align or center graphics in the draw picture window=To align or center graphics in the draw picture window>proc4
3 To space graphics in the draw picture window=To space graphics in the draw picture window>proc4
:include scrpbken.cnt
:include wpta11en.cnt
1 Adding maps to spreadsheets
1 Adding maps to spreadsheets=Adding maps to spreadsheets>main
2 Creating and positioning maps
2 Creating and positioning maps=Creating and positioning maps>main
3 To copy data from a datamap file to a new notebook=To copy data from a datamap file to a new notebook>proc4
3 To create a map=To create a map>proc4
3 To move a map=To move a map>proc4
3 To resize a map=To resize a map>proc4
3 To change the aspect ratio of a map=To change the aspect ratio of a map>proc4
3 To zoom in on a map=To zoom in on a map>proc4
2 Presenting data on maps
2 Presenting data on maps=Presenting data on maps>main
3 To add color and pattern data to a map=To add color and pattern data to a map>proc4
3 To add a region overlay to a map=To add a region overlay to a map>proc4
3 To include another region on a map=To include another region on a map>proc4
3 To add a static overlay to a map=To add a static overlay to a map>proc4
3 To add a location to a map using a pin overlay=To add a location to a map using a pin overlay>proc4
3 To add a location to a map using longitude and latitude=To add a location to a map using longitude and latitude>proc4
3 To change the appearance of pin labels on a map=To change the appearance of pin labels on a map>proc4
3 To change the appearance of pin symbols on a map=To change the appearance of pin symbols on a map>proc4
2 Editing maps
2 Editing maps=Editing maps>main
3 To edit a map=To edit a map>proc4
3 To redraw a map=To redraw a map>proc4
3 To change the border of a map=To change the border of a map>proc4
3 To change the background of a map=To change the background of a map>proc4
3 To make a map background transparent=To make a map background transparent>proc4
3 To edit a map title=To edit a map title>proc4
3 To change text properties for a map title=To change text properties for a map title>proc4
3 To change the alignment of map titles=To change the alignment of map titles>proc4
2 Customizing map legends
2 Customizing map legends=Customizing map legends>main
3 To add a title to a map legend=To add a title to a map legend>proc4
3 To add text to a map legend=To add text to a map legend>proc4
3 To edit colors or patterns in a map legend=To edit colors or patterns in a map legend>proc4
3 To change the position of a map legend=To change the position of a map legend>proc4
2 Reference: Adding maps to spreadsheets
2 Reference: Adding maps to spreadsheets=Reference Adding maps to spreadsheets>main
3 Example: Setting up map data=Example Setting up map data>proc4
1 Printing
1 Printing=Printing>main
2 Previewing a print job
2 Previewing a print job=Previewing a print job>main
3 To preview a print job=To preview a print job>proc4
3 To increase or decrease the zoom level while previewing a print job=To increase or decrease the zoom level while previewing a print job>proc4
2 Setting up a printer
2 Setting up a printer=Setting up a printer>main
3 To specify a printer for Quattro Pro=To specify a printer for Quattro Pro>proc4
3 To add a printer=To add a printer>proc4
2 Printing the active spreadsheet or notebook
2 Printing the active spreadsheet or notebook=Printing the active spreadsheet or notebook>main
3 To print the active spreadsheet or a notebook=To print the active spreadsheet or a notebook>proc4
3 To cancel a print job=To cancel a print job>proc4
3 To print grid lines or cell formulas=To print grid lines or cell formulas>proc4
3 To print cell comments=To print cell comments>proc4
2 Printing data
2 Printing data=Printing data>main
3 To print data without soft page breaks=To print data without soft page breaks>proc4
3 To print data on a set number of pages=To print data on a set number of pages>proc4
2 Printing charts and maps
2 Printing charts and maps=Printing charts and maps>main
3 To print a graphic=To print a graphic>proc4
3 To print a chart or map=To print a chart or map>proc4
3 To print all charts or maps=To print all charts or maps>proc4
3 To save time when printing graphics=To save time when printing graphics>proc4
2 Printing selected print areas
2 Printing selected print areas=Printing selected print areas>main
3 To print contiguous blocks of cells=To print contiguous blocks of cells>proc4
3 To print noncontiguous blocks of cells=To print noncontiguous blocks of cells>proc4
3 To print 3-D selections of cells=To print 3D selections of cells>proc4
3 To change the cell selection=To change the cell selection>proc4
3 To print certain pages of the active spreadsheet=To print certain pages of the active spreadsheet>proc4
2 Printing to a file
2 Printing to a file=Printing to a file>main
3 To print to a file=To print to a file>proc4
3 To print to a selected printer=To print to a selected printer>proc4
2 Printing headers and footers
2 Printing headers and footers=Printing headers and footers>main
3 To print a header or footer=To print a header or footer>proc4
3 To hide a header or footer=To hide a header or footer>proc4
2 Printing headings
2 Printing headings=Printing headings>main
3 To print row titles as the top heading on each even-numbered page=To print row titles as the top heading on each evennumbered page>proc4
3 To print column titles as the left heading on each page=To print column titles as the left heading on each page>proc4
3 To print top column letters and left row numbers as headings=To print top column letters and left row numbers as headings>proc4
2 Customizing print settings
2 Customizing print settings=Customizing print settings>main
3 To change paper size=To change paper size>proc4
3 To change paper orientation=To change paper orientation>proc4
3 To center print selections between left and right margins=To center print selections between left and right margins>proc4
3 To shrink the width and height of a print selection=To shrink the width and height of a print selection>proc4
3 To shrink or enlarge a print selection=To shrink or enlarge a print selection>proc4
3 To print in black and white=To print in black and white>proc4
2 Saving, restoring, and naming default print settings
2 Saving, restoring, and naming default print settings=Saving restoring and naming default print settings>main
3 To save changes to the default print settings=To save changes to the default print settings>proc4
3 To restore the default print settings=To restore the default print settings>proc4
3 To save the current print settings as a named setting=To save the current print settings as a named setting>proc4
3 To update or delete a named setting=To update or delete a named setting>proc4
3 To print using a named setting=To print using a named setting>proc4
2 Spacing a print job
2 Spacing a print job=Spacing a print job>main
3 To keep or collapse blank lines between cell selections=To keep or collapse blank lines between cell selections>proc4
3 To add space between each printed selection=To add space between each printed selection>proc4
3 To add space between each printed spreadsheet=To add space between each printed spreadsheet>proc4
3 To start each printed selection on a new page=To start each printed selection on a new page>proc4
3 To start each printed spreadsheet on a new page=To start each printed spreadsheet on a new page>proc4
1 Using macros
1 Using macros=Using macros>main
2 Recording and editing Quattro Pro macros
2 Recording and editing Quattro Pro macros=Recording and editing Quattro Pro macros>main
3 To record a Quattro Pro macro=To record a Quattro Pro macro>proc4
3 To pause or resume recording a Quattro Pro macro=To pause or resume recording a Quattro Pro macro>proc4
3 To type a Quattro Pro macro=To type a Quattro Pro macro>proc4
3 To add a command to a macro script=To add a command to a macro script>proc4
3 To delete a command from a macro script=To delete a command from a macro script>proc4
3 To name a Quattro Pro macro=To name a Quattro Pro macro>proc4
2 Working with macro libraries
2 Working with macro libraries=Working with macro libraries>main
3 To create a macro library=To create a macro library>proc4
3 To create a system notebook=To create a system notebook>proc4
3 To hide a system notebook=To hide a system notebook>proc4
2 Recording and editing PerfectScript macros
2 Recording and editing PerfectScript macros=Recording and editing PerfectScript macros>main
3 To record a PerfectScript macro=To record a PerfectScript macro>proc4
3 To pause or resume recording a PerfectScript macro=To pause or resume recording a PerfectScript macro>proc4
3 To type a PerfectScript macro=To type a PerfectScript macro>proc4
3 To create a .wcl file=To create a wcl file>proc4
3 To edit a PerfectScript in the PerfectScript Macro Facility=To edit a PerfectScript in the PerfectScript Macro Facility>proc4
3 To edit a PerfectScript macro in WordPerfect=To edit a PerfectScript macro in WordPerfect>proc4
2 Creating VBA macros
2 Creating VBA macros=Creating VBA macros>main
3 To start VBA from Quattro Pro=To start VBA from Quattro Pro>proc4
3 To display the VBA toolbar=To display the VBA toolbar>proc4
3 To create a VBA project macro in Quattro Pro=To create a VBA project macro in Quattro Pro>proc4
3 To copy PerfectScript to a VBA code module=To copy PerfectScript to a VBA code module>proc4
3 To copy Quattro Pro macros to a VBA code module=To copy Quattro Pro macros to a VBA code module>proc4
3 To play a VBA macro=To play a VBA macro>proc4
2 Debugging and editing a VBA macro
2 Debugging and editing a VBA macro=Debugging and editing a VBA macro>main
3 To debug a VBA macro=To debug a VBA macro>proc4
3 To edit a VBA macro=To edit a VBA macro>proc4
2 Using the PerfectScript class to change a Quattro Pro document
2 Using the PerfectScript class to change a Quattro Pro document=Using the PerfectScript class to change a Quattro Pro document>main
3 To change a Quattro Pro document using the PerfectScript class=To change a Quattro Pro document using the PerfectScript class>proc4
2 Working in Developer mode
2 Working in Developer mode=Working in Developer mode>main
3 To start Quattro Pro in Developer mode=To start Quattro Pro in Developer mode>proc4
3 To modify the title bar in Developer mode=To modify the title bar in Developer mode>proc4
3 To modify the properties of a chart or map object in Developer mode=To modify the properties of a chart or map object in Developer mode>proc4
3 To disable access to property settings in Developer mode=To disable access to property settings in Developer mode>proc4
2 Recording macros using relative and absolute cell references
2 Recording macros using relative and absolute cell references=Recording macros using relative and absolute cell references>main
3 To record a macro using relative or absolute cell references=To record a macro using relative or absolute cell references>proc4
2 Attaching macros to notebooks and buttons
2 Attaching macros to notebooks and buttons=Attaching macros to notebooks and buttons>main
3 To attach a macro to a notebook=To attach a macro to a notebook>proc4
3 To create a macro button=To create a macro button>proc4
3 To link a button to a macro=To link a button to a macro>proc4
3 To attach a macro to a keystroke=To attach a macro to a keystroke>proc4
3 To link a macro button to a dialog box=To link a macro button to a dialog box>proc4
3 To modify a macro button=To modify a macro button>proc4
3 To attach a macro to a toolbar button=To attach a macro to a toolbar button>proc4
3 To add a macro button to the toolbar area=To add a macro button to the toolbar area>proc4
2 Playing macros
2 Playing macros=Playing macros>main
3 To play a Quattro Pro macro=To play a Quattro Pro macro>proc4
3 To play a PerfectScript macro=To play a PerfectScript macro>proc4
3 To play a startup or exit macro in a notebook=To play a startup or exit macro in a notebook>proc4
3 To assign an existing macro as the startup macro=To assign an existing macro as the startup macro>proc4
3 To assign a macro to launch automatically when Quattro Pro launches=To assign a macro to launch automatically when Quattro Pro launches>proc4
3 To stop a macro while it is playing=To stop a macro while it is playing>proc4
2 Debugging Quattro Pro macros
2 Debugging Quattro Pro macros=Debugging Quattro Pro macros>main
3 To play a Quattro Pro macro in debug mode=To play a Quattro Pro macro in debug mode>proc4
3 To set a standard breakpoint in a Quattro Pro macro=To set a standard breakpoint in a Quattro Pro macro>proc4
3 To set a conditional breakpoint in a Quattro Pro macro=To set a conditional breakpoint in a Quattro Pro macro>proc4
3 To set a trace cell for a Quattro Pro macro=To set a trace cell for a Quattro Pro macro>proc4
3 To edit macro cells from the macro debugger=To edit macro cells from the macro debugger>proc4
2 Debugging PerfectScript macros
2 Debugging PerfectScript macros=Debugging PerfectScript macros>main
3 To play a PerfectScript macro in debug mode=To play a PerfectScript macro in debug mode>proc4
3 To set a breakpoint in PerfectScript macros=To set a breakpoint in PerfectScript macros>proc4
2 Customizing application settings using macros
2 Customizing application settings using macros=Customizing application settings using macros>main
3 To save and reset application defaults=To save and reset application defaults>proc4
3 To use the active selection within a macro=To use the active selection within a macro>proc4
3 To update links with macros=To update links with macros>proc4
3 To create self-modifying macros=To create selfmodifying macros>proc4
2 Reference: Using macros
2 Reference: Using macros=Reference Using macros>main
3 Additional macro resources=Additional macro resources>proc4
3 Choosing a macro creation tool=Choosing a macro creation tool>proc4
3 Comparing Quattro Pro macros with PerfectScript=Comparing Quattro Pro macros with PerfectScript>proc4
3 Syntax examples of Quattro Pro macros=Syntax examples of Quattro Pro macros>proc4
3 Understanding Quattro Pro macro syntax=Understanding Quattro Pro macro syntax>proc4
3 Understanding arguments=Understanding arguments>proc4
3 Integrating Visual Basic for Applications with WordPerfect Office=Integrating Visual Basic for Applications with WordPerfect Office>proc4
3 Setting macro breakpoints=Setting macro breakpoints>proc4
3 Example of a VBA project macro in Quattro Pro=Example of a VBA project macro in Quattro Pro>proc4
3 Example of a VBA macro that will manipulate a Quattro Pro document=Example of a VBA macro that will manipulate a Quattro Pro document>proc4
3 Example of using the PerfectScript class to change a Quattro Pro document=Example of using the PerfectScript class to change a Quattro Pro document>proc4
3 Example of accessing the system's date and time values=Example of accessing the systems date and time values>proc4
3 Absolute and relative cell addresses=Absolute and relative cell addresses>proc4
1 Using OLE automation
1 Using OLE automation=Using OLE automation>main
2 Using Quattro Pro with Lotus Notes
2 Using Quattro Pro with Lotus Notes=Using Quattro Pro with Lotus Notes>main
3 To create a field block in Quattro Pro=To create a field block in Quattro Pro>proc4
3 To create a Lotus Notes database=To create a Lotus Notes database>proc4
3 To embed a Quattro Pro notebook in Lotus Notes=To embed a Quattro Pro notebook in Lotus Notes>proc4
3 To create a Lotus Notes view for embedded Quattro Pro fields=To create a Lotus Notes view for embedded Quattro Pro fields>proc4
3 To enter data in Quattro Pro Notes/FX=To enter data in Quattro Pro NotesFX>proc4
2 Reference: Using OLE automation
2 Reference: Using OLE automation=Reference Using OLE automation>main
3 Example: Setting up Notes/FX field blocks=Example Setting up NotesFX field blocks>proc4
3 Automation terms=Automation terms>proc4
3 OLE automation syntax=OLE automation syntax>proc4
3 OLE automation object functions=OLE automation object functions>proc4
3 OLE automation and macros=OLE automation and macros>proc4
3 OLE automation expression examples=OLE automation expression examples>proc4
3 OLE automation macro examples=OLE automation macro examples>proc4
3 Macro syntax and arguments=Macro syntax and arguments>proc4
3 Macro command arguments=Macro command arguments>proc4
3 Macro subroutines=Macro subroutines>proc4
3 Command equivalents=Command equivalents>proc4
3 DDE macro commands=DDE macro commands>proc4
3 Object macro commands=Object macro commands>proc4
1 Working with form controls
1 Working with form controls=Working with form controls>main
2 Creating controls on a spreadsheet
2 Creating controls on a spreadsheet=Creating controls on a spreadsheet>main
3 To add a form control to a spreadsheet=To add a form control to a spreadsheet>proc4
3 To attach a macro to a form control=To attach a macro to a form control>proc4
3 To attach a form control to the Internet=To attach a form control to the Internet>proc4
3 To display a dialog box from a form control=To display a dialog box from a form control>proc4
2 Customizing and managing controls on a spreadsheet
2 Customizing and managing controls on a spreadsheet=Customizing and managing controls on a spreadsheet>main
3 To change the border of a form control=To change the border of a form control>proc4
3 To change the label of a form control=To change the label of a form control>proc4
3 To add a label beside a form control=To add a label beside a form control>proc4
3 To change the object name of a form control=To change the object name of a form control>proc4
3 To enable protection on a form control=To enable protection on a form control>proc4
3 To print a spreadsheet without printing a form control=To print a spreadsheet without printing a form control>proc4
1 Working with custom dialog boxes and controls
1 Working with custom dialog boxes and controls=Working with custom dialog boxes and controls>main
2 Creating custom dialog boxes
2 Creating custom dialog boxes=Creating custom dialog boxes>main
3 To create a custom dialog box=To create a custom dialog box>proc4
3 To add a control to a dialog box=To add a control to a dialog box>proc4
3 To add a label to a dialog box control=To add a label to a dialog box control>proc4
3 To hide a control on a dialog box=To hide a control on a dialog box>proc4
3 To test a dialog box=To test a dialog box>proc4
2 Editing and positioning dialog boxes
2 Editing and positioning dialog boxes=Editing and positioning dialog boxes>main
3 To edit a dialog box window=To edit a dialog box window>proc4
3 To copy a dialog box to another notebook=To copy a dialog box to another notebook>proc4
3 To disable a dialog box=To disable a dialog box>proc4
3 To delete a dialog box=To delete a dialog box>proc4
2 Adding dialog box controls
2 Adding dialog box controls=Adding dialog box controls>main
3 To add a bitmap button to a dialog box=To add a bitmap button to a dialog box>proc4
3 To add a push button to a dialog box=To add a push button to a dialog box>proc4
3 To add a check box to a dialog box=To add a check box to a dialog box>proc4
3 To add a color control to a dialog box=To add a color control to a dialog box>proc4
3 To add a combo box to a dialog box=To add a combo box to a dialog box>proc4
3 To add a label control to a dialog box=To add a label control to a dialog box>proc4
3 To add an edit box to a dialog box=To add an edit box to a dialog box>proc4
3 To add a file control to a dialog box=To add a file control to a dialog box>proc4
3 To add a group box to a dialog box=To add a group box to a dialog box>proc4
3 To add a scroll bar to a dialog box=To add a scroll bar to a dialog box>proc4
3 To add a list box to a dialog box=To add a list box to a dialog box>proc4
3 To add a radio button to a dialog box=To add a radio button to a dialog box>proc4
3 To add a rectangle control to a dialog box=To add a rectangle control to a dialog box>proc4
3 To add a spin control to a dialog box=To add a spin control to a dialog box>proc4
3 To add a tab control to a dialog box=To add a tab control to a dialog box>proc4
3 To add a timer control to a dialog box=To add a timer control to a dialog box>proc4
2 Assigning properties to dialog box controls
2 Assigning properties to dialog box controls=Assigning properties to dialog box controls>main
3 To identify the Name property of a dialog box control=To identify the Name property of a dialog box control>proc4
3 To set the Selected property for a dialog box control=To set the Selected property for a dialog box control>proc4
3 To set the Selection text property for a dialog box control=To set the Selection text property for a dialog box control>proc4
3 To make a dialog box control the default button=To make a dialog box control the default button>proc4
3 To assign a shortcut key to a labeled dialog box control=To assign a shortcut key to a labeled dialog box control>proc4
3 To assign a shortcut key to an unlabelled dialog box control=To assign a shortcut key to an unlabelled dialog box control>proc4
3 To limit access to a dialog box control or dialog box=To limit access to a dialog box control or dialog box>proc4
2 Attaching actions to dialog box controls
2 Attaching actions to dialog box controls=Attaching actions to dialog box controls>main
3 To connect a dialog box control to cells or other controls=To connect a dialog box control to cells or other controls>proc4
3 To specify the action performed by a dialog box control=To specify the action performed by a dialog box control>proc4
3 To create a conditional object link=To create a conditional object link>proc4
3 To delete a connected link command=To delete a connected link command>proc4
2 Editing and positioning dialog box controls
2 Editing and positioning dialog box controls=Editing and positioning dialog box controls>main
3 To rename a control in a dialog box=To rename a control in a dialog box>proc4
3 To move a control in a dialog box=To move a control in a dialog box>proc4
3 To specify an exact position for a control in a dialog box=To specify an exact position for a control in a dialog box>proc4
3 To copy a control in a dialog box=To copy a control in a dialog box>proc4
3 To edit multiple dialog box controls=To edit multiple dialog box controls>proc4
3 To align multiple dialog box controls=To align multiple dialog box controls>proc4
3 To center multiple dialog box controls=To center multiple dialog box controls>proc4
3 To space multiple dialog box controls=To space multiple dialog box controls>proc4
3 To resize multiple dialog box controls=To resize multiple dialog box controls>proc4
3 To change the tab order for dialog box controls=To change the tab order for dialog box controls>proc4
2 Working with child controls in dialog boxes
2 Working with child controls in dialog boxes=Working with child controls in dialog boxes>main
3 To attach a control to group boxes and rectangle controls=To attach a control to group boxes and rectangle controls>proc4
3 To add an unattached control to a parent control=To add an unattached control to a parent control>proc4
3 To separate a control from a parent control=To separate a control from a parent control>proc4
3 To move a child control when the dialog box is resized=To move a child control when the dialog box is resized>proc4
2 Creating Help and tips for controls
2 Creating Help and tips for controls=Creating Help and tips for controls>main
3 To create Help for a dialog box control=To create Help for a dialog box control>proc4
3 To create an application bar hint for a dialog box control=To create an application bar hint for a dialog box control>proc4
3 To link a Help file to a dialog box control=To link a Help file to a dialog box control>proc4
3 To link a dialog box to a Help file=To link a dialog box to a Help file>proc4
3 To link a Help button to a Help file=To link a Help button to a Help file>proc4
2 Using macros to display a dialog box
2 Using macros to display a dialog box=Using macros to display a dialog box>main
3 To display a dialog box and set initial values=To display a dialog box and set initial values>proc4
3 To change the order for setting initial values in a dialog box=To change the order for setting initial values in a dialog box>proc4
3 To reorder controls in a dialog box=To reorder controls in a dialog box>proc4
2 Reference: Working with custom dialog boxes and controls
2 Reference: Working with custom dialog boxes and controls=Reference Working with custom dialog boxes and controls>main
3 Understanding dialog box controls=Understanding dialog box controls>proc4
3 Understanding link commands=Understanding link commands>proc4
3 Understanding link events=Understanding link events>proc4
3 Outline of control-specific properties=Outline of controlspecific properties>proc4
3 Example of using macros to display a dialog box=Example of using macros to display a dialog box>proc4
1 Managing files and data
1 Managing files and data=Managing files and data>main
2 Opening and saving files
2 Opening and saving files=Opening and saving files>main
3 To open a file from another application=To open a file from another application>proc4
3 To open a file from the Internet=To open a file from the Internet>proc4
3 To open a Quicken Interchange Format (.qif) file=To open a Quicken Interchange Format qif file>proc4
3 To save a database file=To save a database file>proc4
3 To save a Quattro Pro file in another format=To save a Quattro Pro file in another format>proc4
2 Sending files
2 Sending files=Sending files>main
3 To send a notebook to another location=To send a notebook to another location>proc4
3 To send a notebook by email=To send a notebook by email>proc4
2 Inserting, importing, and combining files
2 Inserting, importing, and combining files=Inserting importing and combining files>main
3 To insert a file into a notebook=To insert a file into a notebook>proc4
3 To import a text file=To import a text file>proc4
3 To save a text file=To save a text file>proc4
3 To import unformatted text=To import unformatted text>proc4
3 To combine files by using math operations=To combine files by using math operations>proc4
2 Importing text into columns
2 Importing text into columns=Importing text into columns>main
3 To import a text file into columns=To import a text file into columns>proc4
3 To adjust the column width for imported text=To adjust the column width for imported text>proc4
3 To specify a parsing format for imported text=To specify a parsing format for imported text>proc4
3 To customize parse settings for delimited text files=To customize parse settings for delimited text files>proc4
3 To customize parse settings for fixed-width text files=To customize parse settings for fixedwidth text files>proc4
3 To add a fixed-width parse break=To add a fixedwidth parse break>proc4
2 Linking and embedding objects
2 Linking and embedding objects=Linking and embedding objects>main
3 To link an object=To link an object>proc4
3 To embed an object=To embed an object>proc4
3 To copy an object to another application=To copy an object to another application>proc4
3 To resize an OLE object=To resize an OLE object>proc4
2 Editing and updating objects and links
2 Editing and updating objects and links=Editing and updating objects and links>main
3 To edit a linked or embedded OLE object=To edit a linked or embedded OLE object>proc4
3 To update a linked OLE object=To update a linked OLE object>proc4
3 To edit a DDE link=To edit a DDE link>proc4
3 To change the source of a linked OLE object=To change the source of a linked OLE object>proc4
3 To convert an OLE object format=To convert an OLE object format>proc4
3 To change an OLE object's activation effect=To change an OLE objects activation effect>proc4
3 To display an OLE object as an icon=To display an OLE object as an icon>proc4
2 Creating notebook links
2 Creating notebook links=Creating notebook links>main
3 To insert a notebook link=To insert a notebook link>proc4
3 To link notebooks by selecting cells=To link notebooks by selecting cells>proc4
3 To link notebooks by using wildcards=To link notebooks by using wildcards>proc4
3 To link cells=To link cells>proc4
3 To link data between applications=To link data between applications>proc4
3 To insert a hyperlink=To insert a hyperlink>proc4
2 Editing and updating notebook links
2 Editing and updating notebook links=Editing and updating notebook links>main
3 To open a file linked to the active notebook=To open a file linked to the active notebook>proc4
3 To update a link to an unopened file=To update a link to an unopened file>proc4
3 To change a notebook link to another file=To change a notebook link to another file>proc4
3 To delete a notebook link=To delete a notebook link>proc4
3 To delete a hyperlink=To delete a hyperlink>proc4
2 Reference: Managing files and data
2 Reference: Managing files and data=Reference Managing files and data>main
3 File-handling options=Filehandling options>proc4
3 Supported file formats=Supported file formats>proc4
3 Quattro Pro for MS-DOS=Quattro Pro for MSDOS>proc4
3 Graphic formats for importing=Graphic formats for importing>proc4
3 Graphic formats for exporting=Graphic formats for exporting>proc4
3 Rules for combining files=Rules for combining files>proc4
3 Troubleshooting with OLE=Troubleshooting with OLE>proc4
1 Using Workgroups
1 Using Workgroups=Using Workgroups>main
2 Sharing notebooks
2 Sharing notebooks=Sharing notebooks>main
3 To share a notebook=To share a notebook>proc4
3 To resolve a conflict in a shared notebook=To resolve a conflict in a shared notebook>proc4
2 Comparing notebooks
2 Comparing notebooks=Comparing notebooks>main
3 To compare two notebooks=To compare two notebooks>proc4
2 Reviewing notebooks
2 Reviewing notebooks=Reviewing notebooks>main
3 To access review commands=To access review commands>proc4
3 To review a shared notebook=To review a shared notebook>proc4
3 To display or hide cell comments when reviewing a notebook=To display or hide cell comments when reviewing a notebook>proc4
1 Using passwords and startup switches
1 Using passwords and startup switches=Using passwords and startup switches>main
2 Using password protection
2 Using password protection=Using password protection>main
3 To assign a password to a notebook=To assign a password to a notebook>proc4
3 To open a file with low-level password protection=To open a file with lowlevel password protection>proc4
3 To open a file with medium-level password protection=To open a file with mediumlevel password protection>proc4
3 To open a file with high-level password protection=To open a file with highlevel password protection>proc4
3 To open a file with controls-only password protection=To open a file with controlsonly password protection>proc4
3 To change a password for a notebook=To change a password for a notebook>proc4
3 To disable a password for a notebook=To disable a password for a notebook>proc4
2 Using startup switches
2 Using startup switches=Using startup switches>main
3 To start Quattro Pro using a startup switch=To start Quattro Pro using a startup switch>proc4
3 To set a permanent startup switch from the Start menu=To set a permanent startup switch from the Start menu>proc4
3 To set a permanent startup switch from a desktop icon=To set a permanent startup switch from a desktop icon>proc4
1 Working with the Internet
1 Working with the Internet=Working with the Internet>main
2 Publishing spreadsheet data in HTML
2 Publishing spreadsheet data in HTML=Publishing spreadsheet data in HTML>main
3 To save a spreadsheet range as an HTML document=To save a spreadsheet range as an HTML document>proc4
3 To save a table or chart as an HTML document=To save a table or chart as an HTML document>proc4
3 To reorganize an HTML document=To reorganize an HTML document>proc4
3 To add document information to an HTML document=To add document information to an HTML document>proc4
3 To add meta text to an HTML document=To add meta text to an HTML document>proc4
2 Setting HTML style options
2 Setting HTML style options=Setting HTML style options>main
3 To set the graphic type for an HTML document=To set the graphic type for an HTML document>proc4
3 To set the page layout for an HTML document=To set the page layout for an HTML document>proc4
3 To customize color settings for an HTML document=To customize color settings for an HTML document>proc4
2 Using XML with Quattro Pro
2 Using XML with Quattro Pro=Using XML with Quattro Pro>main
3 To manually create XML tags=To manually create XML tags>proc4
3 To automatically create XML tags from labels=To automatically create XML tags from labels>proc4
3 To automatically create XML tags from row or column titles=To automatically create XML tags from row or column titles>proc4
3 To display XML tags=To display XML tags>proc4
3 To create a top-level root element=To create a toplevel root element>proc4
3 To publish tagged data as an XML file=To publish tagged data as an XML file>proc4
2 Working with Web queries
2 Working with Web queries=Working with Web queries>main
3 To create a Web query=To create a Web query>proc4
3 To run a Web query=To run a Web query>proc4
3 To change how a Web query obtains a parameter value=To change how a Web query obtains a parameter value>proc4
3 To set Web query options=To set Web query options>proc4
3 To insert specific Web query data=To insert specific Web query data>proc4
3 To set a Web query refresh interval=To set a Web query refresh interval>proc4
2 Working with Web links
2 Working with Web links=Working with Web links>main
3 To create a Web link=To create a Web link>proc4
3 To refresh Web link data in a range of cells=To refresh Web link data in a range of cells>proc4
3 To manually refresh a Web link=To manually refresh a Web link>proc4
3 To set a Web link refresh interval=To set a Web link refresh interval>proc4
3 To edit a Web link=To edit a Web link>proc4
3 To delete a Web link=To delete a Web link>proc4
2 Linking to Web graphics
2 Linking to Web graphics=Linking to Web graphics>main
3 To insert a Web graphic=To insert a Web graphic>proc4
3 To create a live image link to a dynamic Web graphic=To create a live image link to a dynamic Web graphic>proc4
2 Reference: Working with the Internet
2 Reference: Working with the Internet=Reference Working with the Internet>main
3 Example: XML tag creation=Example XML tag creation>proc4
1 Using Microsoft IntelliMouse
1 Using Microsoft IntelliMouse=Using Microsoft IntelliMouse>main
2 Zooming and scrolling with Microsoft IntelliMouse
2 Zooming and scrolling with Microsoft IntelliMouse=Zooming and scrolling with Microsoft IntelliMouse>main
3 To zoom in or out with Microsoft IntelliMouse=To zoom in or out with Microsoft IntelliMouse>proc4
3 To scroll using Microsoft IntelliMouse=To scroll using Microsoft IntelliMouse>proc4
3 To change Microsoft IntelliMouse settings=To change Microsoft IntelliMouse settings>proc4
3 To AutoScroll with Microsoft IntelliMouse=To AutoScroll with Microsoft IntelliMouse>proc4
:include wt11cmen.cnt
1 Reference information
2 Quattro Pro Glossary
3 Quattro Pro Glossary=glossary
2 Quattro Pro Templates Help
2 Quattro Pro Templates Help=Quattro Pro Templates Help>main
3 Cash Budget=Cash Budget>proc4
3 Future Value of a Lump Sum=Future Value of a Lump Sum>proc4
3 Grading Sheet=Grading Sheet>proc4
3 Home Equity Comparison=Home Equity Comparison>proc4
3 Home Rent or Buy Analysis=Home Rent or Buy Analysis>proc4
3 Personal Budget=Personal Budget>proc4
3 Retirement Budget=Retirement Budget>proc4
3 Retirement Income Plan=Retirement Income Plan>proc4
3 School Budget=School Budget>proc4
3 Statement of Net Worth=Statement of Net Worth>proc4
2 Quattro Pro keyboard shortcuts
2 Quattro Pro keyboard shortcuts=Quattro Pro keyboard shortcuts>main
3 Shortcuts for common tasks=Shortcuts for common tasks>proc4
3 Edit mode keys=Edit mode keys>proc4
3 Object keys=Object keys>proc4
3 Formula Composer keys=Formula Composer keys>proc4
3 Point mode keys=Point mode keys>proc4
3 Print preview keys=Print preview keys>proc4
3 Navigation keys=Navigation keys>proc4
3 Function keys=Function keys>proc4
3 CrossTab report keys=CrossTab report keys>proc4
3 Excel compatibility keys=Excel compatibility keys>proc4
:include qp11fnen.cnt
2 Quattro Pro Macros Help
3 Quattro Pro Macros Help=!EF(`qp11mcen.hlp')
2 Quattro Pro VBA Help
3 Quattro Pro VBA Help=!EF(`qp11vbaen.hlp')
2 WordPerfect Office Macro Command Center
3 WordPerfect Office Macro Command Center=!EF(`wpmc11en.hlp')
3 Properties of form controls
3 Properties of form controls=Properties of form controls>main
4 Active dialog box properties=Active dialog box properties>proc4
4 Active page property=Active page property>proc4
4 Add down button property=Add down button property>proc4
4 Alarm on property=Alarm on property>proc4
4 Alarm time property=Alarm time property>proc4
4 Allow point mode property=Allow point mode property>proc4
4 Attach child property=Attach child property>proc4
4 Bitmap property=Bitmap property>proc4
4 Button type property=Button type property>proc4
4 Convert text property=Convert text property>proc4
4 Current time property=Current time property>proc4
4 Custom color property=Custom color property>proc4
4 Default property=Default property>proc4
4 Default button property=Default button property>proc4
4 Depend on property=Depend on property>proc4
4 Dialog type property=Dialog type property>proc4
4 Dimension property=Dimension property>proc4
4 Disabled property=Disabled property>proc4
4 Draw beveling property=Draw beveling property>proc4
4 Draw to right property=Draw to right property>proc4
4 Edit disabled property=Edit disabled property>proc4
4 Edit length property=Edit length property>proc4
4 Enabled property=Enabled property>proc4
4 Field type property=Field type property>proc4
4 56 colors property=56 colors property>proc4
4 File type list property=File type list property>proc4
4 Fill color property=Fill color property>proc4
4 Frame color property=Frame color property>proc4
4 Grayed property=Grayed property>proc4
4 Grid options property=Grid options property>proc4
4 Group text property=Group text property>proc4
4 Help line property=Help line property>proc4
4 Hidden property=Hidden property>proc4
4 History list property=History list property>proc4
4 Interval in units property=Interval in units property>proc4
4 Label font property=Label font property>proc4
4 Label text property=Label text property>proc4
4 List property=List property>proc4
4 List length property=List length property>proc4
4 Maximum property=Maximum property>proc4
4 Minimum property=Minimum property>proc4
4 Name property=Name property>proc4
4 Number of columns property=Number of columns property>proc4
4 Object help property=Object help property>proc4
4 Object ID property=Object ID property>proc4
4 Ordered property=Ordered property>proc4
4 Page list property=Page list property>proc4
4 Page name text property=Page name text property>proc4
4 Parameters property=Parameters property>proc4
4 Position adjust property=Position adjust property>proc4
4 Process value property=Process value property>proc4
4 Rectangle style property=Rectangle style property>proc4
4 Select location property=Select location property>proc4
4 Selected property=Selected property>proc4
4 Selection text property=Selection text property>proc4
4 Show property=Show property>proc4
4 Show frame property=Show frame property>proc4
4 Show time property=Show time property>proc4
4 Tab stop property=Tab stop property>proc4
4 Terminate dialog property=Terminate dialog property>proc4
4 Text draw flags property=Text draw flags property>proc4
4 Timer on property=Timer on property>proc4
4 Title property=Title property>proc4
4 Units in milliseconds property=Units in milliseconds property>proc4
4 Value property=Value property>proc4
3 Properties of dialog box controls
3 Properties of dialog box controls=Properties of dialog box controls>main
4 Bitmap button control=Bitmap button control>proc4
4 Check box control=Check box control>proc4
4 Color control=Color control>proc4
4 Combo box control=Combo box control>proc4
4 Edit field control=Edit field control>proc4
4 Edit integer control=Edit integer control>proc4
4 File control =File control >proc4
4 Group box control=Group box control>proc4
4 Label control=Label control>proc4
4 List box control=List Box control>proc4
4 Push button control=Push button control>proc4
4 Radio button control=Radio button control>proc4
4 Rectangle control=Rectangle control>proc4
4 Scroll bar control=Scroll bar control>proc4
4 Spin control=Spin control>proc4
4 Tab control=Tab control>proc4
4 Time control=Time control>proc4
3 Examples of linking controls
3 Examples of linking controls=Examples of linking controls>main
4 Linking bitmap buttons=Linking bitmap buttons>proc4
4 Linking push buttons=Linking push buttons>proc4
4 Linking check boxes=Linking check boxes>proc4
4 Linking combo boxes=Linking combo boxes>proc4
4 Linking edit fields=Linking edit fields>proc4
4 Linking file controls=Linking file controls>proc4
4 Linking group boxes=Linking group boxes>proc4
4 Linking scroll bars=Linking scroll bars>proc4
4 Linking list boxes=Linking list boxes>proc4
4 Linking radio buttons=Linking radio buttons>proc4
4 Linking spin controls=Linking spin controls>proc4
4 Linking timer controls=Linking timer controls>proc4