I AM NEW TO EXCEL BUT SURELY SOMEONE HAS ASKED THIS QUESTION BEFORE. I HAVE
AN EXCEL SPREADSHEET THAT HAS OVER 200 ENTRIES. WHEN YOU GET DOWN BELOW THE
FOLD WHO CAN REMEMBER WHAT DATA GOES IN COLUMN A, B. C. D, AND SO FORTH.
INSTEAD I WANT TO INSERT LAST NAME, FIRST NAME, ADDRESS, CITY, STATE, ZIP,
PHONE, AND SO FORTH IN THE HEADINGS FOR THE VARIOUS COLUMNS. THEN WHEN I AM
DOWN IN THE BODY OF THE SPREADSHEET IT WILL BE EASY TO KNOW WHAT DATA TO
ENTER IN WHAT COLUMN.

BUT HOW TO DO THIS???? I CANNOT FIND IT IN THE SOFTWARE'S HELP FILE OR ON
THE EXCEL WEBSITE. CAN SOMEONE HELP ME DISCOVER IF THIS CAN BE DONE.

THANKS

NEWBEE@EXCEL2007

Please do NOT SHOUT! and please do NOT multipost. See simple answer in your
posting in .misc
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"NewBee@excel2007" wrote in
message ...
I AM NEW TO EXCEL BUT SURELY SOMEONE HAS ASKED THIS QUESTION BEFORE. I
HAVE
AN EXCEL SPREADSHEET THAT HAS OVER 200 ENTRIES. WHEN YOU GET DOWN BELOW
THE
FOLD WHO CAN REMEMBER WHAT DATA GOES IN COLUMN A, B. C. D, AND SO FORTH.
INSTEAD I WANT TO INSERT LAST NAME, FIRST NAME, ADDRESS, CITY, STATE, ZIP,
PHONE, AND SO FORTH IN THE HEADINGS FOR THE VARIOUS COLUMNS. THEN WHEN I
AM
DOWN IN THE BODY OF THE SPREADSHEET IT WILL BE EASY TO KNOW WHAT DATA TO
ENTER IN WHAT COLUMN.

BUT HOW TO DO THIS???? I CANNOT FIND IT IN THE SOFTWARE'S HELP FILE OR ON
THE EXCEL WEBSITE. CAN SOMEONE HELP ME DISCOVER IF THIS CAN BE DONE.

THANKS

NEWBEE@EXCEL2007

http://www.cpearson.com/excel/HintsA...roupUsers.aspx

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
Please do NOT SHOUT! and please do NOT multipost. See simple answer in
your posting in .misc
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"NewBee@excel2007" wrote in
message ...
I AM NEW TO EXCEL BUT SURELY SOMEONE HAS ASKED THIS QUESTION BEFORE. I
HAVE
AN EXCEL SPREADSHEET THAT HAS OVER 200 ENTRIES. WHEN YOU GET DOWN BELOW
THE
FOLD WHO CAN REMEMBER WHAT DATA GOES IN COLUMN A, B. C. D, AND SO FORTH.
INSTEAD I WANT TO INSERT LAST NAME, FIRST NAME, ADDRESS, CITY, STATE,
ZIP,
PHONE, AND SO FORTH IN THE HEADINGS FOR THE VARIOUS COLUMNS. THEN WHEN I
AM
DOWN IN THE BODY OF THE SPREADSHEET IT WILL BE EASY TO KNOW WHAT DATA TO
ENTER IN WHAT COLUMN.

BUT HOW TO DO THIS???? I CANNOT FIND IT IN THE SOFTWARE'S HELP FILE OR ON
THE EXCEL WEBSITE. CAN SOMEONE HELP ME DISCOVER IF THIS CAN BE DONE.

THANKS

NEWBEE@EXCEL2007

Hey Don... I didn't realize I was shouting... I normally use ALL CAPS and so
didn't change it. Not being used to group discussions I must have violated a
protocol. Please forgive me... I am all new to this.

"Don Guillett" wrote:

http://www.cpearson.com/excel/HintsA...roupUsers.aspx

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
Please do NOT SHOUT! and please do NOT multipost. See simple answer in
your posting in .misc
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"NewBee@excel2007" wrote in
message ...
I AM NEW TO EXCEL BUT SURELY SOMEONE HAS ASKED THIS QUESTION BEFORE. I
HAVE
AN EXCEL SPREADSHEET THAT HAS OVER 200 ENTRIES. WHEN YOU GET DOWN BELOW
THE
FOLD WHO CAN REMEMBER WHAT DATA GOES IN COLUMN A, B. C. D, AND SO FORTH.
INSTEAD I WANT TO INSERT LAST NAME, FIRST NAME, ADDRESS, CITY, STATE,
ZIP,
PHONE, AND SO FORTH IN THE HEADINGS FOR THE VARIOUS COLUMNS. THEN WHEN I
AM
DOWN IN THE BODY OF THE SPREADSHEET IT WILL BE EASY TO KNOW WHAT DATA TO
ENTER IN WHAT COLUMN.

