ProTec Solutions
  • Home
  • About
  • Courses
    • Pastel Accounting Software Courses
    • Bookkeeping Courses
    • Microsoft Excel Courses
  • Prices
  • Why Pastel?
  • Promotions
  • Express Reservations
  • Pro Tips
  • Contact

Converting Formulas to Values with a simple drag and drop in Excel

by ProTec Solutions | Apr 5, 2020 | Excel

Ever used a formula and wanted to keep only the results (or answers) and delete some or all of the data that the formula use to do the calculations with? As soon as you delete any data that the formula refers to it will result in an Error message. With a simple drag...

Categories

  • Excel
  • Pastel

Archives

  • Apr 2020
  • Mar 2020
  • Feb 2020
  • Jan 2020
  • Dec 2019
  • Nov 2019
  • Oct 2019
  • Sep 2019
  • Aug 2019
  • Jul 2019
  • Jun 2019
  • May 2019
  • Apr 2019
  • Mar 2019
  • Feb 2019
  • Jan 2019
  • Dec 2018

Recent Posts

  • Converting Formulas to Values with a simple drag and drop in Excel
  • Using multiple E-mail addresses for Customers in Pastel Partner
  • Entering data or formulas in non-adjacent cells simultaneously in Excel
  • Block Customer / Supplier Assistant in Pastel Partner
  • Renumber Codes in Pastel Partner
  • Facebook
  • Instagram
ProTec Solutions © 2022