Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace values with zeros
I have a large spreadsheet, some areas are for data entry on a monthly basis
the other areas are various text and formulas and blank spaces I want to clear the data entry portion only but its not easy because areas are not next to eachother some formulas and text separate various data entry areas Is there a way to select the whole spreadsheet and replace all the values that were keyed with zeros without affecting the text, formulas or blank areas Thanks in Advance for any help chris |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace values with zeros
Menu EditGotoSpecial and check Constants, and then just hit the delete
key. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "CJ" wrote in message ... I have a large spreadsheet, some areas are for data entry on a monthly basis the other areas are various text and formulas and blank spaces I want to clear the data entry portion only but its not easy because areas are not next to eachother some formulas and text separate various data entry areas Is there a way to select the whole spreadsheet and replace all the values that were keyed with zeros without affecting the text, formulas or blank areas Thanks in Advance for any help chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to automate process of replacing values? | Excel Discussion (Misc queries) | |||
View of x-axis values | Charts and Charting in Excel | |||
How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
How to add equal values and than replace them with their sum? | Excel Worksheet Functions | |||
Leading Zeros in Numeric Values | Excel Worksheet Functions |