How to Copy and Paste from Google Sheet to Excel with Formulas

When you copy and paste from Google Sheet to Excel Spreadsheet you may lose your formulas. The same will be happen with the copied data from Excel to Google Spreadsheets. Is there any solution?

Copy some range or an entire Google Sheet and then open a Microsoft Excel spreadsheet and paste it. The copied data will be get pasted but only text and numbers. Your formulas in Google Sheets are missing! You will see the results of the formulas. There is no paste special option to paste the content as it is.

Steps to Copy and Paste Data with Formulas in Google Sheets

In Google Sheets before copying do as follows.

Go to View Menu and enable Show Formulae.

Now copy the content and paste to Excel. Your Google Spreadsheet data will be copied to Excel retaining the text, numbers and Formulas.

enable formula in Google Sheets

Steps to Copy and Paste Data with Formulas in Microsoft Excel

To copy data from Excel to Google Sheets with Formulas, use the keyboard shortcut Ctrl+~. This will enable the formula view in Excel.

Now copy the data and paste in Google Sheets.

Hope you liked this hidden Google Sheet or Excel tips.

LEAVE A REPLY

Please enter your comment!
Please enter your name here