Copy paste values like a pro! (Excel+Google Sheets)

Copy and paste values (not formulas) using shortcut keys in Excel or Google Sheets! Learn how spreadsheets professionals do it within seconds and become one of them. Save time now by reading our article.

You tried to copy and paste a cell as text value but you ended up pasting its formula instead? Maybe you want to paste a value without formatting?

Sometimes, we want to copy and paste a value from a cell in Excel or in Google Sheets without formatting. To paste a value only like a pro, read our tutorial below!

You can press these keyboard keys to copy, cut or paste data in Excel, Google Sheets or in any other files.

Copy: Command+C
Cut: Command+X
Paste: Command+V

But if you want to only paste values without formatting or match the destination formatting, you may need extra steps.

In Excel, paste a cell as text value by following one of these 2 techniques: using only shortcut keys or a more traditional way.

Select the cell you want to copy then press Command+C on your keyboard. Usually, in Excel, the cell borders will become animated.

In this example, we are copying the cell B4 which includes a VLOOKUP formula.

After pressing Command+C, select a cell where you want to paste the content of the original cell. Now press the following keys: Command+Control+V. The Paste Special window is now visible: click Values and OK.

In our example, we want to paste the B4 content in D4.

You can see the text value is now appearing in the new cell. Well done!

Select the cell you want to copy then click right and select Copy. In Excel, the cell borders become animated usually.

In this example, we are copying the cell B4 which includes a VLOOKUP formula.

Now click right on the cell where you want to paste the content of the original cell. Some pasting options will appear: go to Paste Special>Values.

You just pasted a cell as text value only!

In Google Sheets, you can paste a cell as value only by following different techniques. Today, we share with you the fastest way to copy and paste data as values only!

Select the cell you want to copy then press Command+C on your keyboard. Usually, in Google spreadsheets, the cell borders will become highlighted.

In this example we are copying the cell B3, which includes an IFERROR formula, to the cell D3.

Now select the cell where you want to paste the data and press Command+Alt+V. You just pasted a cell as text value!

Now, you know how to paste values only in Excel and in Google Spreadsheets!

Learn more about the formulas we mentioned in the examples by visiting our blog: VLOOKUP function, IFERROR formula, etc.

Want to become a Spreadsheet expert? Check our Excel online course now!

Advertising
Analytics

Categories

AllAdvertisingFormatsPlatformsKPI'sAd News

What is O&O Advertising?

Discover one more important jargon term used in Programmatic Advertising: O&O advertising. Get familiar with O&O formats and advantages.

Read More

Best DSPs for Programmatic Advertising

Ted Jordan shares his list of best DSPs for Programmatic Advertising so you don’t have to lose time searching the internet to find the right Demand-Side Platform for your campaigns.

Read More
What is Programmatic Advertising?

What is Programmatic Advertising?

Understand what programmatic advertising is and how it works to increase your ROI and become a programmatic specialist.

Read More
Programmatic Advertising: What is a SSP?

Supply-Side Platforms (SSPs) Explained

SSPs basics in advertising: learn what Supply-Side Platforms are used for and who use them. Get familiar with more programmatic advertising technical terms.

Read More
Programmatic Advertising: What is a DSP?

What are DSPs?

A DSP is a great tool to use but what does DSP stand for in marketing? What are some Demand-Side Platforms examples? Today, we answer your questions!

Read More

Advertising News – 09 June 2024

This week, we'll explore Google's latest algorithm update and it's massive impact on independent websites, the newly passed media Freedom Act in the EU aimed at protecting journalists, and a...

Read More

Categories

AllFunctionsToolsShortcut Keys
Split Semicolon Separated Value in Excel

How to split semicolon separated values in Excel

Split semicolon separated values in Excel into columns and rows, or convert columns to semicolon separated values, like an Excel Master!

Read More

How to change shapes in Excel column charts

Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.

Read More

How to use the LEFT, RIGHT and MID functions

Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start...

Read More

Excel IF statement: how to use it for 3 conditions

Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!

Read More
Using Text to Column to Extract texts on Excel

Excel: How to split text into columns

If you need to extract data in Excel, you may want to use the Text to Columns tool. With only 3 steps, it's really easy to split text into columns.

Read More
Navigating with Tab, Enter, and Shift Key on Excel.

How to move between cells when arrow keys are not working (Excel)

Learn how to move between Excel cells without using your mouse or arrow keys. Discover more shortcuts and tricks below!

Read More