Microsoft Office Tutorials and References
In Depth Information
Other Database Functions
7 Double-click the right border of column heading R to change the width of column R to
best fi t (Figure 5–66).
Are there any differences when using these functions on a range?
Yes. The COUNTIF, SUMIF, and database functions will work on any range. The difference
between using these functions on a range and table is that if the function references
a table, then Excel automatically adjusts the fi rst argument as a table grows or shrinks.
The same cannot be said if the function’s fi rst argument is a range reference that is not
defi ned as a table.
Decrease
Decimal
button
Comma
Style
button
=SUMIF(J9:
J21, “A”,
H9:H21)
=COUNTIF(B9:
B21, “M”)
Figure 5–66
To Print the Worksheet and Save the Workbook
Printing
To print individual
sections of the worksheet,
click the Name box in
the formula bar, click
the name of the section
(Criteria or Extract) you
want to print, and then
click Print on the Offi ce
Button menu. When Excel
displays the Print dialog
box, click Selection in the
Print what area and then
click the Print button.
The following steps print the worksheet on one page and save the workbook.
1 Select any cell outside the table.
2 Click the Page Layout tab on the Ribbon and then click the Page Setup Dialog Box
Launcher to display the Page Setup dialog box.
3 Click Landscape in the Orientation area. Click Fit to in the Scaling area.
4 Click the Print button. When the Print dialog box appears, click the OK button to print the
worksheet (Figure 5–67).
5 Click the Save button on the Quick Access Toolbar to save the workbook using the fi le
name, Silver Photography Accessories Sales Rep Table.
6 Click the Page Setup Dialog Box Launcher to display the Page Setup dialog box. Click
Portrait in the Orientation area and then click Adjust to in the Scaling area.
7 Click the OK button to close the Page Setup dialog box.
 
 
Search JabSto ::




Custom Search