ExcelHow to Disable the Quick Analysis Toolbar in Microsoft Excel
In Microsoft Excel, whenever you select a range of cells containing data, a small button...
ExcelHow to Disable ScreenTips (Hover Tooltips) in Microsoft Excel
As you navigate through the Ribbon toolbar in Microsoft Excel, you might notice that pausing...
ExcelHow to Hide the Quick Analysis Tool in Microsoft Excel
In Microsoft Excel, whenever you highlight a block of data—whether it’s two cells or two...
ExcelHow to Disable the Feedback Sound Effects in Microsoft Excel
Microsoft Excel includes a little-known feature called “Provide feedback with sound.” When enabled, Excel plays...
ExcelHow to Disable the Automatic Capitalisation of First Letters in Microsoft Excel
Microsoft Excel includes a built-in AutoCorrect feature that silently monitors your typing and attempts to...
ExcelHow to Hide the Scrollbars in Microsoft Excel
By default, every Microsoft Excel spreadsheet features a vertical scrollbar on the right side and...
ExcelHow to Hide the Sheet Tabs in a Microsoft Excel Workbook
At the bottom of every Microsoft Excel workbook, you will find the sheet tabs (e.g.,...
ExcelHow to Change the Default Number of Sheets in a New Excel Workbook
By default, whenever you launch Microsoft Excel and create a new, blank workbook, it automatically...
ExcelHow to Hide the Quick Access Toolbar in Microsoft Excel
The Quick Access Toolbar (QAT) in Microsoft Excel is a small row of icons—usually containing...
ExcelHow to Hide the Column and Row Headers in Microsoft Excel
Every new spreadsheet in Microsoft Excel displays row numbers down the left-hand side (1, 2,...
ExcelHow to Change the Default Save Format to XLS in Microsoft Excel
Since the release of Microsoft Office 2007, Excel has used the .xlsx format as its...
ExcelHow to Remove the Recently Opened Files List in Microsoft Excel
When you open Microsoft Excel, or click on the “File” menu, you are greeted with...
ExcelHow to Disable the Zoom Slider in the Microsoft Excel Status Bar
At the bottom right corner of the Microsoft Excel window sits the Zoom Slider—a horizontal...
ExcelHow to Hide the Formula Bar in Microsoft Excel
The Formula Bar in Microsoft Excel is the long, white text box situated directly above...
ExcelHow to Hide the Toolbar Ribbon in Microsoft Excel
The “Ribbon” in Microsoft Excel is the large, horizontal toolbar positioned at the top of...
ExcelHow to Hide Columns in Microsoft Excel Based on Cell Value
Hiding columns in Microsoft Excel is a standard procedure for cleaning up reports and dashboards....
ExcelHow to Insert a Hyperlink in an Excel Cell Without Changing Its Formatting
By default, when you insert a hyperlink into a Microsoft Excel cell, the application automatically...