Excel Tips and Tricks

How to get Workbook Statistics in Excel

How to get Workbook Statistics in Excel

Workbook Statistics is a new feature Microsoft has released recently for Excel 365 users. Workbook Statistics is a dialog box that contains information about your spreadsheet such as the number of sheets, tables, formulas, charts, and PivotTables. In this guide, we're...

How to set an Excel expiration date

How to set an Excel expiration date

You may want to set an expiration date for a workbook and prevent access for when creating a trial application, or simply ensuring that the application data is up to date. Unfortunately, Excel doesn’t have a built-in tools to handle this scenario, but you can use VBA...

How to Remove a Line Break in Excel

How to Remove a Line Break in Excel

You sometimes get text with line breaks when copying a text from a website or word document. Although line breaks can be useful for a better layout, they can also make Excel tables look weird. In this guide, we’re going to show you how to Remove Line Breaks in Excel...

How to customize the Excel status bar

How to customize the Excel status bar

Excel's Status bar which is found on the bottom of the application window (like in some other Windows applications), displays additional information about various details, such as some workbook operations, statistical and aggregated values for a selected cell range,...

How to add a diagonal line to a cell in Excel

How to add a diagonal line to a cell in Excel

A diagonal line in a cell is not a very common sight in Excel workbooks. Although they have a somewhat limited use, you can improve your worksheet visuals with simple tricks like this one. In this guide, we’re going to show you how to add a diagonal line to a cell in...

How to save an Excel chart template

How to save an Excel chart template

Charts are a staple in creating dashboards and reporting. It's only natural that Excel supports many chart types with various features. The ability to save templates is very useful for quick access to frequently used chart types. In this guide, we’re going to show how...