![]() ![]() ![]() And you know those pesky users will click the arrows, if they’re temptingly available. Or, maybe you like the pretty colours and automatic total row.īut, you don’t want to encourage users to filter the data - all the rows should always be visible. For example, you might set up tables because they’re a quick and easy way to create a dynamic range. Sometimes, though, you don’t want to have those filter arrows available. Note: If you don’t use the Excel Table feature, you’re limited to a single AutoFilter (or Advanced Filter) per worksheet. That way, the filtered rows in one table won’t affect the others. Just remember to stack the tables, instead of placing them side by side. I use this feature occasionally, when creating small tables on a summary sheet. You can even create more than one Excel table on a worksheet, and have a separate filter on each table. Most of the time, this is a welcome feature, and the arrows make it easy to sort and filter the columns. When you create an Excel Table in Excel 2007 or Excel 2010, autofilter arrows are automatically added to the heading cells. Thanks Lee! Here’s how to turn off filters in Excel table headings. On the Contextures page on Facebook, Lee suggested AutoFilters as a topic for some February posts. Now that the 30 Excel Functions in 30 Days challenge has ended, it’s time to look at a few other features.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |