Excel Data Validation Update

I’ve finally updated my Data Validation intro video, so it shows the steps for creating a drop down list in Excel 2010, instead of Excel 2003. Note: These instructions apply to Excel 2007 too, in case you’re using that version. Data Validation Articles In honour of this momentous occasion, here are links to a few … Continue reading “Excel Data Validation Update”

Add Filter Markers in Excel Pivot Table

If you’re using Excel 2007 or Excel 2010, you can quickly see which fields in a pivot table have filters applied. For example, in the screenshot below, the ItemSold field has been filtered. The arrow drop down has changed to a filter symbol, with a tiny arrow. Earlier Excel Versions In Excel 2003 though, there’s … Continue reading “Add Filter Markers in Excel Pivot Table”

Different Excel Drop Downs from One Source

To help users enter data in a spreadsheet, you can create drop down lists with Excel’s Data Validation feature. For example, in an order form, you could provide drop down lists of customers, products, colours, sizes and shipping methods. Data Validation Source Usually, each of these lists would need a different Source in the Data … Continue reading “Different Excel Drop Downs from One Source”

Show or Hide Excel Data Entry Pop-Up Tips

When you set up a worksheet for other people to use, data validation messages can help them get started. The messages appear, like little ToolTips, when a user clicks on a cell. Users Show or Hide Messages After using the Excel workbook for a while, users might not need those messages anymore, and the pop-up … Continue reading “Show or Hide Excel Data Entry Pop-Up Tips”

Your Customized Excel Toolbars

Yesterday I posted a tip for adding the Refresh All button to the PivotTable toolbar, so you can quickly update all the pivot tables and queries in a workbook. Move Toolbar Buttons In the comments, Jan Karel Pieterse mentioned that he can press Ctrl+Shift, or hold the Alt key, then drag toolbar buttons to a … Continue reading “Your Customized Excel Toolbars”