Excel 2010 FAQ

This article contains answers to common questions pertaining to Excel 2010, the latest PC version of Microsoft Excel, a popular spreadsheet program that is part of the Microsoft Office suite of products.

  1. How can I learn more about Microsoft Excel 2010?
  2. Is there anywhere I can watch videos with more information about Microsoft Excel 2010?
  3. I have a file that was made with an Office 2010 program but I don’t have Office 2010. What do I do?
  4. How do I save?
  5. What are the changes Microsoft made in Excel 2010? What happened to the Office Button?
  6. Is it possible to have multiple preset configurations for the Quick Access Toolbar?
  7. Can I make the Ribbon go away?
  8. Is it possible for me to try Office 2010 without installing it on my computer?
  9. What is the maximum number of items I can pin to the Office Button?
  10. How do I change the position of the Quick Access Toolbar?
  11. How do I add worksheets?
  12. I’ve heard that Pivot Tables are really cool. Where can I learn more about them?
  13. After I use the fill handle to copy a formula in one cell to other cells, the Auto Fill Options button appears. How can I get rid of it?
  14. How can I change the default working folder?
  15. What are the benefits of saving as an ‘Excel Binary Workbook’ in Excel 2010? When do we use that option?
  16. In Excel 2010, what is the formula to add a comma to the end of an email address so that I can copy multiple email addresses from a column and paste them into Norse Mail?
  17. What is ClearType?

Q1: How can I learn more about Microsoft Excel 2010?

See the article Excel 2010 Training.
top

Q2: Is there anywhere I can watch videos with more information about Microsoft Excel 2010?

Yes. Lynda.com is a provider of web-based software training videos and resources. If you are interested in access to Lynda.com please contact the Technology Help Desk at [email protected] or 563-387-1000.

top

Q3: I have a file that was made with an Office 2010 program but I don’t have Office 2010. What do I do?

If you just have one file that you need to be converted, email the file to [email protected] and we can convert it for you. You can also install a plugin from Microsoft to let you open and save files in the new format using Office 2000, XP, or 2003. Download the plugin here
top

Q4: How do I save?

Click the File menu found in the top left corner, and click Save.
top

Q5: What are the changes Microsoft made in Excel 2010? What happened to the Office Button?

Switching back from the Office Button of Excel 2007 to the old File menu is just one of the changes Microsoft made in Excel 2010. Some of the other changes and additions include a customizable Ribbon, Sparklines (intra-cell graphic data summaries), Slicers (customizable interfaces for PivotTables and PivotCharts), built-in screen capture and photo editing utilities, Paste Preview, and online Web App functionality. For details, see Excel 2010 Training.
top

Q6: Is it possible to have multiple preset configurations for the Quick Access Toolbar?

Not directly, but you are allowed to let individual documents have a special Quick Access Toolbar configuration. With that in mind, you could then create a document, customize the Quick Access Toolbar the way you want it, and save the document as a template. Then, when you want to edit a document with that Quick Access Toolbar configuration, you may do so by opening that template.
top

Q7: Can I make the Ribbon go away?

Yes, you can minimize the Ribbon by right clicking on it, and clicking Minimize the Ribbon.
top

Q8: Is it possible for me to try Office 2010 without installing it on my computer?

You can download a free 60-day trial here
top

Q9: What is the maximum number of items I can pin to the Office Button?

You can pin as many items as you can fit into the Recent Documents menu in the Office Button.
top

Q10: How do I change the position of the Quick Access Toolbar?

Click the little arrow next to the Quick Access Toolbar, and choose Show Below the Ribbon or Show Above the Ribbon, depending on where your Quick Access Toolbar is already located.
top

Q11: How do I add worksheets?

Click the Insert Worksheet top

Q12: I’ve heard that Pivot Tables are really cool. Where can I learn more about them?

Go to Help within Excel (press F1) and then click on PivotTable reports and PivotChart reports.
top

Q13: After I use the fill handle to copy a formula in once cell to other cells, the Auto Fill Options button appears. How can I get rid of it?

Click on File > Options > Advanced and uncheck the box labeled Show Paste Options buttons.
top

Q14: How can I change the default working folder?

To set the default file location in Excel,

  • Click the File menu
  • Click Options in the bottom right
  • Click Save on the left side
  • Under “Save workbooks”, type the path in the Default file location box.

This only sets the default for Excel. You follow similar steps to set the default location in Word and the other applications in the Office suite.
top

Q15: What are the benefits of saving as an “Excel Binary Workbook” in Excel 2010? When do we use that option?

The online help for Excel 2010 says: “In addition to the new XML-based file formats, Office Excel 2010 also introduces a binary version of the segmented compressed file format for large or complex workbooks. This file format, the Office Excel 2010 Binary (or BIFF12) file format (.xlsb), can be used for optimal performance and backward compatibility.” In addition, Wikipedia says that using the binary form rather than XML documents helps opening and saving documents more quickly and efficiently. Intended especially for very large documents with tens of thousands of rows, and/or several hundreds of columns.
top

Q16: In Excel 2010, what is the formula to add a comma to the end of an email address so that I can copy multiple email addresses from a column and paste them into Norse Mail?

In excel 2010 you can copy email adresses from a column and paste them into your Norse Mail address bar. Once you click out of the address bar, the emails will be arranged with commas in between. You can also use the following formula in a new column: =A1&”,”
top

Q17: What is ClearType?

ClearType is a technology developed by Microsoft to make it easier to read text on flat panel screens. It uses font antialiasing to give text a more crisp, smooth look. If you like, it can be turned off in the options for the program you are using.
top

Read more training and instructional articles.