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.

TOFU, MOFU, and BOFU Magnets

When you stack magnets, their power is exponential.

 

Stacking Magnets

 

Think about your best clients and what actions they took when first buying from you. Build magnets based on these actions. Here are examples of how to stack magnets:

 

Fractional CFO Service Company

 

  • TOFU – Cash-Flow Forecast Template for Founders.
  • MOFU – 3-part email class on “Scaling from 500K to 5M using videos.
  • BOFU – Free 30-minute “Financial Check” with a 90-day pilot option. 

 

. Residential HVAC / Plumbing Contractor

 

  • TOFU – Seasonal Maintenance Checklist to Avoid Breakdowns 
  • MOFU – Educational videos on “What To Check Before Calling For Help. 
  • BOFU – Free home system inspection plus a discount on annual plans. 

 

Specialty Retailer or E-Commerce Shop

 

    • TOFU – “Find Your Perfect Product Style” quiz with personalized recommendations and a small first-order discount. 
    • MOFU How-To Guides, Lookbooks, and Comparisons
  • BOFU – Limited-time starter kit, cart-abandonment coupons, and free shipping.

This “magnet stack” approach—clear value at each stage, linked to your core offer—will pull the right prospects from curiosity to commitment.

 

Getting it Done

 

Apex Advisory Group, a professional services firm, had four sales reps plus the owner selling and servicing clients, but deals were inconsistent and follow-up was ad-hoc.

 

Apex engaged CCC, www.cccsolutions.com, to help build their sustainable sales pipeline. The team focused on the ideal client’s journey, selected magnets, and created a sales process to manage prospects. The magnets were:

 

    • TOFU – Risk and Readiness Checklist.
  • MOFU – Quarterly Webinars and Case Studies
  • BOFU – Business Circle Invitation

 

CCC set up X2CRM to segment, track, and reach prospects and remind salespeople to follow up. At every stage, the CRM captured new information and responded based on specific prospect actions.

 

Apex Today

 

Apex now has a repeatable sales engine: Their magnets consistently attract new prospects, X2CRM nurtures and scores them, and the sales team focuses its energy on the best opportunities.

 

With CCC Solutions guiding strategy and configuration, Apex built a sustainable, measurable pipeline that increased sales while reducing the chaos of manual follow-up.

 

FREE ebook:
Build More Revenue with Less Follow Up Fatigue

Recent Blogs

Use Lead Magnets to Build Your Sales Engine

Use Lead Magnets to Build Your Sales Engine

Lead magnets are valuable offers that attract the right people, capture their contact information, and lead them to purchase. Concurrently, you get to see who the real prospects are!   Core Magnet Principles   Strong magnets:   Offer specific value...

Get a CRM – Are You Nuts

Get a CRM – Are You Nuts

For professional service companies like Edemco, a team of six, including three sales reps, the decision to implement a CRM wasn’t taken lightly, said Edith Demona, Edemco’s owner.  Edemco’s team felt growing pains as it managed client service, marketing, and sales. ...

Your Personal Touch Sells

Your Personal Touch Sells

Your personal touch is the reason buyers buy from you. As a seller of goods or services, connecting personally with your buyer builds the relationship needed to increase sales conversions.   Personal Touch Obstacles   Hurdles that reduce personalized...