Back in Excel 2007,. That simple name hides a quite different and powerful Excel option that, in our view, Microsoft hasn’t explained very well. Excel is often used for lists and Excel Tables make managing and extending those lists a lot easier. In fact, ‘Excel Lists’ was the name of the Tables predecessor in Excel. Word and PowerPoint have a ‘Tables’ feature but that’s quite different from Excel Tables. Versions Excel Tables are in Excel 2007, 2010, 2013 and 2016 for Windows, though the exact features will have changed over the decade.

Aug 13, 2017 - There's nothing wrong with leaving blank cells in a spreadsheet, but. Press the triangle icon between the A column and the 1 row to select the entirety of the data. How to minimize a window on chrome for mac. How to Play Cuphead and Other PC Games on a Mac. Resize all pictures at the same time There is another way to resize all pictures in active worksheet quickly and conveniently. Step 1: Select all pictures in active worksheet.

Tables are also in Excel 2016 for Mac and seem much the same as Office 2016 for Windows. Format as Table You’ve probably seen Tables because they have a prominent place on the Home tab. The label ‘Format as Table’ and the pull-down gallery gives the notion that Excel Tables are all about appearance/formatting.

Microsoft also gives this impression in their description of Tables. More than just appearances In this article we’ll show you what’s useful in Excel Tables.

We’ll leave aside the styles and galleries to show you the real benefits of tables. Before Excel Tables To understand Tables, let’s look at Excel life before they existed. Lists in Excel were a simple set of columns and rows. You could add some structure to the list by clicking the Home Sort and Filter Filter button. That made Row 1 into headers and little pull-down menus with sort and filter options. The big problem with this was naming and keeping the data together. If you added new rows to the list, you had to change any references to include the new rows.

For example, any formulas or refences with range A1:D5 would have to be changed to A1:D6 when you added a row. Defining a named range helped, but you still needed to redefine the range each time the list was changed. Excel Tables largely solve the naming and expansion issues. They make list sorting and filtering better plus a whole lot more. What makes Excel Tables different Tables are automatically Excel objects that you can refer to in formulas etc.

They are automatically given names, starting with ‘Table1’, shown on the left of the Table Tools Design ribbon. But you can and should change the name to something more obvious. Right next to the Table Name is the important Resize Table option but you may not ever need it because of the vital Excel Table trick, Automatic Resizing. Automatic Resizing Excel Tables automatically expand when you add new rows to the bottom! It’s hard to underestimate the importance and usefulness of this seemingly simple addition. Example of function in excel.