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.

220 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

  7. I have read some good stuff here. Definitely worth bookmarking for revisiting. I wonder how a lot attempt you set to make this kind of excellent informative site.

  8. Good day I am so glad I found your blog page, I really found you by
    accident, while I was browsing on Askjeeve for something else, Anyhow I am here
    now and would just like to say cheers for a tremendous post and
    a all round thrilling blog (I also love the theme/design),
    I don’t have time to go through it all at the moment
    but I have saved it and also added in your RSS feeds,
    so when I have time I will be back to read more, Please do keep
    up the superb b.

    my website online calculator

  9. Howdy! Someone in my Facebook group shared this
    site with us so I came to look it over. I’m definitely enjoying the
    information. I’m book-marking and will be tweeting this to my followers!
    Superb blog and terrific design and style.

  10. Just desire to say your article is as astounding. The clearness in your post is just nice and i can assume you are an expert on this subject.

    Fine with your permission allow me to grab your feed to keep up to date with forthcoming post.

    Thanks a million and please keep up the gratifying work.

    my web blog: June calendar printable

  11. Hey, I think your blog might be having browser compatibility
    issues. When I look at your blog site in Firefox, it looks fine but when opening in Internet Explorer, it has
    some overlapping. I just wanted to give you a quick heads up!
    Other then that, superb blog!

  12. Hello There. I found your weblog using msn. That is a very neatly written article.
    I’ll make sure to bookmark it and come back to learn more of your helpful information. Thank you for the post.
    I will definitely return.

  13. สล็อต xo เว็บไซต์ตรง ไม่ผ่านเอเย่น สมัครสล็อต  ใช้เวลาไม่ถึง 5 นาที พร้อมรับยูสเซอร์จากการสมัคร สล็อต ได้ทันที ท่านจะได้พบกับเกมที่น่าเล่นเพลิดเพลินทั้งได้เงินและความสนุก

  14. Hi, i feel that i noticed you visited my web site so i got here to
    return the prefer?.I am trying to find issues to enhance my website!I guess
    its good enough to use a few of your concepts!!

  15. Wow that was unusual. I just wrote an very long comment
    but after I clicked submit my comment didn’t appear.
    Grrrr… well I’m not writing all that over again. Regardless, just wanted to say wonderful blog!

  16. Hi! I’ᴠe been following your wеbsite for a long
    time now and finally ɡot tһe courage to go ahead ɑnd give
    үou print a calendaг (Stanton) ѕhout out from Kingwood Texas!

    Just wantеd to say keep up the greаt job!

  17. It’s nearlʏ imⲣߋssіble tⲟ find knowledgeable
    people in this particular topic, but you seem like you know what you’re talking ɑbout!
    Thanks

    my site :: pгintable calendar yearly, Nichole,

  18. I like the helpful infо you provide in your articles.
    I ᴡill bookmark your bloɡ and take a look at again гight here frequently.
    I’m quite sure I will be informed many new stuff proper right here!
    Best of luck for tһe next!

    My web-sіte monthly calendar (Alonzo)

  19. Thank you for great information. Hello Administ . Onwin engelsiz giriş adresi ile 7/24 siteye butonlarımızla erişim sağlayabilir ve Onwin üyelik işlemini 3 dakika da halledebilirsiniz. onwin , onwin giriş , onwin güncel giriş , onwin

  20. I’ve been browsing online more than three hours today, yet
    I never found any interesting article like
    yours. It is pretty worth enough for me. Personally,
    if all webmasters and bloggers made good content as you
    did, the web will be a lot more useful than ever before.

  21. I blog often and I really thank you for your information. Your article has
    truly peaked my interest. I’m going to take a note of your site and keep checking for new details about once per week.
    I subscribed to your Feed too.

  22. In today’s digital world, social media sites, especially Instagram, remains a well-known tool for folks to engage. It’s utilized to connect with other individuals anywhere you are in the globe. As an online platform, Instagram allows its own users to discuss as well as view pictures as well as online videos, https://matkafasi.com/user/grayshop7.

  23. Hi there I am so delighted I found your weblog, I really found
    you by accident, while I was looking on Yahoo for something else, Regardless I am here now and would just like to say many
    thanks for a incredible post and a all round entertaining blog (I also love the theme/design), I don’t have time to look over it all at the moment but I have saved it and also added your RSS feeds, so when I have time I
    will be back to read much more, Please do keep up the superb b.

  24. I have been browsing on-line greater than three hours lately, but I by no means found any attention-grabbing article like yours. It’s beautiful worth enough for me. In my view, if all site owners and bloggers made good content material as you probably did, the internet shall be much more useful than ever before. “Truth is not determined by majority vote.” by Doug Gwyn.

  25. cancun adults all inclusive resorts
    [url=https://missihighmor1976.acidblog.net/46124854/story-about-banana-cream-pie-recipe-graham-cracker-crust-easy]hoteles cancun todo incluido[/url]

  26. cheap cancun all inclusive vacation packages
    [url=https://mecuditi1989.blog2learn.com/62972831/story-about-easy-banana-cream-pie-recipe-with-cooked-pudding]cancun area resorts[/url]

  27. Just want to say your article is as astonishing. The clearness to your publish is just cool and that i can think you’re a professional on this subject. Well along with your permission allow me to grasp your feed to stay updated with forthcoming post. Thank you 1,000,000 and please keep up the enjoyable work.

  28. Can I show my graceful appreciation and show my inside to really good stuff and if you want to really
    findout? Let me tell you a brief about how to learn SNS marketing I am always
    here for yall you know that right?

  29. [url=https://marshrutka-dnepr-kharkov.dp.ua/]Маршрутка Днепр Харьков[/url]

    Эпизодично наказывать в соседственный яяма нужно быстро, что-что собственного экстрим-спорт я бы не сказал или оно на ремонте. Яко делать на данном случае? Прийти на выручку труповозка Днепр-Харьков, кок пускается в течение этап назначения чуть-чуть раз в день. Этакий подход позволит я мухой отмахать 215 километров, за 3-4 момента скрываться сверху местности – хоть (а) также вернуться назад!
    Маршрутка Днепр Харьков

  30. Hi! I know this is somewhat off topic but I was wondering if you
    knew where I could find a captcha plugin for my comment form?
    I’m using the same blog platform as yours and I’m having problems finding one?
    Thanks a lot!

  31. [url=https://drugsoverthecounter.shop/#]best over the counter cold medicine[/url] bronchial inhalers over the counter

  32. [url=https://drugsoverthecounter.com/#]epinephrine over the counter[/url] best over the counter diet pills

  33. [url=https://drugsoverthecounter.shop/#]over the counter blood pressure medication[/url] best over the counter gas and bloating medicine

  34. [url=https://drugsoverthecounter.com/#]over the counter ear infection medicine[/url] zofran over the counter

  35. my latest blog post [url=https://freesoftin.us/activate-adobe-substance-3d-designer-11-2-0-full-crack-by-zambo/]torrent adobe substance 3d designer serial key portable free[/url]

  36. >>> [url=https://viagranix.com]click here to find out more [/url] <<<

    *****
    – 24/7 Customer Support
    – No Prescription Required
    – Top Quality Medications
    – Worldwide Shipping
    – Bargain Prices
    *****

    We are found by keywords:
    gst prescribed viagra online
    over the counter replacement for sildenafil
    curtis pharmacy sildenafil
    sildenafil citrate oral jelly 100mg
    cheap viagra
    viagra advertised for 99 pills for 40 dollars
    why do i not get hard with generic viagra

    https://viagranix.com
    price to buy viagra
    losartan and sildenafil citrate
    pills like viagra
    fast delivery generic viagra
    what labs are monitored for sildenafil
    sildenafil products for sale

  37. Pingback: 3checking
  38. [url=https://over-the-counter-drug.com/#]pantoprazole over the counter[/url] ivermectin over the counter walgreens

  39. ничего подобного
    _________________
    vbet rasmiy sayti – [url=http://uzb.bkinf0-456.site/332.html]bukmeykerlar liniyasini kuzatish xizmati[/url] , netbet rasmiy veb-sayti

Leave a Reply

Your email address will not be published. Required fields are marked *