EverydayAppSoft

XLSX Editor Pro - Help File

Overview

XLSX Editor Pro is a spreadsheet editor for Windows that lets you create, open, view, and edit Microsoft Excel–compatible spreadsheets and other common spreadsheet formats.

You can use it to:

  • Enter and format data (text, numbers, dates, currency, percentages)

  • Build calculations with formulas and functions

  • Sort and filter lists, and work with tables

  • Manage multiple sheets within a workbook

  • Save, print, and export copies for sharing

If you’re new to the app, start with Creating a New Spreadsheet or Opening Existing Spreadsheets to get up and running quickly.

Product Support

If you have questions, encounter an issue, or need assistance, our support team is here to help. Please contact us via email at: support [at] everydayappsoft.com

If you enjoy using XLSX Editor Pro, please consider leaving a positive rating and review to help others discover the app.

1. Creating a New Spreadsheet

You can start a new spreadsheet at any time, then choose where to save it on your PC.

Create a new blank spreadsheet

  1. Launch XLSX Editor Pro.

  2. On the start screen, select Create Spreadsheet.

  3. A blank spreadsheet opens. Start entering data in any cell.

Add and rename sheets (optional)

  • To add a sheet, click the + button next to the sheet tabs at the bottom.

  • To rename a sheet, double-click the sheet tab name, type a new name, then press Enter.

Save your new spreadsheet

  1. Select File > Save to save changes to the current file.

  2. If this is a new file, choose a folder, enter a file name, and select a format (for example, .xlsx).

  3. Select Save.

Tip: Use File > Save As to create a copy with a new name or to save in a different format.

2. Opening Existing Spreadsheets

You can open a spreadsheet from the start screen, from within the app, or directly from File Explorer.

Open a file from the start screen

  1. Launch XLSX Editor Pro.

  2. Select Open Spreadsheet.

  3. Browse to the file, select it, then choose Open.

Open a file while another spreadsheet is already open

  1. Select File > Open.

  2. Browse to the file, select it, then choose Open.

Open a recent file

  • On the start screen (or under File), select a file from Recent to reopen it quickly.

Open from File Explorer

  • Double-click a supported spreadsheet file (such as .xlsx) to open it in XLSX Editor Pro.

  • If Windows opens it in a different app, you can change the default app for that file type in Windows settings.

Tip: If a file doesn’t open correctly, save a copy to a local folder (for example, Documents) and try opening it again. For format compatibility, see Supported File Formats.

3. Editing Cells and Formatting Data

This section covers the everyday actions for entering data, editing cells, and formatting worksheets so they are easier to read.

Enter and edit data

  • Click a cell and type to enter text or numbers.

  • Press Enter to confirm and move to the next row. Press Tab to move to the next column.

  • Double-click a cell (or press F2) to edit the existing content.

Select cells and ranges

  • Click a cell to select it.

  • Click and drag to select a range.

  • Use Ctrl + click to select multiple non-adjacent cells or ranges.

Copy, cut, and paste

  1. Select a cell or range.

  2. Use Ctrl+C (copy) or Ctrl+X (cut).

  3. Select the destination cell, then use Ctrl+V (paste).

Tip: If you only want values (not formatting), use the Paste options in the toolbar.

Format numbers (dates, currency, percent, etc.)

  1. Select the cells.

  2. Choose a Number format (for example General, Number, Currency, Percent, Date).

  3. Adjust decimals if needed.

Format text and alignment

  • Change font, size, bold/italic/underline, and text color from the toolbar.

  • Use alignment tools to left/center/right align content, or align it vertically.

  • Turn on Wrap text to display long text on multiple lines within the same cell.

Merge cells (use with care)

  1. Select the cells you want to combine.

  2. Select Merge (choose the merge option you need).

Tip: Merging can affect sorting and filtering. For tables, consider using Center across selection or formatting instead of merge when possible.

Add borders and fill color

  1. Select the cells.

  2. Apply borders to outline data.

  3. Apply fill color to highlight headers or important values.

Clear contents or formatting

  • To remove only the content, select cells and press Delete.

  • To remove formatting, use Clear formatting from the toolbar/menu.

4. Working with Rows, Columns, and Sheets

Use these tools to organize your worksheet layout and manage multiple sheets in the same file.

Insert or delete rows and columns

  1. Select a row number or column letter.

  2. Right-click, then choose Insert or Delete.

Tip: If you select multiple rows/columns first, the same number will be inserted or deleted.

Change column width or row height

  • Drag the border between column letters (or row numbers) to resize.

  • Double-click the border to auto-fit to the content.

Hide or show rows and columns (optional)

  • Right-click the selected row/column and choose Hide.

  • To unhide, select the rows/columns around the hidden area, right-click, then choose Unhide.

Freeze panes (keep headers visible)

  1. Click the cell below your header row (and to the right of any header column).

  2. Select View > Freeze Panes, then choose the option you need.

Add, rename, move, or delete sheets

  • Add: Click the + next to the sheet tabs.

  • Rename: Double-click the sheet tab, type a new name, press Enter.

  • Move/Copy: Drag a sheet tab to a new position (or use the tab menu to copy).

  • Delete: Right-click the sheet tab and choose Delete.

Tip: Use clear sheet names (for example, 2026 Budget, Inventory, Q1 Sales) so it’s easier to navigate later.

