Remove row & column headers
 

How do you remove the column and row titles? I'm wanting to create a form and
not show the row numbers or column letters....can anyone help please.

Thanks

Remove row & column headers
 

Select Tools/Options from Excel's menu bar, click the View tab and uncheck
the "Row & column headers" box in the "Windows options" panel; then click
OK.

Rick


"Ben" wrote in message
...
How do you remove the column and row titles? I'm wanting to create a form
and
not show the row numbers or column letters....can anyone help please.

Thanks

Remove row & column headers
 

Thanks Rick, I've tried what you said but when looking for the "rows &
column's" header I couldn't find it!!! I also tried to look in the
"customise" section and the command wasn't there either! Do I have to upgrade
my 2003 version of excel?

"Rick Rothstein (MVP - VB)" wrote:

Select Tools/Options from Excel's menu bar, click the View tab and uncheck
the "Row & column headers" box in the "Windows options" panel; then click
OK.

Rick


"Ben" wrote in message
...
How do you remove the column and row titles? I'm wanting to create a form
and
not show the row numbers or column letters....can anyone help please.

Thanks

Remove row & column headers
 

Click Tools, then Options.


Ben wrote:

Thanks Rick, I've tried what you said but when looking for the "rows &
column's" header I couldn't find it!!! I also tried to look in the
"customise" section and the command wasn't there either! Do I have to upgrade
my 2003 version of excel?

"Rick Rothstein (MVP - VB)" wrote:


Select Tools/Options from Excel's menu bar, click the View tab and uncheck
the "Row & column headers" box in the "Windows options" panel; then click
OK.

Rick


"Ben" wrote in message
...

How do you remove the column and row titles? I'm wanting to create a form
and
not show the row numbers or column letters....can anyone help please.

Thanks

Remove row & column headers
 

This webpage shows a picture of the View Tab on the Tools/Options dialog box
that you should have been looking at...

http://www.microsoft.com/library/med...ig/ex-view.jpg

Look to the **bottom** area of the panel where there are three columns of
checkboxes (in a section labeled "Window options")... the top item in the
middle column in that section is labeled "Rows & column headers" (the
highlight box pointing to it has the words "Display Headings" in it)... that
is the check box I said you need to uncheck.

Rick


"Ben" wrote in message
...
Thanks Rick, I've tried what you said but when looking for the "rows &
column's" header I couldn't find it!!! I also tried to look in the
"customise" section and the command wasn't there either! Do I have to
upgrade
my 2003 version of excel?

"Rick Rothstein (MVP - VB)" wrote:

Select Tools/Options from Excel's menu bar, click the View tab and
uncheck
the "Row & column headers" box in the "Windows options" panel; then click
OK.

Rick


"Ben" wrote in message
...
How do you remove the column and row titles? I'm wanting to create a
form
and
not show the row numbers or column letters....can anyone help please.

Thanks

Remove row & column headers
 

Thanks Rick...I found it.

Can you tell me how to add an email and print button to the form?

"Rick Rothstein (MVP - VB)" wrote:

This webpage shows a picture of the View Tab on the Tools/Options dialog box
that you should have been looking at...

http://www.microsoft.com/library/med...ig/ex-view.jpg

Look to the **bottom** area of the panel where there are three columns of
checkboxes (in a section labeled "Window options")... the top item in the
middle column in that section is labeled "Rows & column headers" (the
highlight box pointing to it has the words "Display Headings" in it)... that
is the check box I said you need to uncheck.

Rick


"Ben" wrote in message
...
Thanks Rick, I've tried what you said but when looking for the "rows &
column's" header I couldn't find it!!! I also tried to look in the
"customise" section and the command wasn't there either! Do I have to
upgrade
my 2003 version of excel?

"Rick Rothstein (MVP - VB)" wrote:

Select Tools/Options from Excel's menu bar, click the View tab and
uncheck
the "Row & column headers" box in the "Windows options" panel; then click
OK.

Rick


"Ben" wrote in message
...
How do you remove the column and row titles? I'm wanting to create a
form
and
not show the row numbers or column letters....can anyone help please.

Thanks

Remove row & column headers
 

Thanks Bob I found it.

Cheers

"Bob I" wrote:

Click Tools, then Options.


Ben wrote:

Thanks Rick, I've tried what you said but when looking for the "rows &
column's" header I couldn't find it!!! I also tried to look in the
"customise" section and the command wasn't there either! Do I have to upgrade
my 2003 version of excel?

"Rick Rothstein (MVP - VB)" wrote:


Select Tools/Options from Excel's menu bar, click the View tab and uncheck
the "Row & column headers" box in the "Windows options" panel; then click
OK.

Rick


"Ben" wrote in message
...

How do you remove the column and row titles? I'm wanting to create a form
and
not show the row numbers or column letters....can anyone help please.

Thanks

Remove row & column headers
 

You would get the maximum possible number of answers if you would create a
new posting (new thread) for questions having nothing to do with the
original thread. When you do this, explain what you mean be "form". Is that
a worksheet made to look like an input form or are you talking about a
UserForm? If the worksheet, do you want the buttons on the grid itself or
would buttons on the toolbar be acceptable? You might also want to provide
more details on where the email address is to come from (a cell, InputBox
entry, etc.) and, for the print button request, why wouldn't your user
simply use the File/Print option on the menu bar?

Rick


"Ben" wrote in message
...
Thanks Rick...I found it.

Can you tell me how to add an email and print button to the form?

"Rick Rothstein (MVP - VB)" wrote:

This webpage shows a picture of the View Tab on the Tools/Options dialog
box
that you should have been looking at...

http://www.microsoft.com/library/med...ig/ex-view.jpg

Look to the **bottom** area of the panel where there are three columns of
checkboxes (in a section labeled "Window options")... the top item in the
middle column in that section is labeled "Rows & column headers" (the
highlight box pointing to it has the words "Display Headings" in it)...
that
is the check box I said you need to uncheck.

Rick


"Ben" wrote in message
...
Thanks Rick, I've tried what you said but when looking for the "rows &
column's" header I couldn't find it!!! I also tried to look in the
"customise" section and the command wasn't there either! Do I have to
upgrade
my 2003 version of excel?

"Rick Rothstein (MVP - VB)" wrote:

Select Tools/Options from Excel's menu bar, click the View tab and
uncheck
the "Row & column headers" box in the "Windows options" panel; then
click
OK.

Rick


"Ben" wrote in message
...
How do you remove the column and row titles? I'm wanting to create a
form
and
not show the row numbers or column letters....can anyone help
please.

Thanks