blueskyjas.blogg.se

When you have finished adding or removing any commands in the Excel Options box and clicked OK you will immediately see the results in the Quick Access Toolbar: You have now added the Paste Values command to the Quick Access Toolbar, left-click OK to close down the Excel Options box and return to your workbook: Scroll down until you find Paste Values and left-click to select: If you want to Add ‘Paste Special: Values’ to the Quick Access Toolbar then you would first select All Commands from the Command Category Drop Down:Īll the available commands, sorted by Name, will then show in the left hand box. The Excel Options box will open and this allows you to Add or Remove commands to the Quick Access toolbar: Then select ‘ More Commands…’ from the Customise Quick Access Toolbar options box: The process is very simple, first left-click on the black downward arrow which is directly on the right hand side of Quick Access Toolbar: How do I add or remove commands to the Quick Access Toolbar? By default you will have icons for Save, Undo and Redo placed in the Quick Access Toolbar: The Quick Access Toolbar is located above the main components of the Ribbon starting on the top-left side of the workbook. For example if ‘Paste Special: Values’ is a command you use all the time then it would be worth adding to the Quick Access Toolbar so it becomes a single click process saving you time. The Quick Access Toolbar in Excel is a conveniently located area on the Workbook where you can access frequently used commands with a single click. The Quick Access Toolbar in Excel 2010 is a great timesaver for regular Excel users, read on to discover how to Add or Remove commands to the Quick Access Toolbar and speed up your Excel work today…