You can use option buttons on a worksheet, to make it easy for people to pick just one item from several options. There's no programming required – just set up a group box, add option buttons, and link the buttons to a cell. The video at the end of this post shows you those steps.
The option buttons send a value to their linked cell, and we'll take a look at how you can use those numbers.
Continue reading Option Button Scores With CHOOSE Function
In this week's roundup, get started with Office 2016, nominations for a Spreadsheet Hall of Fame, and much more.
Continue reading Excel Roundup 20151005
Today is the 30th anniversary of the first release of Microsoft Excel. To celebrate this auspicious occasion, I invited you to share your memories of getting started with Excel, and thank you for your contributions!
In 2005 there was an Excel 20th anniversary celebration, and I wasn't invited to the party, but I was at Microsoft that day, as you can see in the picture below.
Continue reading Happy 30th Anniversary Excel!
In this week's roundup, learn some Excel history, read Office 2016 reviews, download free add-ins to reduce Excel errors, and much more.
Continue reading Excel Roundup 20150928
Next Wednesday is the 30th anniversary of Excel's first release, and I'd love to hear your Excel memories, and share them here next week. The more the merrier, so please take a few minutes to jot down a few memories.
Here are some questions, to help you get started:
Continue reading When Did You Start Using Excel?
In this week's roundup, avoid nested IF formulas, understand circular references, see bad charts, and much more.
Continue reading Excel Roundup 20150921
Did you know that today is Talk Like a Pirate Day?
Excel is joining the fun, and using a few column headings to say, "Aarrrrrr!"
Do you know of any other pirate words that it can say?
Have a Happy Talk Like a Pirate Day, and step away from the computer for a while!
Do you use the IF function in your workbooks? It's helpful if you want to check something, and then show a result based on the result of your test.
But, things can go horrible wrong if you try to do too much with IF -- sometimes other functions do a better job.
Continue reading Beware the Nested IF Formula in Excel
In this week's roundup, create a seating plan, do case sensitive lookups, learn Excel from Joel Spolsky, and more.
Continue reading Excel Roundup 20150914
What was the first function that you learned in Excel – if you can remember that far back?
I'll bet it was the SUM function. There's an AutoSum button on the Ribbon that makes it very easy to put a total – just select a blank cell below a column of numbers, and click that button.
Continue reading 7 Ways to Sum in Excel