Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Attendance in Excel with Checkboxes

Excel

  • Please log in to reply

#1
mclimbin

mclimbin

    Member

  • Member
  • PipPipPip
  • 128 posts

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


  • 0

Advertisements


#2
SpywareDr

SpywareDr

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,768 posts

PCWorld > Add checkboxes to an Excel spreadsheet


  • 1

#3
mclimbin

mclimbin

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 128 posts

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.


  • 0

#4
SpywareDr

SpywareDr

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,768 posts

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


  • 2

#5
mclimbin

mclimbin

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 128 posts

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

Thanks so much! This is very helpful.

Michael


  • 0

#6
SpywareDr

SpywareDr

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,768 posts

You're more than welcome. :)


  • 0

#7
mclimbin

mclimbin

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 128 posts

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!


  • 0

#8
SpywareDr

SpywareDr

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,768 posts

Try clicking Formulas > Show Formulas.


  • 0






Similar Topics


Also tagged with one or more of these keywords: Excel

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP