X-Table — User Manual

The program window

The X-Table window is made up of several areas (from top to bottom):

1. Title bar — the workbook name, quick buttons (save, undo, redo), command search and the theme switch.
2. Ribbon — the File, Home, Insert, Draw, Page Layout, Formulas, Data, Review, View and Automate tabs with command buttons.
3. Formula bar — the Name Box, the cancel and enter buttons, the Insert Function button and the box with the contents of the current cell.
4. Sheet grid — the cells themselves, with column headings (A, B, C…) and row headings (1, 2, 3…).
5. Sheet tabs — switching between the sheets of the workbook, and horizontal scrolling.
6. Status bar — the current mode, the sum and average of the selected cells, view modes and zoom.

Title bar

The middle of the bar shows the workbook name, for example Book1.xlsx. A dot “•” after the name means the workbook has unsaved changes. To the left and right of the name are these buttons:

AutoSave

A switch. When it is on, a workbook that already has a file on disk is saved automatically after every change. In the browser a workbook is saved by downloading a file, so here your main protection against losing data is the browser draft; save the file yourself.

Home

The button with a house. Opens the start screen: create a new workbook or pick one from the list of recent workbooks.

Save Ctrl+S

Saves the workbook. If the workbook has never been saved, the File › Save As page opens. In the browser the .xlsx file is downloaded to your Downloads folder (or to a folder you choose, if your browser asks where to save).

Undo Ctrl+Z

Undoes the last action. The button is grey when there is nothing to undo.

Undo list

The small arrow next to the Undo button. Shows up to 20 recent actions; clicking a line undoes that action and every action after it at once.

Redo Ctrl+Y

Brings back an action you undid.

More commands

The “…” button. A quick access menu: “New Workbook”, “Open…”, “Save As…”, “Sort A to Z”, “Calculate Now”, “Print…”.

Search commands

The magnifier button on the right. Opens the command palette: start typing the name of an action (for example “freeze” or “borders”) and pick the command from the list. Handy when you don’t remember which tab a button is on.

Share

A menu for exporting a copy of the workbook: “Export as PDF…”, “Save a Copy as Excel Workbook (.xlsx)…”, “Export as CSV…”, “Export as Web Page (.html)…”. The copy is downloaded to your computer; your working workbook does not change.

Comments

Opens the list of all comments in the workbook.

Dark Mode

Switches between the light and dark interface theme. Right-click it to choose “System”, “Light” or “Dark” (“System” follows your operating system setting).

Ribbon

The ribbon is the strip of tabs with buttons below the title bar. The buttons are arranged in groups by purpose (clipboard, font, alignment and so on).

• Switching tabs — click the tab name.
• Collapsing the ribbon — click the tab that is already open, or double-click any tab. Only the row of tab names remains, which leaves more room for the sheet. Click again to expand the ribbon. Keyboard shortcut: Ctrl+F1.
• Buttons with an arrow open a menu. On buttons split into two parts (for example “Underline”, “Borders”, “Fill Color”), the main part applies the last option you chose straight away, and the arrow opens the list of options.
• Scrolling the ribbon — if the window is narrow and the buttons don’t fit, scroll buttons appear at the left and right edges of the ribbon. You can also scroll the ribbon with the mouse wheel or a touchpad gesture.
• Tooltips — hover over a button to see its name and keyboard shortcut.
• Keyboard control — press and release Alt: letter hints appear on the tabs and buttons. Press the letters to choose a tab and a button without the mouse.
• Contextual tabs — “Table Design”, “Chart Design” and “Header & Footer” appear only when a table or chart is selected or a header or footer is being edited (see Contextual tabs).

Formula bar

The formula bar sits between the ribbon and the grid. It shows the actual contents of the active cell: if the cell holds a formula, you see the result in the grid and the formula itself in the formula bar.

Name Box

On the left it shows the address of the active cell (for example, B4) or the size of the selection. Type an address (D200), a range (A1:C10) or a range name into the box and press Enter — X-Table goes there and selects those cells. The arrow on the box opens the list of names defined in the workbook.

Cancel (✕)

Appears while you are typing. Cancels the entry and restores the previous contents of the cell (like the Esc key).

Enter (✓)

Appears while you are typing. Writes the value into the cell (like Enter, but the active cell stays where it is).

Insert Function (fx) Shift+F3

Opens the function picker: find a function by name or category, read its description and fill in the arguments.

Contents box

Click in it to edit the contents of the cell. While you type a formula, X-Table suggests function names and their arguments; cell references are highlighted in colour, and the same cells on the sheet are outlined with a border of the matching colour.

Expand formula bar Ctrl+Shift+U

The arrow at the right edge makes the box multi-line — useful for long formulas and text. Press it again to collapse the box.

You can hide the formula bar: View › Formula Bar (check box).

Sheet grid

• Cell — where a column and a row meet. Its address is the column letter followed by the row number: C5. The active cell has a border around it.
• Selection — drag the mouse across cells, or hold Shift and press the arrow keys. To select several separate areas, hold Ctrl.
• Column and row headings — clicking a letter selects the whole column, clicking a number selects the whole row. Drag the border between headings to change the column width or row height; double-click the border to fit the size to the contents.
• The Select All button — the corner above the row numbers, to the left of the column letters; selects the whole sheet (Ctrl+A).
• Fill handle — the small square in the bottom-right corner of the selection. Drag it down or sideways to copy a value or continue a series (1, 2, 3…; dates). After dragging, the Auto Fill Options button appears: “Copy Cells”, “Fill Series”, “Fill Formatting Only”, “Fill Without Formatting”, and for dates “Fill Days”, “Fill Weekdays”, “Fill Months”, “Fill Years”.
• Moving cells — point at the border of the selection and drag it to a new place.
• A green triangle in the corner of a cell means X-Table suspects an error, for example “Number Stored as Text”. Click the icon next to it and choose “Convert to Number”.

Sheet tabs

A workbook can contain several sheets. The sheet tabs are at the bottom of the window.

Previous sheet / Next sheet

The arrow buttons on the left. Switch to the neighbouring sheet. From the keyboard: Ctrl+Page Up and Ctrl+Page Down.

All sheets

Opens a list of all sheets in the workbook — handy when there are many sheets and the tabs don’t fit.

Sheet tab

Click to open the sheet. Double-click to rename the sheet (type the name and press Enter). Drag to change the order of sheets; drag with Ctrl held down to make a copy of the sheet. The coloured strip under the name is the tab colour.

New sheet (+) Shift+F11

Adds a new blank sheet.

Splitter

The vertical dotted handle between the tabs and the scroll bar. Drag it to give more room to the tabs or to the scroll bar.

Horizontal scroll bar

Scrolls the sheet left and right.

Right-click a tab to open the sheet menu:

Insert Sheet

Inserts a new sheet before the selected one.

Delete

Deletes the sheet together with all its data. You can undo this with Ctrl+Z.

Rename

Lets you edit the name on the tab.

