User guide

QCing Items

www.iprotech.com Ipro eCapture User Guide 6-85

877-324-4776 Q1 2014

Click Defaults to populate the dialog with the Excel default settings as shown

in the previous figure. Some of the options show how to access the setting in

Microsoft Excel. For example, View > Header and Footer: Header/Footer Tab

means from the View menu, choose Header and Footer and click the Header/

Footer Tab. Or another example, Format > Row > Unhide means from the For-

mat menu, choose Row, and then choose Unhide.

• Do not include headers - View > Header and Footer: Header/Footer Tab,

Header drop-down list, None.

• Do not include footers - View > Header and Footer: Header/Footer Tab,

Footer drop-down list, None.

• Reveal hidden columns - Format > Column > Unhide

• Reveal hidden rows - Format > Row > Unhide

• Unhide worksheets - Format > Sheet > Unhide

• Unhide very hidden worksheets - Unhides worksheets that were hidden

by a Microsoft Visual Basic for Applications program that assigned the

property xlSheetVeryHidden. (From the Microsoft Excel Help File: If

sheets are hidden by a Microsoft Visual Basic for Applications program

that assigns the property xlSheetVeryHidden, you cannot use the Unhide

command to display the sheets. If you are using a workbook with Visual

Basic macros and have problems with hidden sheets, contact the owner

of the workbook for more information.)

• Autofit rows - Double click the boundary below that row heading.

• Autofit columns - Double click the right boundary of the column heading

for that row.

•Wrap text - Format > Cells: Alignment Tab, Wrap Text Option.

• Print gridlines - File > Page Setup: Sheet Tab, Under Print, select Grid-

lines checkbox.

• Unhide windows - Window > Unhide.

• No fill color (for cells) - Format > Cells: Patterns Tab, Under Color, click