[mclimbin]

Hello Office gurus,

I would like to set up an Excel spreadsheet that I can use in class to keep attendance. I have a tablet with Win8 and would like to just be able to tap the cell to automatically insert the mark if a student is present. Of course I could tap the cell and then tap a "1," but ideally I'd like to just to cut it down to one action.

 

I have been looking into inserting checkboxes, but they don't seem to be the most efficient way to do this, especially if I want a total column at the end of the row.

 

Do you have any suggestions? I am a pretty basic Excel user but am willing to learn a thing or two.

 

Thanks for your help.

Michael

[Advertisements]

PCWorld > Add checkboxes to an Excel spreadsheet

[SpywareDr]

PCWorld > Add checkboxes to an Excel spreadsheet

[mclimbin]

Thank you for the response. I found that too, but am unsure how to make it work for a spreadsheet that has 30 rows (days in a semester) and 30 columns (students). Can I set up one row and drag it down for 30 rows?

 

It seems like it would leave a huge area of cells (OK, and other 30x30 table) full of "True" and "False." I suppose I could just hide that data and have a column that sums up the number of days.

 

Thanks again.

[SpywareDr]

Like this? Attendance 2014 03.xlsm (57 KB)

[mclimbin]

I never said thank you for this, so here goes:

Thanks so much! This is very helpful.

Michael

[SpywareDr]

You're more than welcome.

[mclimbin]

Hello again SpywareDr. I am playing with your checkbox spreadsheet, but I can't figure out how to expand the sheet, or rather, how to add more columns that will be calculated. When I cut and paste it only pastes the box; when I choose paste special, it only gives options for pasting the box as a .jpg or .png and such. Do you have any suggestions?

 

The problem is that I don't really know what you did to build the sheet so I can't adjust or change it.

 

Thanks!

[SpywareDr]

Try clicking Formulas > Show Formulas.