More Great Excel Tutorials on Envato Tuts+įind comprehensive Excel tutorials on Envato Tuts+ to help you learn how to work with your data better in your spreadhsheets.

Taking screenshots or screen clippings directly inside Excel will save you time, when you need to add snapshots into your workbooks. You can use all of the normal Picture Tools to edit your snapshot as needed. Take screen clippings in Excel for more control over your snapshots.Īfter you do that, you'll jump back to Excel and you'll add the selection to your file as a screenshot. Now you can click and drag to select certain parts of the screen that you want to select. Use the Screen Clipping OptionĪnother option is to choose Insert > Screenshot and then choose Screen Clipping. Apply Crop to your Excel Screenshot after formatting. You can drag the handles to select only the part you want to keep and then press Crop to lock it in. Format and Crop Your Screenshot in Excelįrom there, you could crop the snapshot by using the Picture Tools' Format option. You can click any one of these window thumbnails to add a screenshot of the entire app inserted into your Excel workbook. When you click on it, you'll see thumbnails for the other open apps on your computer. Then, find the Screenshot button here on the ribbon. Start off by making sure that you're on the Insert tab in Excel. Note : Watch this short tutorial screencast or follow the quick steps below, that compliment this video.

Excel shotguns by year