Microsoft Office Tutorials and References
In Depth Information
One More Example—Function Applied to Multiple Categories
3. If you have to do it very often, activate the Select Visible Cells only icon
that it appears in the Quick Access menu.
a. Choose Customize Access Toolbar.
b. In the drop-down menu choose More Commands.
c. Choose all commands.
d. Click on Select Visible Cells, click on Add and OK. See Figure 25.10.
e. You can then click on the icon
(Select Visible Cells), which appears in the
Quick Access menu.
f. Copy the region and Paste in destination.
FIGURE 25.9 Selecting Visible Cells Only through the Menu
FIGURE 25.10 Adding the Icon to the Quick Access Menu