Microsoft Office Tutorials: November 2021

Sunday, November 21, 2021

Reapply a filter and sort or clear a filter

After you have filtered or sorted data in a range of cells or table column, you can either reapply a filter or perform a sort operation to get up-to-date results, or you can clear a filter to redisplay all the data.

Note: When you sort, there is no way to clear the sort order and restore the order that was in place before. However, before you sort you can add a column to contain arbitrary values to preserve the initial sort order, for example, incrementing numbers. Then you can sort on that column to restore the original sort order.

What do you want to do?

Learn more about reapplying a filter and sort
Reapply a filter or sort
Clear a filter for a column
Clear all filters in a worksheet and redisplay all rows

Learn more about reapplying a filter and sort

To determine if a filter is applied, note the icon in the column heading:

A drop-down arrow means that filtering is enabled but no filter is applied.

Tip: When you hover over the heading of a column with filtering enabled but not applied, a screen tip displays "(Showing All)."
A Filter button means that a filter is applied.

Tip: When you hover over the heading of a filtered column, a screen tip displays a description of the filter applied to that column, such as "Equals a red cell color" or "Larger than 150."

When you reapply a filter or sort operation, different results appear for the following reasons:

Data has been added to, modified, or deleted from the range of cells or table column.
The filter is a dynamic date and time filter, such as Today, This Week, or Year to Date.
Values returned by a formula have changed and the worksheet has been recalculated.

Note: When you use the Find dialog box to search filtered data, only the data that is displayed is searched; data that is not displayed is not searched. To search all the data, clear all filters.

Top of Page

Reapply a filter or sort

Note: For a table, filter and sort criteria are saved with the workbook so that you can reapply both the filter and sort each time that you open the workbook. However, for a range of cells, only filter criteria are saved with a workbook, not sort criteria. If you want to save sort criteria so that you can periodically reapply a sort when you open a workbook, it's a good idea to use a table. This is especially important for multicolumn sorts or for sorts that take a long time to create.

To reapply a filter or sort, on the Home tab, in the Editing group, click Sort & Filter, and then click Reapply.

Top of Page

Clear a filter for a column

To clear a filter for one column in a multicolumn range of cells or table, click the Filter button on the heading, and then click Clear Filter from <Column Name>.

Note: If no filter is currently applied, this command is unavailable.

Top of Page

Clear all filters in a worksheet and redisplay all rows

On the Home tab, in the Editing group, click Sort & Filter, and then click Clear.

Top of Page

Overview

A label provides a way for your organization to include a document's properties (or metadata about the document) in the document itself. For example, a law firm may require that notes from meetings with clients be labeled as covered by attorney-client privilege.

You cannot insert a label in a document until the site administrator or list manager configures the appropriate policy for the library or list. If such a policy exists, the Label command appears on the Insert tab so that you can insert labels.

