Question posted 2013 · +7 upvotes
I am looking for a way to insert text into the background of a cell, so that I can still enter numbers on top of that text – similar to a watermark except for an individual cell. Any ways to do this, preferably without using a macro (but open to these solutions as well)?
Accepted answer +6 upvotes
- Select the Cell where you want to make the Background.
- Click “Insert” and insert a rectangular Shape in that location.
- Right click on the shape – select “Format Shape”
- Goto “Fill” and select “Picture or texture fill”
- Goto âInsert from Fileâ option
- Select the picture you want to make water-mark
- Picture will appear at the place of rectangular shape
- Now click on the picture âright clickâ and select Format Picture
- Goto âFillâ and increase the transparency as required to look it like a âWater Markâ or light beckground
- This will get printed also.
Top excel-vba Q&A (6)
- How to clear the entire array? +58 (2010)
- How to change Format of a Cell to Text using VBA +55 (2011)
- Download attachment from Outlook and Open in Excel +43 (2012)
- Can a VBA function in Excel return a range? +36 (2009)
- 2 Dimensional array from range +34 (2013)
- Hiding an Excel worksheet with VBA +33 (2009)
excel-vba solutions on this site
.