FREQUENTLY-ASKED QUESTIONS ABOUT EXCEL 2007
Here are some of our most-frequently-asked
questions about using Excel 2007, along with the answers!
How to use the short cut keys for commands and functions
Excel 2007 files opens in "Read Only" in the older versions of MS Office
Shortcut keys instead of using the mouse
Open Word, Excel or PowerPoint, press the ALT key on the keyboard one time. You should notice a letter on each tab of the ribbon. Press the letter that corresponds with the ribbon tab. Now each function will display a letter, letter combination or number keystroke. They display in upper case letters but they are not case senstive. If a combination of letters is displayed press the first one followed by the second one.
Files open in "Read Only"
When opening an Excel 2007 file in Excel XP, 2000 or 2003 and the user receives the following message:
"The file has been converted to a format you can work with, but the following issues were encountered. The file has been opened in read-only mode to protect the original file. This workbook uses more rows and/or columns than are supported in this version of Excel."
Remove the Set Print Area if one has been set. Use the Print Preview to view the sheets. In the lower left hand corner look for the number of pages. If grid lines or colored areas were placed on a whole row or whole column you may be seeing hundreds of pages. Grid lines and colored areas should only be placed on actual data. You must clear all other unnecessary formatting.
