how do I autocomplete columns

A

Andrew Hodgson

Excel allows me to autocomplete similar values or formulae below the active
cell by double clicking the bottom right corner of the fill handle. The fill
stops last at the last cell populated in in the column left of the active
column.
How do I do the same thing filling the data to the right of the active cell
stopping the fill at the last entry of data in the row above the active row.
Thanks
Andrew
 

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