SOLVED
Home

Including a note on top of every page - not a header

%3CLINGO-SUB%20id%3D%22lingo-sub-679167%22%20slang%3D%22en-US%22%3EIncluding%20a%20note%20on%20top%20of%20every%20page%20-%20not%20a%20header%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679167%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20doing%20an%20Excel%20spreadsheet%20for%20a%20legal%20matter%20and%20need%20to%20include%20a%20note%20on%20the%20top%20of%20each%20page%20indicating%20it%20is%20confidential%20and%20subject%20to%20attorney%2Fclient%20privilege.%20It%20is%20a%20working%20spreadsheet%20not%20meant%20to%20be%20printed%20so%20I%20cannot%20use%20the%20Header%20feature%20--%20I%20need%20it%20to%20appear%20on%20the%20top%20of%20every%20sheet%20in%20my%20workbook.%20How%20can%20I%20do%20this%20and%20still%20be%20able%20to%20format%20the%20cells%2Fcolumns%20for%20the%20remainder%20of%20the%20workbook%3F%20I%20tried%20inserting%20the%20text%20in%20Row1%20and%20merged%20the%20cells%20but%20then%20I%20won't%20be%20able%20to%20manipulate%20the%20columns.%20Anyone%20have%20any%20ideas%3F%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-679167%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-679187%22%20slang%3D%22en-US%22%3ERe%3A%20Including%20a%20note%20on%20top%20of%20every%20page%20-%20not%20a%20header%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679187%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357035%22%20target%3D%22_blank%22%3E%40Claudia534%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENever%20merge%20the%20cells.%20Type%20your%20note%20in%20first%20cell%2C%20select%20range%20in%20first%20row%2C%20Ctrl%2B1%20and%20Center%20across%20selection%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20637px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117533iC499672437178AF6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EWith%20some%20formatting%20the%20result%20is%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20370px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117534i06B106808A257EB4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eand%20you%20and%20you%20may%20work%20with%20your%20columns%20separately.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-679190%22%20slang%3D%22en-US%22%3ERe%3A%20Including%20a%20note%20on%20top%20of%20every%20page%20-%20not%20a%20header%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679190%22%20slang%3D%22en-US%22%3E%3CP%3ESergei%2C%20THANK%20YOU!%26nbsp%3B%20I%20knew%20it%20was%20probably%20something%20very%20basic%20--%20I%20appreciate%20your%20assistance!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-679191%22%20slang%3D%22en-US%22%3ERe%3A%20Including%20a%20note%20on%20top%20of%20every%20page%20-%20not%20a%20header%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679191%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-679192%22%20slang%3D%22en-US%22%3ERe%3A%20Including%20a%20note%20on%20top%20of%20every%20page%20-%20not%20a%20header%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679192%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bupdate%3A%26nbsp%3B%20it%20worked%20like%20a%20charm!%26nbsp%3B%20Thanks%20again!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-679325%22%20slang%3D%22en-US%22%3ERe%3A%20Including%20a%20note%20on%20top%20of%20every%20page%20-%20not%20a%20header%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679325%22%20slang%3D%22en-US%22%3EWhat%20a%20great%20reply%2C%20all%20these%20years%20of%20hassles%20with%20merged%20cells%2C%20never%20too%20old%20to%20learn!!!!!%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%3CBR%20%2F%3ERich%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-679428%22%20slang%3D%22en-US%22%3ERe%3A%20Including%20a%20note%20on%20top%20of%20every%20page%20-%20not%20a%20header%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679428%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357035%22%20target%3D%22_blank%22%3E%40Claudia534%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20a%20further%20thought.%26nbsp%3B%20Since%20your%20confidentiality%20statement%20is%20to%20be%20the%20same%20on%20every%20sheet%20it%20might%20be%20best%20to%20insert%20every%20heading%20at%20the%20same%20time%20by%20selecting%20the%20sheet%20tabs%20with%20shift%20and%20the%20left%20mouse%20button%20before%20following%20Sergei's%20instructions%20(don't%20forget%20to%20select%20just%20one%20sheet%20before%20you%20return%20to%20working%20on%20it%20though).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20since%20we%20are%20discussion%20'centering'%20for%20the%20confidentiality%20statement%20it%20suggests%20you%20are%20not%20using%20column%20XFD.%26nbsp%3B%20The%20visual%20effect%20of%20a%20page%20can%20be%20created%20by%20selecting%20all%20columns%20to%20the%20right%20of%20the%20'page'%20(Ctrl%2BShift%2BRightArrow)%20and%20hiding%20them.%26nbsp%3B%20Removing%20the%20grid%20from%20white%20space%20is%20another%20device%20to%20make%20a%20spreadsheet%20look%20more%20like%20a%20proper%20document.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Claudia534
New Contributor

I am doing an Excel spreadsheet for a legal matter and need to include a note on the top of each page indicating it is confidential and subject to attorney/client privilege. It is a working spreadsheet not meant to be printed so I cannot use the Header feature -- I need it to appear on the top of every sheet in my workbook. How can I do this and still be able to format the cells/columns for the remainder of the workbook? I tried inserting the text in Row1 and merged the cells but then I won't be able to manipulate the columns. Anyone have any ideas? Thanks.

6 Replies

@Claudia534 

 

Never merge the cells. Type your note in first cell, select range in first row, Ctrl+1 and Center across selection

image.png

With some formatting the result is

image.png

and you and you may work with your columns separately.

Solution

Sergei, THANK YOU!  I knew it was probably something very basic -- I appreciate your assistance!  

 

You are welcome

@Sergei Baklan update:  it worked like a charm!  Thanks again!

What a great reply, all these years of hassles with merged cells, never too old to learn!!!!!

Thank you
Rich

@Claudia534 

Just a further thought.  Since your confidentiality statement is to be the same on every sheet it might be best to insert every heading at the same time by selecting the sheet tabs with shift and the left mouse button before following Sergei's instructions (don't forget to select just one sheet before you return to working on it though). 

 

Also, since we are discussion 'centering' for the confidentiality statement it suggests you are not using column XFD.  The visual effect of a page can be created by selecting all columns to the right of the 'page' (Ctrl+Shift+RightArrow) and hiding them.  Removing the grid from white space is another device to make a spreadsheet look more like a proper document.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies