Home

How to formate the top X rows independly as a sheet header from the lower rows

%3CLINGO-SUB%20id%3D%22lingo-sub-455593%22%20slang%3D%22en-US%22%3EHow%20to%20formate%20the%20top%20X%20rows%20independly%20as%20a%20sheet%20header%20from%20the%20lower%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455593%22%20slang%3D%22en-US%22%3E%3CP%3EI%20see%20various%20templates%20which%20show%20a%20header%20section%20at%20the%20top%20of%20the%20sheet%20which%20in%20formatted%20independently%20from%20the%20lower%20rows.%26nbsp%3B%20I%20would%20like%20to%20have%20a%20few%20cells%20in%20the%20%22header%22%20not%20tied%20to%20the%20formatting%20of%20the%20rows%20below.%26nbsp%3B%20How%20is%20this%20done%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-455593%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-455707%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20formate%20the%20top%20X%20rows%20independly%20as%20a%20sheet%20header%20from%20the%20lower%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455707%22%20slang%3D%22en-US%22%3ENot%20sure%20what%20you%20mean%2C%20but%20perhaps%20you%20are%20looking%20for%20the%20%22Format%20as%20Table%22%20functionality%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-455763%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20formate%20the%20top%20X%20rows%20independly%20as%20a%20sheet%20header%20from%20the%20lower%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455763%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20when%20I%20open%20Excel%2C%20I%20can%20choose%20a%20template.%26nbsp%3B%20Several%20templates%20show%20a%20sheet%20header%2C%20with%20the%20rows%20and%20columns%20below.%26nbsp%3B%20The%20first%20template%20I%20see%20is%20one%20for%20%3CEM%3ESales%20Invoice%20Tracker.%26nbsp%3B%20%3C%2FEM%3EIt%20has%20a%20section%20at%20the%20top%20which%20is%20formatted%20separately%20from%20the%20regular%20rows%20and%20columns%20below.%26nbsp%3B%20See%20image%20below.%26nbsp%3B%20I%20want%20this%20feature%2C%20where%20I%20can%20place%20cells%20independently%20from%20the%20formatting%20in%20the%20main%20row%2Fcolumn%20section.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-455793%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20formate%20the%20top%20X%20rows%20independly%20as%20a%20sheet%20header%20from%20the%20lower%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455793%22%20slang%3D%22en-US%22%3EYou%20can%20(manually)%20format%20cells%20in%20any%20way%20you%20like%20using%20the%20tools%20on%20the%20start%20tab%20of%20the%20ribbon.%20I%20think%20that%20is%20precisely%20what%20was%20used%20to%20get%20the%20layout%20and%20appearance%20in%20that%20screen-shot.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-455839%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20formate%20the%20top%20X%20rows%20independly%20as%20a%20sheet%20header%20from%20the%20lower%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455839%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20sorry%2C%20but%20I%20don't%20see%20a%20%3CEM%3EStart%3C%2FEM%3E%20tab%20in%20the%20ribbon%20or%20the%20%3CEM%3ETools.%20%3C%2FEM%3ECan%20you%20please%20clarify%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-455869%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20formate%20the%20top%20X%20rows%20independly%20as%20a%20sheet%20header%20from%20the%20lower%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455869%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F321448%22%20target%3D%22_blank%22%3E%40wcstarks%3C%2FA%3E%20Apologies%2C%20it%20is%20the%20Home%20tab%2C%20in%20Dutch%20it%20is%20called%20Start.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-455912%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20formate%20the%20top%20X%20rows%20independly%20as%20a%20sheet%20header%20from%20the%20lower%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455912%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWell%2C%20the%20Merge%20and%20Center%20feature%20is%20still%20associated%20with%20the%20formatting%20of%20the%20columns%20below.%26nbsp%3B%20It%20does%20not%20allow%20formatting%20independent%20of%20the%20columns%20other%20rows%20and%20columns.%26nbsp%3B%20It%20only%20allows%20one%20to%20merge%20two%20cells%20of%20the%20columns%20or%20rows.%26nbsp%3B%20I%20cannot%20move%20them%20around%20or%20change%20their%20horizontal%20sizes%20without%20affecting%20all%20the%20associated%20columns%20below.%26nbsp%3B%20So%2C%20there%20must%20be%20something%20else%20that%20is%20doing%20as%20shown%20in%20the%20image.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-455950%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20formate%20the%20top%20X%20rows%20independly%20as%20a%20sheet%20header%20from%20the%20lower%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455950%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENever%20mind.%26nbsp%3B%20As%20I%20look%20at%20the%20Invoice%20form%2C%20I%20can%20see%20that%20they%20have%20probably%20just%20merged%20columns.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-458534%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20formate%20the%20top%20X%20rows%20independly%20as%20a%20sheet%20header%20from%20the%20lower%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-458534%22%20slang%3D%22en-US%22%3EExactly.%20Though%20I%20always%20recommend%20NOT%20to%20merge%20cells%2C%20but%20rather%20to%20use%20Center%20accross%20selection%20(from%20the%20format%20cells%20dialog%2C%20horizontal%20alignment%20dropdown)%3C%2FLINGO-BODY%3E
wcstarks
Occasional Contributor

I see various templates which show a header section at the top of the sheet which in formatted independently from the lower rows.  I would like to have a few cells in the "header" not tied to the formatting of the rows below.  How is this done

8 Replies
Highlighted
Not sure what you mean, but perhaps you are looking for the "Format as Table" functionality?

@Jan Karel Pieterse 

For example, when I open Excel, I can choose a template.  Several templates show a sheet header, with the rows and columns below.  The first template I see is one for Sales Invoice Tracker.  It has a section at the top which is formatted separately from the regular rows and columns below.  See image below.  I want this feature, where I can place cells independently from the formatting in the main row/column section.

You can (manually) format cells in any way you like using the tools on the start tab of the ribbon. I think that is precisely what was used to get the layout and appearance in that screen-shot.

@Jan Karel Pieterse 

I am sorry, but I don't see a Start tab in the ribbon or the Tools. Can you please clarify?

@wcstarks Apologies, it is the Home tab, in Dutch it is called Start.

@Jan Karel Pieterse 

Well, the Merge and Center feature is still associated with the formatting of the columns below.  It does not allow formatting independent of the columns other rows and columns.  It only allows one to merge two cells of the columns or rows.  I cannot move them around or change their horizontal sizes without affecting all the associated columns below.  So, there must be something else that is doing as shown in the image.

@Jan Karel Pieterse 

Never mind.  As I look at the Invoice form, I can see that they have probably just merged columns.

Exactly. Though I always recommend NOT to merge cells, but rather to use Center accross selection (from the format cells dialog, horizontal alignment dropdown)
Related Conversations
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies