One Drive in Microsoft Excel

One Drive in Microsoft Excel is considered to be one of the vital Microsoft's cloud platforms where we can efficiently do the following things that are as follows:

1. Working on the particular files.
2. Storing of the various files.
3. And sharing of the files.

This is much similar to the virtual storage drive that can only be accessed if we have Microsoft Account or an Outlook email ID respectively. To access One Drive in Microsoft Excel, go to the File menu tab and select the Save As option, click on One Drive.

Besides this, we can also access the same through the help of the "Open option". Once we click on One Drive option, it will ask us to Login-in. If in case we have already login to Microsoft or Outlook ID, we will move further on the creation of the new account with the help of the Signup option.

And From any file, we can effectively see the Share option at the top right corner. This option will help us share the selected and currently opened files with the people in the same organization respectively.

How to make use of Microsoft Excel One Drive?

To make use of Microsoft Excel One Drive, then in that case, firstly we need to create our Microsoft Account, which is available for free.

Let us move on following the below-mentioned guidelines for creating this:

1. Open out the workbook.
2. Then go to the FILE tab, as it was clearly depicted in the screenshot below.
   
3. Then, it will display a left-pane window with specific options.
4. And after that, we will click on the "Save As" option, as depicted in the figure below.
   
5. Then soon after that, click on the One Drive option, as clearly depicted in the below-attached screenshot.
   
6. And soon after performing the above steps, it will open out the One Drive storage space, as depicted in the below-attached screenshot.
   
7. After that, we will be clicking on the Sign up option in order to create a new account and if in case we already have an account with Microsoft, in that case we will click on the Sign In option effectively, as seen in the below-attached screenshot.
   
8. Then after clicking on the Signup option, it will open a Microsoft One Drive portal.
9. After that, we should move on clicking on the "Sign up for free" button. As seen refer in the below-attached figure.
   
10. And after performing the above steps, it will open out the Signup portal, as depicted in the screenshot below.
11. Then we should click on Create a Microsoft Account and then will set up our account and password.
    
12. And after setting up the account, it will automatically open a One Drive space like the below-attached screenshot.
13. And then click on the Next option respectively.
    
14. And then, after doing the above steps, it will show us the One Drive created space, as seen in the below-attached screenshot.
    

After that, we can use this Drive as storage space for saving and sharing our work with anyone else. And in addition, we can also create our folders and then can keep our files respectively.

Besides all these, we have also created our folder with the name Excel. And for this, we should refer to the below-attached screenshot respectively.

Saving the file on One Drive space

1. And to save our file on One Drive, we should click on File options, as seen in the below-attached screenshot.
   
2. After that, we will click on the "Save As " option and then click on the One Drive - Personal, as depicted in the below-attached screenshot.
   
3. And after that, we will select the specific folder and save our file.
   
4. And then, it will upload the file on One Drive or the SkyDrive space.

How to Share our file with anyone?

And now, to share our file with someone, then, in that case, we need to give them access. And then we will follow the below steps to perform this:

Step 1: First, we need to Open the link Onedrive.live.com and then sign in with our Microsoft account.

Step 2: Then we will be selecting the folder and then right-click on the file which we want to share. And then it will open out the drop-down list of options, and from which we have to click on the Share option, as depicted in the screenshot below.

Step 3: It will open a dialogue box. Click on the Email option, as depicted in the below-attached figure.

Step 4: It will open a dialogue box, in which we will enter the email id of the person with whom we want to share our file.

Things to Remembe

The various points that one needs to keep in mind while working with One Drive in Microsoft Excel are as follows:

1. If any two individuals want to work simultaneously on the same file, they can effectively use the Excel Online option.
2. An individual can quickly access the file from anywhere if the file has been saved on One Drive respectively.