A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do you identify the first row as headers in EXCEL 2007?



 
 
Thread Tools Display Modes
  #1  
Old September 13th 07, 08:32 PM posted to microsoft.public.excel.misc
ljt
external usenet poster
 
Posts: 2
Default How do you identify the first row as headers in EXCEL 2007?

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?
Ads
  #2  
Old September 13th 07, 09:46 PM posted to microsoft.public.excel.misc
Duke Carey
external usenet poster
 
Posts: 1,081
Default How do you identify the first row as headers in EXCEL 2007?

By 'header' I'm assuming you mean freeze panes? It's on the View tab on the
ribbon. You can also get to it by pressong Alt-W, then F

"ljt" wrote:

> 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?

  #3  
Old September 13th 07, 10:02 PM posted to microsoft.public.excel.misc
ljt
external usenet poster
 
Posts: 2
Default How do you identify the first row as headers in EXCEL 2007?

No, actually they are column headers that you would use to sort by.

"Duke Carey" wrote:

> By 'header' I'm assuming you mean freeze panes? It's on the View tab on the
> ribbon. You can also get to it by pressong Alt-W, then F
>
> "ljt" wrote:
>
> > 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?

  #4  
Old September 13th 07, 10:11 PM posted to microsoft.public.excel.misc
Mike Middleton
external usenet poster
 
Posts: 762
Default How do you identify the first row as headers in EXCEL 2007?

ljt -

Select the data or a single cell in a database. Choose Data | Sort, or
choose Home | Sort & Filter | Custom Sort. Either way the Sort dialog box
appears, and the checkbox for "My data has headers" is in the top right
corner.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"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?



  #5  
Old September 13th 07, 10:18 PM posted to microsoft.public.excel.misc
Kevin B
external usenet poster
 
Posts: 1,317
Default How do you identify the first row as headers in EXCEL 2007?

Click the MS Office logo icon on the left side of the application window and
select page setup from the menu
--
Kevin Backmann


"ljt" wrote:

> 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?

  #6  
Old September 14th 07, 12:32 AM posted to microsoft.public.excel.misc
Pat J
external usenet poster
 
Posts: 3
Default How do you identify the first row as headers in EXCEL 2007?

Kevin,
I don't see "page setup" when I click on the MS Office logo icon.
--
Pat J


"Kevin B" wrote:

> Click the MS Office logo icon on the left side of the application window and
> select page setup from the menu
> --
> Kevin Backmann
>
>
> "ljt" wrote:
>
> > 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?

  #7  
Old September 14th 07, 01:02 PM posted to microsoft.public.excel.misc
Bernard Liengme
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?



  #8  
Old November 15th 07, 04:11 PM posted to microsoft.public.excel.misc
Holly
external usenet poster
 
Posts: 94
Default How do you identify the first row as headers in EXCEL 2007?

Select File, Page Set up, Sheet, Print Titles, put cursor in box of Rows to
Repeat, left cick on row on worksheet you want to show on every page, that
row will appear on your Rows to Repeat box, click OK.
--
Holly N


"ljt" wrote:

> 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?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I identify statistical outliers with excel Jeff Excel Discussion (Misc queries) 0 January 7th 07 07:53 AM
Numeric column headers Excel 2007 Dale M Warehime Excel Discussion (Misc queries) 2 June 14th 06 10:11 PM
Excel 2007 worksheet headers do not print Sabrina Excel Worksheet Functions 1 June 12th 06 04:28 PM
what formula in Excel will identify the first zero in a row and... Dawnstar253 Excel Worksheet Functions 2 June 7th 06 05:21 PM
How to identify same row matches in two columns of #s using Excel NBM Excel Discussion (Misc queries) 2 April 13th 06 06:00 AM


All times are GMT +1. The time now is 06:09 PM.


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