Hi All, To copy paste for all the cells. Lets say you have the data in A3 and you want to copy to C3:C44444 cells.Using mouse to select all the cells is little bit difficult.
Now you can do the same with below easy steps. 1. Select B3. 2. Then *Ctrl+C* to copy the data 3. Click once in the Name box, above column A. (Before you click, the Name box contains "B3," which is the cell you just copied.) 4. Type C3:C99999 or, if you prefer, C3:C55000 and press *Enter*. The range is selected. 5. Press *Ctrl+V*. --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
