ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   cell names (https://www.excelbanter.com/excel-discussion-misc-queries/203481-cell-names.html)

Don

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!

Zorrina

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!


Don

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!


Don

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!


Zorrina

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!


David Biddulph[_2_]

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!




Don

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!






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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com