Move or Copy…

A dialog where you choose the new position of the sheet; the “Create a copy” check box copies the sheet instead of moving it.

Duplicate

Immediately creates a copy of the sheet to its right.

Tab Color

A colour palette for the tab; “No Color” removes the colour.

Hide / Unhide…

Hides the sheet (the data is kept and formulas can still refer to it) or shows a hidden sheet.

Protect Sheet… / Unprotect Sheet…

Prevents, or allows again, changes to the cells of the sheet (see Review).

Select All Sheets

Selects every sheet in the workbook.

Status bar and zoom

Mode

The left side shows the mode: Ready — you can select cells; Enter — you are typing a new value; Edit — you are editing existing contents; Point — while typing a formula, you are picking cells with the mouse or arrow keys.

Messages

Warnings also appear here: “Calculate” (manual recalculation is on — press F9), “Circular References: A1” (a formula refers to itself), “Select destination and press Enter or choose Paste” (after copying).

Sum, Average, Count

When more than one cell is selected, the right side automatically shows the Average, the Count (of non-empty cells) and the Sum of the selected numbers. This is the quickest way to get a total without a formula. Right-click the status bar to also turn on Numerical Count, Min and Max, or to turn off figures you don’t need.

View modes

Three buttons: Normal (the grid of cells), Page Layout (the sheet as printed pages with margins, headers and footers), Page Break Preview (shows the page breaks). The same modes are on the View tab.

Zoom

The “−” and “+” buttons zoom out and in by 10%; the slider between them changes the zoom smoothly (from 10 to 400%). Click the percentage to open the “Zoom” dialog with an exact value. From the keyboard: Ctrl+Alt+= and Ctrl+Alt+-. Zoom does not affect printing.

Context menus

Right-clicking (or pressing Shift+F10) opens a menu of commands for whatever is under the pointer.

Cell menu

“Cut”, “Copy”, “Paste”, “Paste Special…”, “Insert…” (cells, shifting others), “Delete…”, “Clear Contents”, “Filter by Selected Cell's Value”, “Sort A to Z”, “Sort Z to A”, “New Comment”, “New Note”, “Format Cells…”, “Pick From Drop-down List…” (offers values already entered in the column), “Define Name…”, “Link…”. After “Copy” or “Cut”, the menu also shows “Insert Copied Cells” and “Insert Cut Cells” — pasting that shifts the neighbouring cells.

Row or column heading menu

“Cut”, “Copy”, “Paste”, “Insert” (a new row or column), “Delete”, “Clear Contents”, “Format Cells…”, “Row Height…” or “Column Width…”, “AutoFit Row Height” or “AutoFit Column Width”, “Hide”, “Unhide”, “Group”; for a column also “Sort A to Z”.

Chart menu

“Delete”, “Select Data…”, “Format Chart Area…”.

File

The File tab is the first tab on the left of the ribbon. It opens a separate screen (the Backstage view) with commands for the workbook as a whole. On the left is a list of sections, on the right the contents of the selected section. To return to the sheet, click Back or press Esc.

Back

Closes the File screen and returns to the sheet.

Home

The start page: tiles for creating a new workbook and the Recent list — workbooks you have worked on lately, with the date they were modified. The “More workbooks” link opens the full list. In the browser you may need to pick recent files again through “Open › Browse…”, because the browser does not give a website access to files without your permission.

New Ctrl+N

The Blank workbook tile creates a new workbook with one sheet. The other tiles create a sample workbook with ready-made data — a good place to try formulas, sorting and charts.

Open Ctrl+O

The Browse… button opens a dialog for choosing a file on your computer. Supported are Excel workbooks (.xlsx, .xlsm, .xls, .xlsb), OpenDocument (.ods), text tables (.csv, .tsv, .txt) and .json. The “Recent” list is shown below. You can also simply drag a file from a folder onto the X-Table window.

Info

The workbook name and location, the number of sheets and the Protect Workbook button (prevents adding, deleting, moving and renaming sheets). In the Properties block you can fill in “Title”, “Subject”, “Author”, “Company”, “Keywords” and “Description” — they are saved in the file.

Save Ctrl+S

Saves the workbook to its file. If the workbook is new, “Save As” opens. In the browser the file is downloaded to your computer.

Save As F12 or Ctrl+Shift+S

In the Save as type list choose “Excel Workbook (*.xlsx)”, “CSV UTF-8 (Comma delimited) (*.csv)”, “Web Page (*.html)” or “PDF (*.pdf)”, then click Download. An Excel workbook keeps everything: sheets, formulas, formatting, charts. CSV, web page and PDF are copies: your working workbook stays in its own format.

Print Ctrl+P

On the right is a preview of the pages with “Previous page” and “Next page” buttons. On the left are the settings:

• Print — X-Table prepares the pages and hands them to the browser; in the browser’s print dialog choose a printer (or “Save as PDF”).
• Print What: “Print Active Sheets” or “Print Entire Workbook”.
• Fit Sheet on One Page — reduces the scale so the whole sheet fits on one page.
• Page Setup… — margins, orientation, paper size, headers and footers, rows to repeat on every page.

Export

• Create PDF — saves the sheet as a PDF document, keeping the page layout (margins, orientation, headers and footers). The PDF is downloaded to your computer.
• Change File Type › CSV (Comma delimited) — saves the active sheet as text with the values separated by commas. Formulas, formatting and other sheets are not included in the CSV — only the values are saved.
• Change File Type › Web Page (.html) — saves the workbook as a web page that can be opened in any browser.

Close Ctrl+W

Closes the workbook. If there are unsaved changes, X-Table offers to save them.

Account

Despite the name, no sign-in is needed. This page shows Product Information — the version, the platform (Web for the browser version) and the licence — and the About button.

Options

Program settings:

• General: “Display theme” (System, Light, Dark), “Interface language” (“Русский”, “English”, “简体中文”, “Español”, “Français”, “Português (Brasil)” or “Türkçe”), “Show formula bar”.
• Editing: “Enable AutoComplete for cell values” — as you type text, X-Table offers to complete it with a value that already appears in the column.
• Save: “Save .xlsx workbooks automatically after every change” (the same as the “AutoSave” switch in the title bar).
• Formulas (when a workbook is open): “Workbook calculation” — “Automatic”, “Automatic Except for Data Tables”, “Manual”; “Enable iterative calculation” with the “Maximum Iterations” (from 1 to 32767) and “Maximum Change” boxes. These settings are saved with the workbook.

User Manual

Opens this guide in a new browser tab.

About

A window with the X-Table version and information about the program (see About).

Importing and exporting CSV

• Open a CSV file: File › Open › Browse… or Data › Get Data (Text/CSV), then choose a .csv, .tsv or .txt file. Each line of the file becomes a row of the sheet, and each value goes into its own cell. Numbers and dates are recognised automatically.
• Save as CSV: File › Export › CSV or File › Save As with the “CSV UTF-8” type. Only the current sheet is saved, and only values (the results of formulas).
• If after opening a CSV file all the data ends up in one column, select that column and use Data › Text to Columns, choosing the right delimiter (for example, a semicolon).

