| Создать | Opens a new blank workbook. |
| Открыть | Displays the File Open dialog box for you to choose a spreadsheet file to open. |
| Список | Displays a list of the 9 most recently used (i.e. opened or saved) files as a shortcut for opening them. |
| Закрыть | Closes the current workbook, after prompting you to save any changes. |
| Сохранить | Saves the current workbook back into the file it was opened from. If this spreadsheet was created with the Файл>Создать menu option rather than opened with the Файл>Открыть menu option, then you will be asked for a file name to save it under. |
| Сохранить как | Displays the File Save dialog box for you to choose a name and location for saving the current workbook. |
| Окно | Displays a list of the currently open workbooks and allows you to select a different one as the active workbook. |
| Печать | Prints the currently displayed sheet. This option will not be available if your device does not support printing. |
| Выход | This shuts down the program, after prompting you to save any changed workbooks. |
| Отменить | This option undoes the last change you made to the spreadsheet, should you make a mistake or just change your mind. There are currently 16 levels of Undo, that is, the program remembers the last 16 things that you did and can step back through them using this menu option. |
| Вырезать | This option removes the contents of the currently selected cells and places them on the clipboard, so that you can paste them somewhere else. Only one selection can be stored on the clipboard at a time, so this will replace whatever was previously on the clipboard. |
| Копировать | This option copies the contents of the currently selected cells and places them on the clipboard, so that you can paste them somewhere else. Only one selection can be stored on the clipboard at a time, so this will replace whatever was previously on the clipboard. |
| Вставить | This option takes the contents of the clipboard and puts it into the currently selected cells. |
| Специальная вставка | When cells are cut or copied to the clipboard, the program stores not only what is displayed in the cell, but also the formula that is in the cell and the formatting. The Вставить menu option will paste all of this information into the target cells, but this menu option allows you to paste just some of that information. A dialog box is displayed for you to choose what is pasted. |
| Заполнение |
| Вниз | Copies the top row of the selection into the other rows of the selection. |
| Вправо | Copies the left column of the selection into the other columns of the selection. |
| Вверх | Copies the bottom row of the selection into the other rows of the selection. |
| Влево | Copies the right column of the selection into the other columns of the selection. |
| Прогрессия | Displays a dialog box that allows you to fill the current selection with a series of numbers or dates. |
|
| Очистить |
| Все | Removes the contents and formatting of the currently selected cells. |
| Форматы | Removes only the formatting of the currently selected cells, leaves the contents unchanged. |
| Содержимое | Removes only the contents of the currently selected cells, leaves the formatting unchanged. |
| примечания | Removes any comments associated with the currently selected cells. |
|
| Удалить | If entire rows or columns have been selected then this menu option will delete the selected rows or columns. Otherwise (that is, one or more cells have been selected) a dialog box will be displayed containing 4 options: (1) со сдвигом влево - delete the selected cells and move the cells on the right of them to the left to take their places, (2) со сдвигом вверх - delete the selected cells and move the cells below them up to take their places, (3) строку - delete the entire rows that the selection spans, the rows below will be moved up, (4) столбец - delete the entire columns that the selection spans, the columns to the right will be moved left. |
| Удалить лист | Delete the currently displayed worksheet, chart or macro sheet. If there is only one worksheet in your spreadsheet file, you will not be allowed to delete it. |
| Переместить/скопировать лист | Allows you to move or copy the current sheet to a different position in the file. |
| Найти | Allows you to look for cells that contain specified things. This menu option displays a dialog box asking you 4 things: (1) the text that you want to search for, (2) whether to look for it in the formulas (what was typed into the cells) or in the values (what is displayed in the cells), (3) whether the search is to be case-sensitive (whether you want upper and lower case letters to be treated as different), and (4) whether to find cells that are equal to the text that you typed or just contain the text that you typed. Entering these and pressing Найти далее will move the cursor to the first cell after the current cursor position that matches your request. The dialog box stays on the screen until it is cancelled, so repeated pressing of the Найти далее button will take you to each of the cells that match your request. |
| Заменить | Allows you to search for text in cell formulas and optionally replace one or all occurrences. |
| Перейти | Allows you to move directly to another part of the worksheet. This menu option displays a dialog box that asks you for a cell reference. Entering the reference and pressing ОК will move the cursor to the specified cell. |
| Ячейки | If entire rows or columns have been selected then this menu option will insert the selected rows or columns. Otherwise (that is, one or more cells have been selected) a dialog box will be displayed containing 4 options: (1) со сдвигом вправо - the cells to the right of the selection will be moved to the right to make room for the new cells, (2) со сдвигом вниз - the cells below the selection will be moved down to make room for the new cells, (3) строку - the entire rows that the selection spans will be inserted, (4) столбец - the entire columns that the selection spans will be inserted. |
| Строки | Inserts one or more new rows where the selection is. |
| Столбцы | Inserts one or more new columns where the selection is. |
| Лист | Inserts a blank worksheet at the end of the spreadsheet file. |
| Диаграмма |
| Лист | Inserts a new chart sheet at the end of the spreadsheet file. If no cells have been selected then the Формат диаграммы dialog box will be displayed, otherwise a default column chart will be built using the selected data. |
| Объект | Inserts a new chart object on the current worksheet. Drag the pointer across the worksheet to indicate where the chart should be placed. If no cells have been selected then the Формат диаграммы dialog box will be displayed, otherwise a default column chart will be built using the selected data. |
|
| Макрос | Inserts a blank macro sheet at the end of the spreadsheet file. Macro sheets are used for storing custom (user-defined) functions and commands. |
| Функция | Displays a dialog box from which you can select a function to be inserted into the current cell formula. |
| Имя |
| Присвоить | Displays a dialog box showing the names that have been defined for references in this spreadsheet file. It allows you to add new names, change the references of existing names, or to delete names that are no longer required. |
|
| Примечание | This option allows you to add a comment to the currently selected cell. If there is already a comment attached to the cell, then this option will be changed to Изменить примечание, and the existing comment will be displayed for you to change. You can press the Escape key to leave without entering or changing the comment, or you can click outside the comment box to save the changes. When a cell contains a comment, there will be a comment indicator in the top-right corner of the cell. To display a comment you can either use this menu option, or you can click and hold the pointer on the cell for 1/2 a second, the comment will be displayed until you move or release the pointer. To remove a comment from a cell, use the Правка Очистить Примечания menu option. |
| Элемент управления |
| Метка | Inserts a label. |
| Окно группы | Inserts a group box. |
| Кнопка | Inserts a command button. |
| Флажок | Inserts a check box. |
| Кнопка | Inserts an option button. |
| Окно списка | Inserts a list box. |
| Раскр список | Inserts a combo box. |
| Полоса прокр | Inserts a horizontal or vertical scroll bar. |
| Рег счетчика | Inserts a spin control. |
|
| Графический объект |
| Линия | Inserts a line. |
| Прямоуг | Inserts a rectangle. |
| Овал | Inserts an oval. |
| Подпись | Inserts a text box. |
|
| Ячейки | Displays a dialog box that allows you to change the way that the contents of the selected cells are displayed. You can change the way that numbers, amounts of money, dates, times and text are formatted. You can change the colour of the text, the pattern and colour of the cell background, and the type and colour of the cell borders. |
| Строка |
| Высота | Displays a dialog box showing the current height of the selected rows in points (the unit of measurement used for text), and allows you to change it. You can also change the row height by dragging the separator between the row numbers. |
| Автоподбор высоты | Sets the row height to the largest required for the values displayed in the row. You can also autofit a row by double-clicking on the separator below the row number. |
| Скрыть | Hides the selected rows. |
| Отобразить | Unhides the selected rows. Because you cannot select individual hidden rows, you will have to use the Правка>Перейти menu option to move the cursor to the required row, or select all the rows from the one above the hidden rows to the one below, before using this option. |
|
| Столбец |
| Ширина | Displays a dialog box showing the current width of the selected columns in characters, and allows you to change it. You can also change the column width by dragging the separator between the column headings. |
| Автоподбор ширины | Sets the column width to the largest required for the values displayed in the selected cells. You can also autofit a column by double-clicking on the separator to the right of the column heading. |
| Скрыть | Hides the selected columns. |
| Отобразить | Unhides the selected columns. Because you cannot select individual hidden columns, you will have to use the Правка>Перейти menu option to move the cursor to the required column, or select all the columns from the one to the left of the hidden columns to the one to the right, before using this option. |
| Стандартная ширина | Displays a dialog box showing the default width of the columns on the current sheet, and allows you to change it. |
|
| Лист |
| Переименовать | Displays a dialog box showing the current sheet name, and allows you to change it. |
| Скрыть | Allows you to hide the currently displayed sheet. |
| Отобразить | Allows you to select a hidden sheet to be displayed. |
| Сетка | Allows you to turn the gridlines on and off for the current sheet. |
| Заголовки | Allows you to turn the row and column headings on and off for the current sheet. |
| Масштаб | Allows you to set the zoom level for the current sheet. |
| Защитить | Allows you to turn protection on and off for the current sheet. When protection is on, only cells that are not locked (set by using the Формат>Ячейки menu option) can be changed. |
| Формулы | Allows you to toggle the display of the cell formulas and cell values for the current sheet. |
| Цвет ярлычок | Allows you to change the tab color for the current sheet. |
|
| Файл | Allows you to select whether the Vertical scrollbar, Horizontal scrollbar and Sheet tabs are to be displayed for sheets in the current file. |
| Программа | Allows you to select whether the Toolbar, Formula bar and Status bar are to be displayed by the program. |
| Условное | Allows you to select alternative formatting for cells depending on conditions. |
| Закрепить | On a worksheet, this allows you to fix the currently displayed row and/or column headings so that they will not move when the sheet is scrolled. When you use this option, the rows above the cursor cell and the columns to the left of it will be fixed. For example, if you want the top row to stay the same when you page down through the sheet, move the cursor to cell A2 and then use this menu option, the row above cell A2, which is row 1, will stay displayed when you page through the sheet, and as there are no columns to the left of cell A2, no columns will be fixed. When this option has been used, the menu option changes to Снять закрепление which allows you to free the rows and columns again. |
| Данные |
| Сортировка | Displays a dialog box that allows you to sort the currently selected cells, either by rows or columns, in ascending or descending order. |
| Автофильтр | Allows you to filter the spreadsheet rows by specifying selection criteria. |
| Форма | Allows you to display, update and search a table of data one record at a time. |
| условия на значения | Allows you to restrict the range of values that can be entered into a cell, or display a drop-down list to choose a value from, and display input and error messages. |
| Подбор параметра | Allows you to set a cell to a specific value by changing another cell. |
|
| Диаграмма | On a chart sheet, this displays a dialog box that allows you to change the type of the chart, the data that is used, and the way in which the chart is formatted. |
| Элемент управления | Displays a dialog box that allows you to set the attributes of the currently selected Control object. |
| Графический объект | Displays a dialog box that allows you to set the attributes of the currently selected Drawing object. |