How To Use Microsoft Xl

Sign in securely without a password

• How To Use Microsoft Cloud Storage
• How To Use Microsoft Clip Organizer

Got a new Microsoft Lumia 950 or Microsoft Lumia 950 XL and want to get the most out of it? Here's our tips n' tricks guide to the best features found on these premium Windows 10 mobiles. The xl file extension is associated with Microsoft Excel, one of the most popular and powerful tool you can use to create format spreadsheets, graphs and much more. The xl files were used by some earlier versions of Microsoft Excel for spreadsheet files.

Are you tired of trying to remember your password? With this free app, you can sign into your personal Microsoft account without one. For security, you'll use a fingerprint, face recognition, or a PIN. And don't worry—if anything happens to your mobile device or if you forget your PIN, your password will still get you into your account.

The Microsoft Authenticator app is available for Android and iOS.

You can use the app with a mobile phone or a tablet. Learn what it's like to sign in and how you can backup and recover account credentials.

Use two-step verification for more security

If you need more security, you can require a password along with your fingerprint, face recognition, or PIN. This is called two-step verification. For a personal account, you can turn two-step verification on or off, and reset your password. You can also manage app passwords and change your settings. For a work or school account, your administrator will likely decide whether you'll use two-step verification, and then you'll complete the registration process and set it up.

Use time-based, one-time passcodes

The Microsoft Authenticator app also supports the industry standard for time-based, one-time passcodes (also known as TOTP or OTP). Because of that, you can add any online account that also supports this standard to the Microsoft Authenticator app. This will help keep your other online accounts secure.

For instructions on how to add other online accounts, read Add your non-Microsoft accounts.

Microsoft makes it easy to share workbooks with other people in Excel for Office 365. There are 3 options available, and you can use them without leaving the application.

Winclone pro 8 0 29. More:10 Best Free Excel Courses on Udemy in 2020

Option #1: Send Your Excel Workbook as a PDF

Sending an Excel file as a PDF can be a good option. The recipient won't be able to make changes to your worksheet, but they can print or distribute the file as needed.

Here is how you send your spreadsheet as a PDF:

1. Click the Share button in the upper-right corner of Excel.
2. Click Send a Copy button at the bottom of the Send Link dialog box.
3. Click PDF.

A blank e-mail will open with a PDF copy of the spreadsheet added as an attachment. Just write a quick e-mail to your contact and hit send!

Option #2: Send a Copy of Your Excel Workbook

Sending a copy of an Excel workbook is useful if your contact needs to make changes or add data to the spreadsheet. How to buy voicemod pro. Unlike a PDF, you'll have no control over what they do with your spreadsheet but forwarding a copy of your Excel file is a convenient way to share data.

Here is how you send a copy of your Excel Workbook:

1. Click the Share button in the upper-right corner of Excel.
2. Click Send a Copy button at the bottom of the Send Link dialog box.
3. Click Excel Workbook.

How make bootable usb mac. A blank e-mail will open with the current workbook attached. Like option #1 (sending a PDF), you're able to write a brief e-mail to your contact before hitting send.

If you need to collaborate, a remote contact can update the spreadsheet and return it to you. This process won't be as convenient as two people editing a file on the same network – but it will get the job done.

Option #3: Send a Link to a Shared Excel Workbook

Sending a link to a shared Excel workbook allows for real time collaboration. Microsoft refers to this capability as co-authoring – and the technology is pretty cool!

Https www xmind net xmind2020. As long as your Excel workbook is saved on OneDrive, multiple users can collaborate on a spreadsheet at the same time. It's the easiest way to share workbooks in Excel. Scherlokk 4 1 7.

To send a link to a shared Excel workbook:

1. Click the Share button in the upper-right corner of Excel.
2. Enter a name or e-mail address and add a message (optional).
3. Click Send.

Shared Workbook Permissions

The default level of permission, when you send a link to a shared Excel workbook, is to allow editing. To change that setting, we would need to add one or two steps to the process outlined above in the section Option #3: Send a Link to a Shared Excel Workbook.

To send a link to share workbooks in Excel, restricting the user to view-only permission:

How To Use Microsoft Cloud Storage

1. Click the Share button in the upper-right corner of Excel.
2. Click anywhere in the box that says Anyone with the link can edit.
   The Link Settings dialog box appears.
3. Clear the check box next to Allow Editing.
4. Click Apply.
   The Send Link dialog box reappears.
5. Enter a name or e-mail address and add a message (optional).
6. Click Send.

You can also set an expiration date for access to the file – and add a password for an additional layer of security.

Co-Authoring a Shared Excel Workbook

So, what's it like to use a shared Excel workbook? Most things work exactly the same as they normally would, but Excel lets you know that someone else has the file open.

How to Stop Sharing an Excel Workbook

To stop sharing an Excel workbook:

1. Click the Share button in the upper-right corner of Excel.
   The Send Link dialog box appears.
2. Click the 3 dots next to the Send Link heading and select Manage Access.
3. Click the X next to the URL in the Anyone with the link can edit box to remove anonymous access for anyone with a link.
4. Click the Can edit drop down menu below any additional user accounts listed and select Stop sharing.
5. Close the Manage Access dialog box.

Can You Share an Excel Workbook Without OneDrive?

What happens if your organization doesn't want you to store Excel files on OneDrive? You can still share your Excel file with someone else.

If you save your file to a location other than OneDrive then click Share, Excel will prompt you to upload a copy of your workbook to OneDrive. Assuming that's not an option, you can attach a copy of the file to an e-mail and send it to your colleague.

How To Use Microsoft Clip Organizer

Microsoft Excel is a registered trademark of Microsoft Corporation. How to print screen on a keyboard. XL Basics contains articles and educational content related to Microsoft Excel but is not affiliated with Microsoft in any way.