User guide

Chapter 5, Creating Clients, Projects, Custodians, and Jobs
5-68 Ipro eCapture User Guide www.iprotech.com
Q1 2014 877-324-4776
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 2007.
• Do not include headers - Insert tab > Text group > click Header & Footer
to open Design tab. Click Header and choose None from the drop-down
menu.
• Do not include footers - Insert tab > Text group > click Header & Footer
to open Design tab. Click Footer and choose None from the drop-down
menu.
• Reveal hidden columns - Home tab > Cells group. Click Format and
choose Hide & Unhide > Unhide Columns.
• Reveal hidden rows - Home tab > Cells group. Click Format and choose
Hide & Unhide > Unhide Rows.
• Unhide worksheets - Home tab > Cells group > click Format and choose
Hide & Unhide > Unhide Sheet.
• 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 - Home tab > Alignment group. Click Wrap Text.
• Print gridlines - Page Layout tab > Sheet Options group. Under Gridlines
select Print.
• Unhide windows - View tab > Window group. Click Unhide.
• No fill color (for cells) - Home tab > Styles group. Click Cell Styles and
click Normal.
• Clear print area - Page Layout tab. Click Print Area and choose Clear
Print Area from the drop-down menu.