How to Copy Values Without Formulas on Excel [2024 Guide]

Microsoft Excel is an essential software used by countless employees in offices all around the world.

It is easy to use and accessible to everyone that is interested. It is mainly used for keeping records, so accountants or people with similar jobs are adept at using this software.

Although many people are comfortable using almost all the features of Microsoft Excel, not everybody is like that including myself.

So, it is normal for you to have a question like how you can copy and paste values without copying the formulas.

How to copy and paste without formulas on Excel?

The easiest way is to click on the Home tab, click on Copy on the Clipboard section, Select your cell, click on the Paste button and select Values. Select Ok and you are good to go. You can also use Ctrl+C to copy and Ctrl+V to paste. This is explained in great detail in this article.

Quick Navigation show

How to copy values without formulas on Excel easily

It is no surprise that Microsoft Excel is available on platforms other than Windows. It has become an essential part of offices worldwide. Android, macOS and even some iOS devices support Microsoft Excel.

You will find the different methods to copy and paste values without the formulas on Microsoft Excel.

Here are the different ways you can copy and paste values without formulas in Microsoft Excel:

For Windows

Windows is the first platform we should discuss as Excel and Windows are both properties of Microsoft. Without a doubt, Excel is used most by Windows users worldwide.

Here are the steps to copy and paste values without formulas on Windows:

Open Microsoft Excel.
Select the cells that you want to copy.
Click on the Home tab at the top of the screen.
Select Copy in the Clipboard section.
Select the cell you wish to copy to and Paste. You can also paste using the shortcut Ctrl + V.
Use the same process for the other tabs that you wish to copy.

The easier version of this method is to highlight the cell you wish to copy from and press Ctrl+Shift+C on your keyboard. After that, select the cell you want to copy to and press Ctrl+Shift+V.

The other methods to copy and paste values without formulas on Excel are given below.

For macOS

There are not many differences in how you can copy and paste values without the formulas between the windows and the iOS version. So, it should not be too difficult for you to follow the given steps.

Here are the steps to copy and paste values in Excel on macOS:

Click on the cell you want to copy by pressing command+C on your keyboard.
Click on Edit. A menu will pop up.
Select Paste Formula Results. You can also do this by pressing Shift+command+V on your keyboard.

The shorter version of this method is to select the cell you want to coy from and press command+c on your keyboard. You must then select the cell you want to copy to by pressing Shift+command+C on your keyboard.

The other methods to copy values without formulas in Excel on other platforms are given below.

For Android

Microsoft Excel Mobile is the portable version of Microsoft Excel. It has an excellent rating from its users and is a great portable version of Excel.

The UI and settings are similar to the desktop version, so you should not face any difficulty.

Here are the steps to copy and paste values without formulas in the Android version of Microsoft Excel:

Copy the cell you want to copy.
Double-tap on the cell you want to paste to. A ribbon icon will be shown to you.
Tap on the ribbon icon.
Tap on the drop-down menu button(arrow pointing downwards icon).
Tap on the Paste Special.
Select the option that does not copy formulas.

For iOS

Although Apple is the rival company to Microsoft(owner of Excel), iOS devices also support Excel MObile, the portable version of Microsoft Excel.

Even on iOS devices, Excel has a similar UI, so it is very easy to do the same things on iOS as well.

Here are the steps to copy and paste values without formulas in Excel on iOS devices:

Select and copy the cell you want to copy.
Tap twice on the cell you want to copy to. A ribbon icon will be displayed to you.
Tap on the Ribbon icon. A menu will be shown to you.
Tap on the drop-down menu button(arrow pointing downwards button).
Tap on the Paste Special option.
Select the correct option.

How to Highlight Duplicate/Unique Values in Excel

There could be many reasons as to why you need to highlight or duplicate values in Excel. You might need to copy-paste or do other things on a cell. Just follow the given steps below to know how to do it.

Here are the steps to Highlight Duplicate/Unique Values in Excel:

Click on the Home tab at the top right of the screen.
Click on the Conditional formatting option.
Select Highlight Cell Rules.
Select Duplicate Values.
Choose Highlight or Duplicate, whichever you want. You will be prompted to select the highlight color.

How to Enable/Disable the display of Formulas in Cells in Excel

To some, the displaying of formulas may seem annoying or unnecessary. You could be one of those people or it would be helpful for you to not see formulas.

Here are the steps to Enable/Disable the display of Formulas in Cells in Excel:

Click on the Formulas tab.
Click on the Show Formulas button in the Formula Auditing section.

If you want to disable the display of formulas, follow the same steps but instead of selecting the Show Formulas option, you will select the Hide Formulas option.

How to Lock/Unlock cells in Excel

It is not hard to guess some reasons as to why someone would like to lock or unlock some cells in Excel. One reason could be that locking a cell is an excellent way to avoid mistakes from accidental button presses.

Here are the steps to lock or unlock cells in Excel:

Choose the cells you want to change.
Click on the Home tab.
Navigate to the Cells section and then select Format.
Select Format Cells.
Click on the Protection tab.
Uncheck the box beside the Locked option.
Click on OK.

How to hide/unhide rows and columns in Excel

If you want to hide some rows and columns in excel, you just have to follow some simple steps. The steps on how to do this are given below.

Here are the steps on how to unhide/hide rows and columns in Excel:

Select the columns/rows that you want to edit.
Click on the Home tab.
Go to the Cells section and select Format.
Click on the Hide and Unhide option.
Select the Unhide Columns or Unhide Rows option, whichever you desire. The columns and rows you selected will be displayed or hidden depending on the option you selected.

Conclusion

Knowing how important Excel is to people worldwide, I wrote this article in the hopes that it will help readers like you to do some basic functions in Excel with ease. I hope you are now using the knowledge provided here to complete your Excel tasks effortlessly.