The Problem:
In Excel "Cut and Paste" provides multiple options to link to or transfer cell content, but it requires multiple clicks to get what you want.The Solution:
ALT E-S-L is paste as link, if you are using Excel to link to cells (content changes automatically).ALT E-S-B skips blank cells when pasting.
ALT E-S-E transposes rows and columns when pasting.
tl;dr
Use ALT E-S-L to paste links to cells in Excel.
Figure 1: Difficulties working with cells. |
No comments:
Post a Comment