How to add icon Reset print area at the top menu position?
How to add icon Reset print area at the top menu position?
Which version of Excel? If it's 2003 or earlier you can customise the toolbar (View - toolbars - customize...) and drag the Clear Print Area button (from the Commands tab) onto any toolbar you like.
Everyone who confuses correlation and causation ends up dead.
Hi
Office 2007 PRO
In that case you can add it to the Quick Access Toolbar by:
1. Office button - Excel Options, Customize section
2. Change the 'Choose commands from' dropdown to 'All commands'
3. Locate the Clear Print Area command and add it to the QAT. (Note: it will appear as a green circle).
4. Finish.
You can also just use the button on the Page Layout tab.
There is no icon (that's why it shows up with the default green circle when you add it to the QAT). The text will be the same as shown on the Ribbon.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks