Is there a way to "lock" columns, rows and borders so new data
Hi Julie, I tried this with a slightly different out come. i need to lock the
formats and i tried all what u suggested with one minor difference. i need to be able to sort the selected cells, and not have the formats move. which they are moving and its driving me batty. any suggestions? Gregg "JulieD" wrote: Hi what version of excel are you using ... i've just tested it here ... if you choose the cells that you want them to enter data in & "unlock" them and then choose tools/protection /protect sheet and only have select locked cells & select unlock cells ticked then they shouldn't be able to change the formatting of the sheet. (or even of the "unlocked" cells) Cheers JulieD "glaserk" wrote in message ... thanks... but I'm stupid. I need to know how to lock the columns, rows and borders without locking the whole sheet. I tried to allow users to select unlocked cell and format cells, but then nothing could be changed. "Frank Kabel" wrote: Hi have a look at 'Tools - Protection -- Regards Frank Kabel Frankfurt, Germany "glaserk" schrieb im Newsbeitrag ... Help! I don't want to have reformat each time. I have several pages that should look exactly the same, and I want to just fill in the blanks once the format is set up. Is there a way to lock the formats? |
All times are GMT +1. The time now is 12:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com