Apr 13 2023
- last edited on
Aug 03 2023
After editing my form e.g., I first created questions 1-4, and then deleted question 2. When I click on Responses -> Open in Excel, the column for question 2 still appears. How can I remove the column for question 2 such that it does not appear when I open the Excel spreadsheet? Thanks.
May 01 2023 08:33 PM
May 02 2023 10:45 AM
If you have deleted some questions from your survey but the corresponding columns are still appearing in your Excel spreadsheet, it could be because the cells in those columns still contain data. Even if you have deleted the questions from your survey, the responses to those questions would still be saved in the cells in your Excel spreadsheet.
To remove the columns of deleted questions from your Excel spreadsheet, you need to delete the cells that contain the responses to those questions. Here are the steps to do so:
Once you have deleted all the cells containing responses to the deleted questions, the corresponding columns should no longer appear in your Excel spreadsheet. Note that if you have any formulas or references in other cells that refer to the deleted columns, you may need to update those formulas or references accordingly.