Software

Ask something
Discussion Locked

Headers in Excel

0 helpful
9 replies

by qb4006

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

9 replies

by dklippert

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.

by dklippert

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

by sgt_shultz

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?

by qb4006

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.

by oz_media

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.

by oz_media

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.??!?

by don christner

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

This discussion is closed to new replies.