ExcelBanter - auto fill

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - auto fill (https://www.excelbanter.com/excel-discussion-misc-queries/171394-auto-fill.html)

Windy

auto fill

I can't remember how to fill names in a column from the lines above. Can
anyone help?

Bob Umlas, Excel MVP

auto fill

If I undersand what you want to do... select the column, use edit/goto
special, select blanks, then type =, press the up arrow, then ctrl/enter.
HTH

"Windy" wrote:

I can't remember how to fill names in a column from the lines above. Can
anyone help?

All times are GMT +1. The time now is 04:56 PM.