Monday, August 31, 2020

Find or replace text and numbers on a worksheet

Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else. You can include wildcard characters such as question marks, tildes, and asterisks, or numbers in your search terms. You can search by rows and columns, search within comments or values, and search within worksheets or entire workbooks.

Windows Mac Web

Find

To find something, press Ctrl+F, or go to Home > Editing > Find & Select > Find.

Note: In the following example, we've clicked the Options >> button to show the entire Find dialog. By default, it will display with Options hidden.

Press Ctrl+F to launch the Find dialog

  1. In the Find what: box, type the text or numbers you want to find, or click the arrow in the Find what: box, and then select a recent search item from the list.

    Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria.

    • Use the question mark (?) to find any single character — for example, s?t finds "sat" and "set".

    • Use the asterisk (*) to find any number of characters — for example, s*d finds "sad" and "started".

    • Use the tilde (~) followed by ?, *, or ~ to find question marks, asterisks, or other tilde characters  — for example, fy91~? finds "fy91?".

  2. Click Find All or Find Next to run your search.

    Tip: When you click Find All, every occurrence of the criteria that you are searching for will be listed, and clicking a specific occurrence in the list will select its cell. You can sort the results of a Find All search by clicking a column heading.

  3. Click Options>> to further define your search if needed:

    • Within: To search for data in a worksheet or in an entire workbook, select Sheet or Workbook.

    • Search: You can choose to search either By Rows (default), or By Columns.

    • Look in: To search for data with specific details, in the box, click Formulas, Values, Notes, or Comments.

      Note:   Formulas, Values, Notes and Comments are only available on the Find tab; only Formulas are available on the Replace tab.

    • Match case - Check this if you want to search for case-sensitive data.

    • Match entire cell contents - Check this if you want to search for cells that contain just the characters that you typed in the Find what: box.

  4. If you want to search for text or numbers with specific formatting, click Format, and then make your selections in the Find Format dialog box.

    Tip: If you want to find cells that just match a specific format, you can delete any criteria in the Find what box, and then select a specific cell format as an example. Click the arrow next to Format, click Choose Format From Cell, and then click the cell that has the formatting that you want to search for.

Replace

To replace text or numbers, press Ctrl+H, or go to Home > Editing > Find & Select > Replace.

Note: In the following example, we've clicked the Options >> button to show the entire Find dialog. By default, it will display with Options hidden.

Press Ctrl+H to launch the Replace dialog.

  1. In the Find what: box, type the text or numbers you want to find, or click the arrow in the Find what: box, and then select a recent search item from the list.

    Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria.

    • Use the question mark (?) to find any single character — for example, s?t finds "sat" and "set".

    • Use the asterisk (*) to find any number of characters — for example, s*d finds "sad" and "started".

    • Use the tilde (~) followed by ?, *, or ~ to find question marks, asterisks, or other tilde characters  — for example, fy91~? finds "fy91?".

  • In the Replace with: box, enter the text or numbers you want to use to replace the search text.

  1. Click Replace All or Replace.

    Tip: When you click Replace All, every occurrence of the criteria that you are searching for will be replaced, while Replace will update one occurrence at a time.

  2. Click Options>> to further define your search if needed:

    • Within: To search for data in a worksheet or in an entire workbook, select Sheet or Workbook.

    • Search: You can choose to search either By Rows (default), or By Columns.

    • Look in: To search for data with specific details, in the box, click Formulas, Values, Notes, or Comments.

      Note:   Formulas, Values, Notes and Comments are only available on the Find tab; only Formulas are available on the Replace tab.

    • Match case - Check this if you want to search for case-sensitive data.

    • Match entire cell contents - Check this if you want to search for cells that contain just the characters that you typed in the Find what: box.

  3. If you want to search for text or numbers with specific formatting, click Format, and then make your selections in the Find Format dialog box.

    Tip: If you want to find cells that just match a specific format, you can delete any criteria in the Find what box, and then select a specific cell format as an example. Click the arrow next to Format, click Choose Format From Cell, and then click the cell that has the formatting that you want to search for.

There are two distinct methods for finding or replacing text or numbers on the Mac. The first is to use the Find & Replace dialog. The second is to use the Search bar in the ribbon.

Find & Replace dialog

Search bar and options

Replace text or numbers in a workbook or worksheet by pressing Ctrl+H

With the Search bar activated, click the magnifying glass to activate the more search options dialog

To find something, press Ctrl+F, or go to Home > Find & Select > Find.

