Autofilter on a protected sheet

  • Thread starter Thread starter JFL
  • Start date Start date
J

JFL

Hi everybody,

I have a question regarding auto filter usage. I have a sheet/table
which has a table calculating certain values regarding certain other
values manually typed in by third persons.

In order to protect the formulas I have locked the cells but now I
would like to filter out all the rows which are blank in this table in
order to keep just the rows which in the print version are important
to be displayed.

Is that possible, or since the cells are locker nothing can be
filtered?

Best regards,

Jan
 
You must log in or register to reply here.

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

Using Autofilter on a Protected Sheet 18
autofilter results based on cell input 5
Excel 2013: AutoFilter and SUM() 1
Sort-function of AutoFilter doesn't work, when sheet is protected 4
Autofilter with Locked/Protected worksheets 1
VBA: How can I use a string variable as autofilter criteria? 4
Remove Filters from all sheets 10
problems with autofilter and checkboxes 11

Back
Top