Remove Column Headers/Row Headers In Excel

Column headers are the alphabetical character which is displayed in the column header and row headers are the numeric digit which identifies a row.

Sometimes we do not want to show the column names as A,B etc. and row numbers as 1,2,3 etc.

Capture

Go to Headings under Page Layout and deselect the view under the headings.

Capture

The row and column headers will not be shown as below.

Capture

 

 

Share The Knowledge

Random Posts

  • Extract Domains From URLs In Excel

    Let’s see how to extract the domain name from the URL given, extracting the domain name from the URL is […]

    Share The Knowledge
  • Create User Defined Function In Excel

    There are a lot of inbuilt functions that are available for our use in excel, however we may come across […]

    Share The Knowledge
  • Sum Named Range In Excel

    In this post we will see how could we sum a named range in excel. Name Range is a name […]

    Share The Knowledge
  • Insert Symbol In Excel

    There are times when we want to insert some special symbol or characters in excel. We will see how we […]

    Share The Knowledge

Leave a Reply