Friday, July 31, 2020

Stop sharing onedrive or sharepoint files or folders or change permissions

You can stop sharing an item, see who it's shared with, or change the permissions others have to it, if you're the owner of the item.

Note: You can't change the permission of a sharing link from edit to view or from view to edit. The way around it is to delete your sharing link and create a new one with a different permission.

What you see differs depending whether you're signed in with a personal account or a work or school account. Select a tab below to learn more.

Stop or change sharing

Files and folders can be shared by sending someone a sharing link, or by giving them direct access to the file or folder. (People may also have access to a file or folder if they've been given access to the site itself.)

If you are the file owner, you can stop sharing the file or folder.

If someone has been given direct access, or has access through a specific people link, you can also change the sharing permissions between view and edit.

Here are the steps:

  1. Select the file or folder you want to stop sharing.

  2. Select Information Information in the upper-right corner to open the Details pane.

    Note: (The Information icon is just below your profile picture. If you don't see it, make sure you only have one file or folder selected - it won't display if you have multiple items selected.)

  3. On the Details pane, under the Has Access header, you'll see the People icon, the Links icon, and/or the Email icon. These options vary depending on how you have shared the file or folder. Select Manage access and:

    • To stop sharing the file entirely, click Stop sharing.

    • To delete a sharing link, click the ... next to the link, then click the X next to the link to remove it. (You'll get a prompt asking you if you're sure you want to delete the link - if so, click Delete link.)

    • To stop sharing with specific people, expand the list under a specific people link and click the X to remove someone.

    • To change permissions or stop sharing with someone who has direct access, under Direct Access, click the dropdown next to the person's name and choose the option that you want.

Screenshot of the manage access panel showing sharing links. Screenshot of direct access links

Tip: You can also manage a file or folder's sharing permissions through the OneDrive desktop app for Windows 7, Windows 10, and Mac. All you need to do is right-click the shared file or folder in your OneDrive folder on your computer, and select Share, then select More The More Options button on OneDrive.com. > Manage access, and a dialog box will open on your desktop so you can make your selections as described above in step 3.

See the items you've shared

On OneDrive.com, select Shared in the left pane, and then select Shared by me.

Stop or change sharing

If you are the file owner, you can stop or change the sharing permissions. Here are the steps:

  1. Select the file or folder you want to stop sharing.

  2. Select Information Information in the upper-right corner to open the Details pane.

    Note: (The Information icon is just below your profile picture. If you don't see it, make sure you only have one file or folder selected - it won't display if you have multiple items selected.)

  3. On the Details pane, under the Has Access header, you'll see the People icon, the Links icon, and/or the Email icon. These options vary depending on how you have shared the file or folder. Select Manage access.

  4. To remove a sharing link, click the X next to the link to remove it. (You'll get a prompt asking you if you're sure you want to delete the link - if so, click Remove link.) You can also remove it through the Edit link page (see below).

  5. To change the password or expiration date on a sharing link, click the dropdown arrow for the link that you want to edit, and then on the Edit link page:

    • Select the password and change it, or clear the Set password check box to remove the password.

    • Update the link expiration date, or clear the Set link expiration check box to remove the expiration date from the link.

    • Select Remove Link to delete the link and stop sharing with that link. (You'll get a prompt asking you if you're sure you want to remove the link - if so, click Remove link.)

Screenshot of Edit Link settings

Notes: 

  • If your Microsoft account is set with Family Safety, and your parent has turned off contact management, you can only share items with people who are already on your contact list.

  • Please respect copyright and be careful what you share online. Copying or sharing unauthorized materials violates the Microsoft Services Agreement.

See the items you've shared

On OneDrive.com, select Shared in the left pane.

Learn more

Microsoft 365 advanced protection

Need more help?

Online

Get online help
See more support pages for OneDrive and OneDrive for work or school.
For the OneDrive mobile app, see Troubleshoot OneDrive mobile app problems.

OneDrive Admins can also view the OneDrive Tech Community, Help for OneDrive for Admins.

Microsoft virtual support agent icon

Contact Support
If you still need help, contact support through your browser or shake your mobile device while you're in the OneDrive app.

OneDrive Admins can contact Microsoft 365 for business support.

Office 365 community forums

Got feedback?
OneDrive UserVoice is your place to suggest the features you'd like to see us add to OneDrive. While we can't guarantee any specific features or timelines, we will respond to every suggestion that gets at least 500 votes.

Go to the OneDrive UserVoice.

Start an impromptu skype for business meeting

With Skype for Business you can start working with people on a subject that requires immediate attention without having to schedule a meeting in advance. Quickly start an ad hoc meeting by calling, sending an instant message, or sharing your screen, a program, or file with more than one contact.

Start a conference call

Start a Skype for Business conference call to have a quick, impromptu meeting with your co-workers. Make sure your contacts are available by checking their presence status first. Then:

  1. In your Contacts list, hold down the Ctrl key on your keyboard, and click the names of your contacts to select them.

  2. Right-click the selection, click Start a Conference Call, and then click Skype for Business Call.

Your contacts then receive a notification and can accept or decline your request for the conference call.

Tip:  To make it a video call, either select Start a Video Call when starting the call or add video during the meeting by clicking the video icon in the meeting window.

Start a group IM conversation

Start a group instant messaging (IM) conversation by selecting multiple contacts or a contact group from your Contacts list.

  1. In your Contacts list, hold down the Ctrl key on your keyboard, and click each contact that you want to invite.

  2. Right-click the selection, and then click Send an IM.

  3. Type your message and then press Enter on your keyboard.

    Screenshot of group IM

Or, turn an IM conversation that you're having with one person into a group IM conversation, by pausing on the people icon at the bottom of the conversation window, and then clicking Invite more people.

Screenshot of invite more people from IM window

Tip:  Add audio, video, or both to an IM conversation by using the phone and/or video icon below the text input area.

Add sharing

Quickly start sharing your screen with someone from within a conference call or group IM.

  1. In the conversation window, point to the present (monitor) button, and, on the Present tab, click one of the following:

  2. Desktop to show the entire content of your desktop.

  3. Program, and then double-click the program you want.

A sharing toolbar appears at the top of the screen and you'll be notified that you're sharing.

  1. When you're done, click Stop Sharing on the toolbar.

Screenshot of audio and camera buttons

Share PowerPoint slides

  1. In the conversation window, point to the present (monitor) button.

  2. On the Present tab, click PowerPoint, and upload the file.

  3. To move the slides, click Thumbnails, and click the slide you want to show, or use the arrows at the bottom of the meeting room.

  4. Do any of the following:

  5. To see your presenter notes, click Notes.

  6. To use annotations, click the Annotations button on the upper-right side of the slide to open the toolbar, and use highlights, stamps, laser pointer, and so on.

Screenshot of adding PowerPoint to an IM

Send a file

Use the file transfer option to send files during a Skype for Business conversation.

  • Drag the file from your computer, and drop it onto the conversation window.

Skype for Business notifies the recipients that a file is being sent, and they can accept or decline. If the transfer is accepted, the file starts downloading on each recipient's computer.

You can also send a file to contacts you're not currently in conversation with.

  1. In your Contacts list, use the Ctrl key to select the contacts you want to send the file to.

  2. Drag the file onto the selection.

Skype for Business sends a notification to the recipient to accept or decline the file transfer.

Screenshot of file transfer pop up alert

Introduction to lists

A list is a collection of data that you can share with team members and other site users. You'll find SharePoint provides a number of ready-to-use lists and list templates to provide a good starting point for organizing list items. This article explains the concepts behind creating and using lists.

See the following topics for information on how to create, edit, and delete lists.

Note: Note that the information here and the types of lists available to you depend on the version of SharePoint you are using. If you don't know the version contact your administrator, help desk, or manager, or see Which version of SharePoint am I using?.

A site usually includes many default lists, including Links, Announcements, Contacts, Issue Tracking, Surveys, and Tasks that you can use as a focal point for team collaboration or in a business solution. In many cases, these default lists can provide quick, effective solutions with little or no modifications. For example, you can use:

  • Tasks, which include tracking of ownership and progress as well as an in-page timeline for an attractive visual presentation the list content.

  • Issue Tracking, which has versioning and version-history storage, for deeper analysis of workgroup projects and common work tasks.

Lists are rich and flexible and have many built-in features that provide a robust way to store, share, and work with data. You can:

  • Create a list with a variety of columns, including Text, Number, Choice, Currency, Date and Time, Lookup, Yes/No, and Calculated. You can also attach one or more files to a list item to provide additional details, such as a spreadsheet containing supporting numbers or a document containing background information.

  • Create list views to organize, sort, and filter data in different and specific ways; change the metadata, such as adding and deleting columns, and modifying validation rules; and use lists consistently across sites with content types, site columns, and templates. For example, you can view just the current events from a calendar on a home page and create a visual view — similar to a wall calendar — on another page.

  • Create relationships between lists by using a combination of unique columns, lookup columns, and relationship enforcement (cascade and restrict delete), all of which enhance your ability to create more sophisticated business solutions and help preserve the integrity of your data.

  • Create custom lists, display the data in Web Parts and Web Part Pages, and import, export, and link to data from other programs, such as Excel and Access.

  • Track versions and detailed history, require approval to modify data, use item-level and folder security, check-in and check-out, and automatically stay informed about changes by using alerts and RSS feeds.

  • Organize content in a single list into folders for added convenience and better performance, and improve performance in general with large lists by using indexing.

The following are some ways you can work with lists to help you to manage information for your group.

Track versions and detailed history    You can track versions of list items, so that you can see which items have changed from version to version, as well as who changed the list items. If mistakes are made in a newer version, you can restore a previous version of an item. Tracking the history of a list is especially important if your organization needs to monitor a list as it evolves.

Require approval    You can specify that approval for a list item is required before it can be viewed by everyone. Items remain in a pending state until they are approved or rejected by someone who has permission to approve them. You can control which groups of users can view a list item before it is approved.

Customize permissions    You can specify whether participants for your list can read and edit only the items they created or all items in the list. People who have permission to manage lists can read and edit all list items. You can also apply specific permission levels to a single list item, for example, if the item contains confidential information.

Create and manage views    Your group can create different views of the same list. The contents of the actual list don't change, but the items are organized or filtered so that people can find the most important or interesting information, depending on their needs.

Update lists    Regardless of the type of list you are updating the process is similar for adding, editing, and deleting list items. There are two ways to add or edit an item to a list.

  • By using a form, which is the default method.

  • Inline, which means you add the item directly on the list page.

If the list is set up to track versions, a new version of the list item is created each time you edit a list item. You can view a history of how the list item has changed and restore a previous version if you make a mistake in a newer version.

Use formulas and calculated values    You can use formulas and calculated values to dynamically generate information in the columns of a list. The operations can include information other columns in a list as well as system functions such as [today] to indicate the current date. For example, you can specify a default due date that is seven days from the current date.

Keep informed about changes    Lists and views can use RSS, so that members of your workgroup can automatically receive updates. RSS is a technology that enables people to receive and view updates or RSS feeds of news and information in a consolidated location. You can also create email alerts to notify you when the lists are changed or when new items are added. Alerts are a convenient way to keep track of the changes that are important to you.

Create list relationships    To create a relationship between two lists, in the source list, you create a lookup column that retrieves (or "looks up") one or more values from a target list if those values match the value in the lookup column in the source list. If you want, you can continue to add additional columns from the target list to the source list. When you create a lookup column, you can also decide to enforce relationship behavior by setting a cascade delete or restrict delete option that helps keep your data valid and helps prevent inconsistencies that might cause problems down the road.

Share list information with a database program    If you have a database program installed, such as Access, you can export and import data to and from your site, as well as link a table from the database to a list. When you work with your list data in an Access database, you can also create queries, forms, and reports. See Import data into an Access database for more info.

Use lists consistently across sites    If your group works with several types of lists, you can add consistency across multiple lists with content types, site columns, and templates. These features enable you to reuse the settings and list structure in an efficient way. For example, you can create a content type for a customer service issue that specifies certain columns (such as customer contact) and business processes for the content type. Another example is creating a site column for department names that has a drop-down list of departments. You can reuse the column in multiple lists to ensure that the names always appear the same way in each list.

Work on list items from an email program    By using an email program that is compatible with SharePoint technologies, you can take important list information with you. For example, with Outlook, you can view and update tasks, contacts, and discussion boards on your site from Outlook. SeeConnect an external list to Outlook for more info.

Set content targeting    You can enable audience targeting for a list and then make items in the list appear only to people who are members of particular SharePoint and Active Directory groups or audiences. This is accomplished by using Web Parts, such as the Content Query Web Part, that uses audience targeting to filter the list based on the user's membership in a group. Before the items in a list can be enabled for a particular audience, the list itself must be set up with the Audience Targeting column.

The type of list that you use depends on the kind of information that you are sharing.

Announcements    Use an announcements list to share news and status and to provide reminders. Announcements support enhanced formatting with images, hyperlinks, and formatted text.

Contacts    Use a contacts list to store information about people or groups that you work with. If you are using an email or contact management program that is compatible with SharePoint technologies, you can view and update your contacts from your site in the other program. For example, you can update a list of all your organization's suppliers from an email program compatible with SharePoint technologies, such as Outlook. A contacts list doesn't actually manage the members of your site, but it can be used to store and share contacts for your organization, such as a list of external vendors.

Discussion boards    Use a discussion board to provide a central place to record and store team discussions that is similar to the format of newsgroups. If your administrator has enabled lists on your site to receive email messages, discussion boards can store email discussions from most common email programs. For example, you can create a discussion board for your organization's new product release.

Links    Use a links list as a central location for links to the Internet, your company's intranet, and other resources. For example, you might create a list of links to your customers' Web sites.

Promoted Links    Use this list to display a set of link actions in a visual layout.

Calendar    Use a calendar for all of your team's events or for specific situations, such as company holidays. A calendar provides visual views, similar to a desk or wall calendar, of your team events, including meetings, social events, and all-day events. You can also track team milestones, such as deadlines or product release dates that are not related to a specific time interval. If you are using an email or calendar program that is compatible with SharePoint technologies, you can view and update your calendar from your site while working in the other program. For example, you can compare and update your calendar on the site with dates from your Outlook calendar, by viewing both calendars side-by-side or overlaid with each other in Outlook. See Create a calendar for more info.

Tasks    Use a task list to track information about projects and other to-do events for your group. You can assign tasks to people, as well as track the status and percentage complete as the task moves toward completion. If you are using an email or task management program that is compatible with SharePoint technologies, you can view and update your tasks from your site in your other program. For example, you can create a task list for your organization's budget process and then view and update it in Outlook along with your other tasks. See Create a list for more info.

Project tasks    Use a project task list to store task information with a Gantt view and progress bars. You can track the status and percentage complete as the task moves toward completion. If you are using an email or task management program that is compatible with SharePoint technologies, you can view and update your project tasks from your site in your other program. For example, you can create a project task list on your site to identify and assign the work to create a training manual, and then you can track your organization's progress from Project. See Create a list for more info.

Issue tracking    Use an issue-tracking list to store information about specific issues, such as support issues, and track their progress. You can assign issues, categorize them, and relate issues to each other. For example, you can create an issue-tracking list to manage customer service problems and solutions. You can also comment on issues each time you edit them, creating a history of comments without altering the original description of the issue. For example, a customer service representative can record each step taken to resolve a problem and the results. You can also use an Issue Tracking list with a Three-state workflow to help your organization manage issue or project tracking. See Create a list for more info.

Survey    Use a survey to collect and compile feedback, such as an employee satisfaction survey or a quiz. You can design your questions and answers in several different ways and see an overview of your feedback. If you have a spreadsheet or database program installed that is compatible with SharePoint technologies, you can export your results to further analyze them. See Create a survey for more info.

Custom    Use a custom list to start a list from scratch. You can also create a custom list that is based on a spreadsheet, if you have a spreadsheet program that is compatible with SharePoint technologies. For example, you can import a list from Excel that you created to store and manage contracts with vendors. See Create a list based on a spreadsheet for more info.

External lists    Use an external list to work with data that is stored outside SharePoint, but that you can read and write within SharePoint. The data source for an external list is called an External content type. Unlike a native SharePoint list, an external list uses Business Connectivity Services to access data directly from an external system (such as SAP, Siebel, and Microsoft SQL Server), whether that system is a database, Web service, or line-of-business system.

Custom list in Datasheet    View Use Custom list in Datasheet View to create a blank list similar to a custom list but to display the list by default in datasheet view. Datasheet view provides a data grid for viewing and editing data as rows and columns. You can add and edit rows and columns, apply filters and sort orders, display calculated values and totals, and conveniently edit data in the grid cells. Datasheet view requires Office installed on a 32-bit client computer and a browser that supports ActiveX controls.

Status list    Use a status list to display and track the goals of your project. The list includes a set of colored icons to communicate the degree to which goals are met.

Circulations    Use the circulations list to send information, including confirmation stamps, to your team members.

Microsoft IME Dictionary list    Use the Microsoft IME Dictionary list to when you want to use data in the list as a Microsoft IME dictionary. You can convert the Reading column items to Display using Microsoft IME and view the content in Comment in the IME Comment window. The data can be linked to a specific URL.

PerformancePoint Content List    Use a PerformancePoint Content list to store dashboard items, such as scorecards, reports, filters, dashboard pages, and other dashboard items that you create by using PerformancePoint Dashboard Designer.

Languages and Translators    Use a Languages and Translators list with a Translation Management workflow in a Translation Management Library. The workflow uses the list to assign translation tasks to the translator specified in the list for each language. You can create this list manually, or you can choose to have this list automatically created when you add a Translation Management Workflow to a Translation Management library.

KPI List    Use a KPI list to track Key Performance Indicators which allow you to quickly evaluate the progress made against measurable goals. You can set up KPI lists to track performance by using one of four data sources: manually entered data, data in a SharePoint list, data in Excel workbooks, or data from Analysis Services — a component of Microsoft SQL Server. After the KPI list is created, you can use it to display the status of the indicator on a dashboard page.

Import Spreadsheet    Create a list that uses columns and data of an existing spreadsheet. Importing a spreadsheet requires Microsoft Excel or another compatible program.

Add one of these lists to your page

  1. In Sites, click Settings Settings: update your profile, install software and connect it to the cloud , and then click Site contents.

  2. Click the Add an app icon.

    The Add an app icon in the Site Contents dialog.
  3. Scroll through and click the app you want to use. There may be more than one page.

  4. Give the app a unique name so you can recall it later for a page, and click Create.

  5. When you get back to the Site contents screen, you can do three things:

    • Close the window and go back to the page. Add the new app on your page using Insert Web Parts.

    • Click the app and start entering data.

    • Click the ellipses ... and then click change Settings. You can add columns, change names, and do other tasks here.

Organizing lists on a site

Although you can use the features of lists in a variety of ways, how you use them depends on the size and number of lists you have and the needs of your organization.

You may want one large list to serve diverse needs. For example, you might have a large number of technical issues to track across your organization, and the issues may apply to multiple projects and groups.

Use a single list when:

  • Your group needs to see summary information about the list items or different views of the same set of items. For example, a manager may want to see the progress on all technical issues for an organization or see all the issues that were filed within the same time period.

  • People want to browse or search for the issues in the same location on a site.

  • You want to apply the same settings to the list items, such as tracking versions or requiring approval.

  • The groups working on the list share similar characteristics, such as the same levels of permission. Unique permission can be applied to specific list items, but if the levels of permission vary greatly, consider multiple lists.

  • You want to analyze information about the list or receive consolidated updates for the list. You can receive alerts when the list items are changed or see the changes to a list by using RSS technology. RSS feeds enable members of your workgroup to see a consolidated list of information that has changed.

You may want multiple lists when there are distinct differences between the items that you want to manage or between the groups of people who work with them.

Use multiple lists when:

  • You don't expect people to need summaries of the items together.

  • The groups of people working with the information are distinct and have different permission levels.

  • You need to apply different settings, such as versioning or approval, to multiple sets of items.

  • You do not need to analyze the items together or receive consolidated updates about the list.

The following are some of the ways that you can organize lists and list items:

Add columns    To help your group pinpoint the items that are most important, you can add columns to your list. For example, you might add the Project column to a list to help people working on specific projects more easily view and work with their items. You may also want to add more columns if you want to collect additional information for each list item, such as the name of the department or the name of an employee.

If you have multiple items in a list, you may consider indexing certain columns to improve the performance when viewing several items or switching views. This feature doesn't change the way the items are organized, but it may enable organizations to more easily store a large number of items in a list. However, indexing can take up more database space. Create, change, or delete a view of a list or library

Create views    You can use views if the people in your group frequently need to see data in a certain way. Views use columns to sort, group, filter, and display the data. You can also select how many items are displayed at one time in each view. For example, people can browse a list in sets of 25 or 100 list items per page, depending on their preferences and the speed of their connection.

Views give you the flexibility to store a large number of items in a list, but to see only the subsets that you want at a particular time, such as only the issues that were posted this year, or only the current events in a calendar. You can create personal views that are available only to you, and if you have permission to modify a list, you can create public views that are available to everyone.Create, change, or delete a view of a list or library

Create folders    You can add folders to most types of lists, if your list owner has allowed folders to be created. This is especially helpful if your list items can be divided in a particular way, such as by project or by group. Folders help people to more easily scan and manage the list items. SharePoint technologies provide a tree view that enables people to navigate their sites and folders similar to the way that they work with the folders on their hard disk. For example, each department can have its own folder. Create a folder in a list

See Also

Add, edit, or delete list items

Enable and configure versioning for a list or library

Create a folder in a list

Delete a folder in a list

Link tasks in your project in project online

Most projects aren't just a list of completely independent tasks. Usually a project has some tasks that can't start until other tasks have finished. In Project Web App, creating this kind of a relationship between tasks is called "linking" the tasks.

Tip: Project Professional enables you to link tasks in more detailed ways. For example you might want to link a task so that there is some overlap between the finish and start dates, or you might want to link tasks that are in completely separate projects. For more information, see Open a project in Microsoft Project, Link tasks in a project, and Link projects.

To link tasks in Project Web App, simply select the tasks you want to link, and then press Ctrl+F2, or click Link Tasks in the Editing group on the Task tab.

Tip: Project not currently open for editing? Click Projects on the Quick Launch, click the name of your project in the list on the Project Center, and then, on the Project tab or the Task tab, click Edit.

The order in which the selected tasks are linked depends on how you selected them:

  • To link tasks in a specific order,    press Ctrl and then click each individual task in the order that you want them linked. Then press Ctrl+F2, or click Link Tasks in the Editing group on the Task tab.

  • To link consecutive tasks in the order that they are listed in your project,    click a task, press Shift, and then click another task. The two tasks that you clicked, and all tasks that fall between them in the list, are selected. You can also click the row header and drag up or down to select consecutive tasks for linking. Then press Ctrl+F2, or click Link Tasks in the Editing group on the Task tab.

If you no longer want your tasks linked, you can remove a link at any time. To remove task links, select the tasks that you no longer want linked, and then press Ctrl+Shift+F2, or click Unlink Tasks in the Editing group on the Task tab.

Zoom in or out of a document presentation or worksheet

You can zoom in to get a close-up view of your file or zoom out to see more of the page at a reduced size. You can also save a particular zoom setting.

Quickly zoom in or out

  1. On the status bar of your Office app, click the Zoom slider .

    Zoom slider

  2. Slide to the percentage zoom setting that you want. Click - or + to zoom in gradual increments.

Note: In Outlook, the zoom slider zooms only the content in the Reading Pane.

Click the headings below for more information.

You can choose how much of a document, presentation, or worksheet you view on the screen.

In Word

Do one of the following:

Zoom group on the View tab

  • On the View tab, in the Zoom group, click Zoom 100%. This returns the view to 100% zoom.

  • On the View tab, in the Zoom group, click One Page, Multiple Pages, or Page Width.

  • On the View tab, in the Zoom group, click Zoom, and then enter a percentage or choose any other settings that you want.

In PowerPoint

Do one of the following:

Zoom group on View tab

  • On the View tab, in the Zoom group, click Fit to Window, which changes the current slide to the size of your PowerPoint window.

    Note: There also is a Fit to Window button near the zoom slider on the status bar. Zoom slider

  • On the View tab, in the Zoom group, click Zoom, and then enter a percentage or choose any other settings that you want.

In Excel

Do one of the following:

Zoom group on View tab

  • On the View tab, in the Zoom group, click Zoom 100%.

  • On the View tab, in the Zoom group, click Zoom to Selection, which maximizes the view of cells that you've selected.

  • On the View tab, in the Zoom group, click Zoom, and then enter a percentage or choose any other settings that you want.

In Outlook

In the main Outlook window, the zoom slider is the only way to zoom in or out. When you are reading or editing a message, zoom from the ribbon:

  1. In an open message, on the Message tab, in the Zoom group, click Zoom.

  2. In the Zoom dialog box, enter a percentage or choose any other settings that you want.

Note: Word doesn't save zoom settings in documents. Instead, it opens a document at the last zoom level you used.

  1. Open the presentation or worksheet that you want to save with a particular zoom setting.

  2. On the View tab, in the Zoom group, click Zoom.

  3. Choose the setting that you want.

  4. Click Save.

    Keyboard shortcut: Ctrl+S

  1. In Word, Outlook, PowerPoint or Excel, on the status bar, click the Zoom slider View zoom control .

  2. Slide to the percentage zoom setting that you want. Click the - or + buttons to zoom in gradual increments.

Note: In Outlook, the zoom slider zooms only the content in the Reading Pane.

You can choose how much of a document, presentation, or worksheet you view on the screen.

In Word

Do one of the following:

  • On the View tab, in the Zoom group, click Zoom 100%. This returns the view to 100% zoom.

    Word Ribbon Image

  • On the View tab, in the Zoom group, click One Page, Two Pages, or Page Width.

  • On the View tab, in the Zoom group, click Zoom, and then enter a percentage or choose any other settings that you want.

In Microsoft PowerPoint

Do one of the following:

  • On the View tab, in the Zoom group, click Fit to Window, which changes the current slide to the size of your PowerPoint window.

    PowerPoint Ribbon Image

    Note: There also is a Fit to Window button near the zoom slider on the status bar. PowerPoint zoom slider

  • On the View tab, in the Zoom group, click Zoom, and then enter a percentage or choose any other settings that you want.

In Excel

Do one of the following:

  • On the View tab, in the Zoom group, click Zoom 100%.

    Outlook Ribbon Image

  • On the View tab, in the Zoom group, click Zoom to Selection, which maximizes the view of cells that you've selected.

  • On the View tab, in the Zoom group, click Zoom, and then enter a percentage or choose any other settings that you want.

In Outlook

In the main Outlook window, the zoom slider is the only way to zoom in or out. When you are reading or editing a message, zoom from the ribbon:

  1. In an open message, on the Message tab, in the Zoom group, click Zoom.

    Zoom on Outlook messages

  2. In the Zoom dialog box, enter a percentage or choose any other settings that you want.

In Word

To save a particular zoom setting with your document or template so that it always opens with that zoom setting, you must make a change in the document or template first. That can be as simple as adding and deleting one character (or a single space).

  1. Open the document or template that you want to save with a particular zoom setting.

  2. On the View tab, in the Zoom group, click Zoom.

    Word Ribbon Image

  3. Choose the setting that you want.

  4. Add and delete a single character in the document or template.

  5. Click Save.

    Keyboard shortcut: Ctrl+S

In PowerPoint or Excel

  1. Open the presentation or worksheet that you want to save with a particular zoom setting.

  2. On the View tab, in the Zoom group, click Zoom.

  3. Choose the setting that you want.

  4. Click Save.

    Keyboard shortcut: Ctrl+S

Thursday, July 30, 2020

Video make the switch to excel 2013

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

This video shows you the Top five things that have changed in Excel 2013.

If you already know Excel 2003 and want to get up to speed fast with Excel 2013, you are in the right place.

When you see Excel 2013 for the first time, you'll notice some changes.

First, there is a ribbon where the menu bar used to be.

All of your favorite commands are still there, but now they are easier to get to. For example, here are the formatting buttons, and here are the insert things, like Table and Pictures. Need to check spelling? Go to the REVIEW tab.

Look at this. Styles, pictures, diagrams, tables – new ways to use analysis and design tools, like charts. The commands and options to work with the chart are right there on the page.

The file format is new. Now, when you save a new workbook, you'll create a xlsx file, not an xls file. But don't worry. You can open and save xls files in Excel 2013 too, just in case you need to open workbooks from someone working in Excel 2003.

Look what happens now, when you click FILE. This is the backstage, where you go to manage workbook and Excel Options.

The backstage is also where you go to Save and Open files, and also where you go to Share and Export your workbooks.

So, we have just shown you a quick overview of what has changed. Now let's go into more details. In the next video, you'll get a first, in-depth look at Excel 2013. Let's get started.