Find text or numbers in a workbook or worksheet by pressing Ctrl+F

  1. In the Find what: box, type the text or numbers you want to find.

  2. Click Find Next to run your search.

  3. You can further define your search if needed:

    • Within: To search for data in a worksheet or in an entire workbook, select Sheet or Workbook.

    • Search: You can choose to search either By Rows (default), or By Columns.

    • Look in: To search for data with specific details, in the box, click Formulas, Values, Notes, or Comments.

      Note:   Formulas, Values, Notes and Comments are only available on the Find tab; only Formulas are available on the Replace tab.

    • Match case - Check this if you want to search for case-sensitive data.

    • Match entire cell contents - Check this if you want to search for cells that contain just the characters that you typed in the Find what: box.

Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria.

  • Use the question mark (?) to find any single character — for example, s?t finds "sat" and "set".

  • Use the asterisk (*) to find any number of characters — for example, s*d finds "sad" and "started".

  • Use the tilde (~) followed by ?, *, or ~ to find question marks, asterisks, or other tilde characters  — for example, fy91~? finds "fy91?".

To replace text or numbers, press Ctrl+H, or go to Home > Find & Select > Replace.

Replace text or numbers in a workbook or worksheet by pressing Ctrl+H

  1. In the Find what box, type the text or numbers you want to find.

  2. In the Replace with box, enter the text or numbers you want to use to replace the search text.

  3. Click Replace or Replace All.

    Tip: When you click Replace All, every occurrence of the criteria that you are searching for will be replaced, while Replace will update one occurrence at a time.

  4. You can further define your search if needed:

    • Within: To search for data in a worksheet or in an entire workbook, select Sheet or Workbook.

    • Search: You can choose to search either By Rows (default), or By Columns.

    • Match case - Check this if you want to search for case-sensitive data.

    • Match entire cell contents - Check this if you want to search for cells that contain just the characters that you typed in the Find what: box.

Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria.

  • Use the question mark (?) to find any single character — for example, s?t finds "sat" and "set".

  • Use the asterisk (*) to find any number of characters — for example, s*d finds "sad" and "started".

  • Use the tilde (~) followed by ?, *, or ~ to find question marks, asterisks, or other tilde characters  — for example, fy91~? finds "fy91?".

  1. Click any cell to search the entire sheet, or select a specific range of cells to search.

  2. Press Image of the MAC Command button icon +F or click the icon to expand the Search bar, then In the search field Search box , type the text or number that you want to find.

    Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria.

    • Use the question mark (?) to find any single character — for example, s?t finds "sat" and "set".

    • Use the asterisk (*) to find any number of characters — for example, s*d finds "sad" and "started".

    • Use the tilde (~) followed by ?, *, or ~ to find question marks, asterisks, or other tilde characters  — for example, fy91~? finds "fy91?".

  3. Press the Return key.

  4. To find the next instance of the item that you're searching for, click in the search field and press Return, or in the Find dialog box, click Find Next.

    Tip: You can cancel a search in progress by pressing ESC .

  5. To specify additional search options, click the magnifying glass, and then click Search in Sheet or Search in Workbook. You can also select the Advanced option, which will launch the Find dialog.

  1. Click any cell to search the entire sheet, or select a specific range of cells to search.

  2. Press Image of the MAC Command button icon +F to expand the Search bar, then In the search field Search box , type the text or number that you want to find.

    Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria.

    • Use the question mark (?) to find any single character — for example, s?t finds "sat" and "set".

    • Use the asterisk (*) to find any number of characters — for example, s*d finds "sad" and "started".

    • Use the tilde (~) followed by ?, *, or ~ to find question marks, asterisks, or other tilde characters  — for example, fy91~? finds "fy91?".

  3. In the search field, click the magnifying glass, and then click Replace.

  4. In the Replace with box, type the replacement characters.

    To replace the characters in the Find what field with nothing, leave the Replace with field empty.

  5. Click Find Next.

  6. To replace the highlighted occurrence, click Replace.

    To replace all occurrences of the characters in the sheet without reviewing them first, click Replace All.

    Tip: Cancel a search that is in progress simply by pressing ESC.

  7. To specify additional search options, click the magnifying glass, and then click Search in Sheet or Search in Workbook. You can also select the Advanced option, which will launch the Replace dialog.

Find

To find something, press Ctrl+F, or go to Home > Editing > Find & Select > Find.

Note: In the following example, we've clicked > Search Options to show the entire Find dialog. By default, it will display with Search Options hidden.

