Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
GoTo
Selecting every other row in Excel can be helpful. Aside from making it easy to get rid of duplicate rows, it can also be a great way to highlight important information, make the data easier to read with formatting, and more. However … if you’ve ever tried to select every other row in Excel, you…
Read More
When a formula contains an invalid cell or range reference, the #REF! error is displayed. #REF! in Excel is short for reference, and you’ll usually see it pop up when cells that were referenced in formulas are deleted. They can be a nuisance, but they’re usually pretty simple to find and fix. Here’s how to…
Read More
Have you ever called up the Go To dialog in Excel? There is a little button in it that enables you to go to special places in Excel. This post explores some of these special destinations. For starters, let’s call up the Go To dialog within an empty workbook. There are a few different ways…
Read More