How do you add the "local open" button to the quick access toolbar in Excel 2010? I can see the local open option in the file tab, but I can't find a way to add it to the Ribbon or quick access toolbar. Any tips would be greatly appreciated
Right click the Ribbon and click Customize the Ribbon. This will bring up the options panel, where you can also customize the Quick Access toolbar. You add commmands from the left pane to the right pane. At the top, you can filter the commands on the left. Filter by the File Tab.
Check these link
Customize the Quick Access Toolbar- Office Support - it have most of the details to
hope this help to customize in your way..
watch this video to know this how it works