Find text or numbers in a workbook or worksheet by pressing Ctrl+F

  1. In the Find what: box, type the text or numbers you want to find.

    Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria.

    • Use the question mark (?) to find any single character — for example, s?t finds "sat" and "set".

    • Use the asterisk (*) to find any number of characters — for example, s*d finds "sad" and "started".

    • Use the tilde (~) followed by ?, *, or ~ to find question marks, asterisks, or other tilde characters  — for example, fy91~? finds "fy91?".

  2. Click Find Next or Find All to run your search.

    Tip: When you click Find All, every occurrence of the criteria that you are searching for will be listed, and clicking a specific occurrence in the list will select its cell. You can sort the results of a Find All search by clicking a column heading.

  3. Click > Search Options to further define your search if needed:

    • Within: To search for data within a certain selection, choose Selection. To search for data in a worksheet or in an entire workbook, select Sheet or Workbook.

    • Direction: You can choose to search either Down (default), or Up.

    • Match case - Check this if you want to search for case-sensitive data.

    • Match entire cell contents - Check this if you want to search for cells that contain just the characters that you typed in the Find what box.

Replace

To replace text or numbers, press Ctrl+H, or go to Home > Editing > Find & Select > Replace.

Note: In the following example, we've clicked > Search Options to show the entire Find dialog. By default, it will display with Search Options hidden.

Replace text or numbers in a workbook or worksheet by pressing Ctrl+H

  1. In the Find what: box, type the text or numbers you want to find.

    Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria.

    • Use the question mark (?) to find any single character — for example, s?t finds "sat" and "set".

    • Use the asterisk (*) to find any number of characters — for example, s*d finds "sad" and "started".

    • Use the tilde (~) followed by ?, *, or ~ to find question marks, asterisks, or other tilde characters  — for example, fy91~? finds "fy91?".

  2. In the Replace with: box, enter the text or numbers you want to use to replace the search text.

  3. Click Replace or Replace All.

    Tip: When you click Replace All, every occurrence of the criteria that you are searching for will be replaced, while Replace will update one occurrence at a time.

  4. Click > Search Options to further define your search if needed:

    • Within: To search for data within a certain selection, choose Selection. To search for data in a worksheet or in an entire workbook, select Sheet or Workbook.

    • Direction: You can choose to search either Down (default), or Up.

    • Match case - Check this if you want to search for case-sensitive data.

    • Match entire cell contents - Check this if you want to search for cells that contain just the characters that you typed in the Find what box.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

at No comments:

Video adding events to a sharepoint calendar

Make a big impact with Announcements

Note: SkyDrive is now OneDrive, and SkyDrive Pro is now OneDrive for Business. Read more about this change at From SkyDrive to OneDrive.

In less than 2 minutes, learn how to add events to a SharePoint calendar. You can use a calendar to store 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 specific to a time interval.

at No comments:

Accessibility support for staffhub

at No comments:

Work on promo event handouts as a team

Email works well for some types of communication, but if you're brainstorming the perfect handout for an upcoming promotional event, email collaboration can become unwieldyYou need one place where you can work together in real time, coauthor files, and quickly receive approval.

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

Details  

With Microsoft Teams, you can chat in real time, share design files for your promo event handouts, coauthor documents, and keep conversations all in one place. You can also launch a live audio or video call to easily share updates and resolve issues in preparation for the event. 

Images and other assets you upload to Microsoft Teams are automatically saved to SharePoint, so you can easily search for the files you need and avoid version-control problems. You can also store contact and tracking information in the same location, so no one has to spend valuable time hunting for missing information.

Highlights

  • Work with colleagues and internal experts in real time.

  • Quickly share crucial information with the entire team for collective input.

  • Easily access content and tools in a secure, centralized repository.

Learn More

Work in channels

at No comments:

Compare two versions of a workbook by using spreadsheet compare

If other people can edit your workbook, you might open it and wonder "Who changed this? And what did they do?" Microsoft Spreadsheet Compare can answer these questions by finding these changes and highlighting them for you.

Important:  Spreadsheet Compare is only available with Office Professional Plus 2013 or Microsoft 365 Apps for enterprise.

  1. Open Spreadsheet Compare.

  2. In the lower-left pane, choose the options you want included in the workbook comparison, such as formulas, cell formatting, or macros. Or, just Select All.

  3. On the Home tab, choose Compare Files.
    Compare Files

  4. In the Compare Files dialog box, in the Compare row, browse Browse to the earlier version of your workbook. In addition to files saved on your computer or on a network, you can enter a web address to a site where your workbooks are saved.

    Compare Files command

  5. In the Compare Files dialog box, in the To row, browse Browse to the version you want to compare that earlier version against.

    Note:  You can compare two files with the same name if they're saved in different folders.

  6. Choose OK to run the comparison.

