MyTable FAQ
What formats does MyTable support?
XLSX, ODS, XLS, CSV, TSV for reading and editing. Export to PDF.
How do I open an Excel file (.xlsx)?
Open via File → Open or double-click the file. MyTable provides compatibility with Microsoft Excel formats.
Are formulas preserved when opening Excel files?
Yes, MyTable supports over 400 Excel functions. Some Excel-specific functions may be unavailable — the cell will show a #NAME? error.
Is VLOOKUP supported?
Yes, the VLOOKUP function is supported. Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).
How do I create an absolute cell reference?
Press F4 while entering a reference to toggle between types: A1 → $A$1 → A$1 → $A1.
How do I freeze the header row during scrolling?
Select the row below the headers → View → Freeze Rows and Columns.
How do I merge cells?
Select cells → click the Merge & Center button on the toolbar. Or Format → Merge Cells.
How do I print only a selected area?
Select the desired range → Layout → Print Area → Set Print Area → Ctrl+P.
More questions and answers are available at support.myoffice.ru/faq.