How to turn off hyperlink in excel 2010 how to#

Ok, now we know how to open a specific file by creating a hyperlink. Example #2 – Create Hyperlink to Go to Specific Cell In my case, it will open the Sale 2018 file that is located on the Desktop. Step 8: if you click on this link, it will open up the linked file for you. I am giving the name as the file name only, i.e. Step 7: Now, for our understanding, we can give any name to it. Initially, it will create a hyperlink like this. I have selected the Article 1_hyperlinks file. Step 6: Select the files that you want to open quite often. Step 5: If you click on the specified folder, it will show all the files stored in it.

In my case, I have selected Desktop and in desktop Hyperlink folder. Select the location of your targeted file. (By default, when you open hyperlink, it has already selected) In Tab 1, we have 4 options, and in Tab 2, we have 3 options. Mainly there are two tabs available here.

Step 2: There are many things involved in this hyperlink dialogue box. (Shortcut to open the hyperlink) This will open the below dialogue box. Step 1: In the active sheet, press Ctrl + K. I cannot keep going back to the file folder and click to open the workbook rather, I can create a hyperlink to do the job for me.

I am creating a Hyperlink to open the workbook that I use very often when I am creating reports.

How to turn off hyperlink in excel 2010 download#

So these are some options that you have when you need to unsort in Excel and go back to the original dataset.You can download this HYPERLINK Excel Template here – HYPERLINK Excel Template Example #1 – Create Hyperlink to Open Specific File Or if you’re too prudent, you can also use a VBA macro to create a copy with timestamp whenever you save the workbook. In case anything goes wrong and you have to revert back to original data, you will have it in the backup workbook.Īs a best practice, I recommend you make a backup copy at least every day. The best way of this would be to create a copy of the workbook and work on the copied version. Other Options to Unsort DataĪpart from the obvious Control Z, another thing you can do to be able to go back to the original sort data is to create a backup of the dataset. In case you’re using VBA to sort a dataset, you won’t be able to undo it with Control Z, but using a temporary column will still work and help you unsort the data. This will give us the original data back. Once you have this set-up ready, you’re now all set to be able to unsort this data in case the needs arrive.Īll you need to do is sort in an ascending order based on the temporary column that we added. This will add incrementing numbers to all the cells Select both the cells (A2 and A3), place the cursor over the bottom-right part of the selection.This will insert a blank column at the left of your dataset Suppose you have the dataset as shown below and you want to sort it based on the country name in an alphabetical order.Īnd how do you unsort this data (say after 2 days)?īelow are the steps to unsort the data in Excel:

To be able to unsort a dataset, you need a reference that you can use to go back to the original dataset. Unsort Data Using a Temporary Column in Excel There is a simple fix to this ‘un-sorting’ problem. Or you did some other stuff after sorting the data and you only want to undo the sort and not the rest of the things you did. … but what if you closed the workbook and opened it to the next data and Control Z doesn’t work. Of course, there is Control Z that undoes your previous steps… Data sorting is one of the most common tasks people do in Excel.īut what if you want to un-sort in Excel – i.e., is to revert back to the original data that has not been sorted.