Protect Formulas while deleting rows

R

RLD

Is it possible to protect and entire column of formulas in a sheet while
still allowing the DELETION of rows?
 
F

FSt1

hi
your request seems contradictory. if you want to keep a certain column then
you're not accually deleting rows, just the data on both sides of the column.
is that what you want? just delete the data on both sides of the fomula
column?
if so, do this.....
highlight the "rows" that you want to delete. press the F5 key(GoTo)
click the special button. select constrants. click OK.
all of your non-formula data should be highlighted. press the delete key.
VIOLA!!!! ! data gone, formulas still there.

regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect 2
Protect Worksheet to share with older versions of excel 2
sheet and workbook protection 1
hide, unhide column or row after protect worksheet 4
Protect Only Certain Cells 2
protect from deleting rows 2
Delete rows while sheet protected 3
Trace dependants or Precedents on a protected sheet 1

Top