The basic principles for creating, loading, and saving Excel documents are similar to those for Word documents.

You can start the Excel program from the Main windows menu using the command START - Programs - Microsoft Excel. Also, the program can be launched by any of the standard ways launching applications, including double-clicking on the document icon associated with Excel. When you start Excel without specifying a file name, the processor by default prompts you to start creating a new document with a conventional name book1.

Excel document templates have a standard *.xlt extension. If a template name is not specified in the autoload directory, then a new Excel document (workbook) is created with the default settings.

By default, Excel 2000 saves workbooks in the Excel 2000 format, which is identical to the Excel 97 file format but differs from the Excel 2000 file format. previous versions. When you open and save an Excel 2000 workbook in Excel 97, some properties that are unique to the Excel 2000 version are lost. Excel 2000 provides the ability to save the workbook in a special double format(Microsoft Excel 97 - 2000 & 5.0/95). In this case, the book is saved in one file, which includes the format

Excel 2000 without losing any of the features specific to that version.

Shut down Excel like any other Windows applications, is the closing of its window.

Program window

The general view of the Excel 2000 program window is shown in the figure. The Excel window contains all the standard elements inherent in the Windows application window (Fig. 1).

fig.1

Title bar contains the name of the application, the name of the open document, the system menu button, standard window control buttons.

In the Excel window, as in the window of any other Windows application, there are vertical and horizontal scrollbars.

Menu bar the Excel window differs from the Word menu bar by the appearance of only one item Data instead of paragraph Table. Command DATA is intended for manipulations with the contents of table cells (for example, sorting, filtering, data consolidation, etc.).

Toolbars Excel 2000 windows Standard And Formatting are displayed by default on one line in an abbreviated form and contain the most important buttons of similar panels in the Word program. In Excel 2000 using the button Cancel you can undo the last 16 operations.

Fig.2

Below the toolbar in the Excel window is formula bar,(Fig. 2)

which is used to enter and edit data in cells and contains:

1. Name field- a drop-down list that displays the address or name of the active cell or block of table cells.

2. A string field for entering and editing data, intended for viewing and editing text data. Row feature (field)

input and editing is that it:

Yo fully displays the contents of the active cell, which is sometimes not visible in the cell itself;

Y allows you to see the formula or function contained in the current cell, and not her result displayed in the cell itself;

3. Three buttons appear between these fields during data entry to control the entry process:

Ё Change the formula - [=],

ё Confirmation of input - [v],

Ё Cancel input - [x]

Working field(sheet) (Fig. 3) of the Excel window consists of cells, column names and rows. At the top of the worksheet is a row of table column headers.

rice. 3

On the left are the row numbers of the table. At their intersection is an "empty" gray button, which serves to select the entire worksheet.

Below the entire working field is a line with labels (titles) of worksheets available in the book. To the left of the tabs are buttons for moving through the worksheets of the document, and to the right is a horizontal scroll bar.

At the very bottom of the Excel window is the status bar. spreadsheet processor(hint line). It is designed to issue messages to the user regarding his possible actions in this moment. The status bar can contain a spreadsheet status indicator that reflects its mode of operation (Ready, Enter, Edit, Macro Recording), a decoding of the current menu command, and a hint about the purpose of the button used. In addition, there is an auto-calculation field on the status bar, which is used to quickly calculate and view intermediate results. Excel is a reusable program, i.e. Allows you to open multiple documents at the same time. Move between windows open documents can be done by clicking on the document icon on the taskbar or via the Window menu. You can arrange the arrangement of open Excel document windows using the WINDOW - Arrange command. Window Excel document can be divided into two or four subwindows and simultaneously work with different parts of the same table. You can split windows using the command WINDOW - Split, or using window separators - black rectangles on the scroll bars. You can close the window with the menu command WINDOW - Unsplit

In this article, I will give you a step-by-step example with pictures and a fragment of the simplest ready-made VBA code.

How to execute a VBA macro in Excel

For example, the easiest way to run a macro is to understand but difficult to implement:

Macro program to perform its functions.

Now we can move from simple to even simpler) After all, running macros in this way is very inconvenient. Let's look at some simpler options.

Useful advice! If you want to edit a macro then select it in the list of the above described tool and click on the "Enter" button instead of using the "Edit" button. Using the enter button, you can always go to the source code of the selected macro. The Visual Basic editor will automatically open exactly in the place where the code for this macro is written. The "Edit" button, unfortunately, does not work the same way for all macros.