Home tab

The most frequently used commands: clipboard, font, alignment, number formats, styles, inserting and deleting rows, AutoSum, sorting and finding. First select the cells, then click the button — the command applies to the whole selection.

Paste Ctrl+V

Pastes copied or cut cells, starting at the active cell. Right-click the button for the options: “Paste”, “Paste Values” (results only, no formulas), “Paste Formulas”, “Paste Formatting” (formatting only), “Transpose” (rows become columns), “Paste Link” (references to the source cells), “Paste Special…” (Ctrl+Alt+V) — a dialog with all the options.

Cut Ctrl+X

Marks the cells for moving with a moving dashed border. Choose a place and paste — the cells move there.

Copy Ctrl+C

Copies the cells. You can paste several times; Esc removes the copy border. If you press Enter after copying, the cells are pasted into the active cell and copy mode ends.

Format Painter

The brush. Select a cell that has the formatting you want, click the brush, then select the cells that should get the same formatting (font, colour, borders, number format). Double-click the brush to keep it on, so you can format several areas in a row; Esc turns it off.

Font

The box with the font name (Arial, Calibri, Times New Roman, Verdana and others). Choose a font from the list or type its name. If the font is not installed on your computer, the browser shows a similar one.

Font Size

Type a size (from 1 to 409) and press Enter, or choose one from the list (8–72).

Increase Font Size / Decrease Font Size

The “+” and “−” buttons: the size changes by one step of the standard list.

Bold Ctrl+B

Makes the text bold. Click again to undo.

Italic Ctrl+I

Slanted text.

Underline Ctrl+U

Underlines the text. The arrow lets you choose “Underline” or “Double Underline”.

Strikethrough Ctrl+5

Draws a line through the text — handy for completed tasks.

Borders

Draws lines around and inside cells. The main part of the button repeats the last style you chose. The arrow opens the list: “Bottom Border”, “Top Border”, “Left Border”, “Right Border”, “No Border”, “All Borders”, “Outside Borders” (Ctrl+Shift+7), “Thick Outside Borders”, “Bottom Double Border”, “Thick Bottom Border”, “Top and Bottom Border”, “Top and Thick Bottom Border”, “Top and Double Bottom Border”, “Inside Borders”, and “More Borders…” — a dialog for choosing the line style and colour. To remove all borders: Ctrl+Shift+-.

Fill Color

Colours the cell background. The main part applies the last colour (shown as a strip under the icon); the arrow opens a palette of theme colours and standard colours; “No Fill” removes the background.

Font Color

Changes the text colour. Works the same way as Fill Color; “Automatic” restores the normal colour.

Top Align / Middle Align / Bottom Align

The vertical position of the text in the cell. Noticeable when the row is taller than the text.

Orientation

Rotates text: “Angle Counterclockwise”, “Angle Clockwise”, “Vertical Text” (letters stacked one below another), “Rotate Text Up”, “Rotate Text Down”, “Horizontal” (normal text), “Format Cell Alignment…” — a dialog with an exact angle. Useful for narrow column headings.

Wrap Text

Long text wraps onto several lines inside the cell, and the row gets taller. Without wrapping, text runs past the cell border or is cut off. To force a line break while typing, press Alt+Enter.

Align Left / Center / Align Right

Horizontal alignment. By default text is aligned to the left, and numbers and dates to the right.

Decrease Indent / Increase Indent

Moves the contents away from the left edge of the cell — handy for sub-items in a list.

Merge & Center

Merges the selected cells into one and centres the text — the usual way to make a heading above a table. The arrow opens the options: “Merge & Center”, “Merge Across” (each row of the selection is merged separately), “Merge Cells” (without centring), “Unmerge Cells”. When cells are merged, only the value of the top-left cell is kept.

Number Format

This list sets how a value is displayed (the value itself does not change). Each format shows a preview for the current cell:

• General — no special formatting;
• Number — two decimal places;
• Currency (tenge, ₸, by default) and Accounting — with a currency symbol;
• Short Date, Long Date, Time;
• Percentage — 0.15 is shown as 15%;
• Fraction, Scientific (1.2E+06);
• Text — the contents are stored as text even if they look like a number (for codes and numbers with leading zeros);
• More Number Formats… — the “Format Cells” dialog, where you can enter your own format code.

Accounting Number Format

The button with a currency symbol. The main part applies the default accounting format. The arrow opens a list of currencies: “₸ Kazakh tenge” and “₽ Russian ruble” come first, followed by the US dollar, pound sterling, euro, Japanese yen, Chinese yuan, Indian rupee, Swiss franc, Indonesian rupiah, Korean won, Brazilian real, and “More Accounting Formats…”. See also Money.

Percent Style Ctrl+Shift+5

Shows a number as a percentage: 0.25 becomes 25%.

Comma Style

Separates thousands and shows two decimal places: 1234567 → 1,234,567.00.

Increase Decimal / Decrease Decimal

Adds or removes one decimal place. The value is not rounded — only its appearance changes; calculations use the full number.

Conditional Formatting

Automatically colours cells depending on their values. Select a range and choose a rule:

• Highlight Cells Rules: “Greater Than…”, “Less Than…”, “Between…”, “Equal To…”, “Text that Contains…”, “A Date Occurring…”, “Duplicate Values…”. In the dialog, enter the value and choose the formatting.
• Top/Bottom Rules: “Top 10 Items”, “Top 10%”, “Bottom 10 Items”, “Bottom 10%”, “Above Average”, “Below Average”.
• Data Bars — coloured bars inside the cells whose length is proportional to the value (blue, green, red, orange, light blue, purple).
• Color Scales — a fill that shades from one colour to another: “Green - Yellow - Red” and others.
• Icon Sets — arrows, traffic lights, symbols and ratings next to the numbers.
• New Rule… — your own rule based on a formula.
• Clear Rules: “Clear Rules from Selected Cells” or “Clear Rules from Entire Sheet”.
• Manage Rules… — a list of all rules where you can edit or delete them.

Format as Table

Turns a range with headings into a “smart” table: alternating row colours, filter buttons in the headings, and automatic expansion when you add rows. Choose a style from the gallery (light, medium, dark). The Table Design tab then appears.

Cell Styles

A gallery of ready-made styles: “Good”, “Bad”, “Neutral”, headings, totals, number styles and so on. You can create your own style.

Insert

A menu: “Insert Cells…” (a dialog for choosing whether to shift cells down or right), “Insert Sheet Rows”, “Insert Sheet Columns”, “Insert Sheet”. New rows are inserted above the selection, columns to the left of it. Shortcut: Ctrl+Shift+=.

Delete

A menu: “Delete Cells…”, “Delete Sheet Rows”, “Delete Sheet Columns”, “Delete Sheet”. Shortcut: Ctrl+-. Deleting a row removes it entirely rather than just clearing it.

