Ctrl + Enter
--
HTH...

Jim Thomlinson


"stumped-in-excel" wrote:

Excel isn't cooperating - I'm trying to fill in blank cells with the data
above but it's only filling in one box at a time- the one I entered the =A*

Heres the steps I've taken -

Highlited the section of colum A that I need to fill in -

File - Go To - Special - Values - OK

type = uparrow

enter -

Although the column is highlighted only the cell with the =Cell# is filling
in.