View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How do you identify the first row as headers in EXCEL 2007?

I am assuming you what some cells printed at the top of each sheet of paper
(not 'Headers' in the Excel sense)
Fro XL2007 Help:

Print row or column labels on every page
Select the worksheet or worksheets that you want to print. How to select
worksheets
To select Do this A single sheet Click the sheet tab.
If you don't see the tab that you want, click the tab scrolling buttons to
display the tab, and then click the tab.
Two or more adjacent sheets Click the tab for the first sheet. Then hold
down SHIFT while you click the tab for the last sheet that you want to
select. Two or more nonadjacent sheets Click the tab for the first sheet.
Then hold down CTRL while you click the tabs of the other sheets that you
want to select. All sheets in a workbook Right-click a sheet tab, and then
click Select All Sheets on the shortcut menu (shortcut menu: A menu that
shows a list of commands relevant to a particular item. To display a
shortcut menu, right-click an item or press SHIFT+F10.).
Tip When multiple worksheets are selected, [Group] appears in the title bar
at the top of the worksheet. To cancel a selection of multiple worksheets in
a workbook, click any unselected worksheet. If no unselected sheet is
visible, right-click the tab of a selected sheet, and then click Ungroup
Sheets on the shortcut menu.
On the Page Layout tab, in the Page Setup group, click Print Titles.

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"ljt" wrote in message
...
I am trying to identify my first row as headers in Excel 2007. What used
to
be so easy is truly a mystery now. Can anyone please tell me where I do
this?