Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Excel has some useful features that allow you to save time and be a lot more productive in your day-to-day work. One such useful (and less-known) feature in the Custom Lists in Excel. Now, before I get to how to create and use custom lists, let me first explain what’s so great about it. Suppose …
When you have to select a block of cells, the easiest way is to use a mouse, click on a cell and then drag to cover all the cells that you want to select. Or if you’re a keyboard person, you can hold the shift key and move the cursor to make the selection. But …
Conditional Formatting in Excel enables you to quickly format a cell (or range of cells) based on the value or the text in it. For example, below I have an example where I have student’s scores and I have used conditional formatting to highlight all the scores that are above 80. If you’re interested in …
Excel is a really thought out spreadsheet tool and has so many simple tricks that can boost your productivity and save time. But at the same time, there are some simple things that are missing and often leads to a lot of frustration. For example, there are so many ways for you to quickly select …
If you want all the text in your worksheet to stay visible, dragging every column and row by hand gets old quickly. AutoFit can size them from their current contents, so you don’t have to guess the right width or height. In this article, I’ll show you how to AutoFit columns and rows, what to …
Using multiple worksheets in an Excel workbook is an easy way to keep your data organized. For example, you can have different sheets for different regions, or for different months/year, or different projects, etc. And when working with multiple sheets, you may sometimes need to change their names. In this Excel tutorial, I will show …
If you often print your data/work in Excel, I am sure you have faced the issue where it prints multiple pages instead of one single page. Sometimes, it’s so frustrating that a new page is printed just to accommodate a few extra lines of data (which also leads to wastage of paper). There are some …
Apart from using Excel with numeric data, a lot of people also use it with text data. It could as simple as keeping a record of names to something more complex. When working with text data, a common task is to make the data consistent by capitalizing the first letter in each cell (or to …
If you have worked with formulas in Excel for some time, I am sure you have already met the #REF! Error (reference error). Since this is quite common, I thought of writing a tutorial just to tackle the #REF! error. In this Excel tutorial, I will cover what is the #REF! error, what causes it, …
©trumpexcel.com – Free Online Excel Training
