Select the cells or ranges you wish to copy.
Select the “Home” tab.
Select “Copy” in the “Clipboard section.
Select the cell you wish to paste your values to.
Select the lower half of the large “Paste” button. From the extended menu that appears, select “Values“.
Select “OK“

import openpyxl
# Load the Excel workbook
workbook = openpyxl.load_workbook('input.xlsx')
# Select the desired worksheet
worksheet = workbook['Sheet1']
# Create a new workbook to store the copied values
new_workbook = openpyxl.Workbook()
new_worksheet = new_workbook.active
# Iterate through each cell in the source worksheet
for row in worksheet.iter_rows(): for cell in row: # Copy the value from the source cell to the destination cell new_worksheet[cell.coordinate].value = cell.value
# Save the new workbook with only values
new_workbook.save('output.xlsx')

Sub CopyValueOnly() Range("A1").Copy Range("B1").PasteSpecial xlPasteValues
End Sub

Select the cells or ranges you wish to copy.
Select the “Home” tab.
Select “Copy” in the “Clipboard section" or "Copy" from Satndard Toolbar.
Select the cell you wish to paste your values to.
Select the lower half of the large “Paste” button or select "Paste Special" from menu.
From the extended menu that appears, select “Values“.
Select “OK“