Configuring Excel This page describes aspects of changing the program options, setting defaults for worksheets, workbooks and toolbars. There are separate sections for Excel 2010. Excel 2010 - current versions of Windows Where to start? If the date characters (e.g. MM/DD/YY) are in the wrong order for your country and page layout measurements are in the wrong units (i.e. Inches or centimeters) the problem lies in your PC settings rather than with Microsoft Office. From the Windows Start menu, select Control Panel Clock, Language and Region .

Check that the language is set to English UK (or whatever is appropriate for your location) and that the number, time, date and currency settings are as you wish them to be. Some of the default setup options within Excel can be modified by selecting [File] Options. • The default file location is important and specifies the name of the folder on your PC (or network) which will contain all of your data files (i.e. Don't ever save your files in any of the Excel program folders. This will make backing up or copying files extremely difficult. You should create a new folder and name it something like 'C: Users local_name Documents Excel'.

• The number of worksheets in each new workbook. By default this is three and you can Insert more at any time if you need them.

Quit all Microsoft Office for Mac applications. On the Go menu, click Home. Open Library. Note The Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu. Open the Preferences folder. Click View, click Arrange by, and then select Name. Excel automatically opens files that are stored in both the Excel Startup folder and an optional alternate startup folder. To prevent a file from opening each time you open Excel, move the workbook from either the.

• To set the default Font and Size e.g. Arial 11, select [File] Options General. • If you intend to write any macros or add visual basic code to a spreadsheet the [Developer] ribbon must be activated. Select [File] Options Customize Ribbon . In the Main Tabs box, make sure that the Developer check box is selected. B A special file called Personal.xlsb can be used to save any macros or user defined functions which you want to be available for general use and which are not specific to (and saved within) a particular spreadsheet. The personal workbook is not saved using the normal File Save options.

To create it [a] open Excel and select the ribbon option [Developer] Code Record Macro. [b] In the Record Macro dialog box, ensure the macro is to be stored in the Personal Macro Workbook. Move the cursor to represent a simple macro command and then Stop Recording. This macro probably does not have any purpose other than to cause Excel to create the Personal.xlsb file.

[c] Close all other workbooks and exit from Excel. The program will prompt you to save a new Personal macro workbook. Thereafter, whenever you open Excel, the Personal macro workbook will open as a hidden file and any saved macros will be available. In order to edit or add a macro, the workbook must be unhidden via: [View] Window Unhide and then using the [Developer] Code Visual Basic option.

After editing the code, hide the workbook again. Dvb-t usb dongle driver for mac. When Excel is closed, you will be prompted to save the changes. If Excel fails to recognise and automatically load the Personal workbook, try moving the file from a personal XLstart folder into the machine XLstart folder (see below). Whenever you record and save a macro you are given the option of saving it in either the current workbook or in your Personal macro file. Remember that if you give someone else a workbook which makes use of a function stored in your Personal file, the function won't be available to them and an error will occur in any cells where it has been used. Even if you can not write programs in visual basic, Excel allows you to record useful macros.