LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default copy without altering the value

Hi,

Select the 5 by 5 range and choose copy, move to the target cells and choose
Edit, Paste Special, Paste Link (the button at the bottom left of the dialog
box).


--
Thanks,
Shane Devenshire


"freebee" wrote:

Hi,
After I copied 5 rows+5 columns from the top to bottom of the same worksheet
(since it's very long), the cell value at the bottom were all different from
the top. How do I keep them the same?
Thank you.



 
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
Please help me with altering text in excel Mark New Users to Excel 5 November 16th 06 04:33 AM
Altering the X-axis Maguire Charts and Charting in Excel 2 May 14th 06 07:45 PM
Altering VLookup Formula addie Excel Worksheet Functions 1 February 16th 06 01:04 AM
Values won't display after altering a formula. Mike O Excel Worksheet Functions 1 March 13th 05 11:21 PM
Formula keeps altering by itself! Julie P. Excel Worksheet Functions 3 February 2nd 05 10:20 AM


All times are GMT +1. The time now is 10:45 PM.

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

About Us

"It's about Microsoft Excel"