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.

Keyboard Shortcuts

Quickly Insert the SUM Function

By Jeff Lenning | October 31, 2013 |

Let’s face it, Excel users probably insert the SUM function more often than any other function. As you know, we can improve our productivity by keeping our hands on our keyboards. This post discusses my favorite keyboard shortcut for inserting the SUM function. Keyboard Shortcut The SUM function is easily inserted into a workbook with…

Read More

How to Flatten, Repeat, and Fill Labels Down in Excel

By Jeff Lenning | July 25, 2013 | Comments Off on How to Flatten, Repeat, and Fill Labels Down in Excel

In this post, we’ll cover a handy technique for manually filling data labels down through an Excel range. This can also be referred to as repeating the labels, or, as flattening the data. Let’s get into it. Note: An alternative would be to use a Get & Transform query, as discussed in this post. Flattening…

Read More

Keyboard Shortcuts: Precedents

By Jeff Lenning | May 30, 2013 |

You know I love keyboard shortcuts.  I believe that keeping your hands on your keyboard will improve your speed.  I recently came across two very cool shortcuts I’d like to share in this post. Precedent First, let’s get a term cleared up.  A Precedent is something that comes earlier, or before.  In Excel, this idea…

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

Make an Excel Worksheet Very Hidden

By Jeff Lenning | April 4, 2013 |

Did you know that Excel has two levels of hidden worksheets?  Excel has “hidden” worksheets, and, “very hidden” worksheets. This post walks through the differences, and how to hide worksheets at each level. By default, all new worksheets are visible.  A visible worksheet’s tab appears in the bottom of the Excel window, enabling the user…

Read More