| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy row below
Worked great!
Thank you! "Peo Sjoblom" wrote: Select the whole range, press F5, click special and select blanks type an equal sign and hit the down arrow, then press ctrl + enter It might take a while if it is large, also before you do this make a copy of the workbook in case you are doing it incorrectly -- Regards, Peo Sjoblom "Cathy Landry" wrote in message ... hello, I need to copy the row below thus making a duplicate row of data. "Peo Sjoblom" wrote: If you delete the blank row (using editdelete) the next row below will take it's place -- Regards, Peo Sjoblom "Cathy Landry" wrote in message ... Hello, I have a huge spreadsheet that I've inserted a blank row in between my data, now I need to copy the entire row below into the blank row above it. Any suggestions? Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
| copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
Threaded Mode
