[excel] lock the layout? Solved

Question

Hello,

I would like to know if it is possible to lock the borders configured on the cells in Excel but not the content?
That is to say, a table with a layout and well-defined borders in which you just paste information without modifying the presentation.

Having found nothing on the forum, I hope you can help me!!

Thank you!

Ju

G.David · Accepted Answer

cell
tab protection
uncheck the lock box ( this will apply to all selected cells ) for your input areas
OK
tools
protection
protect the sheet
you can set a password that is case sensitive ( a<>A )
Sincerely
G.David
--
respect is not a given
it is earned

Furtif · Answer

Hello

Another method:

Data / Validation ....

You can select for each cell or groups the type of data that is allowed to be entered.

It's a very selective filter ..... worth trying.
--
** @+ / Stealth **
** Certified non-smoker ..... no, really not tempted! **

co and co · Answer

Hello I would like to protect the formatting of a document I can protect cells, but when I copy and paste, the formatting is reproduced. Is there a method? Thank you.

invité · Answer

When you copy, then use "Paste Special" and uncheck "Format".

G.David · Answer

Which version of Excel are you using?
If it's 2003, when you protect your document, it prevents the selection of locked cells (this is done by not allowing it mmmfff!!)
--
Respect is not a given; it is earned.
Sincerely, G. David

fanvio · Answer

Hello, sorry to revive this forum, but I have a problem of the same kind.

At work, we use an Excel spreadsheet for medication processing sheets. I'm looking for a way to lock the layouts without preventing users from typing text in the cells.
Actually, the table fits perfectly on one page, which is very convenient for us, but sometimes when modifying a treatment, the doctor deletes a row, which reduces the size, or adds rows, so it ends up on two pages, or even deletes part of the table layout and the sheet looks like a mess.
I would like them to be able to delete content (if a treatment is finished), or add content, but without changing the rows.
(For now, I go back after them on my personal time, and update the sheet myself, but with 80 treatment sheets and an average of 30 treatment changes per week, I have better things to do.)
If it helps, I am working with Office 2010 on a Windows XP PC.

I hope someone can help me
Have a good day, everyone.

encorecinqminutes... · Answer

D.I.Y.: "sacrifice" a column or a row by reducing it to 0.2cm and coloring it black, for example (right-click -> format cell), and only work in the cells in between. (Of course, this won't work if you need a more complex layout than a simple grid.)

[excel] lock the layout?

7 réponses

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

My tv turns off and then on again repeatedly?

Executable from a python file

Pay in 4 installments cdiscount

The alt gr key is not working on my keyboard.

Code 80072efe how to get windows update working again

Video in ".3gp" format