• View
• Edit
• History
• Print

Dcf43d75474321009db4b5b08b9a71dc

Summary
Number:	KB0000005	Workflow:	published
Knowledge Base:	IT	Published:	2014-09-09
Category:	Applications / Microsoft / Excel
Author:	Boris Catino
Valid to:	2020-01-01
Short description:	Excel Functionality

---

Excel Functionality

Copying formulas without changing cell locations

1. When you want to know how to copy a formula and keep portions of the formula from changing relative to where they are being copied, precede each portion of the cell specifications that aren't supposed to change with $.
2. For example, if a formula contains the cell reference: B2, which is not supposed to change if the formula is copied to another cell, then change B2 to $B$2
3. If, for example, the column specification, B, can change in B2, but not the row specification, 2, then change B2 to B$2 Similarly, if the row specification, 2, can change in B2, but not the column specification, B, then change B2 to $B2
   
   

How to use formula to manipulate data in Col A and put results in Col B

1. Type a value in box A1
2. Click box B1
3. Click the Summation (sigma) notation symbol in to toolbar (autosum)
4. In the formula box, type "*1.03" after the "+SUM(A1)"
5. Hit Enter -- box B1 will now show the new value.
6. Type in more values in col A (A2,A3,A4, etc).
7. Highlight column B, and select Edit-->Fill-->FillDown, to apply the formula to the entire column.
8. To round values, click the B column and select Format-->Style-->Currency.

Enlarging Default Font Sizes in MS Excel

Click Excel in the upper left hand corner.

1. Select Preferences....
2. Select the General tab.
3. Next to “Standard Font,” you can select the default font type and size.
4. After you click OK, quit Excel to apply the changes.

Defining the print area so that document fits on one page

If you are unable to print the desired area of the spreadsheet on a single page, the print area may be defined incorrectly, or it may need to be specified.

Click and drag the mouse to draw a selection box around the cells that should be printed. In the file menu, highlight "Print Area" and select "Set Print Area." This will surround the cells with a dashed line. Cells that fall outside the print area will be moved to the next page.

To clear an existing print area definition, highlight "Print Area" in the file menu, and select "Clear Print Area."

The maximum size of the user-defined print area depends on the margins of the page. To change the margins, select "Page Setup" in the file menu, and click on the "Margins" tab.

To fit a large area onto a single page, it may be necessary to adjust the scaling of the printed output. To change the scaling, select "Page Setup" in the file menu, and click on the "Page" tab. The output can be scaled by an arbitrary factor, or it can be automatically fit to one or more pages.

I'm getting an error when trying to open an Excel file.

Some users may get errors when opening files with macros in Excel X for Macintosh. Those whose User folders are being stored on a volume other than the startup volume are most likely to be affected. This has been affecting some people trying to submit the Excel-based academic HR forms, which are Excel-based. Deleting the preference file "Office Registration Cache X" often fixes the problem:

1. Quit any programs you have running, especially any parts of the Office suite (Excel, Word, etc.)
2. Go to Go > Home > Library > Preferences > Microsoft.
3. Locate the file Office Registration Cache X and drag it to the trash. (Note: Don't empty the trash just yet.)
4. Try opening the Excel form again.
   If it still doesn't work, repeat steps 1-4 and then continue:
5. Open up TextEdit (found under Go > Applications) and create a new document by pressing +n.
6. Go to File > Save As....
7. Name the file Office Registration Cache X. (Note: Be sure to get the spelling and capitalization exactly.)
8. Save it under Home > Library > Preferences > Microsoft.
   Note: There are actually two libraries: one under the user's Home and one under the Macintosh HD. Be sure to use the one under Home. The exact name of user's Home is the short name of the user's local account on their Macintosh, and it will have a house icon. You can select home by pressing command - shift -h in the Save As dialogue box.
9. Quit TextEdit.
10. Go back to Go > Home > Library > Preferences.
11. Click once on Office Registration Cache X to select it, and then go to File > Get Info.
12. Check the box for Locked.
13. Try the file again.