Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy rows down
hey all,
i have a single column of rows id,type 1,phone 2, 3, 4,email 5, 6, is there an easy way to fill in the blanks with the previous non-blank type? like this? 1,phone 2,phone 3,phone 4,email 5,email 6,email thanks, rodchar |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy rows down
Select the column.
F5SpecialBlanksOK In active blank cell type an = sign the point or arrow to cell above/ CTRL + ENTER to fill in. Copy/paste special(in place)valuesokesc. Gord Dibben MS Excel MVP On Fri, 9 Jan 2009 11:05:09 -0800, rodchar wrote: hey all, i have a single column of rows id,type 1,phone 2, 3, 4,email 5, 6, is there an easy way to fill in the blanks with the previous non-blank type? like this? 1,phone 2,phone 3,phone 4,email 5,email 6,email thanks, rodchar |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy rows down
Sean read my mind on this one on an earlier reply:
The only fix I can give you is to unmerge the rows. Then, just enter the person's name in each of the rows. That would fix it. Suggestion would be to highlight the column and uncheck merge cells. Then, in the first blank row, enter = and reference the cell just above. Copy this formula and do Edit - Go to - Special - Blanks and paste. Copy the column again and paste-special values to get rid of the formulas... Thanks, rod. "rodchar" wrote: hey all, i have a single column of rows id,type 1,phone 2, 3, 4,email 5, 6, is there an easy way to fill in the blanks with the previous non-blank type? like this? 1,phone 2,phone 3,phone 4,email 5,email 6,email thanks, rodchar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I Copy and Paste onto Same Rows after filtering out rows. | Excel Discussion (Misc queries) | |||
Copy rows from one worksheet automatically, ignore rows that are b | Excel Worksheet Functions | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
Copy only new rows | Excel Discussion (Misc queries) | |||
Hide Rows - copy and paste only rows that show | Excel Worksheet Functions |