When Excel pastes cell ranges as links, it also does it over empty cells. The Copy Range as Link tool allows you to select a range of cells, then activate the tool and select a cell in which to paste the results.
- Select a cell range.
- Click in the toolbox to see the dialog box
- Pick a cell in which to paste the results, in this case it will be cell D2.
- If you require to paste with formats, just check the option in the dialog box.
Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment confirmation to [email protected] 31 days after purchase.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft