Look Who it Was Random video

Excel - Move Excel Settings From One Computer to Another - Episode 750

712 views · Published 5 February 2009 · 2:17 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Save Settings Wizard to move custom lists from one computer to another.

Welcome back to the MrExcel netcast! In this video, we're going to talk about a useful tool that will make your life a lot easier when it comes to transferring custom lists from one computer to another. As we all know, creating custom lists in Excel can save us a lot of time and effort, but it can be a hassle to transfer them to a different computer. That's where the SAVE MY SETTINGS WIZARD comes in.

To access this tool, simply go to START, ALL PROGRAMS, MICROSOFT OFFICE, MICROSOFT OFFICE TOOLS, and click on the SAVE MY SETTINGS WIZARD. I highly recommend running this wizard once a week to ensure that your settings are always backed up. Once you open the wizard, click NEXT and then select the option to restore settings from another machine. From there, you can browse and select the OPS file that contains all of your registry settings.

The OPS file is about 8K in size and contains everything from your email accounts to your custom lists. Once you click FINISH, the wizard will quickly pull in all of the files and registry settings from the OPS file. It's important to note that you should have no Office programs running while the wizard is restoring your settings. Once it's done, you can open Excel and go to TOOLS, OPTIONS, CUSTOM LISTS to see that all of your custom lists from the other machine have been successfully transferred.

This is a great way to not only backup your settings in case of a crash, but also to easily transfer your favorite Excel settings from one computer to another. So, make sure to use the SAVE MY SETTINGS WIZARD to save yourself time and effort. Thanks for watching this netcast from MrExcel, and we'll see you next time for more Excel tips and tricks!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Introduction to custom lists
(00:21) Defining a custom list
(00:32) Difficulty transferring custom lists between computers
(00:42) Solution: Save My Settings Wizard
(00:52) Recommendation to run once a week
(01:02) Restoring settings from another machine
(01:15) Process of pulling in files and registry settings
(01:30) Viewing custom lists in Excel
(01:43) Benefits of using Save My Settings Wizard
(01:55) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152141/



Do you need to transfer custom lists and other settings from one Office installation to another computer? The Save My Settings wizard will make this a snap. Episode 750 will show you how.

More from this channel