On Nov 29, 4:21 pm, seshuramakrishna
wrote:
i have a list of data in that there a number of blank cells.My problem was
those blank cells is fill with above cell data automatically
plz any body help me


--
seshu

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm....mspx?mid=e33c...

Hi,
Select all the data containing the blank cells. Now press Ctrl+G and
then Press "Special" on the left bottom. Select "Blanks" from the list
of available options. Now all the blank cells with be selected. Now
check for the Active cell in the "Name Box". (Name Box is the box
which contains the address of active cell. It is just above the
uppermost left corner of the worksheet i.e., column A). Supposing the
active cell is A5, enter A4 and then Press Ctrl+enter. All blank cells
will be filled with value from upper cells.

Regards
CA Kanwaljit Singh Dhunna
India