In this post we will check two aspects of the copy and paste formulas between two popular spreadsheet applications – Excel and Google Sheets. First thing is copy and paste from Google Sheet to Excel with formulas and the next the opposite to it. That means copy formulas from Excel to Google Sheets.
What Happens Normally When You Copy and Paste from Two Different Spreadsheet Applications?
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? Yes. Here is the solution to copy and paste from Google Sheet to Excel with Formulas and vice a versa.
Copy and Paste from Google Sheet to Excel with Formulas
You will normally copy some ranges 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.
In Google Sheets before copying do as follows. First go to View Menu and enable Show Formula. Then copy the content and paste to Excel. Your Google Spreadsheet data will be copied to Excel retaining the text, numbers and Formulas.
Some times it may not work due to software update or some other reason which is not in our hand. In this case you may first paste the copied content in the Office 365 Excel spreadsheet on your browser. Now copy that content as it is, when you copy using Ctrl+C, give few seconds to Excel to properly copy the content, and then paste on Excel offline application.
Copy Data from Excel to Google Sheets with Formulas
To copy data from Excel to Google Sheets with Formulas, use the keyboard shortcut Ctrl+~ in Excel. This will enable the formula view in Excel. Now copy the data and paste it directly in Google Sheets. It will work.
Hope you liked this hidden Google Sheet and Excel tips. You can send us similar tips with us in comments or mail to us using the contact form above navigation menu.