BUT HOW TO DO THIS???? I CANNOT FIND IT IN THE SOFTWARE'S HELP FILE OR ON
THE EXCEL WEBSITE. CAN SOMEONE HELP ME DISCOVER IF THIS CAN BE DONE.

THANKS

NEWBEE@EXCEL2007

We all live and learn, and we were all new at something at least once!
Welcome to the wonderful world of newsgroups.
I understand how you can get used to ALL CAPS - our accounting department
where I work uses a system that only recognizes them (dumb system) and I get
all kinds of frustrated when I first sit down to assist someone and suddenly
fIND aLL mY tYPING turned inside out and bassakwards.


"NewBee@excel2007" wrote:

Hey Don... I didn't realize I was shouting... I normally use ALL CAPS and so
didn't change it. Not being used to group discussions I must have violated a
protocol. Please forgive me... I am all new to this.

"Don Guillett" wrote:

http://www.cpearson.com/excel/HintsA...roupUsers.aspx

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
Please do NOT SHOUT! and please do NOT multipost. See simple answer in
your posting in .misc
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"NewBee@excel2007" wrote in
message ...
I AM NEW TO EXCEL BUT SURELY SOMEONE HAS ASKED THIS QUESTION BEFORE. I
HAVE
AN EXCEL SPREADSHEET THAT HAS OVER 200 ENTRIES. WHEN YOU GET DOWN BELOW
THE
FOLD WHO CAN REMEMBER WHAT DATA GOES IN COLUMN A, B. C. D, AND SO FORTH.
INSTEAD I WANT TO INSERT LAST NAME, FIRST NAME, ADDRESS, CITY, STATE,
ZIP,
PHONE, AND SO FORTH IN THE HEADINGS FOR THE VARIOUS COLUMNS. THEN WHEN I
AM
DOWN IN THE BODY OF THE SPREADSHEET IT WILL BE EASY TO KNOW WHAT DATA TO
ENTER IN WHAT COLUMN.

BUT HOW TO DO THIS???? I CANNOT FIND IT IN THE SOFTWARE'S HELP FILE OR ON
THE EXCEL WEBSITE. CAN SOMEONE HELP ME DISCOVER IF THIS CAN BE DONE.

THANKS

NEWBEE@EXCEL2007

Just above the up (top) arrow in the right-hand vertical scroll-bar
theere is a very small button, the width of the scroll-bar and of
height about a third of its width.

With the column headers at the top of the visible screen, drag this
small button down one row.

The screen will split into two with a horizontal divide. When you
scroll the bottom spreadsheet the top (column headers) stay still.

Similarly for a vertical split by dragging the small button the the
right of the right hand arrow of the horizontal scroll bar.

OR

Select the row below the column headers by clicking in the row
indicator column. Then select Window Freeze from the main window.

Alan Lloyd

thanks so much for this solution... it was really, really helpful
may you be blessed this day

" wrote:

Just above the up (top) arrow in the right-hand vertical scroll-bar
theere is a very small button, the width of the scroll-bar and of
height about a third of its width.

With the column headers at the top of the visible screen, drag this
small button down one row.

The screen will split into two with a horizontal divide. When you
scroll the bottom spreadsheet the top (column headers) stay still.

Similarly for a vertical split by dragging the small button the the
right of the right hand arrow of the horizontal scroll bar.

OR

Select the row below the column headers by clicking in the row
indicator column. Then select Window Freeze from the main window.

Alan Lloyd

Hi,

what you are trying to do should be done with Freeze panes not Split Screen.
Place your cursor on the row below the titles and in column A and choose
View, Freeze Panes, Freeze Panes.

All caps is not a newsgroup issue, but and internat issue.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


" wrote:

Just above the up (top) arrow in the right-hand vertical scroll-bar
theere is a very small button, the width of the scroll-bar and of
height about a third of its width.

With the column headers at the top of the visible screen, drag this
small button down one row.

The screen will split into two with a horizontal divide. When you
scroll the bottom spreadsheet the top (column headers) stay still.

Similarly for a vertical split by dragging the small button the the
right of the right hand arrow of the horizontal scroll bar.

OR

Select the row below the column headers by clicking in the row
indicator column. Then select Window Freeze from the main window.

Alan Lloyd