Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change column headings or freeze row 1
I ahve added an excel control to my VB.net program.
I would like to do either one of the following. Is it possible to freeze just row 1 and how. Is iy possible to change the column headings to my own column names -- Thank You Jason |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change column headings or freeze row 1
On Apr 23, 3:19*pm, jfeiner99
wrote: I ahve added an excel control to my VB.net program. I would like to do either one of the following. Is it possible to freeze just row 1 and how. Is iy possible to change the column headings to my own column names -- Thank You Jason Hi, I can help you with the first question: Is it possible to freeze just row 1 and how. You can do this by: 1. Select a cell in row 2 e.g. A2 2. Go to Window Freeze Pane You can now scroll down the excell spreadsheet leaving row 1 always on display I hope this is what you meant! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change column headings or freeze row 1
Nadia, thank you for you reply, however i can't go to windows freeze pane
because it is a control I have added to a VB.net program. In addition when i tried it in excell not part of my computer program it freezes many columns and rows i only want row 1 to freeze. If I am missing something please correct me this has been a trouble spot for over 2 months for me now. -- Thank You Jason " wrote: On Apr 23, 3:19 pm, jfeiner99 wrote: I ahve added an excel control to my VB.net program. I would like to do either one of the following. Is it possible to freeze just row 1 and how. Is iy possible to change the column headings to my own column names -- Thank You Jason Hi, I can help you with the first question: Is it possible to freeze just row 1 and how. You can do this by: 1. Select a cell in row 2 e.g. A2 2. Go to Window Freeze Pane You can now scroll down the excell spreadsheet leaving row 1 always on display I hope this is what you meant! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change column headings or freeze row 1
On Apr 23, 4:31*pm, jfeiner99
wrote: Nadia, thank you for you reply, however i can't go to windows freeze pane because it is a control I have added to a VB.net program. *In addition when i tried it in excell not part of my computer program it freezes many columns and rows i only want row 1 to freeze. *If I am missing something please correct me this has been a trouble spot for over 2 months for me now. -- Thank You Jason " wrote: On Apr 23, 3:19 pm, jfeiner99 wrote: I ahve added an excel control to my VB.net program. I would like to do either one of the following. Is it possible to freeze just row 1 and how. Is iy possible to change the column headings to my own column names -- Thank You Jason Hi, I can help you with the first question: Is it possible to freeze just row 1 and how. You can do this by: * * * *1. Select a cell in row 2 e.g. A2 * * * *2. Go to Window Freeze Pane You can now scroll down the excell spreadsheet leaving row 1 always on display I hope this is what you meant!- Hide quoted text - - Show quoted text - oh, I'm sorry, I don't know in that case :$ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
How do I change column and row headings. | Excel Discussion (Misc queries) | |||
change column headings letters | Setting up and Configuration of Excel | |||
How do I change the column headings in Excel? | Excel Discussion (Misc queries) | |||
how do you change column headings in excel? | Excel Discussion (Misc queries) |