Learn Excel Now

Conquer the Fear of Excel

Keep up to date on all the newest live trainings, events, and tutorials.

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Excel Formatting Essentials: Hiding Extra Rows & Columns

August 24, 2016 by Tyrone Pernsley 2 Comments

Removing Lines In Excel Featured ImageToday’s Excel blog post comes directly from a Learn Excel Now customer who was having trouble formatting her spreadsheet. She wanted to hide the extra rows and columns of the spreadsheet grid after creating a chart.

Here is what she wrote to Learn Excel Now:

“I produce weekly reports for my boss. He likes them to be in a 3D Pie Chart. But I can never seem to format it correctly. He showed me the report my coworker Carol sends him. It’s just a single chart – there is no spreadsheet behind it! It looks so clean and neat, like a single image. I want to be able to do that.”

And she can. For today’s example we will take the following spreadsheet and create a chart. Then we will format that chart so that it is the single image in the worksheet.

Removing Lines in Excel Image 1

To create the chart:

  • Highlight the group of cells you want to chart
  • Go to the Insert tab on the home ribbon
  • Select the type of chart you want to use (3D Pie Chart in this case)

To make the chart the single image on the worksheet:

  • Expand the chart to cover the underlying data in the spreadsheet
  • Click on the first column visible to the right of the chart
  • Enter the keyboard shortcut Ctrl+Shift+à (right arrow key) to go to the last column
  • Open the right click menu and select Hide
  • Click on the first row visible underneath the chart
  • Enter the keyboard shortcut Ctrl+Shift+Down Arrow Key to go to the last row
  • Open the right click menu and select Hide

You have now hidden all of the rows and columns in the spreadsheet, leaving the chart as the lone visible image on the worksheet. Here is a Gif showing what to do:

Removing Lines in Excel Gif 1

Using the keyboard shortcuts to go to the last row and column can come in handy in many situations. Anytime you want to make the spreadsheet a close off image, you can hide those rows and columns.

We here at Learn Excel Now hope you feel comfortable using this convenient formatting tool.

Like Learn Excel Now? Follow us on social media and share our content with your networks! And don’t forget to sign up for the Newsletter.

Kevin – Learn Excel Now

Filed Under: Formatting Tagged With: charts, Excel 2013, Excel formatting, formatting, hiding columns, hiding rows

Keep up to date on all the newest live trainings, events, and tutorials.

Comments

  1. Deb Wolfrum says

    August 24, 2016 at 3:19 pm

    I would like to add one comment… never-ever-ever hide Row 1 or Column A. I see in this demonstration Column A does not show and Row 1 is included in what rows are being hidden.

    Reply
  2. Erasmus Schneider says

    August 25, 2016 at 7:50 am

    This is a neat trick. However, I am using Excel 2016 on a Mac and I was unable to find a corresponding shortcut key combination to highlight all rows or columns below or to the right, repectively.
    Any suggestion?
    thanks

    Reply

Leave a Reply Cancel reply

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

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.

Sitemap

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-800-964-6033
384 Technology Drive
Malvern, PA 19355

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

Copyright © 2019 ­ Learn Excel Now

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