#1   Report Post  
Posted to microsoft.public.excel.misc
Don Don is offline
external usenet poster
 
Posts: 487
Default cell names

Silly question- but I have been looking for over an hour with no success!
How do I print the cell names with the spreadsheet?
You know- so the A, B, C shows across the top, and the 1,2,3 shows down the
side?
For the life of me- I can't find it!
I'm working with Office 2007.
many thanks!
and sorry for asking such a dumb question!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default cell names

Hi,

(There should be a similar option in 2007)
In Excel 2003, on the File menu, click Page Setup. In the Sheet tab, select
the Row and column headings check box.

"Don" wrote:

Silly question- but I have been looking for over an hour with no success!
How do I print the cell names with the spreadsheet?
You know- so the A, B, C shows across the top, and the 1,2,3 shows down the
side?
For the life of me- I can't find it!
I'm working with Office 2007.
many thanks!
and sorry for asking such a dumb question!

  #3   Report Post  
Posted to microsoft.public.excel.misc
Don Don is offline
external usenet poster
 
Posts: 487
Default cell names

Hey Zorrina
(neat name)
I found that, clicked on the box, saved the file to the desktop- all is well.
THEN, when I try to drag it onto a Word document, the letters and numbers
disappear!
Grrrrr

"Zorrina" wrote:

Hi,

(There should be a similar option in 2007)
In Excel 2003, on the File menu, click Page Setup. In the Sheet tab, select
the Row and column headings check box.

"Don" wrote:

Silly question- but I have been looking for over an hour with no success!
How do I print the cell names with the spreadsheet?
You know- so the A, B, C shows across the top, and the 1,2,3 shows down the
side?
For the life of me- I can't find it!
I'm working with Office 2007.
many thanks!
and sorry for asking such a dumb question!

  #4   Report Post  
Posted to microsoft.public.excel.misc
Don Don is offline
external usenet poster
 
Posts: 487
Default cell names

I should add- it will print the cell names, but refuses to transfer them over
onto a Word document. This is where I need it the most!
Thanks again for your help.

"Don" wrote:

Hey Zorrina
(neat name)
I found that, clicked on the box, saved the file to the desktop- all is well.
THEN, when I try to drag it onto a Word document, the letters and numbers
disappear!
Grrrrr

"Zorrina" wrote:

Hi,

(There should be a similar option in 2007)
In Excel 2003, on the File menu, click Page Setup. In the Sheet tab, select
the Row and column headings check box.

"Don" wrote:

Silly question- but I have been looking for over an hour with no success!
How do I print the cell names with the spreadsheet?
You know- so the A, B, C shows across the top, and the 1,2,3 shows down the
side?
For the life of me- I can't find it!
I'm working with Office 2007.
many thanks!
and sorry for asking such a dumb question!

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default cell names

Thanks, Don. :-)

I am afraid, short of taking a screenshot to paste into Word (you would not
be able to edit the excel file in Word then), I am unable to suggest anything
else.

You could also insert the excel sheet as an icon (Double-clicking the icon
will let you edit the excel sheet). But when you print the Word document, it
would print the excel as an icon. :-(

This is an interesting puzzle and I hope someone else solves this soon.

"Don" wrote:

I should add- it will print the cell names, but refuses to transfer them over
onto a Word document. This is where I need it the most!
Thanks again for your help.

"Don" wrote:

Hey Zorrina
(neat name)
I found that, clicked on the box, saved the file to the desktop- all is well.
THEN, when I try to drag it onto a Word document, the letters and numbers
disappear!
Grrrrr

"Zorrina" wrote:

Hi,

(There should be a similar option in 2007)
In Excel 2003, on the File menu, click Page Setup. In the Sheet tab, select
the Row and column headings check box.

"Don" wrote:

Silly question- but I have been looking for over an hour with no success!
How do I print the cell names with the spreadsheet?
You know- so the A, B, C shows across the top, and the 1,2,3 shows down the
side?
For the life of me- I can't find it!
I'm working with Office 2007.
many thanks!
and sorry for asking such a dumb question!



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default cell names

If you want something to copy across to Word, you could insert a new row at
the top of the sheet, & label the columns A, B, C, etc., and similarly
insert a new column to the left & label the rows 1, 2, 3, etc. The top left
cell is A1, of course.
--
David Biddulph

"Don" wrote in message
...
I should add- it will print the cell names, but refuses to transfer them
over
onto a Word document. This is where I need it the most!
Thanks again for your help.

"Don" wrote:

Hey Zorrina
(neat name)
I found that, clicked on the box, saved the file to the desktop- all is
well.
THEN, when I try to drag it onto a Word document, the letters and numbers
disappear!
Grrrrr

"Zorrina" wrote:

Hi,

(There should be a similar option in 2007)
In Excel 2003, on the File menu, click Page Setup. In the Sheet tab,
select
the Row and column headings check box.

"Don" wrote:

Silly question- but I have been looking for over an hour with no
success!
How do I print the cell names with the spreadsheet?
You know- so the A, B, C shows across the top, and the 1,2,3 shows
down the
side?
For the life of me- I can't find it!
I'm working with Office 2007.
many thanks!
and sorry for asking such a dumb question!



  #7   Report Post  
Posted to microsoft.public.excel.misc
Don Don is offline
external usenet poster
 
Posts: 487
Default cell names

That is what I eventually did- I thought there "must be a way."
Thanks for your help, folks!

"David Biddulph" wrote:

If you want something to copy across to Word, you could insert a new row at
the top of the sheet, & label the columns A, B, C, etc., and similarly
insert a new column to the left & label the rows 1, 2, 3, etc. The top left
cell is A1, of course.
--
David Biddulph

"Don" wrote in message
...
I should add- it will print the cell names, but refuses to transfer them
over
onto a Word document. This is where I need it the most!
Thanks again for your help.

"Don" wrote:

Hey Zorrina
(neat name)
I found that, clicked on the box, saved the file to the desktop- all is
well.
THEN, when I try to drag it onto a Word document, the letters and numbers
disappear!
Grrrrr

"Zorrina" wrote:

Hi,

(There should be a similar option in 2007)
In Excel 2003, on the File menu, click Page Setup. In the Sheet tab,
select
the Row and column headings check box.

"Don" wrote:

Silly question- but I have been looking for over an hour with no
success!
How do I print the cell names with the spreadsheet?
You know- so the A, B, C shows across the top, and the 1,2,3 shows
down the
side?
For the life of me- I can't find it!
I'm working with Office 2007.
many thanks!
and sorry for asking such a dumb question!




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
Cell names = sheet names Vince Excel Worksheet Functions 9 February 8th 08 03:59 PM
difference between cell names and cell labels bobby769 Excel Discussion (Misc queries) 2 January 26th 07 03:51 AM
How to create table of cell names with the name's cell address WildwoodEngr Excel Discussion (Misc queries) 1 October 26th 06 02:52 PM
Cell names e_vandenbush Excel Discussion (Misc queries) 2 January 16th 06 10:58 PM
Cell names bboult Excel Discussion (Misc queries) 1 November 17th 05 03:24 PM


All times are GMT +1. The time now is 03:22 AM.

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

About Us

"It's about Microsoft Excel"