Microsoft Excel Toolbar Settings File
3.2 | 12 Votes
What is an XLB file?
An XLB file is a settings file created by Microsoft Excel, a spreadsheet application. It stores custom settings for toolbars (also known as command bars) that can be modified within Excel. Along with the custom settings, XLB files also include information about which toolbars are visible, where they are located, and what options are available on each toolbar.
Excel toolbars allow you to quickly access important functions, such as "Save," "Undo," "Redo," "Copy," and "Cut." You can customize the toolbar by adding your favorite commands, which include commands available in the various tabs in the ribbon and macros.
Excel saves all of the toolbar settings in the XLB file, which you can transfer from one computer to another to set up the toolbar.
How do I customize the toolbar in Excel 365?
You can customize your toolbar in several ways in Excel 365:
- Select File → Options → Quick Access Toolbar
- Click the down arrow icon in the toolbar, then select More Commands...
- Right-click a command in the ribbon and select Add to Quick Access Toolbar
In older versions of Excel, select Toolbars from the View menu to access the customization options.
Once you close Excel, the application saves any changes you made to the toolbar in the XLB file.
Where are the Excel XLB toolbar settings files located?
XLB settings file are typically stored in one of the two directories:
- C:\Users\[username]\Application Data\Microsoft\Excel
NOTE: If you delete the XLB file, Excel will regenerate it when opened again, but any customizations will be lost.
How to open an XLB file
You can only open XLB files with Microsoft Excel in Windows and macOS. To open an XLB file, select File → Open, choose the XLB file, and click Open.
Programs that open or reference XLB files
OpenOffice.org Module Information File
2.0 | 2 Votes
File used by OpenOffice.org, a free productivity suite developed by Oracle; contains information about a component library or macro, which is written in the OpenOffice.org Basic language and stored in an .XBA file.
XLB files are used with the other library files for loading modules. They are saved using XML formatting and use the names script.xlb and dialogue.xlb.
NOTE: OpenOffice.org was replaced by Apache OpenOffice in 2012.