The dynamic pictures consume memory and should ideally be deleted once you have used them.Ī great feature that allows you to see the content of specified cells from a completely different part of the model. As you change the data captured in step 1 above, you should see the picture update.īe careful: don’t use this feature as an infinite resource. The picture will appear as an object on the Excel worksheet. Click a destination point on the screen for the dynamic picture.Click the Camera button on the quick access toolbar.Select an area of the screen to capture.Choose “OK” to close the Excel Options dialog box.Choose the “Add” button to install the camera function on the quick access toolbar.Scroll down the list of commands until you find the “Camera” feature.Choose “All Commands” from the “Choose from commands” dropdown.Right click the quick access toolbar and choose “Customize Quick Access Toolbar”.This tool is very useful to see how other parts of a model are impacted when the assumptions change. This means that the photo will update as the captured information in the worksheet updates. This feature enables you to make dynamic photos of the Excel screen. ![]() Discover some of the most useful lesser known features that can have a huge impact on your financial modeling workflow when using Microsoft Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |