Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Creating Excel Tables: Quick Tip to Get Up-to-Speed

June 15, 2016 by Tyrone Pernsley

Excel provides you with many preset formatting options that you simply need to click to activate. One of the most common and most useful is to set your data as a table. There are many advantages to organizing your data in a table. It makes it easier to sort and filter important data, find totals automatically and create charts and graphs.

Setting your data as a table is fairly easy. First, you take your basic dataset:

Tables Image

And then you apply the table setting:

Excel Tables Gif 1

As you can see from the above Gif, there are many table styles to choose from:

Excel Tables Image 2

This gives you the power to customize your Excel table to your preference.

Pro tip: you can add more customization to your formatting by using the Cell Styles tool to add colors, text formatting and other elements to make your table pop:

Excel Tables Image 3

Once you have your table formatted, you can us the dropdown menu to quickly filter information:

Tables Image 1

You also have the ability organize your dataset in a variety of ways.

We here at Learn Excel Now hope you enjoyed this week’s quick tip on Excel Tables.

Like Learn Excel Now? Follow our social media pages and share out content with your networks!

Kevin – Learn Excel Now

Setting a Print Area in Excel

January 27, 2016 by Tyrone Pernsley

Setting the Print Area in ExcelPrinting with excel is always a challenge. Even excel experts have difficulties printing exactly what they want from their excel spreadsheets. If this is a daily fear or challenge at your workplace this post is for you!

Special Paste

To make printing excel spreadsheets quick and easy, you can define a print area that includes just that selection of cells that you desire to be printed. A print area is a range of cells that you can designate to print when you do not want to print the entire excel spreadsheet or continuously highlight cells then search for “Print Selection”

Print Area

To set a print area in excel spreadsheets, all you have to do is highlight the cells that you desire to be printed (called the print area) then move your cursor up to the Page Layout tab in the Page Setup group, click the Print Area dropdown arrow, then click Set Print Area. To check if you have done this correctly, you can go to the “print” option in the File group to make sure your designated cells will be printed.

To add cells to an existing print area, simply highlight the cells that are adjacent to your previous designated print area cells then move your cursor up to the Page Layout tab in the Page Setup group, click the Print Area dropdown arrow, and then click Add to Print Area. To check if you have done this correctly, you can go to the “print” option in the File group to confirm that the new cells have been added to your previous print area.

The only catch to this is that if the new cells that you would like to add are not adjacent to your existing print area than another separate printer area will be created. Additional print areas will be printed on separate pages.

The print area that you have designated will be saved when you save your excel spreadsheet so that each time you want to print this spreadsheet, your designated print area will only be printed.

Finally, if you would like to remove the print area, just highlight the cells that you would like to clear then move your cursor up to the Page Layout tab in the Page Setup group, click the Print Area dropdown arrow, then click Clear Print Area. Just remember that if you clear one print area than all the other print areas you have will be removed from your spreadsheet. To check if you have done this correctly, you can go to the “print” option in the File group to confirm that the print area has disappeared so that you can successfully print the entire excel spreadsheet.

Now you are a print area expert! You now know how to select, add, and clear print areas in excel spreadsheets. Hopefully this post has helped you conquer your fear of constantly printing specific sections of excel spreadsheets!

We hope you found todays quick and easy Excel lesson beneficial. Don’t forget to follow ups on Social Media and subscribe to the blog to get convenient, quick tips like this, and other great Excel training tips so that you can take the fear out of Excel.

Like Learn Excel Now? Sign up for the newsletter!

-Kevin, Learn Excel Now

Excel Tricks: Easy Data Fill

December 23, 2015 by Tyrone Pernsley

Excel is great for summarizing your data. You can create tables, charts, PivotTables, and more. The following tips are provided to give you the power to do easy data summary in Excel.
[Read more…]

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In