Advice 1: How to change the settings in Excel

The table editor Microsoft Office Excel is the most common today an application for working with spreadsheets. After the installation of a new version of this program quite often, you must change its settings to lead them to a familiar sight. Access program settings in recent releases of the editor is organized in different ways.
How to change the settings in Excel
You will need
  • Spreadsheet editor of Microsoft Office Excel.
Instruction
1
Expand the "File" menu in the table editor. If you are using a version of Excel 2010 you need to click the mouse on the green button in the upper left corner of the application window. In version 2007 it is approximately in the same place is a large round button without any inscriptions, which the manufacturer in all the documents refers to Microsoft Office. To open this menu and other method - press Alt and the program will display each menu item letters of the Russian alphabet. Pressing the key with the corresponding letter will reveal the associated menu item "File" are assigned the letter "f".
2
Select "Options"if you are using Excel 2010 is the second from the bottom row in the main menu. In Excel 2007 this item replaces the button with the text "Options Excel", placed in the lower right corner of the open menu - click it. Both of these actions open the settings page spreadsheet broken down into sections, a list of which is placed at its left edge.
3
If you are using an even earlier version of Microsoft Excel (e.g. Excel 2003), then search for the desired item in the "tools" section of the application menu. It's called "Options" and opens a separate settings window, composed of thirteen tabs.
4
A setup table editor, you can change without using the settings page. For example, to change the default zoom level of the pages is enough to spin the mouse wheel while pressing the Ctrl key. Installed in this way, the increase (or decrease) will be automatically saved by the application and used when you next start Excel.
Note
Not always open the document uses the settings set by you in the spreadsheet editor. If this table was created using other systems, when it is saved they have been written to the file and when you open your Excel read and reproduced them especially for this document.

Advice 2 : How to configure Excel

Microsoft Office Excel is designed to analyze and process data, working with formulas, spreadsheets, graphs, charts. The range of actions available for execution in this application is extremely wide. But first, it's better to get acquainted with the software interface to configure MS Excel for themselves.
How to configure Excel
Instruction
1
The developers have ensured that all the necessary user tools were easily accessible and they do not have to search long. So the main menu "File" with the usual commands "Open", "Create", "Save", and so forth collapsed under the Office button in the upper left corner of the program window, and often used options, commands and tools included on the tape.
2
On the ribbon, there are tabs such as "Home", "Insert", "Formula", "Data" and so on. Each tab presents a number of tools that, in turn, are divided into categories and sub-categories. Tape can be shown as in the collapsed and expanded view. To select the view ribbon, click the right mouse button and select marker in the menu "Roll the tape" or, conversely, remove a token from this item using the left mouse button.
3
Over the tape to the left of the Office button located in the quick access toolbar. There may be buttons that the user is often required during operation, for example, with the commands "Save", "Undo last action", "Return action". If you click on the arrow button in the right part of the panel, unfold the submenu. In it, you can mark with a marker the commands that you need, and they will appear as buttons on the quick access toolbar. If commands in the list is too few, select "Other commands" and add the buttons from the expanded list.
4
To customize the status bar, right-click the mouse on the lower pane in the program window. Unfold the menu. Mark with a marker the items that should be displayed when working with Excel worksheet: signatures, page numbers, the mode of the cell, scale and so on.
5
To access the advanced settings in Excel, click the Office button and select the end menu item "Excel Options". This will open a new dialog box. In his left part shows the topics: "Basic", "Formula", "Resources", "add-ins" and so on. At the right of each section you can select certain options for working with Excel, starting with color changing interface, and ending with the setting calculations and working with formulas. All changes in the settings, you must confirm by pressing OK.
Is the advice useful?
Search