Any document that already exists in the list or library when the policy is established is not assigned a label (which therefore can't be inserted) until the document is checked out and checked back in. Documents that are uploaded to a list or library with a label policy already in effect are automatically assigned labels that can be inserted immediately.

Insert a label manually

Depending upon how a label policy is configured, you can be required to insert labels into documents that reside in libraries on an Office SharePoint Server 2007 site.

Note: You cannot change the formatting of a label, such as font or text size. The formatting is determined by the site administrator or list manager when he or she creates the label policy.

If the library is not already open, click its name on the Quick Launch.

If the name of your library does not appear on the Quick Launch, click View All Site Content, and then click the name of your library.
Point to the document that you want, click the arrow that appears, and then click Edit in Microsoft Office program name — for example, Edit in Microsoft Office Word.
Place your cursor in the location in the document where you want to insert the label.
On the Insert tab, in the Barcode group, click Label.

Note: The Label command appears on the Insert tab only if a label policy is in effect for a server document.
Click Save to save your changes.

Insert a label when you save or print

A library on an SharePoint site can have a label policy that requires you to insert a label when you save or print a document.

If the document does not already contain a label when you save or print, you are prompted to insert one. If you click Yes when prompted, the label is inserted in a default location.

If the file is read-only, the label is inserted at the cursor's current location.
If the file is in Edit mode, the label is inserted in a default location.
- In Word The label is inserted in the header of the first page of the document.
- In Excel The label is inserted in the first cell on the first worksheet in the workbook.
- In PowerPoint The label is inserted in the center of the first slide in the presentation.

Enter hours on your timesheet in project online

The time you spend on tasks and other non-project work is captured on your timesheet.

On the Quick Launch, click Timesheet.
Find the task that you worked on in the list on the left side, and then follow the row across to the right side of the view.

Fill in your hours across the top row of the grid, next to Actual.

Timesheet row

The bottom row of the grid shows the Planned hours, from when the task was initially scheduled in the project.

Tip: Slide the splitter in the middle over to see more of either side of the view.

Splitter between two sides of a timesheet

Understand customer preferences and predict requests

To improve offerings and predict preferences, you need to know as much about your customers as possible. Direct customer input should be obtained and quantified. The compiled information needs to be relevant, shareable and interactive for decision makers to act on.

Details

With Power BI, you can gather historical sales data and turn it into meaningful information to make better decisions. Interactive dashboards let you visualize data and share your analytics with stakeholders.

Use Yammer to get feedback and data directly from your customers by adding them to an external group. Once you have insights, you can start or join relevant internal conversations to share what you've learned. It's easy to differentiate between internal and external Yammer groups, so you always know where information is coming from and who is providing it.

Highlights

Share customer feedback across the company.
Make customer sales data interactive.
Talk directly to customers.

Learn More

BI capabilities in Excel and Microsoft 365

Call a contact on their phone or mobile number

To call someone, do one of the following:

From the left, tap the forth icon, enter the person's phone number, and then tap Call.

To call someone on their work or mobile number, from the left, tap the second icon to get to the Contacts screen. Find the person in your Contacts list or type their name in the search box. When you find the contact, tap their name, and then either their work or mobile number. This will call the person on their work line or mobile phone.

Apply shading to alternate rows or columns in a worksheet

This article shows you how to automatically apply shading to every other row or column in a worksheet.

Windows Web



There are two ways to apply shading to alternate rows or columns —you can apply the shading by using a simple conditional formatting formula, or, you can apply a predefined Excel table style to your data.

One way to apply shading to alternate rows or columns in your worksheet is by creating a conditional formatting rule. This rule uses a formula to determine whether a row is even or odd numbered, and then applies the shading accordingly. The formula is shown here:

=MOD(ROW(),2)=0

Note: If you want to apply shading to alternate columns instead of alternate rows, enter =MOD(COLUMN(),2)=0 instead.

On the worksheet, do one of the following:
- To apply the shading to a specific range of cells, select the cells you want to format.
- To apply the shading to the entire worksheet, click the Select All button.
On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click New Rule.
In the New Formatting Rule dialog box, under Select a Rule Type, click Use a formula to determine which cells to format.
In the Format values where this formula is true box, enter =MOD(ROW(),2)=0, as shown in the following illustration.
Click Format.
In the Format Cells dialog box, click the Fill tab.
Select the background or pattern color that you want to use for the shaded rows, and then click OK.

At this point, the color you just selected should appear in the Preview window in the New Formatting Rule dialog box.
To apply the formatting to the cells on your worksheet, click OK

Note: To view or edit the conditional formatting rule, on the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click Manage Rules.

Another way to quickly add shading or banding to alternate rows is by applying a predefined Excel table style. This is useful when you want to format a specific range of cells, and you want the additional benefits that you get with a table, such the ability to quickly display total rows or header rows in which filter drop-down lists automatically appear.

By default, banding is applied to the rows in a table to make the data easier to read. The automatic banding continues if you add or delete rows in the table.

Banded rows in an Excel table

If you find you want the table style without the table functionality, you can convert the table to a regular range of data. If you do this, however, you won't get the automatic banding as you add more data to your range.

On the worksheet, select the range of cells that you want to format.
On the Home tab, in the Styles group, click Format as Table.
Under Light, Medium, or Dark, click the table style that you want to use.

Tip: Custom table styles are available under Custom after you create one or more of them. For information about how to create a custom table style, see Format an Excel table.
In the Format as Table dialog box, click OK.

Notice that the Banded Rows check box is selected by default in the Table Style Options group.

If you want to apply shading to alternate columns instead of alternate rows, you can clear this check box and select Banded Columns instead.
If you want to convert the Excel table back to a regular range of cells, click anywhere in the table to display the tools necessary for converting the table back to a range of data.
On the Design tab, in the Tools group, click Convert to Range.

Tip: You can also right-click the table, click Table, and then click Convert to Range.

Note: You cannot create custom conditional formatting rules to apply shading to alternate rows or columns in Excel for the web.

When you create a table in Excel for the web, by default, every other row in the table is shaded. The automatic banding continues if you add or delete rows in the table. However, you can apply shading to alternate columns. To do that:

Select any cell in the table.
Click the Table Design tab, and under Style Options, select the Banded Columns checkbox.

To remove shading from rows or columns, under Style Options, remove the checkbox next to Banded Rows or Banded Columns.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

Create a bulleted or numbered list

You can create a bulleted or numbered list in Publisher inside a text box.

Newer versions Office 2007



Create a text box

On the ribbon, select the Insert tab, then click Draw Text Box.
In the document, click where you want to create your text, draw the text box to the size you want, and then release.

Create a bulleted list

On the Home tab, select Bullets to create a bulleted list.
Select the bullet style that you want.
Type the first item in your list, and then do one of the following:

To start a new line with a bullet, press ENTER.

To start a new line without a bullet, press SHIFT+ENTER.

To end a bulleted list, press ENTER twice.

To create sub-bullets, select the bulleted text and then press TAB.

Create a numbered list

On the Home tab, select Numbering to create a numbered list.
Select the numbering format that you want.
Type the first item in your list, and then do one of the following:

To start a new line with a number, press ENTER.

Note: Publisher will automatically number the paragraphs in your list. If you add or delete paragraphs, Publisher will update the numbers.

To start a new line without a number, press SHIFT+ENTER.

To end a numbered list, press ENTER twice.

To create a multilevel numbered list, start a new numbered list, select the numbering style, and then indent the new list.

Note: Office 2007 has reached the end of its support lifecycle, meaning there are no new security updates, non-security updates, free or paid assisted support options, or online technical content updates. Customers who are using Office 2007 products and services should move to Office 365 or upgrade to supported versions of Office products and services, such as Office 2016.

Create a text box

On the Objects toolbar, click the Text Box tool Button image , and then click inside your publication.

Create a bulleted list

On the Format menu, click Bullets and Numbering, and then click the Bullets tab.
Select the options you want, and then click OK.
Type the first item in your list, and then do one of the following:

To start a new line with a bullet, press ENTER.

To start a new line without a bullet, press SHIFT+ENTER.

To create a sub-bullet, select the bulleted text and press TAB.
To end a bulleted list, press ENTER twice.

Create a numbered list

On the Format menu, click Bullets and Numbering, and then click the Numbering tab.
Select the formatting options you want, and then click OK.

Note: Publisher will automatically number the paragraphs in your list. If you add or delete paragraphs, Publisher will update the numbers.
Type the first item in your list, and then do one of the following:

To start a new line with a number, press ENTER.

To start a new line without a number, press SHIFT+ENTER.

To end a numbered list, press ENTER twice.

To create a

Report abuse in onedrive

If you've received a link to an offensive or illegal file or folder stored in OneDrive, you can report it for us to review.

If you're part of an organization that has its own procedures for reporting abuse, please follow your organization's procedures or start by contacting your Office 365 administrator.

On the OneDrive website, sign in with your Microsoft account, and then check your Shared view.

If you don't want to sign in or you want to report the file anonymously, use the anonymous Report Abuse form.
Right-click the offensive or illegal file and select Report abuse.
Select the reason you're reporting the content, such as Harassment or threatening, type any details you want to share in the comment box, and then select Report abuse.

Note: If the offensive content was posted on a work or school account associated with a paid Office 365 subscription, you will be directed to contact the organization responsible for the content directly.

Between and operator

Determines whether the value of an expression falls within a specified range of values. You can use this operator within SQL statements.

Syntax

expr [Not] Betweenvalue1Andvalue2

The Between...And operator syntax has these parts:

Part	Description
expr	Expression identifying the field that contains the data you want to evaluate.
value1, value2	Expressions against which you want to evaluate expr.

Remarks

If the value of expr is between value1 and value2 (inclusive), the Between...And operator returns True; otherwise, it returns False. You can include the Not logical operator to evaluate the opposite condition (that is, whether expr lies outside the range defined by value1 and value2).

You might use Between...And to determine whether the value of a field falls within a specified numeric range. The following example determines whether an order was shipped to a location within a range of postal codes. If the postal code is between 98101 and 98199, the IIf function returns "Local". Otherwise, it returns "Nonlocal".

SELECT IIf(PostalCode Between 98101 And 98199, "Local", "Nonlocal") FROM Publishers

If expr, value1, or value2 is Null, Between...And returns a Null value.

Because wildcard characters , such as *, are treated as literals, you cannot use them with the Between...And operator. For example, you cannot use 980* and 989* to find all postal codes that start with 980 to 989. Instead, you have two alternatives for accomplishing this. You can add an expression to the query that takes the left three characters of the text field and use Between...And on those characters. Or you can pad the high and low values with extra characters — in this case, 98000 to 98999, or 98000 to 98999 – 9999 if using extended postal codes. (You must omit the – 0000 from the low values because otherwise 98000 is dropped if some postal codes have extended sections and others do not.)

Customize your lists

Customize each list by choosing a different background. Just select the three dots in the top right and then select a color or image as your list's background.

Groceries list with the more menu open and a theme selected

You can also add an emoji to the beginning of your list's name and the emoji will be displayed as the list's icon in the sidebar.

Blocking someone will stop their email coming to your Inbox.

Block someone in Outlook.com

To block someone in Outlook.com, select the messages or senders you want to block.
From the top toolbar, select Junk > Block (or Spam > Block).
Select OK. The messages you select will be deleted and all future messages will be blocked from your mailbox.

Notes:

To unblock someone, open your Blocked senders list and select the next to their name.
If you're still receiving email in your Inbox from a sender you blocked, see Receiving email from blocked senders in Outlook.com.

Mark email as junk or spam in Outlook.com

Select the messages you want to mark as junk.
At the top of the screen, select Junk > Junk (or Spam > Spam) to move the message to your Junk or Spam folder.

Notes:

If email is being sent to your Junk folder in error, read Mail goes to the Junk folder by mistake.
Messages in your Junk folder are automatically deleted between 10 and 30 days after they arrive.

Other options to help keep junk or spam out of your inbox

Select the arrow to see more.

This will block everyone except those in your Safe senders list. Remember to include everyone you want to hear from.

Open your Safe senders and domains and select Add.
Type the email addresses or domains of your contacts and other people you want to add, and press Enter.
Under Filters, select from:
- Only trust email from addresses in my Safe senders and domains list and Safe mailing lists
- Block attachments, pictures, and links from anyone not in my Safe senders and domains list
Select Save.

Use this feature to block individuals or organizations.

Open Blocked senders and domains and select Add.
Type the email address or domain that you want to block, and press Enter.
Select Save.
Notes:
- To remove someone from a list, select next to the email address or domain.
- You can have up to 1,024 addresses or domains in the Blocked senders and Safe senders lists. If you want to add more than that, try blocking domains instead of individual email addresses.

Rules can help filter out specific words that repeatedly come from different or hidden email addresses.

Open your Outlook.com Rules and select + Add new rule.
Every rule needs at least three things: a name, a condition, and an action.

Rules can also contain exceptions to conditions. You can add multiple conditions, actions, and exceptions at each step by choosing Add a condition, Add an action, and Add an exception.

For example, to create a rule that deletes all email with the word "weather" in the subject:
Name = "Weather"; Condition = Subject includes "Weather"; Action = Delete
Tips:
- Rules only work on email in your Inbox.
- If you don't want any more rules to run after this one does, select the Stop processing more rules check box. For more information, see Stop processing more rules in Outlook.com.
Press Save to create your rule.

When you post to a message board, newsgroup, chat room, or other public website, spell out your entire email address, for example, chesterbeane AT outlook DOT com. This way, a person can interpret your address, but the automated programs that spammers use often can't.

Spammers get rich when people buy their "products." Don't reply to spam (even to unsubscribe), buy anything from an unfamiliar business, or agree to hold or transfer money for anyone. Beware of messages that appear to come from Microsoft and that ask for your password or threaten to close your account or expire your password. They're false.

You can greatly reduce your risk from hackers, viruses, and worms if you have a firewall, keep your Windows and Microsoft Office software up to date, and install antivirus and anti-spyware software (and update all routinely).

If you want to stop receiving newsletters or promotions, you can unsubscribe from your inbox.

In your inbox, select a newsletter or promotional email.
At the top of the reading pane, select Unsubscribe.

When you shop online, companies sometimes pre-select check boxes that indicate you agree that it's fine to sell or give your email address to responsible parties. If you don't want to receive email from those companies, make sure you clear the check boxes.

Avoid posting your email address on social networking sites, large Internet directories, or job-posting sites. Don't even post it on your own website, unless you disguise it as described in "Disguise your email address", below.

When you sign up for web-based services such as banking, shopping, or newsletters, carefully read the privacy policy before you reveal your email address so you don't unwittingly agree to share confidential information.

The privacy policy should outline the terms and circumstances regarding if or how the site will share your information. If a website doesn't post a privacy statement, consider taking your business elsewhere.

Still need help?

Note: You will need to sign in first to get support. If you can't sign in, go to Account support.

Sunday, November 21, 2021

What do you want to do?

Learn more about reapplying a filter and sort

Reapply a filter or sort

Clear a filter for a column

Clear all filters in a worksheet and redisplay all rows

See Also

In this article

Overview

Insert a label manually

Insert a label when you save or print

Details

Highlights

Learn More

Technique 1: Apply shading to alternate rows or columns by using conditional formatting

Technique 2: Apply shading to alternate rows or columns by using an Excel table style

Need more help?

Syntax

Remarks

In this topic

Tell Me feature

Office support website

Technical support for customers with disabilities

Description

Syntax

Example

Saturday, November 20, 2021

Building block galleries

Insert a building block from a gallery

Create a building block

Add a poll to a Teams channel or chat

Feedback for Microsoft Forms

See Also

See Also

Block someone in Outlook.com

Mark email as junk or spam in Outlook.com

Other options to help keep junk or spam out of your inbox

Block all unknown senders

Use your blocked senders list

Create a rule to remove unwanted email

Disguise your email address

Ignore junk email or instant messages

Improve your computer's security

Unsubscribe from newsletters or promotions

Look for pre-selected check boxes

Share your email address only with people you know

Read the privacy policy

Still need help?

Related Topics