Microsoft Excel is a powerful tool for data analysis and calculation. However, it can be frustrating when Excel refuses to work properly. So when you have any problem with Excel, such as Excel stuck on opening or being saved, running the program in Safe Mode can be helpful. This article will show you how to open Excel in Safe Mode.
You may be wondering why you want to open Excel in Safe Mode. Well, launching Excel in Safe Mode helps you to fix any problems with the program, as it loads only basic features and settings, disabling any add-ons or third-party extensions. father.
In addition, Safe Mode helps to recover damaged workbooks or if Excel files become unresponsive. On the other hand, starting Excel in Safe Mode has some limitations. Continue reading to know what it is.
Restrict Excel usage in safe mode
While Excel in Safe Mode helps with troubleshooting and general problem solving, some limitations come with it. Excel in Safe Mode disables advanced features and settings, including add-ons, custom toolbars, advanced formatting options, and macros.
Additionally, some features, such as certain chart animations and graphics, may not work properly in Safe Mode. Additionally, it also disables some Excel settings that prevent certain Excel functions, such as sorting, filtering, and formatting, from working properly.
It should be noted that Safe Mode is designed to troubleshoot and resolve problems and cannot act as a permanent fix. That said, let’s understand how to open Excel in Safe Mode.
How to start Excel in Safe Mode
There are many ways to open Excel in Safe Mode which we will discuss in detail in the next few sections. If you regularly use Excel in Safe Mode, we recommend switching to the third method.
1. Use the CTRL . modifier key
This is the easiest and simplest method to launch Excel in Safe Mode. Follow the steps below.
Step 1: Press the Windows key on your keyboard to open the Start menu and type Microsoft Excel.
Step 2: Hold down the Ctrl key on your keyboard and click once on the Excel icon.
Note: If you’ve pinned or have Excel on your desktop, hold down the Ctrl key and double-click the Excel shortcut’s icon.
Step 3: In the dialog box that says ‘You are holding down the CTRL key. Do you want to start Excel in Safe mode?’ Click Yes.
That’s it. Microsoft Excel will launch in Safe Mode. To confirm, you can see Safe Mode written above the toolbar at the top of the screen.
2. Using the Windows Command Line
Step 1: Press the Windows key on your keyboard, type Runand then click Open.
Note: Alternatively, press ‘Windows Key + R’ on your keyboard to quickly open the Run command box.
Step 2: In the text field, enter the command below and click OK.
superior/safe
Your go. This command will trigger Excel to open in Safe Mode and like the method above you can confirm by checking if Safe Mode is written at the top of the screen next to the default filename.
For whatever reason, if you tend to use Microsoft Excel in Safe Mode every day, you can create a shortcut to open Excel in Safe Mode by default. Check out the next method.
3. How to Create a Shortcut to Always Open Excel in Safe Mode
Sometimes the easiest way to launch an app you use every day with small changes in settings is to create a shortcut and place it on the desktop as a shortcut. Follow the steps mentioned below to create a similar safe mode for Excel.
Step 1: Press the Windows key on your keyboard, type Exceland click ‘Open file location.’
Step 2: Right-click on the Excel application and select Properties from the context menu.
Note: Alternatively, press the ‘Alt + Enter’ key on your keyboard.
Step 3: In the Excel Properties window, under Shortcuts, add ‘add /safe’ to the path that ends in the Target box.
Note: Make sure you leave a space before adding the forward slash.
Step 4: Finally click Apply and then OK.
Step 5: Now, copy the Excel application shortcut using the right-click menu and paste it on the desktop.
Note: Also, you can use ‘Ctrl + C’ and ‘Ctrl + V’ to copy and paste the app to your desktop.
There you have it. You have successfully placed an Excel shortcut that, when launched, will open Excel in Safe Mode without you having to press or run any commands.
If a shortcut isn’t what you’re looking for, instead, for some reason, you want to launch Excel in Safe Mode while Windows is in Safe Mode, switch to next law.
How to start Excel in Safe Mode while Windows is in Safe Mode
Safe Mode, which can be for launching an application or running on an environment, helps troubleshoot and fix various problems with various diagnostic tools and troubleshooting methods. Follow the instructions below to start Excel in safe mode when Windows is in safe mode.
Step 1: Press the Windows key, type Settingand then click Open.
Note: Alternatively, press ‘Windows + i’ on your keyboard to directly open the Settings app.
Step 2: In System preferences, scroll down and click Restore.
Step 3: Under Advanced Startup, click Restart now.
Step 4: From the pop-up window, select Restart now.
Step 5: Windows will automatically restart and display the Choose an option window, click Troubleshoot.
Step 6: Select Advanced Options followed by Startup Settings.
Step 7: Under Startup Settings, click Restart.
Step 8: Press 4 to enter Safe Mode.
Step 9: When Windows launches in Safe Mode. Press ‘Windows + R’ to open the Run command box, enter the command below and click OK.
superior/safe
Your go. You have launched Excel in Safe Mode in Windows Safe Mode. To exit Safe Mode, close Excel and restart Windows. If you have any questions, check out the FAQ section below.
FAQ for opening Excel in Safe Mode
1. Can you save Excel in safe mode?
Yes, you can save Excel files while using Safe Mode. Excel’s ability to save files is a basic feature and is not exclusive to Regular Mode. However, if you are working on a file with macros or plugins, they may not work correctly in Safe Mode. And saving such files in Safe Mode can cause problems when you try to open them in normal mode.
2. Can we copy data in safe mode?
Yes, you can copy data in Safe Mode the same way you do in normal mode. Copying and pasting data are basic Excel functions, and Safe Mode does not restrict them.
File Troubleshooting
Now that you know how to open Excel in Safe Mode, let’s continue to troubleshoot and fix problems that cause Excel to malfunction. You may also want to read how to start Windows 10 in Safe Mode and when to use it.
Categories: How to
Source: thpttranhungdao.edu.vn/en/