General discussion

  • Creator
    Topic
  • #2304470

    Headers in Excel

    Locked

    by qb4006 ·

    Hi is it possible to make a type of header in Excel that is permanent and whose cell sizes can’t be altered? For example, lets say I want to make a header on the top of the page that says “MY Company”. Can I then change the size (i.e. width)of the cells that are below the header without changing the size of the cells within my header? I’m not sure if this would be considered a header or a template or what. I hope I’ve explained this clearly

    Thanks

All Comments

  • Author
    Replies
    • #2739790

      Reply To: Headers in Excel

      by dklippert ·

      In reply to Headers in Excel

      You can select the row(s) you want to serve as a header and set your selection in File>Page Setup choose the Sheet tab. You can now use Format Cells Protection to lock down the spreadsheet. You’ll have to format and unlock any cells that you want to allow changes.
      You could also place a graphic on the page.

      • #2739757

        Reply To: Headers in Excel

        by dklippert ·

        In reply to Reply To: Headers in Excel

        The only way you can accomplish this:

        “size of the “A” column for example but not have “A” column change on the header row but just below it.”

        is to place a graphic on the spreadsheet. You can not make a column wider in a specific spot. You can manipulte tables in Word this way, but not in Excel

    • #2739789

      Reply To: Headers in Excel

      by sgt_shultz ·

      In reply to Headers in Excel

      For viewing on screen and entering data, see if Freeze Panes is what you want. make your header rows, then place your curser on leftmost cell of next blank row down, then pick Window/Freeze Panes…
      Or else, maybe best for printing, go into File/Page Setup/Header-Footer
      is this what you are asking?

      • #2739774

        Reply To: Headers in Excel

        by qb4006 ·

        In reply to Reply To: Headers in Excel

        Thanks but this isn’t quite it. I want to be able to change the size of the “A” column for example but not have “A” column change on the header row but just below it.

    • #2739745

      Reply To: Headers in Excel

      by oz_media ·

      In reply to Headers in Excel

      Just go to VIEW > Header and Footer
      This lets you add a header and footer (just like Word)that has NOTHIONG to do with the excell sheet at all until printed or print previewed.

      No need to play with cell formatting.

      • #2739744

        Reply To: Headers in Excel

        by oz_media ·

        In reply to Reply To: Headers in Excel

        I haven’t been drinking it just my typing.

      • #2738122

        Reply To: Headers in Excel

        by oz_media ·

        In reply to Reply To: Headers in Excel

        I don’t understand why everyone is making this seem so complicated. From what I understand, you need to add a Header to your page without it affecting the cell formats.
        VIEW>Header and Footer DONE! No need to merge cells etc.??!?

    • #2738185

      Reply To: Headers in Excel

      by don christner ·

      In reply to Headers in Excel

      I would put the header in row 1 then select however many columns that you normally would fit on a page and merge those cells on row 1 into one cell. Center the header text using format-cell, then use cell protection to protect row 1.

      Any changes below row 1 should be allowed, but no one can change row 1 except you.

      Don

    • #2738075

      Reply To: Headers in Excel

      by qb4006 ·

      In reply to Headers in Excel

      This question was closed by the author

Viewing 4 reply threads