Possible to lock formatting only (still allowing data to be altered)?
I often am able to set up my excel tables in advance - Borders, bold or italic cells, etc. and then later when the data is available I often am copying and pasting values from other worksheets and formulas from with in my own sheet. Unfortunately when pasting I lose my formatting.
Is it possible to lock-in the formatting at some point before I begin putting in data? It would save me a huge amount of time.
I want to Lock the formatting on an excel sheet so when I sort the data in the sheet the background colors and cell formatting stay in place, and just the data shifts.
I would like to lock a set of rows and columns, but still allow the users to use the grouping I have set on various spreadsheets. Is this possible? If so, how to make it work, current if I lock any positron of the page, then try to use the grouping buttons. they tell me the data is locked and
I am trying to format my worksheet so that additional lines/columns cannot be added and cells cannot be merged. This is a sheet that is being distributed to other users for them to add relevant information. I need to be able to lock the formatting but NOT the editing.
I am making a large spreadsheet that others will use and they will have to paste large amounts of data onto the spreadsheet. The issue is that when they paste their data the conditional format that I set up for them is removed. Is there a way to lock the format in place and let them paste still? I would be happy with protecting the sheet and allowing paste to still be an option.
Related Applications & Scripts
Instantly Lock And Unlock EXE Program Files The EXE Vault is a handy software program that lets you 'lock' exe files (including setup files) so they can't be opened. The Vault is very easy to use. Simply open the file, click the option and hit 'Do It'. Last 5 actions are shown in a easy to follow list at the bottom. Simple yet very efficient.
Make your site go viral by requiring your users to Facebook Like, Google+1 or Tweet about your page to reveal premium content. Simply wrap the content you want to protect with the script and your content will be protected until the users shares your page. Viral-Lock is the first of its kind to combine Facebook, Google+ and Twitter to give maximal viral impact. More likes and tweets = More money for you.
Based on our Viral Lock plugin for WordPress the PHP version enables you to integrate the power of Viral Lock into anything. Anything you can put in a PHP file can be protected!
My ASP Page Lock is the easiest, fastest and cheapest way to restrict access to any page in your site.
Completely idiot proof, you should have no trouble installing and using it within a matter of minutes.
M.A.P.L is written in ASP/VBscript using Macromedia Ultradev, it is 100% customisable and extendible. Easy straight forward setup just one line of code per page! Even a complete novice can use it.
Just upload 'My ASP Page Lock' onto your webserver and you're ready to go! No ASP knowledge is required.
Save your PDF form to disk and open it again without loosing your entries.
Who has not come across the situation: You complete a PDF form in Acrobat Reader and when it comes to saving your data, nothing happens. Or worse: You close the program and all your data is lost. The reason for this is: Acrobat Reader cannot save any form field data! This is not only time consuming but also very unpleasant.
pdf-FormServer eliminates this problem in a very easy way! Once this software solution has been installed, all filled out PDF forms can be saved locally either as FDF, XFDF (for further electronic processing) or directly to PDF. No need to mention that all forms that have been filled once can be read again with the included data and also altered at a later date or send by email.