Check out a wide range of Excel topics, from basic functions and formulas to more advanced topics like VBA and macros.
Whenever I work on a lengthy report that I need to forward to someone for review, I usually look for ways to highlight sections in the report that require attention. I used to add cell colors like yellow to do this. But then, some reports already have cell colors in them, so adding more would … Read more
When writing a report in Excel, most of us have this particular list that we regularly add in a specific order (e.g., a list of departments, regions, or stores). Typing them once is fine. But doing it every single time is a different story. It can become pretty annoying, especially if you have a long … Read more
Copying column widths is easy to do in Excel. We only need to: And that’s it! We are good to go. Easy-peasy, right? Excel, unfortunately, doesn’t have a similar feature for copying row heights. But don’t worry! In this article, I’ll show you four methods to copy row height in Excel. Each of them has … Read more
Dollar signs ($) in Excel are great for quickly identifying cells that contain monetary values. There are times, however, that it would be better to remove them. In this article, I’ll show you four different ways to do this. Each approach has its pros and cons, so choose whichever fits your needs. The first two … Read more
Timestamps in Excel typically contain both the date and the time. We often, however, disregard the time and only use the dates in timestamps. In this tutorial, I will show you varying ways you can do to remove the time – both temporarily and permanently. Before I give a breakdown of the various methods to … Read more