Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Preventing formulas being pasted over while editing
I am a semi experienced excel user however I find when entering data for
monthly reports, I seem to be deleting formulas when editing data and therefore my spreadsheets don't calculate correctly. I have heard there is a button that I can turn on and off when editing worksheets that will protect my formulas. Where is that device and or how do I enter data so that I won't lose my formulas? Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Preventing formulas being pasted over while editing
Presume you're talking about accidental overwrite of formula cells with
manual inputs ? (A cell can only hold either a value or a formula at any one time) To minimize accidental overwrites of formula cells, we can apply sheet protection with data cells unlocked to allow inputs Try this: Select* the data input cells, say, select B2:B10 Click Format Cells Protection tab Uncheck "Locked" OK Then click Tools Protection Protect Sheet Enter password (optional) OK *We can multi-select data cells by holding down the CTRL key while selecting, and unlock all at one go -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "pollyanna" wrote in message ... I am a semi experienced excel user however I find when entering data for monthly reports, I seem to be deleting formulas when editing data and therefore my spreadsheets don't calculate correctly. I have heard there is a button that I can turn on and off when editing worksheets that will protect my formulas. Where is that device and or how do I enter data so that I won't lose my formulas? Thanks |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Preventing formulas being pasted over while editing
In addition to turning on protection and for use when you have it
turned off you could also color code input cells and calculated cells. Color Coding Cells for Usage (#colorcoding) http://www.mvps.org/dmcritchie/excel...tm#colorcoding Basically my suggestion is: white or pale color background for input areas formula results with another text and/or background color Conditional Formatting may add additional color to your mix. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Max" wrote in message ... Presume you're talking about accidental overwrite of formula cells with manual inputs ? (A cell can only hold either a value or a formula at any one time) To minimize accidental overwrites of formula cells, we can apply sheet protection with data cells unlocked to allow inputs Try this: Select* the data input cells, say, select B2:B10 Click Format Cells Protection tab Uncheck "Locked" OK Then click Tools Protection Protect Sheet Enter password (optional) OK *We can multi-select data cells by holding down the CTRL key while selecting, and unlock all at one go -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "pollyanna" wrote in message ... I am a semi experienced excel user however I find when entering data for monthly reports, I seem to be deleting formulas when editing data and therefore my spreadsheets don't calculate correctly. I have heard there is a button that I can turn on and off when editing worksheets that will protect my formulas. Where is that device and or how do I enter data so that I won't lose my formulas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
scalable headings in Microsoft Excel when editing long formulas | Excel Discussion (Misc queries) | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Delete the formulas of webpage, copied & pasted on excel sheet | Excel Discussion (Misc queries) | |||
displaying borders when editing the formulas | Setting up and Configuration of Excel | |||
Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) |