Forum Discussion
Excelkid
Aug 07, 2025Copper Contributor
Add a copy tab function, but remove all the formulas
Hi, I’m familiar with how to copy a tab and then use "Paste Values" to remove all the formulas. However, would it be possible for you and your team to create a feature or shortcut that automatically ...
HansVogelaar
Aug 07, 2025MVP
In the desktop version of Excel on Windows/Mac, you can use a macro for this purpose:
Sub CopySheetValues()
Dim ws As Worksheet
Dim wt As Worksheet
On Error GoTo ErrHandler
Application.ScreenUpdating = False
Set ws = ActiveSheet
ws.Copy After:=ws
Set wt = ws.Next
With wt.UsedRange
.Value = .Value
End With
ExitHandler:
Application.ScreenUpdating = True
Exit Sub
ErrHandler:
MsgBox Err.Description, vbExclamation
Resume ExitHandler
End Sub
If you create this macro in your personal macro workbook (see here for more info), you can call it anywhere. For ease of use, you can create a keyboard shortcut and/or a Quick Access Toolbar button for the macro.