![]() ![]() The third and fourth commands are Undo and Redo. The second command is File Save, which performs the same task as Ctrl + S. By not saving the file automatically, I always can close a file without saving it, then reopen the last version of my file. I always keep AutoSave off because I tend to make many blunders while I’m working in Excel, and I don’t want those blunders saved automatically. Honestly, I’ve never needed a workbook-specific QAT command, but you should know that the option is available. To remove a command from your QAT, just select it in area 4 and then click Remove in area 3.Īrea 5 allows you to add the command to all documents in Excel or just to the active workbook. Then you can move the selected command up or down by using the controls in area 6. Once you choose a command in area 2, click Add in area 3, which adds them to area 4. By having access to them all, I can just search alphabetically for the commands I want to add. However, the choice that I use most often is the third choice: All Commands. When you get the time, you might want to examine that list for the fun of it. ![]() The second choice for the list of filters is intriguing: Commands Not in the Ribbon. Choose File, Options and then click the Quick Access Toolbar tab.Īny of these actions will display a large dialog that includes this area:Īrea 1 is a dropdown list box that allows you to filter the commands you see in area 2.Left-click the right-most icon in your QAT-the one with the tiny down-pointing arrow.Right-click any tool in your QAT and choose Customize Quick Access Toolbar….I can think of at least three ways to do that: To modify the QAT, you first need to click the Quick Access Toolbar tab of your Excel Options dialog. Your QAT is the toolbar that’s at the very top of your screen by default. I use eight great tools in my Quick Action Toolbar (QAT), and you might want to consider using them yourself.īefore I get into the tools, let’s start with a quick look at how to add tools to your QAT, and how to remove them. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |