When SecureSheet is live, administrators may have minor adjustments to make to merged cells – needing to merge or unmerge. Administrators may use the Merge Cells administrator tool in SecureSheet while the sheet is live, and users are active – instead of exporting and importing for minor updates. If you are planning maintenance on the sheet and will be locking, exporting and importing updates, and the merge cell updates are not urgent, you may want to consider holding to make them in Excel during the maintenance period.


Video:  Merge and Unmerge Cells

Merging and UnMerging Cells

  1. Login to SecureSheet.
  2. Select the SecureSheet from your home page.
  3. Go to the appropriate sheet in your SecureSheet where you want to adjust column widths.
  4. Select Administration from the View drop-down.

  1. Select Merge Cells from the Format drop-down.

  1. The Merge Cell options will appear.
    1. Enter the Starting Cell you want to merge or unmerge. 

NOTE:  If you are unmerging cells, skip to Step D.

    1. Enter How many columns across? you want to merge.
    2. Enter How many rows down? you want to merge (if applicable).
    3. Click Merge/UnMerge Cells then click Close to return to the Administration view.


Notes about Merging and UnMerging Cells

  • Updates to merged cells (merging or unmerging) are applicable across all views in SecureSheet.
  • If you merge/unmerge cells online in SecureSheet, Export Values/Formulas/Formats to get the most recent Excel version.
    • If you don’t export to start with the most recent Excel version when you intend to update off-line, you will overwrite changes that were made online in SecureSheet. Always export first to get the most recent Excel version.
  • If you export and make column width adjustments off-line in Excel, select the Merged Cells option when you are importing, and be cautious not to select the formulas and values options on the import so you do not overwrite updates made by your users.