| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is Paste Formulas option is acting like Paste All option?
I'm not sure if I'm doing something differently now, but I swore this used to
work. 1) Select cells with formulas 2) Copy 3) Select cells where I want these formulas 4) Paste Special - Formulas Befo Formulas are now in the new cells. Now: Formulas and Data overwrites the new cells. Has anyone seen this or can anyone explain what I'm doing wrong? Thanks, jlk |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why is Paste Formulas option is acting like Paste All option?
Hi,
I am not sure if I misunderstood something but, if you hit ENTER after the paste special comand, excel overwrith all information, fomarts, etc... hth regards from Brazil Marcelo "GoHokiesJLK" escreveu: I'm not sure if I'm doing something differently now, but I swore this used to work. 1) Select cells with formulas 2) Copy 3) Select cells where I want these formulas 4) Paste Special - Formulas Befo Formulas are now in the new cells. Now: Formulas and Data overwrites the new cells. Has anyone seen this or can anyone explain what I'm doing wrong? Thanks, jlk |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why is Paste Formulas option is acting like Paste All option?
I appreciate the response, but I'm not pressing the Enter Key - I am clicking
the OK button... jlk "Marcelo" wrote: Hi, I am not sure if I misunderstood something but, if you hit ENTER after the paste special comand, excel overwrith all information, fomarts, etc... hth regards from Brazil Marcelo "GoHokiesJLK" escreveu: I'm not sure if I'm doing something differently now, but I swore this used to work. 1) Select cells with formulas 2) Copy 3) Select cells where I want these formulas 4) Paste Special - Formulas Befo Formulas are now in the new cells. Now: Formulas and Data overwrites the new cells. Has anyone seen this or can anyone explain what I'm doing wrong? Thanks, jlk |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy & Paste Visible Cells with Formulas | Excel Worksheet Functions | |||
| excel - numbers as text | New Users to Excel | |||
| copy and paste formulas | Excel Worksheet Functions | |||
| Cut and Paste into spreadsheet with locked formulas | Excel Worksheet Functions | |||
| How to cut and paste with locked formulas | Excel Discussion (Misc queries) | |||
Linear Mode
