LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Paste Special

I am trying to copy a series of cells within the same colum and paste within
that same colum without changing the formula....whenever I paste it changes
the formula to match the cells that I am pasting it in.
For example:
A4=sum(A1:A4)
I want to past this formula into A5 where it still reads (A1:A4)

I know that I am making this harder than it needs to be!
Please help
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste Special - Validation Lori-Wheaten Excel Discussion (Misc queries) 0 July 21st 06 03:18 PM
Paste Special and Linking ajkim001 Excel Discussion (Misc queries) 8 March 14th 06 02:10 PM
Paste Special Problem ajkim001 Excel Discussion (Misc queries) 1 March 10th 06 11:50 PM
strange Paste special pmarques Excel Discussion (Misc queries) 1 February 8th 06 07:18 PM
Paste special treats cells as a picture charlie Excel Discussion (Misc queries) 2 November 17th 05 04:00 PM


All times are GMT +1. The time now is 04:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"