excel 2016 quick access toolbar make smaller

How to Make the Quick Access Toolbar Smaller in Excel 2016

Are you tired of cluttered toolbars taking up valuable space on your screen? If so, this article will show you how to make the Quick Access Toolbar (QAT) smaller in Excel 2016.

Before we dive into the steps, it's essential to ensure that your data is accurate and complete. This includes checking for blank rows or columns, formulas that include sheet names, and sorting issues. We'll cover these important steps below.

Firstly, make sure you don't have any blank rows or columns within your data. To check for this, press Ctrl+A to select the entire region, then inspect the selection to ensure all data is included.

If some of the data was not selected, find the blank rows or columns and adjust the selection accordingly. For example, in the screenshot below, hidden column E is blank.

Next, select one cell in the column you want to sort. To help prevent sorting problems, follow these steps before you sort Excel data:

1. Check for formulas that include an sheet name in references to cells on the current sheet.

2. Match or order with the wrong customer address. You could end up with names and phone numbers that don't match.

The data might be sorted, while other data is not sorted. This can cause issues when trying to analyze your data.

Now, let's move on to making the Quick Access Toolbar smaller in Excel 2016. To do this:

1. Right-click on the QAT and select 'Customize Quick Access Toolbar' from the context menu.

2. In the Customize Quick Access Toolbar dialog box, click on the 'Reset' button to reset the toolbar to its default state.

3. Click on the 'OK' button to close the dialog box.

Your QAT should now be smaller and more manageable. You can also customize the toolbar further by adding or removing buttons as needed.

Before you start sorting your data, make sure to make a backup copy of your Microsoft Excel file. This will ensure that you have a saved version in case anything goes wrong during the sorting process. You can use my free Excel Backup tool to create a quick and easy backup copy.

In conclusion, making the Quick Access Toolbar smaller in Excel 2016 is a simple process that requires just a few clicks. By following these steps, you'll be able to customize your toolbar to suit your needs and ensure that your data is accurate and complete before sorting.

Excel 2016 quick access toolbar make smaller