Articles with the tag:
Close
Changelog
Close

How to merge cells

Introduction

If you need to merge cells to position your text better (e.g., the name of the table or a long text fragment within the table), use the Merge tool of ONLYOFFICE Spreadsheet Editor.

Type 1. Merge and Align Center

  1. Click on the cell at the beginning of the needed range, hold the left mouse button, and drag until you select the cell range you need.

    select cell range

  2. Go to the Home tab and click on the Merge and center icon merge and center icon.

    merge and center - result

Type 2. Merge Across

  1. Click on the cell at the beginning of the needed range, hold the left mouse button, and drag until you select the cell range you need.

    select cell range

  2. Go to the Home tab and click on the arrow next to the Merge and center Merge and center icon icon to open a drop-down menu.

    merge and center - menu

  3. Choose the Merge Across option to align the text left and preserve the rows without merging them.

    merge across

Type 3. Merge Cells

  1. Click on the cell at the beginning of the needed range, hold the left mouse button, and drag until you select the cell range you need.

    select cell range

  2. Go to the Home tab and click on the arrow next to the Merge and center Merge and center icon icon to open a drop-down menu.

    merge and center - menu

  3. Choose the Merge Cells option to preserve the preset alignment.

Unmerge Cells

  1. Click on the merged area.

    merged area

  2. Go to the Home tab and click on the arrow next to the Merge and center Merge and center icon icon to open a drop-down menu.

    unmerge

  3. Choose the Unmerge Cells option to bring the cells back to their original state.
How to create a new document?
Close
Try now for free Try and make your decision No need to install anything
to see all the features in action
You Might Also Like This:
Close