Microsoft Office Tutorials and References
In Depth Information
10 With a USB ﬂ ash drive connected to one of the computer’s USB ports, click the Save button
on the Quick Access Toolbar. Save the workbook using the ﬁ le name, Silver Photography
Accessories Sales Rep Table on the USB ﬂ ash drive. (Figure 5–4).
When should the Center Across Selection alignment be used instead of the Merge &
Center button on the Ribbon?
In Step 4, the Center Across Selection horizontal alignment was used to center the table
title in row 7 horizontally across the range A7:H7. In earlier chapters, the Merge & Center
button on the Home tab on the Ribbon was used to center text across a range. The major
difference between the Center Across Selection horizontal alignment and the Merge &
Center button is that, unlike the Merge & Center button, the Center Across Selection
horizontal alignment does not merge the selected cell range into one cell.
blank rows at top of
worksheet will be
used to store criteria
for use in a query
list title and