If you work with tables and lists in Excel, you may need to have them printed out. If there are several tables in a worksheet and you want to print a table or a list in the worksheet, there’s a built-in tool in excel that allows you print only a table or list, instead of the whole sheet.

Before you do this, you will have to create a table for the list.

After you have converted the list into a table, you can then go ahead to print the table in excel.

The command to print a table in excel is not available on the Ribbon, and so you will have to add it to the Ribbon or on the Quick Access Toolbar.

To do this, here are the steps you should follow:

1. Right-click on the Ribbon and select ‘Customize the Ribbon’

2. Under the ‘Choose commands from’ field, select Commands Not in the Ribbon

3. Then scroll down to select Print List

Before you add it, you will need to first create a new group tab to add to the Excel ribbon.

4. So click on the + sign of Home in the Main Tabs to bring down the list in the Home tab.

5. Click on ‘New Group’ to add the new group to the Home tab

6. Click on ‘Rename’ to rename it. Here, I have renamed the new group ‘Print Table

Now you have the Print Table tab added to the Home tab group. You can move it up or down to the location you want it.

7. Now, add the Print List from the dropdown list to the new group tab you created

8. Click ok

9. Go to Home tab and select the ‘Print Table’ command you just added

Note:

You have to select any cell in the list or table to activate the ‘Print Table tab. If the table or list is not selected, the tab will not be activated as shown below:

10. Now you can select any cell in the table you want to print and click on ‘Print Table’ to print the list or table.

10 Replies to “How To Print a Table in Excel the Easy Way (Tables and Lists)”

  1. Very good blog you have here but I was curious if you knew of any forums that cover the same topics discussed in this article? I’d really love to be a part of online community where I can get suggestions from other experienced individuals that share the same interest. If you have any recommendations, please let me know. Many thanks!

  2. hello there and thank you for your information – I have definitely picked up anything new from right here. I did however expertise a few technical points using this site, as I experienced to reload the site a lot of times previous to I could get it to load correctly. I had been wondering if your hosting is OK? Not that I’m complaining, but sluggish loading instances times will sometimes affect your placement in google and could damage your quality score if ads and marketing with Adwords. Well I’m adding this RSS to my e-mail and could look out for much more of your respective fascinating content. Make sure you update this again very soon..

  3. Hi, Neat post. There is an issue along with your site in web explorer, could test thisK IE nonetheless is the marketplace chief and a big portion of folks will omit your magnificent writing because of this problem.

  4. Together with every little thing which seems to be developing inside this specific subject material, many of your points of view happen to be quite exciting. Nonetheless, I appologize, because I do not give credence to your entire strategy, all be it refreshing none the less. It seems to us that your comments are generally not totally validated and in fact you are yourself not even entirely convinced of the argument. In any case I did enjoy looking at it.

  5. The next time I read a blog, I hope that it doesnt disappoint me as much as this one. I mean, I know it was my choice to read, but I actually thought youd have something interesting to say. All I hear is a bunch of whining about something that you could fix if you werent too busy looking for attention.

  6. Undeniably imagine that that you said. Your favourite reason seemed to be on the web the simplest factor to understand of. I say to you, I definitely get annoyed even as people think about concerns that they plainly do not understand about. You managed to hit the nail upon the top as well as outlined out the whole thing without having side effect , other folks could take a signal. Will probably be back to get more. Thanks

Leave a Reply

Your email address will not be published.