FREQUENTLY-ASKED QUESTIONS ABOUT EXCEL 2007
Here are some of our most-frequently-asked
questions about using Excel 2007, along with the answers!
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.
Convert UPPERCASE to lower or Proper case without retyping
Stop the retyping and follow these steps. This is a two part process. First you will create a formula to convert the text then you will copy and paste the value into a new column.
1. Insert 2 blank columns to the right of the column in question (A). The example below shows column A in UPPERCASE column B and C are blank, column D has a location.
2. In this example a formula would be placed in the first cell to the right of the first name B2.
3. Type the following formula =Proper(A2) pressing enter will convert the UPPERCASE NAME to the proper case name. Example below shows both the formula and the proper case name.
4. Now using the Autofill handle in the lower right hand corner of B2 click hold and drag this down the column to copy the formula that converts the character case. DO NOT DELETE COLUMN A at this time.
5. Now that column B has the proper case displayed you must copy Column B and paste it into column C using Paste Special. Reminder: Column B is only displaying a value of a formula not the actual text. Click on the column heading B to select the column. Copy using CTRL+C or the copy icon.
6. Paste Special: Right mouse click in cell C2, then select Paste Special from the quick menu. The Paste Special dialog box will appear.
7. Click on the radio button for Values. This will paste the value of the convert formula into column C.
8. If Column C looks correct you can now delete Column A and B.
Note: There are two other formulas that change case as well: =UPPER(cell) will convert to all upper case characters. =LOWER(cell) will convert to all lower case characters. Replace (cell) with the actual cell location.