| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing the top bar of excel?? Eg. from A to Date, B to cost etc
I there a way of changing the top and side bar of excel? So instead of going
A, B, C, D, E etc to something of my choice?? And also making these float down the page when I scroll down the page so they are always in view? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing the top bar of excel?? Eg. from A to Date, B to cost etc
Hi
You can't change the rows or columns. The usual way around this it to add your own underneath/alongside the existing ones. Then go to Tools/Option/View/ and uncheck 'Row and column headers'. To keep these visible as you scroll, select cell B2 and go to Window/Freeze Panes. Hope this helps. Andy. "theweazel" wrote in message ... I there a way of changing the top and side bar of excel? So instead of going A, B, C, D, E etc to something of my choice?? And also making these float down the page when I scroll down the page so they are always in view? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing cell contents so that Excel recognises it as a date | Excel Discussion (Misc queries) | |||
| Excel ignores boot-time regional settings when interpreting a date | Excel Discussion (Misc queries) | |||
| Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
| How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
| Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
Linear Mode
