How To Delete Every Other Row In Excel (or Every Nth Row)

This tutorial details deleting every other row in Excel. The requirement of the time may be some systematic sampling or selection, keeping data of even-numbered weeks/months, or maybe just slashing out one-half of too much information.In this guide, we demonstrate deleting alternate rows using functions & filtering and VBA. We use the … [Read more...]

#REF! Error In Excel – How To Fix

Say you’ve got this worksheet from a couple of months ago ready to work with. You pull it up on your computer and start working. You’re updating the worksheet and suddenly, you notice that a few of the old formulas are showing a #REF! error. The fix? Just reference the correct element.#REF! error is pretty simple to solve. In this tutorial, … [Read more...]

How To Copy Formatting In Excel (3 Easy Ways + Shortcut)

What happens when you copy-paste, let’s say a column of information, in Excel? You get the values and the font and cell formatting; an exact duplicate. Today’s tutorial is about copying the format of one or more cells to other cells in the same worksheet, workbook, or even to other workbooks.That brings us to the next question. What happens … [Read more...]

How To Count Number of Characters In Excel (3 Easy Ways)

Let’s learn how to count the number of characters in Excel. The count could be performed on a single cell and even a range of cells. While learning that, let’s also shed some light on counting specific characters too. This tutorial will teach you all that is mentioned above using the LEN function with different combos of the SUBSTITUTE, SUMPRODUCT, … [Read more...]

How To Insert a Checkmark Symbol In Excel

A checkmark or a tickmark can be used in Excel and this is the face of it - ✓Why do you need a checkmark in Excel? Most commonly, a checkmark says "Done". A more representable way of having "Done" and "Not Done" or "Yes" and "No" on the worksheets can be ticks and crosses. If that reminds you so much of a teacher's red ink on your work, … [Read more...]

#VALUE! Error In Excel – How To Fix

Excel doesn’t make mistakes, but you as a user, might. If you’ve entered a formula, and Excel can’t understand what one or more of the elements in the formula are trying to do, or if they are incorrectly entered, you’ll receive an error. The fix for each type of error is different.In this article, we’ll walk you through how you can resolve the … [Read more...]

How To Change Border Color In Excel (3 Easy Ways)

If the regular black borders are not doing it for you and your organization senses are screaming for order, color sorting will do what nothing else can. Many a time it may not be practical to change the font color. While color fill is another good sorting friend, this tutorial is all about changing border colors.Why switch out of black borders? … [Read more...]

How To Remove Time From Date/Timestamp In Excel

In this tutorial, we are dealing with timestamps including dates. If you need to extract date from the timestamp or erase the time component from a date, we will look into a few features and functions to achieve it.With a present data of timestamps, you may need to single out the dates and you know how Excel tries that you do the least work … [Read more...]