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