|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Mar 7th, 2002, 09:04 AM
|
#1 |
|
Guest
Posts: n/a
|
Hello
I am wondering if I have a data with the following format Data 12 23 45 67 I need to fill in the space with the number above, is there an easy way to do that? Please help Thank you |
|
|
Mar 7th, 2002, 09:20 AM
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Austin, Texas USA
Posts: 11,654
|
Select your column of values. Choose the Edit | Go To... | Special Blanks menu command. Type a reference to the unselected cell above the active cell (i.e., if your first data value is in cell A1, the you'd be entering =A1 into the active cell, A2). Press Control+Enter which will place the entered formula in each selected, empty cell. Select your column of values once more and perform Copy/Paste Special Values.
|
|
|
|
Mar 7th, 2002, 09:28 AM
|
#3 |
|
Guest
Posts: n/a
|
This is easy but I hope that I can give you the correct steps as I have the menu in hebrew:
Choose the cells that in column containing data and blanks Edit Move to Special Blanks now enter in the active cell formula "=A1" Ctrl+Enter This will fill all blanks with the data above them Eli |
|
|
|
Mar 7th, 2002, 09:34 AM
|
#4 |
|
Guest
Posts: n/a
|
Thanks Mark
it works the way i need it One more question, is there a way to make those duplicated cells blank? eg. makes the number in white text please help Thanks again |
|
|
|
Mar 7th, 2002, 09:37 AM
|
#5 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: Austin, Texas USA
Posts: 11,654
|
Quote:
=A2=A1 Before applying this condition select column A and tab to cell A2 to make it the active cell. |
|
|
|
|
|
Mar 7th, 2002, 09:42 AM
|
#6 |
|
Guest
Posts: n/a
|
That is so cool
Thanks alot Mark |
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
