A TECHTORIAL

TEXT IN AN EXCEL WATERMARK


Sometimes, you'll want to use text as a watermark; for example, when indicating that data is confidential during parent conferences or for other unofficial uses. Using text as n Excel watermark is trickier than using an image, but it can be done. Just be prepared to play around a little here and there!

  • Open Excel (or a new spreadsheet).
  • Click View > Header and Footer > Customize Header.
  • Click in the Center Section.
  • (Here's where the playing around comes in!) Hit ENTER/RETURN on the keyboard about 20 times, and then type the text you want to use as the watermark.
  • Highlight the text you typed, and click the Format Text icon.

  • Choose a font type, style, and size. (Note: There is no option to lighten the text or change its orientation. Keep that in mind as you play with where the text will land on the spreadsheet.)
  • Click OK twice.
You might need to type data into your spreadsheet (or go to File > Page Preview) to see the watermark.

For those comfortable with Excel and other programs, if you must have a text watermark that's more transparent, considering the following:

  • Create a watermark in Excel.
  • Take a screen shot of the watermark.
  • Save the screenshot as a .jpg.
  • Insert the watermark text (now actually an image).
  • Make the image transparent. Phew!

Next: Learn more.

 

 
Close window