Excel 2007 | How To Protect Selected Cells

Protecting selected cells is a great feature to use if users need access to your spreadsheets. This gives people the option to modify your spreadsheet with the exception of the few cells that you’ve protected. Use this tip if you’re creating forms, schedules or applications! As always, let us know if there are things you [...]

Excel 2007 | How To Insert A Pop-Up Picture In A Cell

Pop-ups in your Excel spreadsheet make your document look more alive. Use this quick tip to help spice up your presentation! As always, let us know if there are things you need help with. You can receive these updates automatically through email by clicking below: Subscribe to admins4admins.com by Email HOW TO INSERT A POP-UP [...]

Excel 2007 | How To Insert Drop-Down List

 Create professional looking spreadsheets by including drop-down lists. Here’s how:    HOW TO FIND THE PASSWORD OPTION IN EXCEL 2007 1. To create a list of valid entries for the drop‐down list, type the entries in a single column or row without blank cells 2. Select the “cell” where you want the drop‐down list. 3. [...]

Excel 2007 | Passwords – Where Did That Option Go?

 If you’re anything like me, you probably got lost trying to find the basic things in Excel 2007. Creating passwords for my worksheets was one of the many things I couldn’t find in this new program. Well, stress no more. Here it is! Who knew they would hide it under “Save As”?      As [...]