Excel tips: convert formulas to values

Excel Tips: convert formulas to values

A quick and easy way with Mouse to convert formulas to values, rather than using Paste Special… Values:

How?

Position your mouse pointer over the edge of a selected range of cell.

The pointer will change to a four-headed arrow.

With your right mouse button, drag away from then back to its original position.

Now release drag, you can select Copy Here As Values Only from the 6 options

and for single cell: Press {f2}{f9}{enter}

 

 

Exshail

Replies (1)

I knew this already, however I beleive that pasting value only cells are a better way to accomplish this.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
Featured ARTICLESHIP 17 November 2026
Associate/ Article Trainee

M/s. A V C & Co.

New Delhi

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details