Excel allows you to capture portions of your worksheet as a picture that you can then use in a variety of other ways. This picture is linked to the source. Here’s how to take the snapshot.

Excel provides a nifty little tool that allows you to create a picture from a range of cells, from a chart, or from another object in your worksheet. Follow these steps:
Select the cells or other object you want a picture of. (If you select cells, they must be contiguous.)
Display the Home tab of the ribbon.
Click the down arrow under the Paste tool in the Clipboard group. Excel displays a list of options.
Click As Picture to display a submenu.
Click Copy as Picture. Excel displays the Copy Picture dialog box. (Click here to see a related figure.)
In the top part of the dialog box, specify what you want in the picture.
In the bottom part of the dialog box, specify how you want the graphic saved.
Click OK.
The result is that you now have a graphic in the Clipboard—either a metapicture or a bitmap, depending on your choice in the bottom portion of the dialog box—that you can paste anywhere. Paste it in another workbook, paste it in an e-mail, or paste it in a Word document. You can paste it just about anywhere because it is no longer an Excel object, but an actual graphic.
You should know that if you choose “As Shown On Screen” in the Copy Picture dialog box, that doesn’t mean that Excel copies the picture exactly as shown. The copied picture will always be at a 100% zoom magnification, regardless of what zoom setting you are using.

Merging cells is a common task when creating reports in worksheets. But merged cells can play havoc with the normal functioning of some of Excel’s tools. Knowing where those cells are located could be helpful so that you can determine whether to remove them or not.

Here is one way to identify which cells are merged in a workbook.

You can use Excel’s searching capabilities. Follow these steps:
Press Ctrl+F. Excel displays the Find tab of the Find and Replace dialog box.
If necessary, click the Options button to make sure the Find and Replace dialog box is expanded to show all options.

Find dialog showing options

Make sure the Find What box is empty.
With the insertion point in the Find What box, click the Format button. Excel displays the Find Format dialog box.
Make sure the Alignment tab is displayed and check the Merge Cells check box.
Click OK to close the Find Format dialog box.
Click Find All.
Excel searches for any merged cells and if they are located, the cells are displayed in the bottom of the Find and Replace dialog box. You can then select one of the found ranges and the corresponding range is selected in the worksheet.