Tutorial: Using Excel’s Paste Special Shortcuts to Quickly Share Data Across Documents

Two weeks ago, we showed you how to use Excel’s Paste Special to copy complex items within an Excel spreadsheet. This gives you the control to paste and format data in different ways. If you missed this tutorial, click here to read it.

Efficiency and productivity are very important for any organization. Knowing shortcuts for frequently used programs saves time. We would like to share shortcuts for Paste Special to help you increase your productivity time.

After you open the Paste Special dialog box, you can press the underlined letter for the option that you want. Believe it or not, knowing the letter and pressing it verses using your mouse can shave a few seconds off of each action.

All Paste all cell contents and formatting. Press A
Formulas Paste only the formulas as entered in the formula bar. Press F
Values Paste only the values (not the formulas). Press V
Formats Paste only the copied formatting. Press T
Comments Paste only comments attached to the cell. Press C
Validation Paste only the data validation settings from copied cells. Press N
All using Source theme Paste all cell contents and formatting from copied cells. Press H
All except borders Paste all cell contents without borders. Press X
Column widths Paste only column widths from copied cells. Press W
Formulas and number formats Paste only formulas and number formats from copied cells. Press R
Values and number formats Paste only the values (not formulas) and number formats from copied cells. Press U

 

If you have a question about Excel or would like us to cover a how-to topic, please contact us.

Contact us for a FREE X2CRM Demo

Learn how X2CRM can help you sell more with less effort

FREE ebook:
Build More Revenue with Less Follow Up Fatigue

Recent Blogs

7 things to look for in CRM software for small business

7 things to look for in CRM software for small business

Shopping for CRM software can be like shopping for a vehicle. When you look for a vehicle, you need to decide if you are looking for a sedan, SUV, or truck. Do you need all-wheel drive or front-wheel drive? Do you need extra safety features like lane-change indicators...

How to Introduce a New Product to your Customers with your CRM

How to Introduce a New Product to your Customers with your CRM

In our last blog, we shared the story of Gerald Manes who owns a security system installation company called GMInstalls. From the time he implemented his company’s CRM, the quality of leads increased and the cycle to close a sale shortened. Gerald was happy and began...

Marketing and Sales Pain Points and How to Overcome them

Marketing and Sales Pain Points and How to Overcome them

Gerald Manes, known as GM, owns a security system installation company and employs 5 salespeople, 10 technicians, and 2 administrators. GM also oversees marketing and sales. Over 2 years ago, he decided to implement a CRM (customer relationship software). He was...

Request an X2CRM Demo