Excel tips and tutorials
A data validation drop down list in Excel only shows one column of items. See how to show multiple columns in Excel drop down list — we’ll use something different from an ordinary in-cell drop down.
Continue reading “Show Multiple Columns in Excel Drop Down List”
Last week, you had a chance to win John Walkenbach’s new book – 101 Excel 2013 Tips, Tricks & Timesavers, thanks to Katie Mohr at Wiley. Thanks for all your comments – those were great tips!
How hot was it in your neighbourhood last week? It was so hot, here in Mississauga, that I stayed inside, most of the week. On the bright side, I got lots of work done, but I’d rather have cooler temperatures, than hot, muggy days.
Do you ever put a picture or clip art on a spreadsheet? I don’t use them very often, but occasionally I’ll add a small picture on an instruction worksheet, or insert a company logo on a printable form.
Continue reading “Remove Picture Background and Excel Book Giveaway”
You can create drop down lists on a worksheet with Excel’s data validation feature, and they make data entry much easier – usually! Sometimes things go wrong though, like missing drop down arrows in Excel 2013. Have you seen that problem?
Do you ever use the Data Table feature in Excel? It’s one of the “What-if Analysis” tools, found on the Ribbon’s Data tab, along with Scenario Manager, and Goal Seek.
You can experiment with one or two variables in a formula, and see formula results in an Excel Data Table, in a compact layout.
Continue reading “See Formula Results in an Excel Data Table”
To make it easy for people to enter data on a worksheet, you can insert a check box control, using the Form Control tools on the Developer Tab. Then, use check box result in Excel formula solutions.
When you create a named Excel table with the Table command on the Ribbon’s Insert tab, the table retains any formatting that it currently has, and the default Table Style is applied.
Last week, I was updating my web page that shows how to show a combo box in a cell that has a drop down list. Here’s a screen shot of that workbook.
In Excel, you can set up drop down lists that are dependent on the selection made in another cell. In this example, you select a region in column B, and only the customers in that region are in the dependent drop down list in column C.
