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.

389 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

  40. Hi this is somewhat of off topic but I was wondering if blogs
    use WYSIWYG editors or if you have to manually code with HTML.

    I’m starting a blog soon but have no coding know-how so I wanted to get advice from someone with experience.
    Any help would be enormously appreciated!

    My blog real poker online

  41. п»їMedicament prescribing information. Read information now.
    [url=https://stromectolst.com/#]ivermectin 1mg[/url]
    Long-Term Effects. Get warning information here.

  42. [url=https://1winen.in]1win апк[/url]

    Mobile Version Allows Play Online Through Mirror or official website gambling resource. to the Customer acceptable all necessary functions and during mobile
    1winen.in

  43. Thank you for every other magnificent post. Where else could anyone get that type of info in such a perfect approach of writing?
    I’ve a presentation subsequent week, and I’m on the search for such information.

  44. Comprehensive side effect and adverse reaction information. Top 100 Searched Drugs.
    ivermectin 1
    Prescription Drug Information, Interactions & Side. Actual trends of drug.

  45. Actual trends of drug. Learn about the side effects, dosages, and interactions.
    [url=https://stromectolst.com/#]cost of stromectol medication[/url]
    Generic Name. Actual trends of drug.

  46. Everything about medicine. Learn about the side effects, dosages, and interactions.
    ivermectin
    safe and effective drugs are available. Medicament prescribing information.

  47. Everything information about medication. Learn about the side effects, dosages, and interactions.
    ivermectin 12 mg
    Everything what you want to know about pills. Get warning information here.

  48. earch our drug database. Everything information about medication.
    [url=https://mobic.store/#]how to buy mobic without rx[/url]
    Learn about the side effects, dosages, and interactions. Read information now.

  49. Everything what you want to know about pills. Learn about the side effects, dosages, and interactions.
    https://nexium.top/# where buy generic nexium without dr prescription
    Get warning information here. Actual trends of drug.

  50. Drugs information sheet. Generic Name. [url=https://avodart.science/#]can i purchase generic avodart without insurance[/url]
    drug information and news for professionals and consumers. Medicament prescribing information.

  51. Головоломки от Brain Test! Ответы и прохождение всех уровней игры, brain test 2 уровень.
    [url=https://brain-test3.ru/]brain test пройти[/url]
    как проходить игру brain test – [url=http://www.brain-test3.ru]http://brain-test3.ru/[/url]
    [url=http://google.mk/url?q=http://brain-test3.ru]http://www.google.tl/url?q=http://brain-test3.ru[/url]

    [url=https://mainichi-benkyou.blog.ss-blog.jp/2016-03-11?comment_success=2023-02-06T15:41:30&time=1675665690]Интересные и хитрые головоломки от Brain Test! прохождение всех уровней[/url] 0eaac1a

  52. Everything what you want to know about pills. Some are medicines that help people when doctors prescribe.
    [url=https://levaquin.science/#]can i buy cheap levaquin without insurance[/url]
    Everything what you want to know about pills. Get here.

  53. drug information and news for professionals and consumers. drug information and news for professionals and consumers.
    [url=https://mobic.store/#]cost of mobic[/url]
    п»їMedicament prescribing information. Cautions.

  54. чат бот что это – поможем в общении с клиентов
    [url=https://chat-bot-dlya-obshcheniya.ru]общаться с ботом[/url]
    бот с которым можно переписываться – [url=http://www.chat-bot-dlya-obshcheniya.ru/]http://www.chat-bot-dlya-obshcheniya.ru[/url]
    [url=http://www.websiteoutlook.com/www.chat-bot-dlya-obshcheniya.ru]http://google.ml/url?q=http://chat-bot-dlya-obshcheniya.ru[/url]

    [url=https://saigoncantho.com.vn/huong-dan-cai-dat-phan-mem-pencot-tren-iphone/#comment-5587]чат бот – Программа, задачей которой является взаимодействие, ведение бесед и реагирование на пользователя.[/url] 226660e

  55. Greetings! I know this is kinda off topic nevertheless I’d figured I’d ask.
    Would you be interested in trading links or maybe guest writing a blog article or vice-versa?

    My site discusses a lot of the same topics as yours and I think we could greatly benefit
    from each other. If you happen to be interested feel free to shoot me an e-mail.
    I look forward to hearing from you! Great blog by the way!

  56. safe and effective drugs are available. safe and effective drugs are available.
    [url=https://mobic.store/#]can i buy cheap mobic without rx[/url]
    Get here. Read information now.

  57. [url=https://lookerstudio.google.com/embed/reporting/cd3adad2-b471-4d41-878f-218ae65c39f9/page/7uoED]Robux Free 2023[/url] [url=https://lookerstudio.google.com/embed/reporting/c7d9f973-eaac-49e1-8758-38be3475a4d1/page/UxoED]How to Get Free Robux[/url]

  58. [url=https://autobuy96.ru/]срочный выкуп авто свердловская область[/url] – выкуп автомобилей после дтп челябинская область, выкуп автомобилей не находу челябинск

  59. Get information now. Long-Term Effects.
    [url=https://finasteridest.com/]order generic propecia[/url]
    Some trends of drugs. Get here.

  60. Everything about medicine. Comprehensive side effect and adverse reaction information. [url=https://amoxicillins.com/]amoxicillin 500mg tablets price in india[/url]
    Generic Name. Read here.

  61. Comprehensive side effect and adverse reaction information. safe and effective drugs are available.
    [url=https://finasteridest.com/]get generic propecia price[/url]
    drug information and news for professionals and consumers. Everything what you want to know about pills.

  62. Read information now. Drug information.
    [url=https://finasteridest.com/]buying cheap propecia without insurance[/url]
    Some trends of drugs. Some trends of drugs.

  63. Some trends of drugs. Read information now. [url=https://amoxicillins.online/]amoxicillin for sale[/url]
    Top 100 Searched Drugs. Commonly Used Drugs Charts.

  64. Everything information about medication. Top 100 Searched Drugs.
    [url=https://clomiphenes.com]can i purchase generic clomid without dr prescription[/url]
    Prescription Drug Information, Interactions & Side. Get here.

  65. Top 100 Searched Drugs. Everything what you want to know about pills. [url=https://amoxicillins.online/]amoxicillin no prescription[/url]
    drug information and news for professionals and consumers. Read here.

  66. Read now. Learn about the side effects, dosages, and interactions.
    [url=https://finasteridest.com/]how to buy propecia without a prescription[/url]
    Get information now. Get warning information here.

  67. Definitive journal of drugs and therapeutics. Comprehensive side effect and adverse reaction information.
    ed meds
    Drugs information sheet. Drugs information sheet.

  68. Get information now. Read here.
    [url=https://edonlinefast.com]buy erection pills[/url]
    Read now. earch our drug database.

  69. I am sorting out relevant information about gate io recently, and I saw your article, and your creative ideas are of great help to me. However, I have doubts about some creative issues, can you answer them for me? I will continue to pay attention to your reply. Thanks.

Leave a Reply

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