5. Formulas and Functions

Formulas let you calculate values automatically based on the data in your worksheet. Functions are built-in formulas for common tasks (such as totals, averages, and lookups).

Create a basic formula

  1. Click the cell where you want the result.

  2. Type = to start the formula.

  3. Click the cells you want to use (or type their references), then enter an operator such as +, -, *, or /.

  4. Press Enter.

Example: =B2+C2

Use a function (SUM, AVERAGE, etc.)

  1. Click the result cell.

  2. Type = and the function name, then open parentheses.
    Example: =SUM(

  3. Select the range, close parentheses, then press Enter.

Example: =SUM(B2:B20)

Insert a function from the toolbar

  • Select the result cell, then use Insert Function (or the function list) to search and add a function without typing it from scratch.

Relative vs. absolute references

When you copy a formula, cell references can change automatically.

  • Relative reference: A1 changes when copied.

  • Absolute reference: $A$1 stays fixed when copied.

Tip: When editing a formula, press F4 (if available) to toggle reference types (for example, A1 → $A$1).

Use named ranges (optional)

Named ranges make formulas easier to read.

  1. Select a cell or range.

  2. Create a Name (for example, Sales_2026).

  3. Use the name in formulas instead of the cell range.

Tip: If a formula returns an error, recheck parentheses, range selection, and whether you’re referencing the correct sheet and cells.

6. Sorting, Filtering, and Tables

Use these tools to organize large lists and focus on the data you need.

Sort data

  1. Click a cell inside the data range.

  2. Select Sort.

  3. Choose the column to sort by, then select A to Z or Z to A.

Tip: If your first row is a header, make sure it’s treated as a header so it stays at the top during sorting.

Filter data (show only matching rows)

  1. Click a cell inside the data range.

  2. Turn on Filter.

  3. Use the filter arrow in a column header to pick values or set conditions.

  4. Clear the filter to show all rows again.

Tip: Filters are best when your data has a single header row and no blank rows inside the list.

Format as a table

Tables make it easier to read and work with structured data.

  1. Select any cell in your data range.

  2. Select Format as Table (or Table).

  3. Confirm the range and whether your table has headers.

Remove duplicate values (optional)

  1. Select the range (or click inside the table).

  2. Select Remove Duplicates.

  3. Choose which columns to check, then confirm.

Tip: Save a copy before removing duplicates if you may need to restore the original data later.

7. Saving, Printing, and Exporting

Use the File menu to save changes, create a copy, print your worksheet, or export it to another format.

Save changes

  • Select File > Save to save updates to the current file.

  • Use Ctrl+S to save quickly.

Save a copy (Save As)

  1. Select File > Save As.

  2. Choose a folder and file name.

  3. Select the format you want (for example, .xlsx), then save.

Print a worksheet

  1. Select File > Print to open print settings and preview.

  2. Choose the printer and adjust options such as:

    • Orientation (Portrait/Landscape)

    • Paper size

    • Margins

    • Scaling (fit to page, if needed)

  3. Select Print.

Tip: If the sheet prints on multiple pages unexpectedly, set the print area or use scaling to fit the content to one page width.

Export (common options)

Depending on the available export options in your build, you can export a spreadsheet to formats such as:

  • PDF (for sharing or printing)

  • Images (for snapshots of sheets or ranges)

To export:

  1. Select File > Export (or Download as).

  2. Choose the target format and any available options.

  3. Choose a save location and confirm.

Tip: Exporting creates a separate copy. Your original spreadsheet file remains unchanged unless you also save it.

8. Supported File Formats

XLSX Editor Pro is optimized for Excel-compatible spreadsheets and OpenDocument spreadsheets. Some file types may be converted to XLSX when opened for editing to improve compatibility and processing.

Open for editing (common)

  • XLSX

  • XLSM

  • XLSB

  • XLTX

  • ODS

  • CSV

Open for viewing (varies by file)

  • XLS

  • XLT / XLTM

  • FODS / OTS

  • SXC

  • XML

  • ET / ETT

  • NUMBERS

Export / Download as (where available)

  • XLSX, ODS, CSV

  • PDF, PDF/A

  • XLTX, OTS

  • JPG/JPEG, PNG

Tip: If a file opens but looks different, save a copy as .xlsx and continue editing from that version for the most consistent results.

9. Tips for Everyday Use

  • Turn your first row into headers. Keep column titles in row 1, then use Filter so you can sort and search cleanly.

  • Freeze headers for long lists. Use Freeze Panes so column titles stay visible while you scroll.

  • Use number formats instead of typing symbols. For currency, percent, dates, and decimals, apply a Number format rather than manually typing $ or %.

  • Avoid merging cells in data tables. Merge is fine for titles, but it can make sorting and filtering harder in everyday spreadsheets.

  • Auto-fit for clean layout. Double-click a column border to auto-fit to the longest value in that column.

  • Copy formulas safely. If a reference must stay fixed (like a tax rate cell), switch it to an absolute reference (for example $B$2) before copying.

  • Preview before printing. Always check Print preview and use scaling (fit to page width) to prevent unwanted page breaks.

  • Save a copy before “big” changes. Before removing duplicates, mass formatting, or large edits, use Save As to create a backup version.

Table of Contents

Table of Contents