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.

Qualifying Prospects – Asking the Right Questions

Finally, you can ask, “From 1 to 10, what is your commitment level to move forward? Real prospects acknowledge obstacles and discuss how to overcome them. They also ask engagement specific questions about how to manage the project.

Impact Counts

When you combine the power of qualifying questions with your CRM’s ability to segment based on prospect ranking, personalize, and automate outreach, the results are more sales and shorter sales cycles.

Let your CRM free you up for your priority prospects and you will close more sales.

Let’s Meet and Finalize Your Qualifying Questions!

FREE ebook:
Build More Revenue with Less Follow Up Fatigue

Recent Blogs

Qualifying Prospects – Asking the Right Questions

Mar 18, 2026

What are the best questions to ask when qualifying prospects? How can you phrase questions so you don’t sound aggressive and offensive? Qualifying Prospects Many of us chase prospects thinking they are likely to buy. Often, we are disappointed when they don’t....

Do Marketing and Sales Agree – Ask Your Sales Funnel

Mar 4, 2026

How do you know when marketing and sales are not aligned? Ask your sales funnel. A sales funnel shows whether marketing and sales are aligned by: Revealing lead types. Showing lead movement across funnel stages. Identifying where leads consistently stall. The funnel...

5 Questions To Ask About CRMs

Feb 18, 2026

CRMs come in all sizes and shapes which can be confusing. As a business owner or VP of Sales, the right CRM will have significant impacts on your sales pipeline. What is a CRM? How do I know if I need one? What should I know before getting one? CRMs –...