Menu options

Menu Plik
Menu Edycja
Menu Wstaw
Menu Format


Menu Plik

NowyOpens a new blank workbook.
OtwórzDisplays the File Open dialog box for you to choose a spreadsheet file to open.
Ostatnio używaneDisplays a list of the 9 most recently used (i.e. opened or saved) files as a shortcut for opening them.
ZamknijCloses the current workbook, after prompting you to save any changes.
ZapiszSaves the current workbook back into the file it was opened from. If this spreadsheet was created with the Plik Nowy menu option rather than opened with the Plik Otwórz menu option, then you will be asked for a file name to save it under.
Zapisz jakoDisplays the File Save dialog box for you to choose a name and location for saving the current workbook.
OknoDisplays a list of the currently open workbooks and allows you to select a different one as the active workbook.
DrukujPrints the currently displayed sheet. This option will not be available if your device does not support printing.
ZakończThis shuts down the program, after prompting you to save any changed workbooks.


Menu Edycja

CofnijThis 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 Cofnij, that is, the program remembers the last 16 things that you did and can step back through them using this menu option.
WytnijThis 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.
KopiujThis 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.
WklejThis option takes the contents of the clipboard and puts it into the currently selected cells.
Wklej specjalnieWhen 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 Wklej 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.
Wypełnij
W dółCopies the top row of the selection into the other rows of the selection.
W prawoCopies the left column of the selection into the other columns of the selection.
W góręCopies the bottom row of the selection into the other rows of the selection.
W lewoCopies the right column of the selection into the other columns of the selection.
Serie danychDisplays a dialog box that allows you to fill the current selection with a series of numbers or dates.
Wyczyść
WszystkoRemoves the contents and formatting of the currently selected cells.
FormatyRemoves only the formatting of the currently selected cells, leaves the contents unchanged.
ZawartośćRemoves only the contents of the currently selected cells, leaves the formatting unchanged.
KomentarzeRemoves any comments associated with the currently selected cells.
Usuń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) Przesuń komórki w lewo - delete the selected cells and move the cells on the right of them to the left to take their places, (2) Przesuń komórki do góry - delete the selected cells and move the cells below them up to take their places, (3) Cały wiersz - delete the entire rows that the selection spans, the rows below will be moved up, (4) Cała kolumna - delete the entire columns that the selection spans, the columns to the right will be moved left.
Usuń arkuszDelete 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.
Przenieś lub kopiuj arkuszAllows you to move or copy the current sheet to a different position in the file.
Znajdź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 Znajdź następny 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 Znajdź następny button will take you to each of the cells that match your request.
Idź doAllows 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 OK will move the cursor to the specified cell.


Menu Wstaw

KomórkiIf 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) Przesuń komórki w prawo - the cells to the right of the selection will be moved to the right to make room for the new cells, (2) Przesuń komórki w dół - the cells below the selection will be moved down to make room for the new cells, (3) Cały wiersz - the entire rows that the selection spans will be inserted, (4) Cała kolumna - the entire columns that the selection spans will be inserted.
WierszeInserts one or more new rows where the selection is.
KolumnyInserts one or more new columns where the selection is.
ArkuszInserts a blank worksheet at the end of the spreadsheet file.
Wykres
ArkuszInserts a new chart sheet at the end of the spreadsheet file. If no cells have been selected then the Format Wykres dialog box will be displayed, otherwise a default column chart will be built using the selected data.
ObiektInserts 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 Format Wykres dialog box will be displayed, otherwise a default column chart will be built using the selected data.
MakroInserts a blank macro sheet at the end of the spreadsheet file. Macro sheets are used for storing custom (user-defined) functions and commands.
FunkcjeDisplays a dialog box from which you can select a function to be inserted into the current cell formula.
Nazwy
DefiniujDisplays 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.
KomentarzThis 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 Edytuj komentarz, 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 Edycja Wyczyść Komentarze menu option.
Formant
EtykietaInserts a label.
Pole grupyInserts a group box.
PrzyciskInserts a command button.
Pole wyboruInserts a check box.
Przycisk opcjiInserts an option button.
Pole listyInserts a list box.
Rozwijana listaInserts a combo box.
Pasek przewijaniaInserts a horizontal or vertical scroll bar.
PokrętłoInserts a spin control.
Obiekt rysunkowy
LiniaInserts a line.
ProstokątInserts a rectangle.
ElipsaInserts an oval.
Pole tekstoweInserts a text box.


Menu Format

KomórkiDisplays 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.
Wiersz
Wysokość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.
AutodopasowanieSets 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.
UkryjHides the selected rows.
OdkryjUnhides the selected rows. Because you cannot select individual hidden rows, you will have to use the Edycja Idź do 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.
Kolumna
Szerokość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.
AutodopasowanieSets 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.
UkryjHides the selected columns.
OdkryjUnhides the selected columns. Because you cannot select individual hidden columns, you will have to use the Edycja Idź do 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.
Standardowa szerokośćDisplays a dialog box showing the default width of the columns on the current sheet, and allows you to change it.
Arkusz
Zmień nazwęDisplays a dialog box showing the current sheet name, and allows you to change it.
UkryjAllows you to hide the currently displayed sheet.
OdkryjAllows you to select a hidden sheet to be displayed.
Linie siatkiAllows you to turn the gridlines on and off for the current sheet.
NagłówkiAllows you to turn the row and column headings on and off for the current sheet.
PowiększenieAllows you to set the zoom level for the current sheet.
Chroń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 Format Komórki menu option) can be changed.
FormułyAllows you to toggle the display of the cell formulas and cell values for the current sheet.
Kolor kartyAllows you to change the tab color for the current sheet.
PlikAllows you to select whether the Vertical scrollbar, Horizontal scrollbar and Sheet tabs are to be displayed for sheets in the current file.
ProgramAllows you to select whether the Toolbar, Formula bar and Status bar are to be displayed by the program.
WarunkoweAllows you to select alternative formatting for cells depending on conditions.
ZablokujOn 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 Odblokuj which allows you to free the rows and columns again.
Dane
SortujDisplays a dialog box that allows you to sort the currently selected cells, either by rows or columns, in ascending or descending order.
Filtr
AutofiltrAllows you to filter the spreadsheet rows by specifying selection criteria.
Pokaż wszystkoTurns off any active filters.
Zaawansowany filtrAllows you to filter the spreadsheet rows by specifying more complex criteria.
FormularzAllows you to display, update and search a table of data one record at a time.
SprawdzanieAllows 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.
Szukaj wynikuAllows you to set a cell to a specific value by changing another cell.
WykresOn 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.
FormantDisplays a dialog box that allows you to set the attributes of the currently selected Control object.
Obiekt rysunkowyDisplays a dialog box that allows you to set the attributes of the currently selected Drawing object.