Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default custom header

Is it possible to link my custom header to the name tab on my work sheet? If
my tab name is March 2009, I don't want to re type this in my print header.
Also can these tabs be automated for example insert current date?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default custom header

Which version of Excel?

2002 and newer have that functionality when setting up Custom Headers or
Footers.


Gord Dibben MS Excel MVP

On Tue, 10 Mar 2009 12:58:02 -0700, ct_pws_3
wrote:

Is it possible to link my custom header to the name tab on my work sheet? If
my tab name is March 2009, I don't want to re type this in my print header.
Also can these tabs be automated for example insert current date?


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default custom header

Thank you for responding, I have the latestest version of excel/ vista

"Gord Dibben" wrote:

Which version of Excel?

2002 and newer have that functionality when setting up Custom Headers or
Footers.


Gord Dibben MS Excel MVP

On Tue, 10 Mar 2009 12:58:02 -0700, ct_pws_3
wrote:

Is it possible to link my custom header to the name tab on my work sheet? If
my tab name is March 2009, I don't want to re type this in my print header.
Also can these tabs be automated for example insert current date?



  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default custom header

On Ribbon...................

InsertHeader and Footer

Click on the Options that you want.

Date.....Time........Sheet Name etc.


Gord


On Tue, 10 Mar 2009 15:06:01 -0700, ct_pws_3
wrote:

Thank you for responding, I have the latestest version of excel/ vista

"Gord Dibben" wrote:

Which version of Excel?

2002 and newer have that functionality when setting up Custom Headers or
Footers.


Gord Dibben MS Excel MVP

On Tue, 10 Mar 2009 12:58:02 -0700, ct_pws_3
wrote:

Is it possible to link my custom header to the name tab on my work sheet? If
my tab name is March 2009, I don't want to re type this in my print header.
Also can these tabs be automated for example insert current date?




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
Custom header Carmel Setting up and Configuration of Excel 1 November 29th 05 05:58 PM
Can you link a custom property to an Excel custom header text? LouErc Setting up and Configuration of Excel 0 November 8th 05 04:58 PM
Excel: custom header - is it possible to paste into header? Maureen D. Excel Worksheet Functions 0 November 4th 05 03:07 PM
custom header Marlis Excel Discussion (Misc queries) 5 August 26th 05 01:28 PM
how do I permanetly add custom header to excel header list? GARY Excel Discussion (Misc queries) 1 December 15th 04 08:52 PM


All times are GMT +1. The time now is 08:14 PM.

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

About Us

"It's about Microsoft Excel"