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

Women holding her glasses up close to a computer screen and reading about how to select every other row in Excel

Four Ways to Select Every Other Row in Excel

By Excel University | January 3, 2023 |

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
Frustrated woman looking at a computer screen while learning how to fix #REF in Excel

What’s #REF in Excel and How to Fix It

By Excel University | November 15, 2022 |

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

Go To Special Places in Excel

By Jeff Lenning | April 25, 2013 |

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