Where are my Excel 2010 gurus?

ASmallWonder

I'm making a form for my team so they can give me all kinds of information I need to fill out another form (efficient, huh?  Don't even start me on that lol).  One of the columns is going to ask them to indicate which departments are impacted by this entry and there are 9 options.  Can I/how can I make a cell with check boxes with all 9 options?  I know I could make each entry 9 rows long with a drop down available in each and they can populate any of the 9 rows but I'd really love to have all 9 in one cell.

momofcatan

https://office.microsoft.com/en-ca/excel-help/add-a-check-box-option-button-or-toggle-button-to-a-worksheet-HP010342138.aspx

Like this? Not sure how clear those instructions are, I can't check it out myself because I'm stuck in excel 2003...

Nix55

majwv8 said:

I'm not answering your original question, but have you worked with Google docs and Google forms? That's my goto for surveying people and organizing the responses in a spreadsheet.

My thoughts exactly. Google sharing has been life changing for me at work.

ASmallWonder

@steamboat123 I've never used infopath @majwv9 I haven't used Google docs and forms before.  Unfortunately, this needs to go on a sharepoint for my company and not hosted externally :-(

BUT!  I did manage to figure out how to add the check boxes so that you all