Note:  If you get an "Unable to open workbook" message, this might mean a workbook is password protected. Click OK and then enter the password. Learn more about how passwords and Spreadsheet Compare work together.

The results of the comparison appear in a two-pane grid. The workbook on the left corresponds to the "Compare" file you chose and the workbook on the right corresponds to the "To" file. Details appear in a pane below the two grids. Changes are highlighted by color, depending on the kind of change.

Comparison results

Understanding the results

  • In the side-by-side grid, a worksheet for each file is compared to the worksheet in the other file, beginning with the leftmost worksheet in each. If a worksheet is hidden in a workbook, it's still shown and compared in Spreadsheet Compare.

  • If the cells are too narrow to show the cell contents, click Resize Cells to Fit.
    Resize Cells

  • Differences are highlighted with a cell fill color or text font color, depending on the type of difference. For example, cells with "entered values" (non-formula cells) are formatted with a green fill color in the side-by-side grid, and with a green font in the pane results list. The lower-left pane is a legend that shows what the colors mean.

Other ways to work with the comparison results

If you want to save your results or analyze them elsewhere, you can export them to an Excel file or copy and paste them into in another program, such as Microsoft Word. There's also an option for getting a high-fidelity look at each worksheet that shows the cell formatting, close to what you'd see it in Excel.

  • You can export the results to an easier to read Excel file. Click Home > Export Results.

  • Click Home > Copy Results to Clipboard to copy and paste the results to another program.

  • To show cell formatting from the workbook, click Home > Show Workbook Colors.

Other reasons to compare workbooks

  • Say your organization is due to be audited. You need a trail for your critical workbooks that shows the changes month over month or year over year. This trail can help you find and correct mistakes before the auditors find them.

  • In addition to comparing contents of worksheets, you can use Spreadsheet Compare to check for differences in VBA (Visual Basic for Applications) code. The results are returned in a window in which you can see the differences side by side.

at No comments:

Search for email in outlook for windows

In Outlook, use Instant Search to quickly find emails in your crowded inbox or in one of your many folders.

Save time with Search

  1. Select the search box.

  2. Type what you're looking for, like part of a subject or a contact's name.

  3. If you want to narrow your search, select one of the options in the Search tab that appears:

    • From

    • Subject

    • Has Attachments

    • Categorized

    • This Week

    • Sent To

    • Unread

    • Flagged

    • Important

    • Recent Searches

    • More commands

If you need to search for contacts or events:

  1. Select Calendar or People.

  2. Select the search box in either location and type the contact or event you are searching for.

Using Search to find your email in Outlook

Using Search in Outlook

Using search in Outlook to find contacts

Note: Features and information in this guide apply to Outlook Mail as available through Microsoft 365.

at No comments:

Sunday, August 30, 2020

Use a codec to play windows media files

If you're getting an error message that says an additional plug-in is required to play back Windows Media in your presentation, you likely need to download a plug-in like Flip4Mac or Switch before you can play some Windows Media files. Read this page to see which plug-in supports your version of Mac OS X.

at No comments:

Lcase function

Returns a String that has been converted to lowercase.

Syntax

LCase ( string )

The required stringargument is any valid string expression. If string contains Null, Null is returned.

Remarks

Only uppercase letters are converted to lowercase; all lowercase letters and nonletter characters remain unchanged.

Query example

Expression

Results

SELECT LCase(ProductDesc) AS Lower_ProductDesc FROM ProductSales;

Converts the values from "ProductDesc" field into Lowercase and displays in column Lower_ProductDesc.

VBA example

Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box.

This example uses the LCase function to return a lowercase version of a string.

Dim UpperCase, LowerCase
Uppercase = "Hello World 1234"    ' String to convert.
Lowercase = Lcase(UpperCase) ' Returns "hello world 1234"

See Also

String functions and how to use them

at No comments:

Shapes stencils and templates in visio 2013

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


Shapes, stencils, and templates are the main building blocks of Visio 2013. Mastering them is the key to making meaningful diagrams for almost every purpose.

Inside this course:

Work with Visio shapes (1:34)
If you're beginner at Visio, you need to understand one concept first. And that is: In Visio, almost anything is a shape. Take this course to understand the basics of Visio shapes and how to work with them.

Two kinds of Visio shapes: 1-D and 2-D (2:56)
There are two kinds of shapes in Visio: 1-D and 2-D. You can identify them easily by selecting them and looking at their handles. This video will explain how, and also explain what each kind of shape is for.