Format

A menu for sizes, visibility and protection:

• “Row Height…”, “AutoFit Row Height”, “Column Width…”, “AutoFit Column Width”, “Default Width…”;
• “Hide Rows” (Ctrl+9), “Hide Columns” (Ctrl+0), “Unhide Rows” (Ctrl+Shift+9), “Unhide Columns” (Ctrl+Shift+0), “Hide Sheet”, “Unhide Sheet…”;
• “Rename Sheet”, “Move or Copy Sheet…”;
• “Protect Sheet…” / “Unprotect Sheet…”, “Lock Cell” (locked cells cannot be changed while the sheet is protected), “Format Cells…” (Ctrl+1).

The Format Cells dialog (Ctrl+1) has the tabs “Number” (format categories, a sample, a “Currency symbol:” row with the ₸ Tenge, ₽ Ruble, $ Dollar and € Euro buttons, and a box for your own format code), “Alignment”, “Font”, “Border”, “Fill” and “Protection”.

AutoSum Alt+=

Goes below a column of numbers (or to the right of a row) and inserts a =SUM(…) formula with a suggested range. Check the selected range and press Enter. The arrow offers other summary functions: SUM, AVERAGE, COUNT (count of numbers), MAX, MIN and “More Functions…”.

Fill

A menu: “Down” (Ctrl+D) — copies the top cell of the selection into all the cells below it; “Right” (Ctrl+R); “Up”; “Left”; “Series…” — a dialog for linear, growth and date series with a step you set; “Flash Fill” (Ctrl+E) — X-Table works out the pattern from one or two examples (for example, takes the first name out of “Smith John”).

Clear

A menu: “Clear All” (values and formatting), “Clear Formats” (formatting only), “Clear Contents” (values only, like the Delete key), “Clear Comments and Notes”, “Clear Hyperlinks”.

Sort & Filter

A menu: “Sort A to Z” (ascending), “Sort Z to A” (descending), “Custom Sort…”, “Filter” (Ctrl+Shift+L), “Clear” (removes the filter conditions), “Reapply” (applies the filter again after the data has changed). More in Sort, filter, find.

Find & Select

A menu: “Find…” (Ctrl+F), “Replace…” (Ctrl+H), “Go To…” (Ctrl+G or F5) — jumps to an address or name, “Go To Special…” — selects cells of a particular type, plus quick items: “Formulas”, “Notes”, “Conditional Formatting”, “Constants”, “Data Validation” — each selects all cells of that type on the sheet.

Insert tab

Adds tables, pictures, shapes, charts, links, comments and special symbols to the workbook.

PivotTable

Creates a PivotTable — a summary report that groups and totals data (for example, sales by month and by manager). Select the source range with headings and click the button; a pane opens where you drag fields into rows, columns, values and filters.

Table Ctrl+T

Turns the selected range into a formatted table with filters in the headings (the same as “Format as Table” on the Home tab, with the default style).

Pictures

Inserts a picture from your computer. Options: “Place in Cell” — the picture becomes the contents of the cell and moves with it; “Place over Cells” — the picture floats freely over the sheet, and you can drag it and resize it by the corners.

Shapes

Draws a shape over the sheet: “Rectangle”, “Rounded Rectangle”, “Oval”, “Triangle”, “Line”, “Arrow”, “Text Box”. After inserting, you can move and stretch the shape; Delete removes the selected shape.

Icons

A library of simple icons (hover to see the name). Click to place an icon on the sheet.

Before inserting a chart, select the data together with the row and column headings. The chart appears over the sheet; you can drag it, resize it and adjust it on the Chart Design tab. To insert a default chart quickly, press Alt+F1.

Recommended Charts

Opens the “Insert Chart” dialog with previews of the chart types that suit your data. Pick one and click “OK”.

Column or Bar

Vertical columns or horizontal bars: “Clustered Column”, “Stacked Column”, “100% Stacked Column”, “Clustered Bar”, “Stacked Bar”, “100% Stacked Bar”. Good for comparing amounts.

Line or Area

“Line”, “Line with Markers”, “Stacked Line”, “Area”, “Stacked Area”, “100% Stacked Area”. Good for changes over time.

Pie or Doughnut

“Pie” and “Doughnut” — parts of a whole (for example, how expenses are split).

Scatter or Bubble

“Scatter”, “Scatter with Lines”, “Bubble” — how one quantity depends on another.

Statistic

“Histogram” of a distribution (how often values fall into intervals) and “Box & Whisker” (median, quartiles, outliers).

Hierarchy & more

“Treemap”, “Sunburst”, “Waterfall”, “Funnel”, “Radar”, “Stock”, “Combo”.

Slicer

Inserts a panel of buttons for filtering a table: clicking a value shows only the matching rows. The active cell must be inside a table.

Sparklines

Tiny charts inside a single cell: “Line”, “Column”, “Win/Loss”. In the dialog, enter the data range and the cell where the sparkline should go.

Checkbox

Inserts check boxes into the selected cells. A click or the Space key ticks and unticks a box; the cell holds TRUE or FALSE, which you can use in formulas (for example, =COUNTIF(A2:A20,TRUE)).

Link Ctrl+K

Inserts a hyperlink to a web page, an email address or a place in the workbook (a sheet and cell). Enter the text to display and the address.

Comment Ctrl+Shift+F2

Adds a comment to the cell for discussion: people can reply to it. A cell with a comment is marked with an indicator in the corner.

Text Box

Inserts a text box — a block of text over the sheet that is not tied to any cells.

Header & Footer

Switches the sheet to Page Layout view and starts editing the header right on the page. The Header & Footer tab appears.

Symbol

Inserts a special character into the cell: €, £, ¥, ©, ®, ™, ±, ≠, ≤, ≥, ÷, ×, ∞, µ, α, β, π, Σ, Ω, °, •, …, arrows, ✓, ★, ½, ¼.

Draw tab

Handwritten marks over the sheet with the mouse, a pen or your finger: circle an important number, underline something, draw an arrow.

Select Objects

Selection mode: click a drawing or shape to select, move or delete it.

Pen (Blue)

Draws a thin blue line. The active pen has a border around it; click it again to stop drawing.

Pen (Black)

Draws a thin black line.

Pen (Red)

Draws a thin red line — handy for review remarks.

Highlighter

A wide, semi-transparent yellow line for highlighting.

Eraser

Erases the ink strokes you move it over.

Ink to Shape

Turns the last stroke you drew into a neat shape (rectangle, oval, line and so on).

Page Layout tab

The look of the workbook, and preparing a sheet for printing and PDF.

Themes

A set of matching colours and fonts for the whole workbook. Each theme’s colours are shown next to its name. Changing the theme changes the colours of the palette, table styles and charts.

Margins

The space between the content and the edges of the paper: “Normal”, “Wide”, “Narrow” or “Custom Margins…” (the “Page Setup” dialog with exact values for the margins, header and footer).

Orientation

