This specific tutorial is a single movie from chapter one of the Office 2008 for Mac: Small Business Projects course presented by lynda.com author Maria Langer. I'd like to be able to change the formatting (color, size, font) of a Combo Box in Excel for Mac but cannot find a solution or come up with one on my own.

• General: • Sheets in N ew W orkbook: The spinner sets the number of blank worksheets a new workbook will have by default. • Standard F ont: Choose a default font. Unless you have a compelling reason to change this, leave this as “body font,” which is roughly the same as the default font. • Preferred F ile L ocation: Set the default location for Excel files.

• Show This Number of Recent Documents: Set the number of recently used workbooks shown in Excel’s File menu by typing in a figure here. Recently used items in the File menu don’t disappear after a month. This list is based on the quantity you set. • View: • Comments: Adjust how comments are displayed.

• Show F ormulas: Display formulas instead of calculation values. • Show Z ero V alues: Displays a 0 instead of an empty cell when selected. • Show S heet T abs: Deselect to hide all the sheet tabs with the horizontal scroll bar. Selecting redisplays the scroll bar. • Edit: • Automatically convert date systems: When selected, Excel automatically corrects for differences between the 1900 (Windows) and 1904 date systems (Mac) during copy and paste.

The destination workbook’s format is adopted. • AutoCorrect: You can have Excel fix your common typing blunders automatically. • Calculation: When not set to Automatically, working with large spreadsheets with lots of complicated formulas can be faster and easier. If you turn off Excel’s automatic calculation capability, you need to turn it back on again, or Excel’s formulas won’t calculate.

Windows media player on mac for chrome. This is especially important if you turn off automatic calculation using a macro. Free word fonts for mac. Be certain your code turns the Automatically option back on under all circumstances.

I want to have Excel 2011 (for Mac) open to a blank worksheet that is zoomed to 125% and it has taken a very long time to figure this out. It involves saving a template to a buried location, then manipulating the file in Finder to remove the extension.

Simple, once you know the trick. The buried location is: Macintosh HD:Users: username:Library:Application Support:Microsoft:Office:User Templates:My Templates: Or you can check to see where the Excel startup files are located on your computer. Just to go Excel > Preferences then select General and click the Select box for At startup, open all files in. This is where a modified template file should go. Change the Default Workbook in Excel 2011 • Open Excel 2011 • Choose View > Zoom, then select 125% and click OK • Choose File > Save As • In the Save As: box type in Workbook • Click the Format: drop-down button and choose Excel Template (.xltx) • Make sure you save it to the startup location (discussed above) • Click Save Note: Keep in mind that I have to have my workbooks open with just one worksheet.

If you have several worksheets in the Workbook Template file, you may have to set the zoom for each sheet. The Default Workbook Secret The trick now is to open Finder and navigate to the startup folder, select the Workbook.xltx file you just created, and delete the.xltx portion of the file name.

I did this by selecting the file, clicking once to highlight the name, then selected the.xltx extension and hit the delete key. Excel will warn you that this may be dangerous but stay the course and click Remove. Now open Excel 2011 and you’ll be looking at a worksheet that is zoomed to 125% in the default workbook. One More Thing – New Worksheets We’re not done just yet because we need to do the same thing once again, but this time save the file with the name Sheet, so that when you add a new sheet to a workbook the zoom will automatically be set at 125%.

My Summary The default files Excel uses for a new Workbook and a new Sheet are template files, with the extension removed, and located in the startup files location. A common fallacy is that Excel for Mac uses the Normal Template. This belief took me in the wrong direction for quite some time. Hopefully this post will set the record straight. Obviously, you can set more preferences than having a 125% zoom view of the worksheet.