List Unique Values from a Range
Excel has an easy built-in way to show the unique values from a list of numbers you provide. You can use it to filter a unique list of numbers, dates, strings or whatever you need to have listed.
Read More
How Do I Get Just the Last Word from a Cell?
This is an example of a question I recently received in the comment section of a post that I think others will find useful.
Read More
Ask Your Questions to Excel Hints
I receive questions all the time from readers of excel hints, both through the contact form as well as questions posted in the comment sections of posts. So let’s start sharing some of these with everyone.
Read More
Working with Userforms Part 1: Hello World! Button
Over the next few posts we will look at how to build a userform and put it to good use. Using a userform will provide additional functionality in your project that using the spreadsheet alone may not provide. One way to give your project that customized polished look, may be to incorporate the use of userforms.
Read More
Change the Default Location for Saving Files
Here’s a quick tip I recently found that I immediately began using when I came across it. Does it seem like Excel randomly picks where to save your files when you go to save them? Do you wish you could specify the default folder that first comes up when you try to save? This quick tip shows you how to make that change.
Read More
Loading ...