Attention! Macros created in Excel add-ins may not be available by default in the Macro dialog box list for security policy purposes. After all, macro names in Excel add-ins are usually hidden from third-party users. But if you enter the correct corresponding value in the "Macro Name:" field, then all the buttons in the dialog box will be active. This means that they are ready to work with this macro from the add-on and the user is the author of the add-on or a trusted person.

Running a macro with hotkeys

For each macro in Excel, you can assign your own combination of hot keys. Thanks to this, you can call your macro program when you press a specific key combination on the keyboard. What could be easier?

To assign your own key combination for a specific macro, do this:

Now press your hot key combination to call the selected macro. As you can see, your macro has now been assigned a shortcut key combination.

Note! The Macro Options dialog box provides a field for entering a description of the macro. This description will be available at the bottom when selecting a macro from the list. We recommend that you always sign your macros. This custom tone of Excel ethic will be greatly appreciated when the list is filled with dozens of macros.

Useful advice! Try not to use popular hotkey combinations for working with Excel: CTRL+S; CTRL+A; CTRL+T; CTRL+C; CTRL+V; CTRL+SHIFT+L etc. After all, then their purpose will be changed. In the "Macro Options" window, it is also possible to use the SHIFT key in key combinations. As soon as you give keyboard focus to the "Keyboard shortcut: CTRL+" input field and try to enter a capital letter for the combination, naturally using the SHIFT key on the keyboard, the name of the input field will immediately change to "Keyboard shortcut: CTRL+ SHIFT+".

The result will be a slightly longer combination, which will allow you to expand the options to bypass commonly used hotkeys.

How to run a macro from the Quick Access Toolbar

Excel allows users to run macros using the panel quick access to the tools. This panel is located at the very top of the program window by default.

To run a macro using the Quick Access Toolbar, you need to do this:

Now on the quick access toolbar there is one more button for. Just click on it and the macro will immediately run.

Useful advice! To change the appearance of a button for a macro in the "Excel Options" - "Quick Access Toolbar" window, select the macro from the right list of "Customize the Quick Access Toolbar" and click the "Change" button. A small gallery of icons for the new design will be offered appearance macro launch buttons from the toolbar.

The main disadvantage of placing a button with a macro on the toolbar is that the button will always be available for other files, even when the file with this macro is closed. And if in such cases you click on the macro start button, then the file where it is located will open and only then the VBA code will be executed.

Run a macro from a button in an Excel worksheet

If you only want to run a macro from within an Excel workbook, where does it contain its source code? In such cases, a great solution would be to create a button on Excel sheet and assign it to run a specific macro. For this:

After you create a button, you can customize it by changing its size and position on the sheet. To do this, right-click on the button again, and then press the Esc key on your keyboard to hide context menu. The button will have markers with which you can change its size. Move the mouse cursor over any marker on the edges or corners of the button and hold down the left mouse button and drag, thus changing its size. Now click on the button with the left mouse button and while holding it, move the button across the sheet of the Excel document to any other place. To commit all button changes, click the left mouse button in any area of ​​the sheet (for example, in any cell) outside the button area.

Now if we click on the button with the left mouse button, the VBA code assigned to it will immediately be executed.

If the software package is already installed on your computer Microsoft Office 2013, you can immediately launch Microsoft Excel 2013 and start exploring it in depth. If you are just going to install it, refer to the installation article. The process is detailed there. Microsoft installations Office 2013. In this article, we will cover the launch of Microsoft Excel 2013 and the basic questions regarding the creation of documents.

If you have Windows 8 operating system installed on your computer, to run Microsoft Excel 2013 you need to home screen use the scrollbar to move to the right (to see the tiles that do not fit on the screen) and click on the Excel icon (it is green). An example of the location of this icon on the home screen is shown in fig. 1.1.

If you are using operating system Windows 7, click on the button Start, in the menu that appears - on the Microsoft Office 2013 folder, and then in the drop-down list - on the Excel 2013 item (Fig. 1.2). As a result of these actions, the start window of Microsoft Excel will open (Fig. 1.3).

Here you need to immediately clarify that the document you are working with in Microsoft Excel is called a book. The start window allows you to select a book that you have worked with before from the list on the left side of the window, or create a new book. Moreover, you can create an empty book, or you can create a book based on a template. Sample- this is a blank book with pre-made inscriptions and other elements. Templates help you quickly create documents of the same type. If you are creating a book for the first time, click on the Blank Book item, as shown in Figure 1. 1.3.

A window will open with the caption book1- Excel and a blank sheet with a grid separating cells in the workspace of the window. You can get to work.