Are you trying to fill the empty cells with the value of the cell above it?

If yes:

Select the range
F5|Special|blanks|ok
type =
hit the up arrow key
hit ctrl-enter (to fill all the blank cells with that formula)

Now select all the range
edit|copy
Edit|paste special|values

From your description, it looks like the copy data wasn't needed and you didn't
hit ctrl-enter instead of enter when filling the empty cells.

whatzzup wrote:

Hi Lori, thanks. I tried using the instruction but i ahve failed maybe i
misunderstand the command. I copy data,f5,special,blanks,ok, =, up
arrow,enter, select all data, copy paste special values. I did all that so
maybe i miss a step please can you put me right...thanks a lot

"Lori" wrote:

Maybe this, similar to Dalglish instructions:

Make a copy of the data
Choose F5 Special blanks
press [=] followed by [Up Arrow] then [Enter]
Select all data and copy and paste values
Delete any rows you don't want to show

"whatzzup" wrote:

Good afternoon all, i am struggling to create a spreadsheet looking like this
below, this is an hierarchical dropdown, i know its not simple.

Product Type Desc extra
Clothes
Dress
Pants
Long
Regular
Short
Loose
Skirt
Pleated
Causual
Mini
Party
Sweater
Longsleeves
Black
Short sleeves
Red
Blue
Vegetable
Lettuce
x
y
I would appreciate this very much i have been looking at the Dalglish
template and cant seem to be able to match this.
Very much appreciated....

--

Dave Peterson