Visio stencils and templates (3:06)
What's a Visio stencil? This video tutorial will explain. It will also explain the different between a Visio stencil and a Visio template.

Search for Visio shapes (1:38)
If you don't see a shape you want, trying searching Visio for one. This training video will explain how to do that, plus you'll learn how to browse other Visio stencils for shapes that you want.

Draw and download Visio shapes (2:32)
Lines, circles, rectangles - they're all easily drawn using Visio. Watch this video to learn how.

Course summary
A brief reminder of the key points in this course.

More courses available at Microsoft Office Training.

at No comments:

Known issues opening irm protected emails sent from users in other office 365 organizations

In some cases, Outlook may be unable to open a message sent from a user in a different Microsoft 365 organization if the message has been protected with Information Rights Management.

Symptoms

When you try to open a protected message sent from a user in a different Microsoft 365 organization – even if you are signed in to Office with an account that has permission to open that message – you're unable to open it, and you may see one of the following notifications:

  1. A message that says: You are not signed in to Office with an account that has permission to open this message. You may sign in a new account into Office that has permission or request permission from the content owner.

    • Selecting Add Account and signing in again does not resolve the issue.

  2. A Sign inwindow that asks you to Type the email of the account you would like to use to open this message.

    • Signing in does not resolve the issue.

  3. An Accounts window that shows you the account(s) currently signed in to Office.

    • Selecting the appropriate account does not resolve the issue.

    • Selecting Add Account and signing in again does not resolve the issue.

Resolution

Outlook 365 versions

Several issues pertaining to decrypting and opening IRM-protected messages sent from users in other Microsoft 365 organizations have been fixed in the following Outlook subscription version:

  • Outlook 365: version 1808+

If your Outlook version is older than the version listed above, please update to the newest version and try again. To find your version number, see About Office: What version of Office am I using?

Tip: Microsoft 365 has multiple release channels that deliver updates on different schedules. This page details which versions are currently available in which channels.  

Outlook perpetual versions

If you can view your email in Outlook on the web, The Outlook standalone versions haven't yet been patched with the fixes released to Outlook for Microsoft 365. Fixes are currently in development for the following versions.

  • Outlook 2016

  • Outlook 2019

This page will be updated with information about updates for the standalone perpetual versions of Outlook when the updates are released.

Notes: 

  • This issue will not be fixed in Outlook versions that are out of mainstream support, such as Outlook 2010 and Outlook 2013.

  • You can use Outlook on the web to view these IRM-protected messages.

at No comments:

Outlook com shared calendar is no longer editable or syncing after migration

Last updated: July 20, 2017

STATUS: FIXED

This issue is fixed in the latest updates.

To ensure that your calendars and email sync correctly, reconnect your Outlook.com account to Outlook for Windows. For detailed instructions, see Reconnect Outlook 2016 or Outlook 2013 to Outlook.com for uninterrupted email access.

More Resources

Icon Experts (brain, gears)

Ask the experts

Connect with experts, discuss the latest Outlook news and best practices, and read our blog.

Outlook Tech Community

Icon Community

Get help in the community

Ask a question and find solutions from Support Agents, MVPs, Engineers, and Outlook users.

Outlook Forum on Answers

Icon feature request (light bulb, idea)

Suggest a new feature

We love reading your suggestions and feedback! Share your thoughts. We're listening.

Outlook UserVoice

See Also

Fixes or workarounds for recent issues in Outlook for Windows

Resolve Outlook for Windows issues with automated troubleshooting tools  

at No comments:

Video update your profile

Make a big impact with Announcements

Try it!

Keep your Office profile up to date so your teammates can get to know more about you, what skills you have, and what you're working on right now.

Edit your profile page

  1. Sign in to office.com/signin with your Microsoft 365 for business.

  2. Select your profile picture.

  3. Select My profile.

  4. Select Update profile.

  5. Update the information you want, such as About me, Projects, and more.

    Note: To keep some information private, select the globe The globe shows that everyone can see the information and then select Only you can see this. Some information you might not be able to edit because it is controlled by your IT or HR department.

Change your profile picture

  1. Select Upload a new photo.

  2. Select Change your photo.

    If you see the photo pane, skip this step.

  3. Select Upload a new photo.

  4. Select a picture, and then select Open.

  5. Select Set as profile photo.

  6. Select Close

Change the cover photo

  1. Select Change cover photo.

  2. Select a category of photos.

  3. Select a photo from the list or select Colors

Want more?

View and update your profile in Office Delve

What is Microsoft 365?

Word training

Excel training

PowerPoint training

Outlook training

at No comments:
View web version