+ Reply to Thread
Results 1 to 38 of 38

How do I change column headings from A,B,C to actual words?

  1. #1
    Registered User
    Join Date
    08-11-2005
    Posts
    2

    Exclamation How do I change column headings from A,B,C to actual words?

    I want my column headings across the top to have actual words in there instead of being just the alphabet all the way across. I like to have my rows match up to the numbers on the left but if I make a column heading starting in row 1, then my numbers are off on the left by one because the heading takes up one of my lines. Is there any way to make the A, B, C...be actual the headings for my columns? If so, how do I change them?

    Thanks!
    Nicole

  2. #2
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  3. #3
    Registered User
    Join Date
    08-11-2005
    Posts
    2

    Actually, this is not what I meant...

    I actually meant, is there any way to change what's in the gray cells at the top of the page. The gray cells that say A, B, C, D... I would rather my column headings be in those gray cells than those letters.

    Thanks!

    Nicole

  4. #4
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  5. #5
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  6. #6
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  7. #7
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  8. #8
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  9. #9
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  10. #10
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  11. #11
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  12. #12
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  13. #13
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  14. #14
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  15. #15
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  16. #16
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  17. #17
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  18. #18
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  19. #19
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  20. #20
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  21. #21
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  22. #22
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  23. #23
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  24. #24
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  25. #25
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  26. #26
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  27. #27
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  28. #28
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  29. #29
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  30. #30
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  31. #31
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  32. #32
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  33. #33
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  34. #34
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  35. #35
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  36. #36
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  37. #37
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    You can use window -Freeze Panes in the menu bar
    to freeze the first column and Row.
    Select cell b2 and do window -Freeze Panes

    You can put your own headers in the first row and column then

    Under Tools -options -View uncheck row & column headers so
    the default row and column headers are gone




    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I want my column headings across the top to have actual words in there
    > instead of being just the alphabet all the way across. I like to have
    > my rows match up to the numbers on the left but if I make a column
    > heading starting in row 1, then my numbers are off on the left by one
    > because the heading takes up one of my lines. Is there any way to make
    > the A, B, C...be actual the headings for my columns? If so, how do I
    > change them?
    >
    > Thanks!
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




  38. #38
    Ron de Bruin
    Guest

    Re: How do I change column headings from A,B,C to actual words?

    Hi Nicole

    No, you have only the option that I already posted

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "LCMom01" <[email protected]> wrote in message
    news:[email protected]...
    >
    > I actually meant, is there any way to change what's in the gray cells at
    > the top of the page. The gray cells that say A, B, C, D... I would
    > rather my column headings be in those gray cells than those letters.
    >
    > Thanks!
    >
    > Nicole
    >
    >
    > --
    > LCMom01
    > ------------------------------------------------------------------------
    > LCMom01's Profile: http://www.excelforum.com/member.php...o&userid=26185
    > View this thread: http://www.excelforum.com/showthread...hreadid=394938
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1