Can I allow cell merging in a protected sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to setup a protected spreadsheet but want users to be able to
merge certain cells. When I turn the protection on I am not able to use the
merge function on cells that have not been locked, is their any way round
this?
 
Format > Cells> Protection, remove tick in the mark in the "Lock Cell
indicator"only for the cells that you want the users to merge, so by
using your Ctrl+mouse click, on the cells that you want users to merge,
untick or remove the tick for these specific cells, and the protect your
workbook


T
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect sheet but be able to merge cells 1
Merging cells in a Protected Sheet 2
How can I merge unprotected cells in a protected worksheet? 1
allow merging cells in protected sheet 1
Merged cells withing Protected Sheets 3
Windows 7 Autofit row heights of merged cells in protected worksheet 0
Protected Sheets 2
How to subtract a number from a Mergefield? 0

Back
Top