Tag Archives: Toolbar customization

PowerPoint – Making a Mask

Creating a mask effect in PowerPoint is easy, once you’ve located the Shape Combine command. You can add this command to the Ribbon or the Quick Access Toolbar.

Below, you see it being added to my toolbar.Adding the Shape Combine Command to the Toolbar

Adding the Shape Combine Command to the Toolbar, alternately look for the Combine Shapes command as more options are available.The command will not be active until there are two shapes selected. Below, I’ve created a blue rectangle and a red oval. The oval shape will be cut out from the rectangle.Blue rectangle with red oval positioned for the cut out.

Blue rectangle with red oval positioned for the cut out.You may prefer to add the Combine Shapes command instead. More options are available as you can see below.

Select the shapes you wish to combine.
Both shapes are selected, so the Combine Shapes button is active

The result of the Shape Combine command, a rectangle with an oval “hole: in the center.The result of the Combine Shapes Command

The result of the Combine Shapes CommandOnce the mask is created, you can dress it up. Below, I’ve changed the fill to an image of a leafy forest floor.The forest floor has a hole in it.

The forest floor has a hole in it.Now I can layer whatever image I wish (in this case a frog) under the mask. You can animate the layer underneath the mask. Can you image a wheel of creatures rotating into the viewpoint in the center of the mask? That would be great for a talk about ecology!

Can you spot the frog?
Can you spot the frog?

 

Excel: Select Visible (2)

The Select Visible Cells Only button on the Quick Access Toolbar
The Select Visible Cells Only button on the Quick Access Toolbar

The Select Visible Cells Only function is so useful, I like to add it to the Quick Access Toolbar (QAT) in Excel. These instructions are based on Excel 2010, but will be similar in all current versions of Excel.

Quick Access Toolbar Customization
Quick Access Toolbar Customization

The Quick Access Toolbar starts in the top right corner of the Excel window.  The customize button is circled in red. Clicking on that button displays the menu shown below.

Move the QAT under the ribbon
Move the QAT under the ribbon

The first change I like to make is to its’ position. I like to move it under the Ribbon, since there will be more room for buttons there. Over time I tend to fill the QAT up with frequently used tools.

After I move the QAT below the ribbon, I go hunting for useful commands to add.  Click the More Commands… option and the Customize the Quick Access Toolbar dialog opens up.

Customize the Quick Access Toolbar - Popular Commands
Customize the Quick Access Toolbar – Popular Commands

The dialog box defaults to Popular Commands.  Try scrolling through this list and find the Format Painter. Press the Add button, to add it to the Quick Access Toolbar. This is a useful tool to have at hand!

By clicking on the Choose commands from drop-down list, a selection will be displayed.

Drop-down list of source commands.
Drop-down list of source commands.

Select All Commands from this list. Hundreds of Excel commands will display, and this is where it is useful to know the name of the command you are looking for. Scroll until you find Select Visible Cells.

Finding the Select Visible Cells command
Finding the Select Visible Cells command

Select it, Click on the Add button, and click OK.

Simply select the cells you wish to copy and press the Select Visible Cells button. Paste your information and only what you see will be pasted.