Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Title in row 1
How do you get a title/column names to appear in the row 1 and have row 1
start below it. ie. row 1 has no number 1? And how get title to center if going with title and not column names? I tried the window freeze but 1 still appears in row 1. Messes up the data. ie. say I have 20 rows data and shows total count of 21 when actually 20 because the column names/title are in row 1. Thanks. -- Paul |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Title in row 1
Hi questionman,
You cannot change the numbering on the rows. If you like you can dedicate another column to showing a number if that helps the person reading your spreadsheet, it will probably confuse anyone trying to do maintenance on the sheet. Insert a column before current column A A1: '; (leave empty) A2 =ROW()-1 (fill down with fill handle) More information on possible topics: http://www.mvps.org/dmcritchie/excel/fillhand.htm http://www.mvps.org/dmcritchie/excel/freeze.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "QuestionMan" wrote in message ... How do you get a title/column names to appear in the row 1 and have row 1 start below it. ie. row 1 has no number 1? And how get title to center if going with title and not column names? I tried the window freeze but 1 still appears in row 1. Messes up the data. ie. say I have 20 rows data and shows total count of 21 when actually 20 because the column names/title are in row 1. Thanks. -- Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart title text linked from a cell? Possible? | Excel Discussion (Misc queries) | |||
Excel XP: File name in Title Bar not changed after Save As... | Excel Discussion (Misc queries) | |||
Relative Chart Title? | Charts and Charting in Excel | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel | |||
The x-axis title is truncated in EXCEL charts 2003. | Charts and Charting in Excel |