![]() If you ever find yourself needing to copy to very large ranges using a macro, you can do so using a single command. Press F5 to display the Go To dialog box.The range is selected.Įasy, huh? A similar approach to selecting large ranges could also be used with the Go To box, in this manner: (Before you click, the Name box contains "A3," which is the cell you just copied.) Click once in the Name box, above column A. ![]() Press Ctrl+C to copy its contents to the Clipboard.The easiest way to do the copy is to follow these steps: Let's say that you have a value in cell A3 and you want to copy it to a large range, such as C3:C55000. There are much easier ways to select large ranges, and these selection methods can be used to easily copy values to those large ranges. ![]() Using the mouse to select large ranges of cells is cumbersome, at best. He knows how to use the mouse to scroll in order to select the target range, but if he's copying to thousands (or tens of thousands) of cells, it takes an awfully long time to scroll through screen after screen. Chris wonders if there is a fast way to copy a cell to a very large range. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |