I was running 14.5.4, so updated it as suggested. No help--I still have the same issue. That is, I can add data rows below the table, but they don't get added to the table itself. By the way, I have tried to get it to work on my other computer as well (the same old excel list was on both), and it doesn't work there either. I have some other lists, and on at least some of them I do not have the problem.

How do I add a new tab and the ribbon for the same in Excel 2011 on Mac using VBA or any other approach? All the links I see are about doing the same for Excel 2010 or 2013 for windows.

That is, I converted them to tables, and adding data works just find. The list in question is not huge, but it would be a pain to have to enter the data over again.

Thanks Jerry. Yes, I know about inserting rows--but as in your example, when I am at the bottom of the table I cannot add rows below. What I can do is insert rows above the last row that is recognized as part of the table. I can then use those rows as part of the table, and will keep a dummy row at the bottom. But that means I either have to be satisifed with inserting only one row at a time, or end up with my rows out of order.

Neither problem is critical, but I still would like to know why Excel doesn't recognize additional rows below as part of the table.

Most of the blog posts that deal with customizing the toolbars on Microsoft Office products are written for PC users. Now that MS Office has become the standard for office applications on the Apple Macintosh OS, too, let’s discuss how to.

Please note that these instructions are for the Office 2016 version of the software. Add/Remove Commands to the Ribbon Toolbar To access the configuration screen for the Ribbon toolbar, open a new workbook in Excel and then go to the Preferences menu and select Ribbon and Toolbar. The screen that comes up is of the double list box variety. If you’re unfamiliar with this type of screen, basically you have two boxes with buttons in between them that have arrows facing in opposite directions. You can move items in either of the lists back and forth to the other by selecting an item from the list you want to move the command from and then hitting the arrow button of the direction you wish to move it to.

You can also change the order in which the commands appear by dragging them up or down the list as you wish. There are also drop down list controls at the top of each box so that you can select which category in the toolbar that you want the command to come from or go to. This gives you the most flexible interface for customizing the ribbon toolbar any way you desire. Below is an example image of the Ribbon Toolbar configuration screen. Adding/Removing Toolbar Tabs or Groups By default, when you open the toolbar configuration screen, it opens with a list of the main tabs in the right-hand box and a list of available commands in the left-hand box.

To access the other tabs, you can select another category from the Customize the Ribbon drop down list. If you want to create your own tabs or groups that contain a custom list of commands, you can create a new tab by clicking the + button at the bottom of the Ribbon Customization list box and selecting New Tab or New Group from the context menu that appears. If you decide that there are too many tabs and they are cluttering up your user experience, then you can select the tab you want to go away and then select the – button at the bottom of the Ribbon Customization list box. If you want to rename the tab or group, select it in the list and then can click the gear button to the right of the – button. This will give you the settings context menu that will allow you to make changes. Quick Access Toolbar Customization If you wish to configure the Quick Access Toolbar, which is the one at the very top left-hand corner of the application, you need to select the Quick Access Toolbar option on the right of the toolbar selection bar.