Dear audience, here is just a quick tip on how to easily paste values without much effort. By the way this works in versions 2003 and 2007 of MSXL.
Usually you copy your desired area and then, if you want to paste it select right-click - paste special - values. Alternatively you could use the edit menu in MSXL 2003 or the lower half of the paste button in MSXL 2007. Here is a quick workaround which could be used in both environments (also with pasting over the existing content quick and easy):
- Select the area / range you would like to copy and press
CTRL+Con your keyboard or the copy icon in the toolbar (thanks to Jon Peltier - see comments) - Right-click any of the borders and drag it to the desired location with the right mouse-button still pressed.
- A context menu with several options will appear (see screenshot below). For our purposes here / our example click the
Copy here as values onlyoption. With this approach you also can "overwrite" the original formula and / or calculation.
What ideas would you suggest for this quick and easy method? Is this helpful for you? Please fell free to leave a comment below.
Discuss this blog post in the forums (click the blue button)
Comments
RSS feed for comments to this post.