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
Highlighted
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
Highlighted

@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.

Highlighted
Solution

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

 

Highlighted

You are welcome

Highlighted

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

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

Thank you
Rich
Highlighted

@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