ticking cells

ticking cells

Didn't find your answer?

I want to tick the numbers in my spreadsheet cells and see that i have ticked them as being checked.

Does anyone know how to do this.
I use Excel 5.0

Eric Michael Macias

Replies (6)

Please login or register to join the discussion.

avatar
By newmoon
04th Mar 2003 14:44

Another way!
If the ticks are to go in one column or row, set the font for the row to Wingdings 2, put your capital lock on, and press 'P' to get a tick.
Possibly set the font size to '14' to get a clearer tick.
Press upper case 'o' to get a cross.
Simple - and quick to use!

Thanks (0)
avatar
By SFoster
03rd Mar 2003 18:10

Make them bold
...that's what I do.

Thanks (0)
avatar
By AnonymousUser
03rd Mar 2003 20:17

Tick marks
I use the asterix * on the numberpad in the adjacent column, for example, when checking off cheque journal entries with bank statements. I narrow the "tick" column to 1 or 2 characters wide.
Hope this helps.

Thanks (0)
avatar
By newmoon
03rd Mar 2003 21:05

Wingdings 2
I hope this works with your version of Excel.
Go to 'Insert' then 'Symbols' and choose font Wingdings 2, where you will find it as character 80.
Insert this in a cell and then copy and paste to all the cells you want it in.

Thanks (0)
avatar
By neileg
04th Mar 2003 10:33

Why make it hard?
All these ideas are fine, but I just use a y in the next column. Much easier that popping up the character map or copying and pasting. I can then filter on blanks in this column to show those items not yet reconcilled.

Other of my colleagues use the highlighting approach, which works, but takes longer.

Thanks (0)
avatar
By TODDJOEL
03rd Mar 2003 19:30

Spreadsheet Ticks
Eric

I get ticks by using the font Monotype Sorts in the check cell and putting in 4 - I think I found this some time ago by trial & error.

It might work with some other fonts - hope it helps.

Stan Harvey

Thanks (0)