 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Remove 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 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 > 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 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? > 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 [quoted text clipped - 7 lines] > > > > Thanks Click Tools, then Options. > 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 [quoted text clipped - 12 lines] >>> >>>Thanks Thanks Bob I found it. Cheers > Click Tools, then Options. > [quoted text clipped - 14 lines] > >>> > >>>Thanks 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/media/1033/technet/images/scriptcenter/office/m anage/big/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 > 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 [quoted text clipped - 15 lines] >> > >> > Thanks Thanks Rick...I found it. Can you tell me how to add an email and print button to the form? > This webpage shows a picture of the View Tab on the Tools/Options dialog box > that you should have been looking at... [quoted text clipped - 28 lines] > >> > > >> > Thanks 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 > Thanks Rick...I found it. > [quoted text clipped - 36 lines] >> >> > >> >> > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.