Your future self will thank you if you need to access that information from a new, more complex workbook. If you've been creating tables from your data by going to the Excel ribbon, clicking Insert and then Table, there's an easy keyboard shortcut: After first selecting all your data with Ctrl-A (command-shift-spacebar for Mac), turn it into a table with Ctrl-T (command-T on Mac).īonus tip: Make sure to rename your table to something related to your specific data, instead of leaving the default titles Table1 or Table2.
#Create a cross tab table in excel for mac 2016 update#
In addition, if you make charts from your data, using a table means the chart will automatically update if you add new rows. Tables make it easier to sort, filter and visualize, as well as add new rows that maintain the same formatting as the rows above them. Tables are among the most useful features in Excel for data that is in contiguous columns and rows. So if you've got Power Query on an earlier version of Excel on Windows, a lot of these tips will work for you as well, although they may not work on Excel for Mac.) 1. And many of the query options in Excel 2016's data tab come from the Power Query add-in for Excel 20.
(Note: Keyboard shortcuts will work for the 2016 versions of Excel, including Mac those were the versions tested. Want to get more out of Excel? At Microsoft's inaugural Data Insights Summit last month, several experts offered a slew of suggestions for getting the most out of Excel 2016.
0 kommentar(er)
