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

Excel Speed: Hidden Commands and QAT Buttons

By Jeff Lenning | October 23, 2018 |

Working fast is about knowing features and functions, for sure, but, it is also about how quickly we communicate with Excel. We can set up QAT buttons to activate frequently used commands … and … hidden commands. Hidden commands? Yes … Excel has far more commands than are provided in the standard ribbon tabs. It…

Read More

Excel Speed: 3 Keyboards Shortcuts worth Memorizing

By Jeff Lenning | October 17, 2018 |

In addition to knowing which features and functions can help you work faster in Excel, knowing a few keyboard shortcuts will help as well. You see, the faster you can communicate with Excel the faster you’ll get your Excel-work done. So, in this post, I’ll talk about 3 of my most-used shortcuts and then show…

Read More

Accounting Number Formats QAT

By Jeff Lenning | January 20, 2016 |

Excel has cell formatting designed just for accountants. Not surprisingly, it is called the Accounting Number Format. The built-in ribbon commands apply the format with two decimals and the currency symbol. This post demonstrates how to set up two handy QAT icons so that we can quickly apply this format with no decimals and without a currency…

Read More

Create Keyboard Shortcuts for your Favorite Excel Commands

By Jeff Lenning | June 19, 2014 |

Generally, you can improve your speed by keeping your hands on your keyboard. But, what do you do if there is no built-in keyboard shortcut to execute your favorite command? Well, one approach is to customize the QAT. This post discusses the Quick Access Toolbar and the related keyboard shortcuts it creates. QAT Shortcuts Microsoft…

Read More

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