Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 11th 08, 11:04 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 55
Default how do I create a title for my spreadsheet. As in a headline?

How do I make a headline for my spreadshett? I'd like to center it at the top
of the page. Thank You.

  #2   Report Post  
Old November 12th 08, 01:36 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
Default how do I create a title for my spreadsheet. As in a headline?

Hi,

It depends on whether you are talking about print time or in the spreadsheet.

1. If you want it in you printout only then choose File, Page Setup,
Header/Footers tab, Custom Header and enter the title you want in the Center
section.

2. If you are talking about the spreadsheet, then type the title you want in
A1, change the Font as desired, Highlight A1:E1 or as many cells as you want
the title spread over and click the Merge & Center toolbar button, (the one
after the Right align button).

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"mandy" wrote:

How do I make a headline for my spreadshett? I'd like to center it at the top
of the page. Thank You.



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
Headline with macro's disappears Palle korsholm Excel Discussion (Misc queries) 0 April 7th 08 02:13 PM
Change Title of Spreadsheet Stockwell43 Excel Discussion (Misc queries) 14 December 20th 07 04:11 PM
How do I create a Title row or field in Excel 2003? hookturner New Users to Excel 1 August 15th 07 05:06 PM
how do i create make the title always stay at top when scolling d. chipre Excel Discussion (Misc queries) 4 February 27th 07 04:38 PM
Need help with "Headline Counter" spreadsheet... Cloy Excel Discussion (Misc queries) 1 November 21st 06 11:04 AM


All times are GMT +1. The time now is 07:38 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017