“Portrait” (an upright page) or “Landscape” (a sideways page — for wide tables).

Size

Paper size: Letter, Legal, Tabloid, Executive, A3, A4, A5, A6, B4, B5, B6, Japanese postcards and envelopes, B4/B5/B6 (ISO).

Print Area

“Set Print Area” — print only the selected range; “Clear Print Area” — print the whole sheet again.

Breaks

“Insert Page Break” — a new page starts above the active cell (and to the left of it); “Remove Page Break”; “Reset All Page Breaks”.

Print Titles

Opens “Page Setup” on the “Sheet” tab, where you set rows and columns to repeat — for example, so the row with the table headings is printed at the top of every page.

Gridlines: View / Print

“View” — show gridlines in X-Table; “Print” — print gridlines on paper and in PDF.

Headings: View / Print

“View” — show the column letters and row numbers; “Print” — print them.

Sheet Right-to-Left

Mirrors the sheet so that column A is on the right. Needed for right-to-left languages (Arabic, Hebrew).

Formulas tab

Inserting functions, working with names, checking formulas and controlling recalculation. Formula basics are described in Formulas and references, and a list of functions in Functions.

Insert Function Shift+F3

A dialog for finding a function by name or description. Choose a function — X-Table shows what it does and its arguments, and inserts it into the active cell.

AutoSum

As on the Home tab: the main part inserts =SUM(…), the arrow offers AVERAGE, COUNT, MAX, MIN or “More Functions…”.

Financial

A list of financial functions (PMT — loan payment, FV — future value, NPV — net present value and others). Hover over a name to see its description; click to insert the function.

Logical

IF, IFS, AND, OR, NOT, IFERROR and other functions for testing conditions.

Text

Functions for working with text: LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, SUBSTITUTE, TEXT, CONCAT and others.

Date & Time

TODAY, NOW, DATE, YEAR, MONTH, DAY, WEEKDAY, NETWORKDAYS and others.

Lookup & Reference

VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH and other functions for finding data in tables.

Math & Trig

SUM, SUMIF, ROUND, ABS, INT, MOD, POWER, SQRT and others.

More Functions

Statistical functions: AVERAGE, COUNT, COUNTIF, MEDIAN, STDEV and others.

Name Manager Ctrl+F3

A list of all names in the workbook: what they refer to and where they are. Here you create, edit and delete names.

Define Name

Gives the selected range a meaningful name, for example Tax or Sales. You can then write =B2*Tax in formulas instead of =B2*$F$1.

Use in Formula

A list of the workbook’s names: click one to insert it into the formula at the cursor. The “Paste Names…” item (F3) opens a dialog with the list of names.

Create from Selection Ctrl+Shift+F3

Creates names automatically from labels: for example, select a table with headings in the first row, and each column gets a name from its heading.

Trace Precedents

Draws arrows from the cells used in the active cell’s formula. Helps you see where a result comes from. To select those cells: Ctrl+[.

Trace Dependents

Draws arrows to the formulas that use the active cell — you can see what will change if you change this value. To select them: Ctrl+].

Remove Arrows

Hides the tracer arrows.

