You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

How do I lock ONLY the formatting on an excel sheet?

How do I lock ONLY the formatting on an excel sheet?

Price: FREE

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.

Visit publisher's web-site: How do I lock ONLY the formatting on an excel sheet?

Category and Tags: ExcelTutorials :

Related Tutorials

Possible to lock formatting only (still allowing data to be altered)?

Free: Yes
Tags: Excel ›

Is it possible to lock a sheet so that data can still be altered but the formating cannot be changed?
I have a simple sheet with some borders and alternating grey & white rows for easier reading when the sheet is printed. There will be another user editing this sheet and I want it to be easy for him so he doesn't have to worry about copying and pasting any formating.
Basically, I want him to be able to edit the sheet without having to think about the formating.

Is it possible to lock-in or freeze formatting?

Free: Yes
Tags: Excel › Functions

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.

How do I lock the formatting of my worksheet but still add text?

Free: Yes
Tags: Excel › Functions

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.

Conditional Formatting to Lock Cells

Free: Yes
Tags: Excel › Functions

Is there a way to lock the adjacent cells in a row, if "contractor" is entered into the cell?

"Lock" screen while switching between sheets

Free: Yes
Tags: Excel › VBA

my first post. I Searched but was unsuccessful.
I have a macro (Excel) which copies and transposes data from an entry sheet to a calculation sheet. During macro execution, the screen flashes between the two sheets. Seizures aside from the flashing screen, it is annoying. There is also a formatting loop that takes a bit of time and I do not want the spreadsheet user to think something is wrong and interrupt the macro.
So, how do I "freeze/lock" the screen or monitor display during execution, and maybe even show the hourglass (or similar), while the code is running?

Related Applications & Scripts

EXE Vault: Lock and Unlock Applications

Free: No
Tags: Software › Excel Security

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.

Viral Lock PHP - Facebook Like, Google+1 or Tweet to Unlock

Free: No

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

Free: No
Tags: ASP › Excel User Authentication

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.

Animated tooltip with HTML formatting

Free: No
Tags: Flash › Excel ToolTips

A very nice and easy way of giving your visitors a quick explanation of a button. It has an alpha animation (which you can also turn off). You can also apply html formatting like bold text.

Swf Lock It!

Free: No
Tags: Flash › Excel Miscellaneous

This a simple way to protect your files. Simple, but very useful. For example: You did a job for your client...he got the files and everything is right, except the fact that he doesn't pay you. With this file, you can make your files expire in any date.
So, if your client doesn't pay you, in some days he could get a nice surprise! You can customize everything. This is a simple file and all instructions are included.

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing