[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Over the years, Google Sheets has greatly improved functionality and collaboration. Whether you’re working alone or collaborating with others, at some point, you’re going to wish you could revisit the past. Thanks to Google Sheets\u2019 version history, you almost can.<\/p>\n
The \u2018undo\u2019 shortcut (Ctrl + Z) is handy immediately after you make a mistake, but what if it\u2019s been a while or the mistake was made by someone else? What if there was no mistake, and you just want to restore or copy an earlier version of the spreadsheet? Fortunately, Google Sheets\u2019 version history allows you to view and interact with previous versions of your file.<\/p>\n
In this post, you will learn about Google Sheets\u2019 version history, including what it is and what you can use it for. You will also learn how to use it to view previous versions and keep track of changes, restore previous versions, make a separate copy of specific versions, name versions, and delete any versions you don\u2019t need.<\/p>\n
To learn more about the different methods available to keep track of changes in Google Sheets, check out our post on how to track changes in Google Sheets<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”what-is-google-sheets-version-history” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Google Sheets\u2019 version history is a great way to revisit or recover past versions of your spreadsheet. Google Sheets automatically saves changes to your file and keeps a log of these changes. Provided you have at least editing permissions<\/a> in this file, you can view these past versions in detail. You can also name 15 of these versions per spreadsheet to make them easier to find, restore a previous version to replace the current version, or make a separate copy of the past version.<\/p>\n Version history works on the whole file. To check who changed a single cell, and when, here’s how to see the edit history of a cell<\/a> in Google Sheets.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-long-does-google-sheets-keep-version” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n There is no set limit to how long Google Sheets keeps the current version of your spreadsheet. Google may occasionally merge revisions, though, so some versions stop appearing on their own. To keep a version from being merged, give it a name. You may have read that versions are deleted after 30 days or once there are 100 newer ones. That rule applies to other files stored in Google Drive, such as PDFs and images, not to Google Sheets.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-see-version-history-in-google-she” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To view a spreadsheet’s history, follow the steps below.<\/p>\n 1.<\/strong> Open your Google Sheets file.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-version-history-open-file.webp” alt=”Google Sheets version history \u2014 Gantt chart spreadsheet open in Google Sheets” title_text=”Gantt chart spreadsheet open in Google Sheets” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Go to File > Version history > See version history. You can also click Last edit at the top right, or press Ctrl + Alt + Shift + H (Cmd + Option + Shift + H on a Mac).<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-version-history-file-menu.webp” alt=”See version history in Google Sheets \u2014 File menu open on Version history, with See version history and its shortcut” title_text=”File menu open on Version history, with See version history and its shortcut” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> You\u2019ll see a sidebar to the right of your spreadsheet containing all versions of your file, with the current version at the top.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-version-history-sidebar.webp” alt=”Google Sheets version history \u2014 sidebar listing the versions, with the January 6 current version at the top” title_text=”Sidebar listing the versions, with the January 6 current version at the top” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Click the arrow to the left of a version to get a detailed list of changes. Each user is assigned a different color to make their changes easier to identify.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-version-history-expand-version.webp” alt=”Google Sheets version history \u2014 arrow next to a version clicked to list its individual edits” title_text=”Arrow next to a version clicked to list its individual edits” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> Clicking on any of these change logs will highlight the changes within the spreadsheet.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-version-history-highlighted-changes.webp” alt=”Google Sheets version history \u2014 edited date cells highlighted in the task table” title_text=”Edited date cells highlighted in the task table” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-restore-a-previous-version-in-goo” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n There are two ways to restore a Google Sheets version so that it replaces the current one.<\/p>\n 1.<\/strong> Go to File > Version history > See version history.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-restore-version-file-menu.webp” alt=”Restore a version in Google Sheets \u2014 File menu open on Version history and See version history” title_text=”File menu open on Version history and See version history” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> From the sidebar, select the version you want to restore.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-restore-version-select.webp” alt=”Restore a version in Google Sheets \u2014 January 5, 7:58 PM version selected, with Restore this version at the top” title_text=”January 5, 7:58 PM version selected, with Restore this version at the top” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Click “Restore this version”, then click “Restore” to confirm.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-restore-this-version-button.webp” alt=”Restore a version in Google Sheets \u2014 Restore this version button outlined at the top left” title_text=”Restore this version button outlined at the top left” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Alternatively, you can click the vertical ellipsis to the right of the version you want to restore to get the options. Select \u2018Restore this version\u2019.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-restore-version-three-dot-menu.webp” alt=”Restore a version in Google Sheets \u2014 three-dot menu next to a version with Restore this version” title_text=”Three-dot menu next to a version with Restore this version” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you work in Excel instead, here’s how to restore a previous version of an Excel file<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-make-a-copy-of-a-previous-version” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you don\u2019t want to replace the current version, you can always make a copy of past versions.<\/p>\n 1.<\/strong> From the version history sidebar, select the version you want to copy.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-copy-version-select.webp” alt=”Copy a version in Google Sheets \u2014 January 5, 7:58 PM version selected in the sidebar” title_text=”January 5, 7:58 PM version selected in the sidebar” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Click the vertical ellipsis to the right of your selection and choose \u2018Make a copy\u2019.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-copy-version-make-a-copy.webp” alt=”Copy a version in Google Sheets \u2014 Make a copy in the three-dot menu next to the selected version” title_text=”Make a copy in the three-dot menu next to the selected version” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> You can choose how to name your file and where to save it. To give the same people access to the copy, check the box to “Share it with the same people”.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-copy-version-dialog.webp” alt=”Copy a version in Google Sheets \u2014 Copy version dialog with the name, My Drive folder and Share it with the same people checked” title_text=”Copy version dialog with the name, My Drive folder and Share it with the same people checked” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-name-a-version-in-google-sheets” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To name the current version of your spreadsheet, go to File > Version history > Name current version.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-name-current-version-menu.webp” alt=”Name a version in Google Sheets \u2014 Name current version in the File menu under Version history” title_text=”Name current version in the File menu under Version history” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-name-current-version-dialog.webp” alt=”Name a version in Google Sheets \u2014 Name current version dialog with Untitled version in the name field” title_text=”Name current version dialog with Untitled version in the name field” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To name an earlier version, open version history, click More (the three dots) next to the version, and choose “Name this version”. You can name up to 15 versions in a spreadsheet, and Google doesn’t merge named versions with others. To list only the versions you named, turn on “Only show named versions”.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-delete-version-history-in-google” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you own the spreadsheet, you can delete its version history. Deleting is permanent, and it only removes versions that don’t have a name.<\/p>\n To delete all unnamed versions:<\/p>\n To delete only the older versions:<\/p>\n If you’re an editor but not the owner, you can get around this by making a copy. The copy won’t inherit the version history, so you can start a new one.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-delete-version-history-copy.webp” alt=”Delete version history in Google Sheets \u2014 version history of a copied file showing only the current version” title_text=”Version history of a copied file showing only the current version” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To hear about edits as they happen, get notified when someone edits your Google Sheets file<\/a>. For other ways to keep a record of changes, check out our guide to track changes in Google Sheets<\/a>.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Usa el historial de versiones de Google Sheets para ver versiones anteriores de una hoja de c\u00e1lculo, restaurar o copiar una, poner nombre a las que necesites y eliminar las antiguas.<\/p>","protected":false},"author":2,"featured_media":263191,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-263175","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/263175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=263175"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/263175\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/263191"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=263175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=263175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=263175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}What is Google Sheets version history?<\/h2>\n
How long does Google Sheets keep version history?<\/h2>\n
How to see version history in Google Sheets<\/h2>\n
How to restore a previous version in Google Sheets<\/h2>\n
How to make a copy of a previous version<\/h2>\n
How to name a version in Google Sheets<\/h2>\n
How to delete version history in Google Sheets<\/h2>\n
\n
\n
Conclusion<\/h2>\n