Check Box

J

Jffphll08

I have a worksheet that I am using to keep track of payments made. I want to
make the cells checkboxes but I want the checks to print when I print the
document.

I cannot even figure out how to create the text box.
 
G

Gord Dibben

An alternate method.

Format the cells to Marlett font then simply type lowercase "a"

If you want a checkbox, open the Forms Toolbar and select the checkbox.

Draw it where you want then right-click on the edge and Format
Control>Properties>.........chackmark in "Print Object"


Gord Dibben MS Excel MVP
 
F

FSt1

hi
if you have a lot of checks, a checkbox may be more trouble than it's worth.
instead you could format the column that you intended for check boxes to the
font
"Marlett" . you could then use the lower case letter "a" to produce a check.
font format "wingdings2" - upper case P produces a check and upper case R
produces a check inside a square. all of these should print on any standard
printer.

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PMT 3
payment worksheet 2
Blank Sheet with Gridlines 11
How do I track credit card debt on one spreadsheet? 1
Excel Excel to track expenses 1
Print Area to include text box 10
Simulate Check Box 10
Spell Check Unlocked Cells Only 9

Top