Wednesday, May 22, 2013

How to Use the Selection Pane in Excel


1. Start Microsoft Excel 2007, and open an existing workbook from your files that contains multiple images that you would like to view with the selection pane.
2. Click to select any one of your images so you can gain access to the Format ribbon. You can tell an image is selected, because it will be surrounded by white sizing handles and the 'Format' tab will appear at the top of the Excel screen.
3. Select the 'Format' tab to display the Format ribbon. This ribbon displays all the settings you can use to format images in Excel.
4. Choose the 'Selection Pane' button in the 'Arrange' section of the Format ribbon. The 'Selection and Visibility' pane will appear on the right side of the Excel screen. This pane displays a list of all the images that appear in the Excel worksheet.
5. Click the button with a picture of the eye to the right of the names of the pictures to hide any of the pictures. Clicking the button again to display the eye will make that image visible.
6. Choose the 'Show All' button at the bottom of the 'Selection and Visibility' pane to show all of the pictures in the workbook. Choose the 'Hide All' button to hide of the pictures.
7. Select the name of a picture and use the up and down arrow buttons at the bottom of the selection pane to change the order of the images on the worksheet.

Blogger news