PQStat - Baza Wiedzy

Selection of a consistent area in a worksheet can be done with mouse or keyboard (Arrow keys + Shift). During selection, the size of the selection (number of rows and columns) is continuously displayed in the message bar. You can select the entire worksheet by simply clicking in the upper left corner of the worksheet with the mouse, or by selecting menu Edit→Select all (Ctrl+A). Whole rows or whole columns are selected by selecting their headers.

Copying or moving cells is done through the copy, cut and paste commands.

The copy, cut and paste commands are available in several places:

• in menu Edit,

• in the context menu of cells,

• on the toolbar ,

• in the context menu for rows and columns,

• via hotkeys: copy (Ctrl+C), cut (Ctrl+X), paste (Ctrl+V).

Deleting data from cells can be performed via menu Edit→Delete (Del)

Undoing the most recently performed operation can be done via menu Edit→Undo (Ctrl+Z). By default, the Program remembers the last 10 operations involving 5000 cells in each cell. You can change these settings in the ''Settings'' window. It should be noted, however, that increasing these values results in greater use of computer memory by the program.

Inserting and deleting rows and columns

You can insert blank rows or columns above or to the left of an existing row or column. This will move the cells down or to the right. To insert a row(s), select the row(s) above which you want to insert a new row(s), and then choose Insert row from the context menu on the selected row number. Inserting columns is done in the same way.

Rows and columns can also be deleted by selecting them and choosing Delete row/Delete column from the context menu in the row or column number..

Finding/replacing a cell value * To find or replace the entire contents of a cell with another value, use the Find/Replace window, which is accessible via menu Edit→Find/Replace (Ctrl+F) .

The upper part of the Find/Replace window is used for searching and the lower part is used for replacing cell values.

To search for data, enter a search string in the upper part of the window, select the search order and choose the Find button.

To find and replace the entire contents of a cell with another value, fill in the upper and lower parts of the window. Fill in the upper part of the window as you would for a data search. In the lower part of the window type the data that you want to replace and choose Find and Replace or Find and Replace All when you want to replace all the occurrences of the searched data. Searching as well as replacing is done in direct view mode of the operations performed on the sheet.