| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying data across lines
hi,
I have a list which has been exported into excel, I need to copy rows down, but there are gaps. i.e Row Heading data west 123 145 675 East 565 698 123 985 South 122 122 145 How do I copy the row headings which in this example are West, East and South? thanks amanda |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying data across lines
- Select column and F5-Special-blanks-OK.
- Press [=] then [up arrow] then ctrl+enter. (so if A3 is the active cell, enter =A2 followed by ctrl enter.) - Select column then copy, editpastes special values to fix values. On 9 Mar, 12:01, Amanda wrote: hi, I have a list which has been exported into excel, I need to copy rows down, but there are gaps. i.e Row Heading data west 123 145 675 East 565 698 123 985 South 122 122 145 How do I copy the row headings which in this example are West, East and South? thanks amanda |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying data across lines
Hi Lori,
This appears to only complete for one cell, rather than copying down the column, is that right? Thanks Amanda "Lori" wrote: - Select column and F5-Special-blanks-OK. - Press [=] then [up arrow] then ctrl+enter. (so if A3 is the active cell, enter =A2 followed by ctrl enter.) - Select column then copy, editpastes special values to fix values. On 9 Mar, 12:01, Amanda wrote: hi, I have a list which has been exported into excel, I need to copy rows down, but there are gaps. i.e Row Heading data west 123 145 675 East 565 698 123 985 South 122 122 145 How do I copy the row headings which in this example are West, East and South? thanks amanda |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying data across lines
Amanda - you need to use the CTRL+ENTER keystroke to enter the formula
into all the blank cells. Otherwise copy the single formula, choose F5- special-blanks and paste. On Mar 9, 1:04 pm, Amanda wrote: Hi Lori, This appears to only complete for one cell, rather than copying down the column, is that right? Thanks Amanda "Lori" wrote: - Select column and F5-Special-blanks-OK. - Press [=] then [up arrow] then ctrl+enter. (so if A3 is the active cell, enter =A2 followed by ctrl enter.) - Select column then copy, editpastes special values to fix values. On 9 Mar, 12:01, Amanda wrote: hi, I have a list which has been exported into excel, I need to copy rows down, but there are gaps. i.e Row Heading data west 123 145 675 East 565 698 123 985 South 122 122 145 How do I copy the row headings which in this example are West, East and South? thanks amanda- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying certain lines from a text file | Excel Discussion (Misc queries) | |||
| add lines of data to spreadsheet | Excel Discussion (Misc queries) | |||
| Inserting Lines or Copying lines with formulas but without data | Excel Discussion (Misc queries) | |||
| Excel, how copy subtotals without copying all lines inbetween? | Excel Discussion (Misc queries) | |||
| Record data on two lines | Excel Discussion (Misc queries) | |||
Hybrid Mode