Show Formulas Ctrl+`

Shows the formulas themselves in the cells instead of their results. Press again to return to the normal view.

Error Checking

The main part opens a dialog that goes through the cells with errors one by one and suggests fixes. The arrow offers “Error Checking…” and “Circular References” — a list of cells whose formula refers to itself, directly or indirectly; click one to go to that cell.

Evaluate Formula

Calculates a complex formula step by step, showing the intermediate result of each part. Handy for tracking down a mistake.

Watch Window

A pane where you can add important cells (for example, totals on another sheet) and keep an eye on their values while you work elsewhere in the workbook.

Calculation Options

“Automatic” — formulas are recalculated straight after every change (the normal mode); “Automatic Except for Data Tables”; “Manual” — recalculation only on command, useful for very large workbooks. In manual mode the status bar shows “Calculate”.

Calculate Now F9

Recalculates all formulas in the workbook.

Calculate Sheet Shift+F9

Recalculates the current sheet only.

Data tab

Importing, sorting, filtering, cleaning and analysing data.

Get Data (Text/CSV)

Opens a file picker for importing text data: .csv, .tsv, .txt (and other supported formats). More in Importing and exporting CSV.

Sort A to Z

Sorts the table around the active cell by that cell’s column in ascending order: text alphabetically, numbers from smallest to largest, dates from earliest to latest. Whole table rows are moved together, so the data in a row stays together.

Sort Z to A

The same in descending order.

Sort

The “Custom Sort” dialog: sort by several columns (“Sort by”, “Then by”), by values, cell colour or font colour, in ascending or descending order. “+ Add Level” adds another condition, “✕” removes a level.

Filter Ctrl+Shift+L

Turns AutoFilter on and off: arrow buttons appear in the heading cells for picking rows.

Clear

Removes all filter conditions — all rows are visible again (the filter buttons stay).

Reapply

Applies the current filter conditions again — needed after data has been changed or added.

Advanced

The “Advanced Filter” dialog: picks rows by complex conditions written in a separate criteria range, and can copy the result to another place.

Text to Columns

Splits the text of one column into several: for example, “Smith;John;London” → three columns. Choose a delimiter (comma, semicolon, space, tab or a character of your own) or fixed width.

Flash Fill Ctrl+E

Type one or two examples of the result you want in the next column (for example, just the surname from a full name) and click the button — X-Table fills in the remaining rows following the pattern.

Remove Duplicates

Removes repeated rows. In the dialog, tick the columns that decide whether two rows are the same. X-Table reports how many rows were removed and how many unique rows remain.

Data Validation

Limits what can be entered in cells. “Data Validation…” — the rule dialog: whole or decimal numbers in a range, dates, text length, a list (a drop-down list of values in the cell — it also opens with Alt+↓), a custom formula; an input message and an error alert. “Circle Invalid Data” — circles values already entered that fail the rule. “Clear Validation” — removes the rules.

What-If Analysis

“Goal Seek…” — finds the value of an input cell that makes a formula give the result you need (for example, what price to set so that revenue reaches 1,000,000); “Scenario Manager…” — stores several sets of input data and switches between them; “Data Table…” — shows how a formula’s result changes for different values of one or two inputs.

Forecast Sheet

Takes a series of dated values, forecasts future periods and creates a new sheet with a forecast table and chart.

Group Alt+Shift+→

Combines the selected rows or columns into a group that can be collapsed with the “−” button to the left of (or above) the grid.

Ungroup Alt+Shift+←

Removes the grouping.

Subtotal

Inserts total rows for each group of identical values (for example, sales for each city) and a grand total. Sort the data by the grouping column first.

Show Detail / Hide Detail

Expands or collapses the group that contains the active cell.

Settings

The outline settings dialog: where summary rows and columns are placed relative to the data.

Data Analysis

A set of statistical analysis tools: descriptive statistics, histogram, correlation, regression, moving average and others. Choose a tool, enter the input range and where to put the output.

Solver

Optimisation: finds the values of several changing cells at which a target formula reaches its maximum, minimum or a given value, subject to constraints (for example, a production plan with a limited budget).

Review tab

Proofing, comments, notes and protecting data from changes.

Spelling F7

Checks the spelling of the text in cells and suggests corrections.

Workbook Statistics

Shows information about the workbook: the number of sheets, filled cells, formulas, tables, charts and comments.

Check Accessibility

Looks for things that get in the way of people with disabilities (for example, pictures without alternative text, merged cells, sheets without meaningful names) and suggests how to fix them.

New Comment Ctrl+Shift+F2

Adds a discussion comment to the active cell: people can reply to it, and the thread can be resolved.

Delete

Deletes the comment in the active cell.

Previous / Next

Goes to the previous or next comment on the sheet.

Show Comments

Opens and closes the side pane with all the comments on the sheet. While the pane is open, the button has a border around it.

Notes

A note is a simple annotation on a cell with no replies (what older versions of Excel called a “comment”). The menu: “New Note” (Shift+F2), “Show/Hide Note” (the note stays visible instead of appearing only on hover), “Show All Notes”, “Convert to Comments”.

Protect Sheet / Unprotect Sheet

Prevents changes to the locked cells of the sheet. In the dialog you can set a password and tick what users are still allowed to do (select cells, format, sort, use the filter and so on). By default all cells are locked; to leave input fields open, unlock them before protecting the sheet: Home › Format › Lock Cell or Format Cells › Protection. While the sheet is protected, the button is called “Unprotect Sheet”.

Protect Workbook

Locks the structure of the workbook: sheets cannot be added, deleted, moved, renamed or hidden. You can set a password. Click again to remove the protection (you will be asked for the password if there is one).

Allow Edit Ranges

Sets ranges that can still be changed on a protected sheet (with a separate password if needed).

View tab

View modes, showing parts of the window, zoom, freezing panes and interface settings.

Normal

The normal working mode — a continuous grid of cells.

Page Break Preview

Shows how the sheet is divided into printed pages: page boundaries are marked with lines, and you can drag them.

Page Layout

The sheet looks like a stack of printed pages with margins, a ruler, and headers and footers. Click in the header or footer area to type text.

Ruler

Shows rulers along the edges of the pages. Available only in Page Layout view.

Gridlines

Shows or hides the grey lines between cells (does not affect printing).

Formula Bar

Shows or hides the formula bar.

Headings

Shows or hides the column letters and row numbers.

Zoom

A dialog for choosing the zoom: preset values (200%, 100%, 75%, 50%, 25%), “Fit selection” or your own number.

100%

Returns to normal size.

Zoom to Selection

Sets the zoom so that the selected range fills the whole window.

New Window

Opens another window with the same workbook — you can look at different sheets, or different parts of one sheet, at the same time. Changes show up in both windows.

Arrange All

Arranges the open windows side by side: left to right, top to bottom, or cascaded.

Freeze Panes

Rows and columns stay in place while you scroll — the table headings are always visible. The menu: “Freeze Panes” (freezes the rows above and the columns to the left of the active cell; for example, to freeze row 1 and column A, click B2 first), “Freeze Top Row”, “Freeze First Column”, “Unfreeze Panes”.

Switch Windows

A list of open workbooks and windows; the current one has a check mark, and clicking another switches to it.

Display theme

“System” (follows the operating system), “Light” or “Dark”.

Animations

When this is on, the selection border glides smoothly to the new cell instead of jumping. Turn it off if the animation is distracting.

Interface size

The scale of the whole interface (buttons, text, ribbon): “Auto”, 75%, 90%, 110%, 125%, 150%, 175%, 200%. Useful on small or very large screens.

Interface language

The language of menus and buttons: “Русский”, “English”, “简体中文”, “Español”, “Français”, “Português (Brasil)” or “Türkçe”. In Russian, Spanish, French, Portuguese and Turkish, formulas use ; between arguments and a decimal comma, numbers show local thousands separators, and dates typed with slashes are read day first, as in those versions of Excel. If your system language is not one of these, X-Table starts in English.

Automate tab

Macros for repetitive tasks, and utility tools.

Macros Alt+F8

A dialog listing the workbook’s macros: run, edit, delete, assign a keyboard shortcut.

Record Macro / Stop Recording

Starts recording your actions (typing, formatting, sorting and so on) as a macro. While recording, the button is called “Stop Recording”: click it to save the macro. You can then repeat it with a single click.

Use Relative References

If this is on before recording starts, the macro remembers its steps relative to the selected cell rather than as fixed addresses — so you can apply it to other data.

New Macro

Opens an editor where you build a macro step by step from commands.

Run Macro

The main part runs the last macro you ran (or the only one in the workbook). The arrow shows a “Recent” list and all the macros in the workbook, plus the “Macros…” item. The macro is applied to the current selection.

Command Palette

Finds and runs any X-Table command by name (the same as the magnifier button in the title bar).

Agent Control

Help for developers: how external programs and AI agents can control the spreadsheet through the MCP protocol. Regular users don’t need this button.

Action Journal

A list of all commands run in this session. Commands from the journal can be repeated.

Check for Updates…

Checks whether a new version is out. The browser version updates itself the next time you open the page.

About X-Table

The X-Table version and information about the program.

Contextual tabs

These tabs appear on the ribbon to the right of the others (their names are highlighted in colour), and only while the matching object is selected.

Table Design

Appears when the active cell is inside a table created with the “Table” or “Format as Table” button.

Table Name

The box with the table name (for example, Table1). Type a meaningful name — you can use it in formulas: =SUM(Sales[Amount]).

Resize Table

Sets a new range for the table, for example to include rows or columns you have added.

Remove Duplicates

Removes repeated rows in the table.

Convert to Range

Turns the table into ordinary cells. The formatting stays, but the filters and automatic expansion are gone.

Insert Slicer

Adds a panel of buttons for quickly filtering the table.

Header Row

Shows or hides the first row with the column names and filter buttons.

Total Row

Adds a total row at the bottom; in each of its cells you can choose a function (sum, average, count and so on).

Banded Rows / Banded Columns

Striped shading of rows or columns to make them easier to read.

First Column / Last Column

Shows the first or last column in bold.

Table Styles

A row of style samples; the current one has a border. The arrow button on the right opens the full gallery (light, medium and dark styles).

Chart Design

Appears when a chart is selected (click it).

Add Chart Element

“Legend: Bottom”, “Legend: Right”, “Legend: Top”, “Legend: None”; “Data Labels: Show” / “Data Labels: None” (values above the columns or points); “Gridlines: Show” / “Gridlines: None”.

Switch Row/Column

Swaps series and categories: what were labels on the horizontal axis become series in the legend, and the other way round.

Select Data

A dialog where you change the chart’s data range and add or remove series.

Change Chart Type

Switches the type without re-creating the chart: clustered or stacked column, bar, line, area, pie, doughnut, scatter, radar, waterfall, funnel, treemap.

Format Pane

A side pane for fine-tuning: colours, fills, lines, axes, fonts.

Chart Title

Changes the text of the chart title.

Delete Chart

Deletes the selected chart (the Delete key does the same).

Header & Footer

Appears while you are editing a header or footer in Page Layout view (the Insert › Header & Footer button, or a click in the header or footer area). A header or footer has three parts — left, centre and right.

Header / Footer

Ready-made options: “(none)”, “Page 1”, “Page 1 of ?”, the sheet name, the file name, “Sheet name, Page 1”, “File name, Page 1”.

Page Number

Inserts a field with the number of the current page.

Number of Pages

Inserts the total number of pages — together with the page number this gives “Page 2 of 5”.

Current Date / Current Time

The date and time of printing — updated automatically.

File Path / File Name

The full path to the workbook file, or just its name.

Sheet Name

The name of the current sheet.

Go to Header / Go to Footer

Switches editing between the header and the footer.

Different First Page

The first page can have its own header and footer (or none).

Different Odd & Even Pages

Separate headers and footers for even and odd pages — for double-sided printing.

Scale with Document

Headers and footers shrink along with the sheet when fit-to-page scaling is on.

Align with Page Margins

The edges of the header and footer line up with the page margins.

To finish editing, click any cell on the sheet or press Esc.

Entering data

Select a cell and start typing — the contents are replaced. Press Enter to store the value and move down, Tab to move right, Shift+Enter to move up, Shift+Tab to move left. Esc cancels the entry. To edit existing contents instead of replacing them, press F2 or double-click the cell. Delete clears the selected cells.

X-Table works out the type of a value by itself: numbers and dates are aligned to the right and take part in calculations, text is aligned to the left.

Text

• Anything that is not recognised as a number or date is stored as text: Smith, Almaty, 10 Abay St..
• Long text spills over into the next cell if the cell to the right is empty. Turn on Home › Wrap Text or widen the column.
• A new line inside a cell — Alt+Enter.
• To keep a number as text (contract number 000125, phone number, ID number), start with an apostrophe: '000125. The apostrophe is not displayed. Another way is to give the cells the “Text” format in advance.
• As you type, X-Table offers to complete the entry with a value that already appears in the column (AutoComplete). Press Enter to accept it, or keep typing.

Numbers

• Whole numbers and decimals: 125, -40, 3.75.
• Use a dot for the decimal part: 12.5. A comma is treated as a thousands separator: 1,500 is one thousand five hundred. How the number looks on the sheet depends on the number format.
• You can enter a negative number in brackets: (250) = −250.
• Scientific notation: 1.5E+6 = 1,500,000.
• Logical values: TRUE and FALSE.
• If you see ####### instead of a number, the number doesn’t fit in the cell — widen the column (double-click the right border of the column heading).

Dates and times

A date is stored as a number (the count of days since 1 January 1900), so you can calculate with dates: =B2-A2 gives the number of days between two dates, =A2+30 gives the date 30 days later.

Dates entered with other separators or produced by a formula can be shown as 05.04.2026: select the cells, open Format Cells (Ctrl+1) › “Number” and type dd.mm.yyyy into the format code box. For a date with a time, use dd.mm.yyyy hh:mm.

Percentages

• Type a number with a percent sign: 15%. The cell stores 0.15 and shows 15% — in formulas you can write =B2*C2 directly, where C2 = 15%.
• Or type 0.15 and click Home › Percent Style (Ctrl+Shift+5).
• If you type 15 and then apply the percent format, you get 1500% — set the format first and then type, or type the % sign straight away.
• The number of decimal places is set with the “Increase Decimal” and “Decrease Decimal” buttons.

Money: ₸, ₽, $, €

You can type an amount together with the currency symbol — X-Table stores a number in the cell and gives it a currency format, so such amounts can be added up, compared and used in any formula. The symbol is shown after the number (except the dollar, which goes before it).

It is easy to check that a cell holds a number: select several amounts and their Sum appears in the status bar. For example, =SUM(B2:B10) over a column with 1500 ₸, 2300 ₸ and so on gives a total in tenge.

You can also do it the other way round — type plain numbers and set the currency with a format:

• Format Cells (Ctrl+1) › “Number” tab › Currency category: tenge is used by default. The “Currency symbol:” row with the ₸ Tenge, ₽ Ruble, $ Dollar and € Euro buttons switches the symbol. In the format code box you can set your own look, for example #,##0 "₸" — without the decimal part.
• Home › Accounting Number Format › arrow: the list starts with “₸ Kazakh tenge” and “₽ Russian ruble”, followed by the dollar, euro and other currencies. The accounting format lines up the currency symbols in a column.
• Ctrl+Shift+4 — currency format in dollars.

Formulas and references

How to enter a formula

1. Select the cell for the result.
2. Type the = sign. Without it, X-Table stores text, not a formula.
3. Type the expression: numbers, cell addresses, operators and functions. Instead of typing a cell address you can click the cell with the mouse (Point mode).
4. Press Enter. The result appears in the cell, and the formula is shown in the formula bar.

Example: A1 holds the price 1200, B1 the quantity 3; type =A1*B1 in C1 — you get 3600. If you change the price, the result is recalculated automatically.

Relative and absolute references

When a formula is copied or dragged with the fill handle, the addresses in it shift. The $ sign locks part of an address.

Example: F1 holds the dollar exchange rate. Type =B2*$F$1 in C2 and drag it down: in each row, that row’s amount from column B is multiplied by the same rate from F1.

Quick switching: while editing, put the cursor on an address and press F4 — the address cycles through A1 → $A$1 → A$1 → $A1.

References to other sheets

• The form is SheetName!Address. For example, =Sheet2!A1 or =SUM(Sheet2!B2:B20).
• If the sheet name contains spaces or punctuation, put it in apostrophes: ='Sales 2026'!C5.
• The easiest way: start the formula with =, click the tab of the sheet you need, select the cell and press Enter — X-Table fills in the reference for you.
• When you rename a sheet, references to it in formulas are updated automatically.

Reference highlighting

While you type or edit a formula, each reference in the formula bar gets its own colour, and the matching cells on the sheet are outlined with a border of the same colour. This makes it easy to check that the formula takes its data from the right places. You can drag a border with the mouse to another range — the reference in the formula changes. To see the links of a finished formula, use Formulas › Trace Precedents and Trace Dependents.

Names

You can give a cell or range a name (Formulas › Define Name or the Name Box to the left of the formula bar): for example, Rate. The formula =B2*Rate is then clearer than =B2*$F$1, and the name always points to the same cell.

Functions

A function is a ready-made formula that performs a calculation on the arguments in brackets. Function names are written in English, arguments are separated by commas, and text in arguments goes in double quotes: =COUNTIF(B2:B100,"Almaty"). When you type = and the first letters, X-Table shows a list of matching functions and a hint about their arguments. You can find every function with the Insert Function (fx) button.

Formula errors

If a formula cannot be calculated, the cell shows an error code instead of a result. These are the same codes Excel uses, and they are written to the file unchanged, so Excel in any language opens the workbook correctly. (In the Russian interface X-Table shows the Russian names of the codes, as the Russian version of Excel does.)

Circular references

A circular reference happens when a formula refers to itself, directly or through other cells. For example, B10 contains =SUM(B1:B10) — the sum includes the total cell itself. Such a formula cannot be calculated in the normal way.

• The status bar shows the warning “Circular References: B10” with the cell address.
• For a list of all such cells: Formulas › Error Checking (arrow) › Circular References. Click an address to go to the cell.
• To fix it, change the range so that it doesn’t include the cell itself — in the example, =SUM(B1:B9).
• If you want the loop on purpose (iterative calculations), turn on File › Options › Formulas › Enable iterative calculation and set the maximum number of iterations.

To find the cause of any error, Formulas › Evaluate Formula (step-by-step calculation) and Trace Precedents are useful.

Sorting, AutoFilter, find and replace

Sorting

1. Click any cell in the column you want to sort by (you don’t need to select the whole table — X-Table finds its edges and leaves the heading row in place).
2. Click Data › Sort A to Z (ascending) or Sort Z to A (descending). The same commands are in the Home › Sort & Filter menu and in the cell context menu.
3. To sort by several columns (for example, first by city, then by amount), click Data › Sort: in the “Sort by” row choose the first column and the order, and use “+ Add Level” to add “Then by”. You can sort by values, cell colour or font colour.

AutoFilter

1. Click a cell inside a table with headings and click Data › Filter (Ctrl+Shift+L). Arrow buttons appear in the headings.
2. Click the arrow in the column you need (or press Alt+↓ on the heading). A menu opens:
   • Sort Ascending / Sort Descending by this column;
   • Search — a box for quickly finding a value in the list;
   • (Select All) and the list of the column’s unique values with check boxes; “(Blanks)” stands for empty cells;
   • Clear Filter — show all rows for this column;
   • Apply (or Enter) — keep only the ticked values.
3. Rows that don’t pass the filter are hidden (not deleted). The row numbers of a filtered table are shown in a different colour, and the button icon changes on the column that has a condition.
4. You can filter by several columns at once — the conditions combine.
5. To remove all conditions: Data › Clear. To turn the filter off completely, click Data › Filter again.

A quick way: right-click a cell with a value and choose “Filter by Selected Cell's Value” — only rows with the same value remain.

While a filter is on, the status bar counts the sum and average of the visible selected cells only — handy for quick totals.

Find and replace

Find Ctrl+F

Type text in the “Find what” box. “Find Next” goes to the next match; “Find All” shows a list of all the cells found — click a line in the list to go to that cell.

Replace Ctrl+H

Fill in “Find what” and “Replace with”. “Replace” changes the current match and moves to the next one; “Replace All” changes all matches at once and reports how many there were.

Search options

“Match case” — tells upper and lower case apart; “Match entire cell contents” — finds only cells whose whole contents match (a search for 10 will not find 100); “Within workbook” — searches all sheets, not just the current one.

Go To (Ctrl+G or F5) — jumps to an address or name; the “Special…” button in this dialog opens “Go To Special” (formulas, constants, blank cells, notes and so on).

Undo and redo

Undo Ctrl+Z

Undoes the last action: typing, deleting, formatting, sorting, inserting rows, deleting a sheet and so on. Press it several times to undo several actions in a row. The button is in the title bar (a left arrow).

Undo several actions at once

The arrow next to the Undo button shows a list of recent actions (up to 20). Choose a line — that action and all actions after it are undone.

Redo Ctrl+Y or Ctrl+Shift+Z

Repeats an action you undid. If you do something new after undoing, the undone steps can no longer be brought back.

• Each open workbook has its own undo history.
• While you are typing in a cell, Ctrl+Z undoes the edit inside the cell; Esc cancels the whole entry.
• Saving a file and exporting cannot be undone — but you can still roll back the contents of the workbook after them.

Keyboard shortcuts

The shortcuts are given for Windows and Linux. On a Mac, use Cmd instead of Ctrl and Option instead of Alt. The shortcuts work when a cell on the sheet is selected (not when an input box or dialog is open). Digits in shortcuts are the keys in the top row of the keyboard.

Excel compatibility

• Files. X-Table opens Microsoft Excel workbooks (.xlsx, .xlsm, .xls, .xlsb), OpenDocument (.ods) and text tables (.csv, .tsv, .txt). It saves to .xlsx — a file that opens in Excel and in other spreadsheet programs.
• What carries over. Sheets, values, formulas, number formats, fonts, fills, borders, merged cells, column widths and row heights, frozen panes, tables, conditional formatting, data validation, names, comments and notes, hyperlinks, charts, pictures, page setup, headers and footers, sheet protection.
• Formulas. The same functions as in Excel are used, with English names and a comma between arguments — as in the English version of Excel. An Excel file always stores formulas in their English form, so workbooks from the Russian version of Excel (where people type =СУММ(A1:A5;B1)) open without loss: in X-Table the same formula appears as =SUM(A1:A5,B1). New formulas must be typed in the English form.
• Error codes are written to the file as the international codes (#DIV/0!, #VALUE! and so on), so Excel in any language reads them correctly. In the Russian interface they are displayed in Russian — see Formula errors.
• Money amounts typed with a currency symbol (1500 ₸, 250 ₽) are saved as numbers with a currency format and remain numbers in Excel.
• Dates. The same date system as in Excel is used (counting from 1900), so dates and date calculations match.
• VBA macros from .xlsm files are kept when the file is saved again, but they are not run. For automation, use X-Table macros (the Automate tab).
• Fonts. If a font used in the file is not on your computer, the browser substitutes a similar one; this can slightly affect column widths and line wrapping.
• Interface. The ribbon, tabs, button names and keyboard shortcuts are arranged as in Excel, so the techniques you know work here too.

Updates

The web version is always the latest. The Windows program learns about new versions from the X-WORLD server by itself, when it starts with an internet connection. To check by hand: Automate › Check for Updates.

• A new version is out. A window asks “A new version of X-Table is available. Update now?”. Nothing is downloaded or installed without your consent.
• Later. The window closes, and X-Table reminds you at the next check.
• Update. X-Table downloads the installer from the X-WORLD server and checks that the file is complete and genuine. Then the program closes; if any workbooks are unsaved, it asks about saving them first. The installer puts the new version in the same folder, with the same shortcuts and file types, and opens X-Table.
• No internet. Your work is not interrupted: the update is offered once you are online again.

About

X-Table is the spreadsheet editor of the X-WORLD office suite. The version number, platform and licence are shown in File › Account and in the Automate › About X-Table window.

X-Table is based on the open-source project GridCraft (Apache License 2.0).

Other X-WORLD products: the X-Word text editor.