Our Blog

Working with Cells - Excel Shortcuts for Cut-and-Paste

Microsoft Excel provides efficient tools to work with data. To improve its usability it helps to work with shortcuts for commonly used tasks. Shortcuts for the different options of "Copy and Paste" are great timesavers.

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

The LabOMator Designed by Templateism | MyBloggerLab Copyright © 2014

Powered by Blogger.