To clear visable cells in a subtotal - can it be done?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have created a subtotal for a sheet, is it now possible to delete the
contents of the visble cell (s) in a column, on the visable cells only?

Thanks in advance for any help

Regards Noel
 
Hi
I have created a subtotal for a sheet, is it now possible to delete the
contents of the visble cell (s) in a column, on the visable cells only?

Thanks in advance for any help

Regards Noel
Click to expand...
Try
Select first visible cell in column press control-shift-down arrow to select
the visible cells in that column. Then Edit Menu -Clear-Contents
Paul
 

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

move to another cell within a subtotal report within a macro 1
SUBTOTAL function to average column without blanks 2
sum of visable cells in filtered range 7
Subtotal 3
Subtotal of values in cells containing formula 1
calculating subtotals for sequential blank cells in 1 column 1
How do I subtotal specific / random rows from a spreadsheet? 1
Subtotal Function - add formula to all blank rows 1

Back
Top