• Home
  • Blog
  • Resume
  • Contact
  • Projects
  • Gallery
  • Amit’s Resume
  • About Nagpur
KEEP IN TOUCH

Change Row and Column Headers

Aug17
2006
Leave a Comment Written by admin

You cannot change the default Row (1,2,3,…) and Column (A,B,C,D….) headers, but a workaround is:
1. Enter what you’d like to be your Row Headers in the first column after cell A1
2. Enter what you’d like to be your Column Headers in the first row after cell A1
3. Format first row and column to match the default headers
4. Go to Tools>Options>View Tab>Clear the Row & column Headers check box.

Now, your sheet might look like this:

Related posts:

  1. Stack Columns of Data on one column
  2. Change the creation date of a workbook
  3. PMT Worksheet Function
  4. Change references
  5. Find the last filled column
Posted in Uncategorized - Tagged Column Headers, Row Headers
SHARE THIS Twitter Facebook Delicious StumbleUpon E-mail
« Assign macro to a button
» Text Search Count

No Comments Yet

Leave a Reply Cancel reply

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

*

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">

Tags

Access Alt F8 Books boxplot cells charts count cursor dashboard data mining dbase design error excel excel functions export filter flip LaTex MS query Number Err ODBC pipes Press Alt F11 Public Sub python R random numbers Range Cells report scripting software sparklines SQL SQL server stack columns statistics stemming string tag cloud text mining UDF VBA visualization wildcard

Network

View Ashutosh Nandeshwar's profile on LinkedIn

Recent Comments

  • W. McNabb on The search key was not found in any record in Access
  • Manuel on The search key was not found in any record in Access
  • Wendy Naples on The search key was not found in any record in Access
  • larry on Access Export to Excel (2007)
  • Betty Chou on Projects

Related Posts

  1. Stack Columns of Data on one column
  2. Change the creation date of a workbook
  3. PMT Worksheet Function
  4. Change references
  5. Find the last filled column

EvoLve theme by Blogatize  •  Powered by WordPress nandeshwar.info