{"id":5952,"date":"2021-08-24T11:22:00","date_gmt":"2021-08-24T09:22:00","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=5952"},"modified":"2025-06-16T22:08:44","modified_gmt":"2025-06-16T20:08:44","slug":"comment-afficher-lhistorique-des-modifications-dans-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-features\/how-to-view-the-history-of-changes-in-google-sheets\/","title":{"rendered":"Comment afficher l'historique des modifications dans Google Sheets ?"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _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.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Google Sheets<\/a> is a great option for those who deal with a lot of information. This is because Google offers a range of features specifically designed to optimize collaboration and productivity. One of these many features is edit history. Edit history allows you to revisit the different versions of your spreadsheet, which can be used for a variety of reasons. For example, you may want to return back to a version that was particularly useful and effective. Alternatively, you may want to restore your last version after accidentally deleting something \u2013 it happens to the best of us! In this article, we will show you how to view the edit history in Google Sheets as well as other edit history tips, so you can use this feature to your advantage.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Google Sheets edit history<\/h3>\n

As a cloud-based platform, Google Sheets is a great spreadsheet program to use when inputting and updating a large amount of data. Google Sheets\u2019s edit history feature is particularly helpful when it comes to this. Edit history can help you to pinpoint specific data inputs that you may want to revisit. Furthermore, if your data is being automatically updated, the edit history feature can help you to revisit a specific date to identify certain data updates. In short, edit history is a great tool to pinpoint and explore specific aspects of dynamic data.<\/p>\n

Let\u2019s take a look at an example of how the edit history feature can be used. Here\u2019s a snapshot of a file that a sales manager uses to store sales information all the way from Jan 2015 till the current month. This data is updated every month. In order to look at data updates from a specific month, we can use the edit history feature.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/08\/View-history.png” alt=”Google Sheets edit history” title_text=”View history” align=”center” _builder_version=”4.23.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

There are two ways you can access the edit history feature; the menu option and the keyboard combination. Let\u2019s go through a step-by-step of these options:<\/p>\n

[\/et_pb_text][et_pb_text admin_label=”Connections T – Automate between spreadsheets – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.4″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” saved_tabs=”all” global_colors_info=”{}” global_module=”255443″ theme_builder_area=”post_content”]<\/p>\n

\"\"<\/p>\n

\"39\"<\/p>\n

Automate data transfers between spreadsheets
<\/span><\/p>\n

Find out how<\/a><\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

1. Using the menu option<\/h4>\n

You can view a history of your changes to a Google Sheets file using the menu option. To do this, simply navigate to File<\/b> > Version History<\/b> > See version history<\/b><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/08\/View-history-\u2013-1.png” alt=”Google Sheets edit history 1″ title_text=”View history \u2013 1″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

From here, a sidebar should appear on the right side of your screen listing all of the available versions of your file. Each version is clearly labeled with the date, time, and editor of the changes from when it was last saved.<\/p>\n

If you would like to identify which particular areas of your file have been changed, make sure you have the \u2018show changes\u2019 checkbox ticked. This will highlight the changes made to the previous version. In this example, cell A2 is highlighted, because we changed the first name from Lance to Laney.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/08\/View-history-\u2013-2.png” alt=”Google Sheets edit history 2″ title_text=”View history \u2013 2″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Moreover, the edit history feature also allows you to permanently restore a past version of your file. To do this, simply select the past version you would like to restore and click the restore this version<\/b> button located at the top of your screen. This will now permanently become your current version.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/08\/View-history-\u2013-3.png” alt=”Google Sheets edit history 2″ title_text=”View history \u2013 3″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Now let\u2019s take a look at the alternative way to use the edit history feature using a keyboard shortcut.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

2. Using the keyboard combination<\/h4>\n

As an alternative (and perhaps the quicker option) to access the edit history of your Google Sheets file, you can use the following keyboard combination:<\/p>\n

Ctrl + Alt + Shift + H or, for Mac, Cmd + Alt + Shift + H<\/b><\/p>\n

This will take you straight to the sidebar where you can access past versions the same as above.[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

3. Naming your versions<\/h4>\n

As mentioned previously, each version of your Google Sheets file is labeled, by default, after the date and time it was last saved. However, if you are constantly editing your file, or you have frequent data updates, these versions can become very difficult to track and identify. Instead, we recommend that you rename your various versions in order to quickly and easily find the right one you need. Luckily for us, Google Sheets has already provided an easy way to do this for both your past and current versions of your Google Sheets file.<\/p>\n

In order to rename your current version, you can go directly through the navigation menu by choosing File<\/b> > Version history<\/b> > Name current version<\/b>.<\/p>\n

However, you can also name your current version and past versions by using the previous menu option or keyboard combination to access the edit history sidebar. Here, simply select a version of your file, click on the \u2018more actions\u2019 menu (the three dots icon), and then choosing Name this version.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/08\/View-history-\u2013-4.png” alt=”Google Sheets edit history 4″ title_text=”View history \u2013 4″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

4. Making copies<\/h4>\n

Google Sheets also offers the opportunity to create a copy of an old version of your file that doesn\u2019t interfere with your current version. This is a great option if you would like to regain access to an older version of your file without losing the current one. To do this, access the edit history sidebar, click on the \u2018more actions\u2019 menu on your desired version, and select Make a copy<\/b>.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/08\/View-history-\u2013-5.png” alt=”Google Sheets edit history 5″ title_text=”View history \u2013 5″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

And there you have it! The edit history feature on Google Sheets is a fantastic tool that allows you to track, identify and manage all of the past versions of your spreadsheet files. This is particularly beneficial to those dealing with spreadsheets that require automatic updates of data frequently.<\/p>\n

The edit history feature also allows you to restore, rename and make copies of your past versions in order to have complete control over your spreadsheets.<\/p>\n

Check out the following blog post to learn how to easily track changes in Google Sheets, and record your values historically<\/a> using our Sheetgo Append feature. Alternatively, you can find out more about other Google Sheets features and Google Sheets how-to\u2019s in the articles below!<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.22.2″ background_color=”#f9f9ff” custom_margin=”40px||40px||false|false” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Google Sheets is a great option for those who deal with a lot of information. This is because Google offers a range of features specifically designed to optimize collaboration and productivity. One of these many features is edit history. Edit history allows you to revisit the different versions of your spreadsheet, which can be used […]<\/p>\n","protected":false},"author":41,"featured_media":35749,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"On Google Sheets, we usually deal with a lot of information. Very often we may want to tread back to an earlier version, probably because that worked well for us. Or worse, we may have accidentally deleted critical information without our knowledge. Fortunately, the developers of this cloud-based spreadsheets program thought about it and they got our back. They have built in a capability with which we can view the history of changes in Google Sheets. In this post, we quickly explain how we can do that.\n

View history of changes in Google Sheets<\/h4>\nHere\u2019s the snapshot of a file that Fred (sales manager) uses to store sales information all the way from Jan 2015 till the current month. Given the dynamic nature of the information, it keeps changing with time.\n\n\"View\n\nWe have two ways to view the history of changes \u2013 the menu option or the keyboard combination.\n

Using the menu option<\/h4>\nWe can view the history of changes in Google Sheets by navigating to File > Version history > See version history<\/strong>.\n\n\"View\n\nDoing so will pull up a sidebar on which we see the entire list of revisions available, with the current version selected. Please note that checking the \u2018Show changes\u2019 checkbox to true highlights the changes made to the previous version. In this example, cell A3 is highlighted, because we changed the first name from Emilio to Emili.\n\n\"View\n

Using the keyboard combination<\/h4>\nWe can invoke the version history sidebar alternatively using a simple keyboard combination Ctrl + Alt + Shift + H<\/strong> (or Cmd + Alt + Shift + H<\/strong> for Mac). With this approach, we essentially get the same result as above.\n\nWe can switch between versions by selecting the version of our choice on the list of revisions.\n

Naming the versions<\/h4>\nWe notice that each version is, by default, named after the time stamp the version is last saved. If there were a larger number of versions, choosing between the versions can become cumbersome. Instead, if we had names mentioned against these revisions, it would be a lot easier.\n\nGoogle Sheets has built this provision into the application. We can name both the current and previous versions. Naming the current version can be directly done with the menu option File > Version history > Name current version.<\/strong>\n\nOn the other hand, we can name any (including the current) version of the Version history sidebar. We can do so by clicking on the local \u2018More actions<\/strong>\u2018 menu option of the respective version, and then choosing \u2018Name this version<\/strong>\u2018.\n\n\"View\n

Making copies<\/h4>\nGoogle Sheets also offers this cool feature where we can make a copy from a previous version, without interfering the current version. We can do so again from the More actions menu of the corresponding version as shown in the screenshot above.\n\nPlease feel to leave your questions or feedback in the comments section below.","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-5952","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/5952","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=5952"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/5952\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/35749"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=5952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=5952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=5952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}