Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Lines or Copying lines with formulas but without data
Is there any way to insert or copy lines that contain formulas but I don't
want to copy all the field contents; just the formulas??? So when I insert or copy a line, the only contents that are put in the new line are the "=" formulas. Any help or guidance in this is appreciated. Thanks! wnfisba |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Lines or Copying lines with formulas but without data
Edit-Paste Special-select formula
"wnfisba" wrote: Is there any way to insert or copy lines that contain formulas but I don't want to copy all the field contents; just the formulas??? So when I insert or copy a line, the only contents that are put in the new line are the "=" formulas. Any help or guidance in this is appreciated. Thanks! wnfisba |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Lines or Copying lines with formulas but without data
In situations such as that, I find it useful to create a blank row (or column, as the case may be) that has the formulas, but no data. Then every time I add a new row I copy from that one. -- Montrose77 ------------------------------------------------------------------------ Montrose77's Profile: http://www.excelforum.com/member.php...o&userid=18191 View this thread: http://www.excelforum.com/showthread...hreadid=573072 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Excel formulas between sheets | Excel Worksheet Functions | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |