Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove headers from text file | Excel Discussion (Misc queries) | |||
Remove headers in file | Excel Worksheet Functions | |||
Remove Headers | Excel Discussion (Misc queries) | |||
How do I remove outlook headers from my excel worksheet? | Excel Discussion (Misc queries) | |||
remove bold from cell ref headers | Excel Discussion (Misc queries) |