Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
The Excel Team Blog » All Tags » Tables (RSS)

Browse by Tags

  • Excel Table or PivotTable?

    In Excel there are tables and PivotTables. You may wonder why you'd need to create a table when the whole worksheet already looks like one. And you've heard about PivotTables and how complex they are. To be able to use either effectively, it helps to know what each of them does, and when to use one or the other. Continue reading to learn more about the differences between tables and PivotTables. ...( read more ) Read More...

  • Give Excel tables a try

    Okay, you’ve got data arranged in spreadsheet rows and columns, with column headers. So why try tables? Well, tables make it easy to format data, sort, filter, add totals, and use formulas. With tables, you don’t need to fuss to get formatting just right. Excel automatically adds formatting that makes tables stand out from any other data on your spreadsheet. And if you don’t like the formatting you see at first, Excel has many table formats to select from. Tables automatically come...
    Filed under: ,

  • Table Improvements in Excel 2010

    Thanks to Ben Rampson for putting together this post. In today’s article I will outline three features in Office 2010 that improve table interaction in Excel. These feature additions build on the work started Excel 2007, addressing areas with significant customer feedback and further improving the feature area. The first table improvement feature, AutoFilters in sheet headers, builds on work completed in the previous version of Excel. In Office 2007, when the table header of a selected table is scrolled...
    Filed under: , ,

  • Excel 2010: New Search Filter

    Exploring large data sets and creating filters has never been easier than with Excel 2010. Tables, PivotTables and PivotCharts now have a new search functionality that easily enables you to find what you need, filter and repeat for a faster more efficient way of navigating those enormous data sets. Filtering FAST! In Excel 2010 when you click on the dropdown for autofilters, tables, PivotTables and PivotCharts you will now find a new search interface that enable swift navigation of extremely large...

  • A Robust Way To Reference Multiple Columns In a Table

    I’m sure many of you have built a spreadsheet like this before: you’ve got a table of data; one of the columns in this table contains a formula which references a span of columns in the same table. The number of columns you need to reference may change over time as requirements change. How do you you build this table in such a way that the number of columns can be changed without breaking the formula that references them? Let’s walk through a somewhat contrived but simple example to demonstrate the...
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.