by Ilker | May 5, 2020 | Excel Tips & Tricks
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...
by Ilker | Apr 20, 2020 | Excel Tips & Tricks
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...
by Ilker | Apr 17, 2020 | Excel Tips & Tricks
How to enter number starting with zero in Excel Having trouble with entering values that start with zero? By default, Excel removes any leading zeros in front of a number when you type in such a value and press enter. So, this behavior makes it a bit hard to enter...
by Ilker | Apr 14, 2020 | Excel Tips & Tricks
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...
by Ilker | Apr 6, 2020 | Excel Tips & Tricks
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...
by Ilker | Apr 1, 2020 | Excel Tips & Tricks
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...
by Ilker | Mar 31, 2020 | Excel Tips & Tricks
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...
by Ilker | Mar 31, 2020 | Excel Tips & Tricks
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...
by Ilker | Mar 27, 2020 | Excel Tips & Tricks
SUMIFS like other …IF or …IFS function are great tools to aggregate data based on a set of conditions. The downside of this approach is that the criteria must be supplied manually, especially when you need to create a summary table. In this guide, we’re going to show...