<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/platform.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar/25388941?origin\x3dhttps://wildthoughtsfaq.blogspot.com', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>
MWave 468x60

Lakaw is a journey is a step is a move. I love to travel around the world and this is my travel and travel gadget site. Welcome and Enjoy!

A better way to copy and paste large blocks of data in Excel

0 comments | Friday, February 22, 2008

This is a tip for those using Microsoft excel all the time. There is a better way to copy and paste large blocks of data in Excel without the usual dragging from corner to corner just to highlight the data bulk.

Suppose you want to copy a horizontal block of data to several (say 2000) rows down.

First, select the blocks you need to copy - mouse-dragging should not be too difficult for this step. Next, click on a corner cell of the block to be copied to. The address of this cell should appear in the northwest corner of the spreadsheet (see image below).
Next, edit the value in that edit box to include the range.
After hitting enter, the large block of cells should be marked. Now, select [PASTE] from the [Edit] menu and the formulas should be pasted to all chosen cells.

That the Excel Tip for the day. Via.

Labels:

posted by talk

at 2/22/2008 09:16:00 PM Permalink

0 Comments:

<< Home

More Interesting Stories

Related Posts with Thumbnails