# Basic principles

# Main window layout and commands

### Browser

The **Operation Mode Browser** is displayed on the left side of the screen and is used to display the available working modes. The layout of the working modes is similar to the main menu.

[![image-1653310342881.png](https://ozols.lv/doc/uploads/images/gallery/2022-05/scaled-1680-/image-1653310342881.png)](https://ozols.lv/doc/uploads/images/gallery/2022-05/image-1653310342881.png)

The operating modes are displayed hierarchically in the browser. To activate the required action, you must click on the entry to open the lowest level operating modes. For example, by clicking on the Customer Orders command, the Customer Orders overview opens on the right side in the Main Window. To open the next required operating mode, click on it in the browser and the specified operating mode will open in the Main Window.

You can hide or show the browser using toolbar commands [![ico-nav-2.gif](https://ozols.lv/doc/uploads/images/gallery/2020-11/ico-nav-2.gif)](https://doc-ozols-lv.translate.goog/uploads/images/gallery/2020-11/ico-nav-2.gif?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)or the [![ico-nav-1.gif](https://ozols.lv/doc/uploads/images/gallery/2020-11/ico-nav-1.gif)](https://doc-ozols-lv.translate.goog/uploads/images/gallery/2020-11/ico-nav-1.gif?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp) button.

### Main menu

Activation of all program activities is available in the main menu. The main menu is available for the entire duration of the computer program. Using the main menu is similar to using Windows programs.

The operating modes in the program are grouped under the menus Data, Text, Documents, Reports, Lists, Favorites, Configuration, Window, Help. All these operating modes can also be found using the Browser.

The most commonly used main menu commands are also available from the toolbar of your computer program.

### Toolbar

The toolbar is a graphical layout of command buttons that allows you to perform the required action faster and more clearly.

[![image-1653312000456.png](https://ozols.lv/doc/uploads/images/gallery/2022-05/scaled-1680-/image-1653312000456.png)](https://ozols.lv/doc/uploads/images/gallery/2022-05/image-1653312000456.png)

<p class="callout info">**If the toolbar is not visible** , it can be set from the menu using the **ME<span class="shadow">**NU** ‣Configuration </span><span class="shadow">‣ Toolbar ‣ Commands</span>**</p>

##### Customize Toolbar

<p class="callout info">**The toolbar can be configured.** Place the mouse over the Toolbar. Click on the right button and select **Customize Toolbar.**<svg class="svg-icon" data-icon="link" role="presentation" viewbox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"></svg></p>

[![image-1653313855777.png](https://ozols.lv/doc/uploads/images/gallery/2022-05/scaled-1680-/image-1653313855777.png)](https://ozols.lv/doc/uploads/images/gallery/2022-05/image-1653313855777.png)

# Open Windows

<p class="callout info">Sometimes one of the open windows disappears because it has fallen behind another window. To find it:</p>

1. To switch between open windows, press **Ctrl+F1**
2. Or from the menu, press **Window**
3. A list of **open windows** is shown **at the bottom of this window**. To open a window, click on it with the mouse. mouse. [![image-1666682007095.png](https://ozols.lv/doc/uploads/images/gallery/2022-10/scaled-1680-/image-1666682007095.png)](https://ozols.lv/doc/uploads/images/gallery/2022-10/image-1666682007095.png)

# Shortcuts to frequently used forms

1. [<span style="outline-color: var(--color-primary);"><span class="" style="outline-color: var(--color-primary);">Function keys</span></span>](#bkmrk-1.-function-keys)
2. [Opened windows and Function key summary](#bkmrk-2.-opened-windows-an)
3. [General key combinations in OZOLS TMS](#bkmrk-3.-general-key-combi)


#### <span>1. Function keys</span>

<span>The function keys allow you to quickly open one of the OZOLS TMS sections</span>

[![image-1652086973713.png](https://ozols.lv/doc/uploads/images/gallery/2022-05/scaled-1680-/image-1652086973713.png)](https://doc-ozols-lv.translate.goog/uploads/images/gallery/2022-05/image-1652086973713.png?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)

<p class="callout info">**<span>The most frequently used Function keys:</span>**  
**<span>F6</span>**<span> - New Customer </span>**<span>order</span>**  
**<span>F7</span>**<span> - New </span>**<span>Voyage/Expedition</span>**  
**<span>F8</span>**<span> - </span>**<span>Forwarder</span>**<span> 's desktop</span></p>

<table id="bkmrk-funkciju-tausti%C5%86i-pa" width="76%"><tbody><tr><td width="69"><span>Function keys</span>

</td><td width="422"><span>Explanation</span>

</td></tr><tr><td width="69"><span>F2</span>

</td><td width="422">[![image-1649232419840.png](https://ozols.lv/doc/uploads/images/gallery/2022-04/scaled-1680-/image-1649232419840.png)](https://doc-ozols-lv.translate.goog/uploads/images/gallery/2022-04/image-1649232419840.png?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)<span> My favorites - a list of working modes compiled by myself</span>

</td></tr><tr><td width="69"><span>F3</span>

</td><td width="422">[![image-1649232497362.png](https://ozols.lv/doc/uploads/images/gallery/2022-04/scaled-1680-/image-1649232497362.png)](https://doc-ozols-lv.translate.goog/uploads/images/gallery/2022-04/image-1649232497362.png?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)<span>Information card of the cooperation partner</span>

</td></tr><tr><td width="69"><span>F4</span>

</td><td width="422">[![image-1649232520350.png](https://ozols.lv/doc/uploads/images/gallery/2022-04/scaled-1680-/image-1649232520350.png)](https://doc-ozols-lv.translate.goog/uploads/images/gallery/2022-04/image-1649232520350.png?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)<span>Machine/Trailer Details</span>

</td></tr><tr><td width="69"><span>F5</span>

</td><td width="422">[![image-1649232478036.png](https://ozols.lv/doc/uploads/images/gallery/2022-04/scaled-1680-/image-1649232478036.png)](https://doc-ozols-lv.translate.goog/uploads/images/gallery/2022-04/image-1649232478036.png?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)<span>Redrawing (refreshing) information in the open window</span>

</td></tr><tr><td width="69"><span>F6</span>

</td><td width="422">[![image-1649236212445.png](https://ozols.lv/doc/uploads/images/gallery/2022-04/scaled-1680-/image-1649236212445.png)](https://doc-ozols-lv.translate.goog/uploads/images/gallery/2022-04/image-1649236212445.png?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)<span>New Customer order</span>

</td></tr><tr><td width="69"><span>F7</span>

</td><td width="422">[![image-1649236748002.png](https://ozols.lv/doc/uploads/images/gallery/2022-04/scaled-1680-/image-1649236748002.png)](https://doc-ozols-lv.translate.goog/uploads/images/gallery/2022-04/image-1649236748002.png?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)<span>New Voyage/Expedition</span>

</td></tr><tr><td width="69"><span>F8</span>

</td><td width="422">[![image-1649236947008.png](https://ozols.lv/doc/uploads/images/gallery/2022-04/scaled-1680-/image-1649236947008.png)](https://doc-ozols-lv.translate.goog/uploads/images/gallery/2022-04/image-1649236947008.png?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)<span>Forwarder desktop</span>

</td></tr><tr><td width="69"><span>F9</span>

</td><td width="422"><span>Work with debtors</span>

</td></tr><tr><td width="69"><span>F11</span>

</td><td width="422">[![image-1649232520350.png](https://ozols.lv/doc/uploads/images/gallery/2022-04/scaled-1680-/image-1649232520350.png)](https://doc-ozols-lv.translate.goog/uploads/images/gallery/2022-04/image-1649232520350.png?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)<span>Saving and adding information</span>

</td></tr><tr><td width="69"><span>F12</span>

</td><td width="422">[![image-1649232520350.png](https://ozols.lv/doc/uploads/images/gallery/2022-04/scaled-1680-/image-1649232520350.png)](https://doc-ozols-lv.translate.goog/uploads/images/gallery/2022-04/image-1649232520350.png?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)<span>Retention and Closure of Information</span>

</td></tr></tbody></table>

<p class="callout info"><span>If the Function keys </span>**<span>do not work</span>**<span> , press </span>**<span>Fn + Esc on the keyboard</span>**</p>

#### 2. Opened windows and Function key summary

In main menu under **Window** you can find Opened windows and Function key shortcuts and summary

1. **Update data** in the currently open window  **(F5)**
2. **Arrange all**  creates a cascade of open windows. This allows you to quickly switch between open windows
3. Shortcuts to **function keys**
4. Opened windows - Helps to find collapsed windows

[![image-1662031591973.png](https://ozols.lv/doc/uploads/images/gallery/2022-09/scaled-1680-/image-1662031591973.png)](https://ozols.lv/doc/uploads/images/gallery/2022-09/image-1662031591973.png)

#### 3. <span><span class="">General key combinations in OZOLS TMS</span></span>

<div id="bkmrk-key-combinations-exp"><table><tbody><tr><td>**<span>Key combinations</span>**</td><td>**<span>Explanation</span>**</td></tr><tr><td><span>Tab</span></td><td><span>Navigating from field to field</span></td></tr><tr><td><span>Shift+Tab</span></td><td><span>Navigating from field to field backwards</span></td></tr><tr><td><span>Ctrl+Tab</span></td><td><span>Switch between form pages</span></td></tr><tr><td><span>Alt+Arrow Down</span></td><td><span>Opens a drop-down list for selecting a record</span></td></tr><tr><td><span>Shift+Arrow Down</span></td><td><span>Opens a drop-down extended list for selecting a record</span></td></tr><tr><td><span>Shift+Arrow Up</span></td><td><span>Opens the selected drop-down record or, if no record is selected, creates a new record</span></td></tr><tr><td><span>Alt+ underlined letter</span></td><td><span>The mouse cursor moves to the label field containing the underlined letter</span></td></tr><tr><td><span>Escape</span></td><td><span>Cancels changes to the open form</span></td></tr><tr><td><span>Enter</span></td><td><span>Saves open form data</span></td></tr><tr><td><span>Ctrl+G</span></td><td><span>Book document</span></td></tr><tr><td><span>Ctrl+P</span></td><td><span>Prints the selected document</span></td></tr></tbody></table>

</div>

# Filter

<p class="callout info">Almost all sections of OZOLS have the possibility to set a **Filter** for selecting the data you need. The **Filter** is located in the toolbar.</p>

[![image-1662035091447.png](https://ozols.lv/doc/uploads/images/gallery/2022-09/scaled-1680-/image-1662035091447.png)](https://ozols.lv/doc/uploads/images/gallery/2022-09/image-1662035091447.png)

<p class="callout warning">If all records are not displayed when opening one of the OZOLZ TMS sections, make sure that one of the filters has not been **turned on from the previous use**.</p>

- To find a document by number, it is enough to enter **the last two digits of the number.**
- **% sign** in front of the entry enables search for partial number or name.
- To select **several order numbers** , enter them in the "Search number(s)" field, **separated by a comma.**
- **A checkmark[![image-1658824626308.png](https://ozols.lv/doc/uploads/images/gallery/2022-07/scaled-1680-/image-1658824626308.png)](https://doc-ozols-lv.translate.goog/uploads/images/gallery/2022-07/image-1658824626308.png?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)** turns on the specific filter

[![image-1662105184357.png](https://ozols.lv/doc/uploads/images/gallery/2022-09/scaled-1680-/image-1662105184357.png)](https://ozols.lv/doc/uploads/images/gallery/2022-09/image-1662105184357.png)

<p class="callout info">**The additional Search** function built into the filter on the right side of window allows you to enter additional search criteria. More about search options [here.](https://ozols.lv/doc/books/ozols-tms-english/page/search-window)<svg class="svg-icon" data-icon="link" role="presentation" viewbox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"></svg></p>

# Search window

#### How the search window works:

- If you search for, for example, "**ECG**" the program will select all records where the field **name starts with** "ECG"
- If you search " **% ECG**" the program will select all records where **the field record contains** "ECG"
- If you search for “ **!** "ECG" program will select all records where the field name **does not start with** "ECG"
- If there are spelling differences, the **unknown letter** is replaced by an underscore " \_ ". For example, you can search for the word "Vilnius" as "Viln\_\_s"
- Square brackets \[ \] ar used to search for multiple **possible letters** . For example, searching for “ \[ CS \] heryl” will find the result for both Cherlyl and Sheryl

#### Two search windows:

1. The data is searched in the OZOLS **database**;
2. Data is searched only in **the open table**.  
    [![image-1662109232125.png](https://ozols.lv/doc/uploads/images/gallery/2022-09/scaled-1680-/image-1662109232125.png)](https://ozols.lv/doc/uploads/images/gallery/2022-09/image-1662109232125.png)

# Recording and editing history

<p class="callout info">Almost all records or editing made in the OZOLS TMS are logged and their history can be viewed.</p>

##### Record history information:

1. **when and who added** the record ;
2. **when and who opened/viewed** the record ;
3. when and by whom the record has been **edited** and specifically **what** **changes** have been made.

##### To view Record history:

1. Open the desired window and **p**ress** the key combination Ctrl+i**
2. Record info displays which user created, edited or viewed the data
3. If the text "**Edited**" is next to the record, then you can open additional information about the history of the record with a double click.

[![image-1662125004194.png](https://ozols.lv/doc/uploads/images/gallery/2022-09/scaled-1680-/image-1662125004194.png)](https://ozols.lv/doc/uploads/images/gallery/2022-09/image-1662125004194.png)

  
<svg class="svg-icon" data-icon="link" role="presentation" viewbox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"></svg>

# Columns - adjusting the design and content

Read about adjusting the design and content in the following sections:

1. [How to adjust column content and order?](https://ozols.lv/doc/books/ozols-tms-english/page/customize-column-content-and-order)
2. [How to change column width?](https://ozols.lv/doc/books/ozols-tms-english/page/adjusting-column-width)
3. [How to put a colleague's column layout in your Ozols?](https://ozols.lv/doc/books/ozols-tms-english/page/customize-column-content-and-order)
4. [How to quickly change the appearance of columns? - **Defined columns**](https://ozols.lv/doc/books/ozols-tms-english/page/defined-columns)

# Adjusting Column width

#### To change the column width:

Open the OZOLS TMS table where you want to change the width of the columns.  
**1. In the toolbar, select the Columns**  toolbar button [![image-1661778373612.gif](https://ozols.lv/doc/uploads/images/gallery/2022-08/image-1661778373612.gif)](https://ozols.lv/doc/uploads/images/gallery/2022-08/image-1661778373612.gif) or press **Ctrl+K. The Column settings** window will open   
2\. In **the Visible columns** section , select which column width you want to change   
3\. Press the **Change column width** button   
4\. In **the Column width** field, write the desired column width in pixels  
 (informative: 1px ≈ 0.26mm; 100px ≈ 2.6cm)

[![image-1666267231945.png](https://ozols.lv/doc/uploads/images/gallery/2022-10/scaled-1680-/image-1666267231945.png)](https://ozols.lv/doc/uploads/images/gallery/2022-10/image-1666267231945.png)

<p class="callout success">**See also:**   
1) [Customize table ](https://doc-ozols-lv.translate.goog/books/ozols-desktop/page/pielagot-tabulas-kolonnu-saturu-un-secibu?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)**[column content and order](https://doc-ozols-lv.translate.goog/books/ozols-desktop/page/pielagot-tabulas-kolonnu-saturu-un-secibu?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)** 2) [**Defined columns**](https://doc-ozols-lv.translate.goog/books/ozols-desktop/page/definetas-kolonnas?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)</p>

# Customize column content and order

Open the table you want to make changes to

1. **Press the right mouse button** on any of the rows in the table
2. Or in the menu, press **Columns** (Ctrl+K)  
    [![image-1666268786878.png](https://ozols.lv/doc/uploads/images/gallery/2022-10/scaled-1680-/image-1666268786878.png)](https://ozols.lv/doc/uploads/images/gallery/2022-10/image-1666268786878.png)
3. Columns are divided into **Available columns (possibly included in the table)**  and
4. **Visible columns (already included in the table)**
5. Mark with the “mouse” the desired column on one or the other side and press the **Add**  or **Remove buttons** as needed to adjust the table content
6. Change the order of the columns with the **Up** or **Down buttons** . Moving Up moves the column to the left in the table. Moving Below moves the column to the right in the table.

[![image-1666269460278.png](https://ozols.lv/doc/uploads/images/gallery/2022-10/scaled-1680-/image-1666269460278.png)](https://ozols.lv/doc/uploads/images/gallery/2022-10/image-1666269460278.png)

<p class="callout info">**The Save As...** button allows you to save the selected layout as defined. This means that both you and other users of your company's OZOLS database will be able to open this table layout.</p>

<div id="bkmrk--0"><svg class="svg-icon" data-icon="link" role="presentation" viewbox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"></svg></div><p class="callout success">**See also:**   
1) [Change ](https://doc-ozols-lv.translate.goog/books/ozols-desktop/page/kolonnu-platums?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)**[column width](https://doc-ozols-lv.translate.goog/books/ozols-desktop/page/kolonnu-platums?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)** 2) [**Defined columns**](https://doc-ozols-lv.translate.goog/books/ozols-desktop/page/definetas-kolonnas?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)</p>

# Defined columns

<p class="callout info">**Defined columns** allow you to save the table column layout you create with a name. Columns saved in this way are easily available both for their own needs and for installation by other users. So, for example, defined column selections can be created within the company, which can be easily installed by new employees.</p>

First, open the table where you want to install the defined columns. Select the ![](https://ozols.lv/doc/uploads/images/gallery/2020-11/ico-columns.gif) **Columns button on the toolbar ( Ctrl+K )**

1. Click the **Defined Columns… button.**
2. **Default columns** - layout recommended by OZOLS TMS
3. **Columns defined** in your company
4. Click **Save** to activate the defined columns

[![image-1666273150651.png](https://ozols.lv/doc/uploads/images/gallery/2022-10/scaled-1680-/image-1666273150651.png)](https://ozols.lv/doc/uploads/images/gallery/2022-10/image-1666273150651.png)

#### To create a selection of Defined Columns

1. Adjust the columns shown in the table as needed ( [tutorial **here**](https://doc-ozols-lv.translate.goog/books/ozols-desktop/page/pielagot-kolonnu-saturu-un-secibu?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp) ) and press the button **Save as...**
2. To create a New selection of defined columns, press **New...**
3. To edit or delete previously saved defined columns, select **by name**
4. To open a selection of predefined columns, click the ****Defined Columns… button.****[![image-1666273740509.png](https://ozols.lv/doc/uploads/images/gallery/2022-10/scaled-1680-/image-1666273740509.png)](https://ozols.lv/doc/uploads/images/gallery/2022-10/image-1666273740509.png)
5. Gives a name to a selection of defined columns
6. Tick ​​if you want the columns to be available to all users. If the "tick" is not placed, then only you will see this selection
7. Press save. The Defined Columns you have created can be found by clicking the **Defined Columns… button.**
8. If you need to delete one of the previously created selections of Defined columns, open it (5) and press the **Delete button**

[![create_defined_columns1.png](https://ozols.lv/doc/uploads/images/gallery/2022-03/scaled-1680-/image-1646665437129.png)](https://doc-ozols-lv.translate.goog/uploads/images/gallery/2022-03/image-1646665437129.png?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)

<p class="callout info">The Defined Columns you created can be found by clicking the **Defined Columns** button</p>

# Multiselect - highlight the desired rows

<p class="callout info">Multiselect is used when it is necessary to select individual rows in random order. such as cargo and add to the trip.</p>

1\) In the toolbar, select **Multi-select.**  ( **Ctrl+Y)**  
2\) Then, similarly to Excel, holding down the **Ctrl** or **Shift** keys with the "mouse" mark the desired rows  
3\) The marked rows depending on the open window:  
\- The marked loads on the freight forwarder's desktop can be added to the marked flight  
\- [Calculator - the sums of the marked lines](https://doc-ozols-lv.translate.goog/books/ozols-desktop/page/kalkulators-iezimeto-rindu-summas?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)  
\- [Print or export to Excel](https://doc-ozols-lv.translate.goog/books/ozols-desktop/page/drukat-vai-eksportet-uz-excel-tikai-jums-vajadzigos-datus?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)  
\- Depending on the window, additional options are available by pressing the Functions command button![](https://ozols.lv/doc/uploads/images/gallery/2020-10/ico-funkcija.gif)

[![image-1666361530074.png](https://ozols.lv/doc/uploads/images/gallery/2022-10/scaled-1680-/image-1666361530074.png)](https://ozols.lv/doc/uploads/images/gallery/2022-10/image-1666361530074.png)

# Calculator - sums of highlighted rows

<p class="callout info">OZOLS TMS allows you to select individual rows in the table in order to sum the numbers in these rows.</p>

1. In the toolbar, select **Multi Select.**  (shortcut **Ctrl+Y)**
2. Then, similar to Excel, holding the **Ctrl** or **Shift** keys with the "mouse" selects the desired rows
3. **The sums of the highlighted rows are shown in the lower part of the table**

![](https://ozols.lv/doc/uploads/images/gallery/2022-10/image-1666361530074.png)

<p class="callout success">**See also:** [1) Option to print or export highlighted rows **to Excel** ](https://doc-ozols-lv.translate.goog/books/ozols-desktop/page/drukat-vai-eksportet-uz-excel-tikai-jums-vajadzigos-datus?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)[. Press Print ④ and follow the instructions.](https://doc-ozols-lv.translate.goog/books/ozols-desktop/page/drukat-vai-eksportet-uz-excel-tikai-jums-vajadzigos-datus?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)  
2) **Additional options,** depending on the opened window, by pressing the **Functions command button**<svg class="svg-icon" data-icon="link" role="presentation" viewbox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"></svg></p>

# Print or export selected data to Excel

<p class="callout info">Ozols TMS enables you to select the desired data in tables and print or save in Excel:</p>

1. Choose **Filter [![Filtrs](https://ozols.lv/doc/uploads/images/gallery/2022-05/scaled-1680-/image-1651585606852.png)](https://ozols.lv/doc/uploads/images/gallery/2022-05/image-1651585606852.png)** (shortcut **Ctrl+F** ) from the toolbar and select the data you want to select.
2. On the toolbar, choose **Columns** [![ico-columns.gif](https://ozols.lv/doc/uploads/images/gallery/2020-11/ico-columns.gif)](https://ozols.lv/doc/uploads/images/gallery/2020-11/ico-columns.gif)(shortcut **Ctrl+K** ) and choose the columns you need. There is an option to save this column selection in the [**Defined Columns section.**](https://doc-ozols-lv.translate.goog/books/ozols-desktop/page/definetas-kolonnas?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)
3. If you need to select only some rows, select **Multi select [![multi iezīmes](https://ozols.lv/doc/uploads/images/gallery/2022-06/scaled-1680-/image-1654595946120.png)](https://ozols.lv/doc/uploads/images/gallery/2022-06/image-1654595946120.png) from the toolbar.** (shortcut **Ctrl+Y)**
4. Similar to Excel, holding the **Ctrl** or **Shift** keys with the mouse selects the desired rows
5. Choose **View [![image-1661781212158.png](https://ozols.lv/doc/uploads/images/gallery/2022-08/scaled-1680-/image-1661781212158.png) ](https://ozols.lv/doc/uploads/images/gallery/2022-08/image-1661781212158.png)**from the toolbar (shortcut **Ctrl+H** ). At this point, a table with the selected data will be displayed in the main window.
6. **Right-** click anywhere in the newly created table and select **print or export to Excel**

[![image-1661937902064.png](https://ozols.lv/doc/uploads/images/gallery/2022-08/scaled-1680-/image-1661937902064.png)](https://ozols.lv/doc/uploads/images/gallery/2022-08/image-1661937902064.png)

<p class="callout info">To send the data to a **printer** or export to **Excel** , click **View** and follow the instructions.</p>

<div id="bkmrk--0"></div><p class="callout success">**See also:** 1) [**Calculator** - sums of highlighted rows](https://doc-ozols-lv.translate.goog/books/ozols-desktop/page/kalkulators-iezimeto-rindu-summas?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)  
2) [**Column width**](https://doc-ozols-lv.translate.goog/books/ozols-desktop/page/kolonnu-platums?_x_tr_sl=lv&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp)</p>