Excel 2007 | How To Put In Error Bars

 
This is a great and simple tip for creating error bars in your spreadsheet. We provided both step-by-step instructions you can download as well as screen shots of each step.
Click here to receive updates automatically: Subscribe to admins4admins.com by Email
HOW TO PUT IN ERROR BARS IN EXCEL
1. Click to select the chart.
2. Click on “Chart [...]

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 need [...]

Excel 2007 | How To Minimize The Ribbon

  
Great tip for creating more space in your spreadsheet is to minimize your ribbon. As you add more data to your spreadsheet, all the space saved is valuable. Try this tip to free up some space!
DOWNLOAD THE STEP-BY-STEP INSTRUCTIONS HERE:
Excel 2007 | Minimize The Ribbon (PDF)
 
HOW TO MINIMIZE THE RIBBON
1.         Click on the “Customize Quick [...]

Excel 2007 | Split Information Across Multiple Cells

 
This excel tip is useful for common tasks as an administrative assistant. Learn to easily split information across multiple cells in excel. The most common use for this is splitting first and last names, phone numbers, titles etc. Follow the simple steps below and you’ll find how easy it is. The PDF  instructions is a great visual [...]

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. On the Data tab, in [...]

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 always, let us [...]