Resources

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...

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...

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,...

When it comes to flipping the rows and columns your data in Excel you have two options: The Paste Special feature and the TRANSPOSE formula. Transposing in this sense means rotatating a range of values columns to rows or vice versa. In this guide, we’re going to show...

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...

In addition to using Paste Special to evaluate numbers with operators, you can also use this feature to modify formulas. Formulas can be bound to other formulas or named ranges with the use of mathematical operators. In this guide, we’re going to show how to use Paste...

If you need to modify multiple numbers at once, you can use the Paste Special feature of Excel. Although pasting only values or formatting are more common use cases of the Paste Special feature, it has more tricks in its pocket. In this guide, we’re going to show how...