1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

EXCEL, Can i put headings on rows and columns??

Discussion in 'Business Applications' started by john1, Apr 8, 2003.

Thread Status:
Not open for further replies.
  1. john1

    john1 Thread Starter

    Joined:
    Nov 25, 2000
    Messages:
    8,994
    Hi,

    I would like to put names or numbers on the columns
    and rows.

    Ive managed to get a table to work for me, its a set
    of multiples for 45
    the first cell is blank, the next is the first entry
    and i put 45 in this case here, the rest of the table
    fills itself in with multiples of 45.

    Thing is, when i print it out, i want the columns and
    rows to have headings.

    Is there a way to do this please?

    The drawing is only aproximate, i have to convert to
    bmp, then add in the extra numbers, which dont change
    they could be background, the colour doesnt matter it
    is only there to separate the columns and rows from
    the multiples of 45.
    Later if its 46 or 47 i would use the same table.

    <img src="http://forums.techguy.org/attachment.php?postid=807031">

    by using the tens and units you get the multiple at
    the intersection.
    row 20 and column 2 give the result for 22 times 45

    There might be better ways, but this works ok.

    Regards, John
     

    Attached Files:

  2. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    I set up the rows and column headings the way you want.
    Then I hid the "real" row and column headings.

    www.theofficeexperts.com/downloads/ForJohn1.xls


    You can left-click to view it.
    Right-click and choose Save target as to save it.
     
  3. john1

    john1 Thread Starter

    Joined:
    Nov 25, 2000
    Messages:
    8,994
    Thanks very much Dreamboat,

    I have saved that setup, and it shows fine on the
    Print Preview, but now i have a problem with my
    printer.
    And i cant figure out what the flashing light is
    trying to tell me.
    I spose the hardware forum is the place to go now.

    Thanks for your help,
    John.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/127894

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice