Forum Discussion
Excel Range of Updating Cells From 1 Sheet to Another Sheet
Another couple of options
Ctrl+Alt+V (which pops up Paste Special window) and her character associated with menu item. In this case Ctrl+Alt+V+L
Ctrl+V, Ctrl (Paste Special icons will appear), arrow Down, Down, Down, Right, Enter
Select the entire source range.
Copy it by clicking the Copy button on the Home tab of the ribbon or by pressing Ctrl+C.
Activate the target sheet, and select the top left cell of the target range.
Click the lower half of the Paste button on the Home tab of the ribbon.
Click 'Paste Link'.
Excel will paste a link formula for each of the cells in the source range.
By chance are you aware if there is a hotkey that would allow me to paste with the paste link option vs having to click paste the the option?
IE As you listed above there was the option to use Ctl C for the copy & traditionally the paste option has Ctl V. Is there a hotkey to paste the links vs using the mouse?
Either way still nice & thank you so much
Another couple of options
Ctrl+Alt+V (which pops up Paste Special window) and her character associated with menu item. In this case Ctrl+Alt+V+L
Ctrl+V, Ctrl (Paste Special icons will appear), arrow Down, Down, Down, Right, Enter
- Thank you so much. Very helpful
Happen to stumble upon the info as you posted. Nice having all these options 🙏
Excel doesn't have a "short" shortcut for Paste Link, but you can use Alt+H V N
- Thank you so much. This is also helpful & nice to know I am not missing a step
I found one combo that is 1 step shorter (2 vs 3 clicks) being Ctl + Alt + V L
Thank you for all the help. I really appreciate it- I am new to this community
Am I supposed to post when something is resolved & if so how do I do so?
Or do I just leave it open & let time take care of the rest?