Using the Autofill, with filtered lists


J

Jo Davis

In Excel 2007, three users are filtering lists of purchased items and adding
spend categories to a blank column based on the results of the filter. We
have a regular problem on one user's machine using the following process- the
list is filtered (using custom filter->contains) to find relevant spend items
and the new category is typed in the top cell of the blank column in the
results. The fill handle is then used to drag and fill the category to all
lines identified by the filter. When the filter is removed, the new category
has been filled in on all lines including the lines which were hidden by the
filter. Is there any way to avoid this and only copy to the cells left
visible by the filter- also is there any reason why this would happen on one
machine and not the others doing the same task?
 
Ad

Advertisements

P

Pete_UK

Don't use the fill handle. Instead, <copy> the single cell, then
highlight the (visible) cells that you want to copy into, then press
<Enter>.

Hope this helps.

Pete
 

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

Top