Drag formula - ignore blank cells


P

Paul

Dragging Formula

Can I drag a formula down and have it ignore any blank cells.

I have a sheet (2000+ rows) which are subtotal by name and then total
for costs.

When viewing the sub-totals I want to add a new formula to the right
then drag this ignoring the blank hidden rows.

Hope this makes sense
 
Ad

Advertisements

S

Sheeloo

Copy the formula
Select the range to copy
Press F5
Click SPECIAL
Choose 'Visible cells only' to omit hidden cells
Press CTRL-V
 

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

How To Have A Cell Be Blank If... 2
"Blank" cells showing unwanted data 4
Excel Drag autofill only part of formula 3
Fill down visible cells only 4
Odd Formula copying Behavior 3
Auto Fill formula when inserting a new line 4
dragging a formula in a filtered table 1
Not able to drag formula to successive cells 2

Top