K2E Canada Inc
  • Home
  • TRAINING
    • WEBINARS
    • UPCOMING EVENTS
    • ROAD TO EXCELLENCE ONLINE SEMINAR
    • SEMINARS
    • CONFERENCES
    • INSTRUCTORS >
      • ALAN SALMON
  • NEWSLETTER
    • Signup
  • ABOUT
  • CONTACT
  • BLOG
  • Home
  • TRAINING
    • WEBINARS
    • UPCOMING EVENTS
    • ROAD TO EXCELLENCE ONLINE SEMINAR
    • SEMINARS
    • CONFERENCES
    • INSTRUCTORS >
      • ALAN SALMON
  • NEWSLETTER
    • Signup
  • ABOUT
  • CONTACT
  • BLOG

Turning Headers On and Off

3/9/2020

0 Comments

 
You already know that the headers in a worksheet come in handy. This is the gray area, at the left and top of a worksheet, which indicates the row and column label used by Excel. You click in the header area if you want to select either a row or header. You also know that you can adjust the height or width or rows or columns by using the row and column header area.

Even though this area is very useful, there may be times when you do not want it displayed. For instance, if you are using Excel to create an on-screen form, then the header areas may be distracting to the intended users of the form.

To control whether headers are turned on or off, follow these steps:
  1. Display the Excel Options dialogue box. In Excel 2010 or a later version, display the File tab of the ribbon and then click Options.)
  2. At the left of the dialogue box, click Advanced.
  3. Scroll through the available options until you see the Display Options for this Worksheet section.
  4. Make sure the Show Row and Column Headers checkbox is selected. If cleared, then the header area is not displayed.
  5. Click on OK.

As with other tasks in Excel, there are additional methods that accomplish the same result, as shown above. These methods use various tabs of the ribbon. One method is to display the Page Layout tab of the ribbon, then clear the View checkbox under Headings in the Sheet Options group. Another method is to display the View tab of the ribbon and clear the Headings checkbox in the Show group.

Notice that Excel does not allow you to control the display of row and column headers individually—they are either both on or both off.

Alan Salmon

0 Comments



Leave a Reply.

    Categories

    All
    Adobe
    Advisory
    AI
    Artificial Intelligence
    Automation
    Business Intelligence
    Cloud Computing
    Collaborate
    Collaboration
    COVID 19
    COVID-19
    CPA
    Cybersecurity
    Ecommerce
    Excel
    Google
    Grammarly
    Internal Priorities
    KPIs
    LET
    Microsoft 365
    Microsoft Teams
    Office
    Office 365
    Online Shop
    Outsourcing
    PivotTables
    Power BI
    PowerPoint
    Productivity
    Ransomware
    Security
    Small Business Accounting Software
    Technology
    Tech Update
    Windows
    Windows 10
    Word
    Work At Home

    Authors


    Ward Blatch
    Ward provides consulting and training services as the Managing Director of K2E Canada Inc. He joined K2E Canada in 2005 and is responsible for the Canadian operations of this international consulting group, which provides professional development technology education for accountants across Canada and the US. Ward lives in rural Nova Scotia and can be reached at ward@k2e.ca.

    Alan Salmon
    Alan Salmon is recognized as Canada’s leading analyst in the area of accounting technology. He has nearly 35 years of business, management systems, education and journalism experience, has a degree in Science and an Advanced Teaching Certificate from the University of Toronto. Alan has now retired from teaching and lives in Brampton, Ontario with his wife Nancy. He can be reached at alan@k2e.ca

    Tommy Stephens
    Tommy is one of the shareholders in K2 Enterprises, affiliating with the Firm in 2003 and joining as a shareholder in 2017. At K2, Tommy focuses on creating and delivering content and is responsible for many of the Firm's management and marketing functions. Tommy resides in the metro Atlanta area. You may reach him at tommy@k2e.com.

    Randy Johnson
    Randy is a nationally recognized educator, consultant, and writer with over 40 years experience in Strategic Technology Planning, Accounting Software Selection, Paperless, Systems and Network Integration, Business Continuity and Disaster Recovery Planning, Business Development and Management, Process Engineering and outsourced managed services. Randy can be reached at randy@k2e.com

    RSS Feed

Training & Education

Webinars
Upcoming Events
Road to Excellence Online Seminar
Seminars
Conferences
Instructors

Tech News

K2E Canada's Tech Update Newsletter

More

Privacy Policy
About
Contact

K2E Canada Inc.  |  591 Highway 221  |  North Kingston, NS Canada B0P 1R0  |  (902) 200-9207
© 2020 K2E Canada Inc. ALL RIGHTS RESERVED.