No circular references (when a formula or function references itsself) was one of the essentials in my Five Formulas and Functions Essentials post. Generally, if you have a circular reference, you’ll get an error message warning you about it. But the message doesn’t tell you where your circular reference is. And if you click Cancel on the [...]
Tag archives for Excel
Sorting Horizontally in Excel
Have you ever needed to sort your Excel column headings? In the data set above, I have sales figures for four products, each listed in no particular order. What if I wanted to see those columns sorted alphabetically, from Apples to Zooms. To do that: 1. Select the column headings you wish to sort and [...]
Sort by Last Name When the Cell Contains the Full Name
Generally, when someone asks how to sort by last name in a cell that contains both first and last name, I advise people to use the Text to Columns feature, but I’ve always wondered if there was another option. Today I found this video about how using the replace feature can isolate the last name [...]
category: Excel
The F8 Shortcut in Excel
Keyboard shortcuts are a fantastic way to save time. But when you accidentally hit a keyboard shortcut you didn’t know existed, they can be infuriating. More than once, I’ve run into someone for whom Excel seemed to be going haywire. Any time they used the arrow keys in Excel, cells would be selected. Any time [...]
Change Worksheet Tab Size in Excel
Sometimes I feel like the text on the worksheet tabs at the bottom of Excel is on the small side. Today I picked up a great tip from OfficeUsers.org, that tells you how you can increase the size of these tabs by increasing the size of your side and bottom scrollbars. When you increase the [...]
About
The McCombs Technology Training Team helps UT Austin business students, faculty, and staff with their technology resources, and with Microsoft Office. The trainers are Holly Green and Ben Bond.
Jeff Hauger, a previous team member, contributed several blog posts.
