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.

VBA

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
Man multitasking while using Microsoft Excel macros to make his spreadsheets faster

Make Your Spreadsheets Faster Using Microsoft Excel Macros

By Excel University | August 2, 2022 |

Do you use Excel frequently and find that you often have to repeat the same tasks over and over? If so, you can use Microsoft Excel macros to automate those tasks and cut down on how much time it takes to complete them! You can create a macro by recording your keystrokes and mouse clicks,…

Read More
Businesswoman walking up steps that represent how to become proficient in Excel in 6 easy steps

How to Become Proficient in Excel in 6 Easy Steps

By Excel University | June 15, 2022 |

Do you know the Excel basics, but want to become a pro? We’re outlining the six steps you can take to learn how to become proficient in Excel.

Read More
Text that says "Excel Formulas Tutorial: What are Formulas and How to Use Them" over a man stacking blocks

Excel Formulas Tutorial: What are Formulas and How to Use Them

By Excel University | April 19, 2022 |

Formulas are what make Excel, Excel. They’re how we perform both simple and complex calculations, and the possibilities are nearly endless as far as what they can do. Today, we’re going back to the basics with an overview of what formulas are and how to use them, as well as sharing our Excel formulas tutorial…

Read More

Extract URL from Hyperlink with an Excel Formula

By Jeff Lenning | February 22, 2022 |

Let’s say you have a hyperlink in a cell in Excel. The hyperlink may have friendly text, such as Click Here, but when you click the link it takes you to a URL such as https://www.excel-university.com. Now, let’s say you want to extract that URL from the hyperlink using an Excel formula. Well … to…

Read More

Insert and Name Sheets from Cell Values

By Jeff Lenning | February 24, 2020 |

In this post, I’ll share a short snippet of VBA code that creates new worksheets based on the names stored in cell values. This can be helpful when you have a list of departments, and want to create one worksheet for each department. Or a list of accounts, or employees, or regions, and so on.…

Read More

SUBTOTAL Macro v2

By Jeff Lenning | September 12, 2018 |

The SUBTOTAL function is one of my favorites. So, I wrote a post about it a while back that provided a macro to insert it. The macro worked kinda like the AutoSum command, but it inserted the SUBTOTAL function instead of the SUM function. Gary posted a suggestion for enhancing the macro, so, I wrote…

Read More

Clear the Input Cell Style for Printing

By Jeff Lenning | February 16, 2017 |

I really like to highlight input cells by applying the Input Cell Style. I also like to try to place all of the input cells for a workbook on a single worksheet. That way, it is easy to update the input cells, and since they aren’t on any of the sheets I need to print,…

Read More

Number Format Macro

By Jeff Lenning | March 17, 2016 |

Excel users often spend a bunch of time applying the same format to number cells. Some numbers are stored values and others are calculated with formulas. The task of manually applying the same format to all of the numbers in the worksheet, especially when the numbers aren’t in a continuous range, can feel quite repetitive.…

Read More
Record Excel Macro by Jeff Lenning

Macro Toolbox

By Jeff Lenning | February 18, 2016 |

When storing utility macros, Excel users often elect to save them in the Personal Macro Workbook. The advantage is that the macros are available whenever Excel is running. The disadvantage is that if you switch or upgrade computers, you may forget to take a backup of the Personal Macro Workbook and thus lose your macros. In…

Read More