Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
expenseconfused
 
Posts: n/a
Default Is it possible to change a template column headings? If so how?

I am using a expense report template from Microsoft Office Excel 2003 Basic
edition, but would like to change the headings on some of the columns, is
this possible? If so, how
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daniel CHEN
 
Posts: n/a
Default Is it possible to change a template column headings? If so how?

1) If the template file you downloaded and saved in your computer is .xls
file, then save it as .xlt file.
2) Open the .xlt file using menu File/Open, NOT by double-click the file
name in browser.
3) Change the headings
4) Save the file as .xlt file


--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"expenseconfused" wrote in
message ...
I am using a expense report template from Microsoft Office Excel 2003
Basic
edition, but would like to change the headings on some of the columns,
is
this possible? If so, how



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miguel Zapico
 
Posts: n/a
Default Is it possible to change a template column headings? If so how?

Maybe the sheet is protected, check if you can do menu
tools-protection-unprotect sheet.
If it is a standard template, it shouldn't ask you for a password.

Hope this helps,
Miguel.

"expenseconfused" wrote:

I am using a expense report template from Microsoft Office Excel 2003 Basic
edition, but would like to change the headings on some of the columns, is
this possible? If so, how

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel, how do I change the column headings from letters to number lazybee Excel Discussion (Misc queries) 4 April 2nd 08 07:44 AM
Can I change column headings A,B,C etc to words lagcdm Setting up and Configuration of Excel 1 January 13th 06 10:43 AM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
change excel column headings from numeric to alphabetical Erasmus Excel Discussion (Misc queries) 1 October 20th 05 02:12 AM
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 07:25 PM


All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"