![]() You can cut and paste this picture into another sheet or resize it as desired. Now left click where you want to place the picture, drag the cursor and release. Your range selection will have animated dashes around it and the mouse cursor will look like a small plus sign. Simply select the cell or range you want to capture in a picture then press the camera button in the QAT. It’s great for making dashboard, dynamic comments that change based on the contents of a cell or cells, or watching a range of values while making changes in another sheet. The camera is definitely a cool tool you should know about. Look for the command called Camera from the All commands menu. This way Excel doesn’t recalculate after each change you make. ![]() This means you can easily turn calculations to Manual while making changes to your spreadsheet and turn it back to Automatic when you’re done. This command will allow you to toggle between Excel’s different calculation options. ![]() Look for the command called Calculation Options from the All commands menu.ĭo you sometimes work with large Excel files with lots of formula where it takes a long time to recalculate the workbook every time you make a change? If so, then adding the Calculation Options command into your QAT can be a big time saver. It will allow you to quickly adjust settings like what happens to the active cell when you press Enter, or changing the default number of sheet in a workbook. ![]() ![]() I find I use this menu so much that it’s worth having the shortcut. This command will allow you to quickly open the Excel Options window instead to going to File menu > Options. Look for the command called Options from the All commands menu. Strikethrough, Double Underline, Subscript and Superscript.A Separator to Keep Your Commands Organized. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |