General discussion

Locked

Headers in Excel

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

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

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.

Collapse -

by DKlippert In reply to

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

Collapse -

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?

Collapse -

by qb4006 In reply to

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.

Collapse -

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.

Collapse -

by Oz_Media In reply to

I haven't been drinking it just my typing.

Collapse -

by Oz_Media In reply to

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

Collapse -

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

Collapse -

by qb4006 In reply to Headers in Excel

This question was closed by the author

Back to Software Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums