When you think of Excel (our most important Excel tips8 Tips for How to Learn Excel Quickly8 Tips for How to Learn Excel QuicklyNot as comfortable with Excel as you would like? Start with simple tips for adding formulas and managing data. Follow this guide, and you'll be up to speed in no time.Read More), you probably think of numbers, calculations, and formulas. But, you also add text to spreadsheets, like headings, descriptions, or people’s names.
- Shortcut Key For Wrap Text In Excel
- Key Function For Wrap Text Powerpoint Macros
- Wrap Text Powerpoint
- Click on the PowerPoint slide to see the wrapped text. (If you use PowerPoint 2016 for Mac, you need to close the Word file before you can see the wrapped text in PowerPoint.) In PowerPoint, the image and wrapped text are in a box that you can drag and resize.
- By Dan Gookin. Graphics in a Word 2016 document must cohabit well with the text. To keep both happy, you must understand Word’s image layout options. For smaller images, or images that otherwise break up a document in an inelegant manner, choose one of the text-wrapping layout options.
Today we’ll cover various ways of working with text in Excel spreadsheets. We discuss several different functions for working with text. Whenever you use a function, always start it with an equals sign (=).
Wrap Text in a Cell
Function Key Shortcuts. F1 Open PowerPoint Help Window (all views except Slide Show view) Opens a list of Slide Show shortcut keys (Slide Show view)F2 Activate text editing in a text object such as a placeholder, box, or shape.
When you enter text in a cell that’s wider than the cell, the text goes past the right border of the cell by default. But it’s easy to have the text wrap to fit the column width. The text wrap adjusts automatically when you change the width of the cell.
To make text wrap in a cell, select the cell and click the Wrap Text button in the Alignment section of the Home tab.
The text is wrapped in the cell and the row height automatically adjusts to fit the text.
If the row height does not automatically adjust, the row may be set to a specific height.
To automatically fit the row height to the text, select the cell. Then, click Format in the Cells section on the Home tab and select AutoFit Row Height.
If you want to keep the row at a specific height, you can change it to make sure the wrapped text fits. Select Row Height from the Format menu. Then, enter a height for the row on the Row Height dialog box and click OK.
You can also drag the bottom border of the row down until all the lines of text fit in the cell.
Enter a Line Break in a Cell
If the text in a cell goes past the right border, you can also insert a line break to manually make the text wrap.
Double-click on the cell to edit the text or press F2. Click the mouse at the point in the text where you want to insert a line break. Then, press Alt + Enter.
The row height adjusts to fit the text if the Format is set to AutoFit Row Height in the Cells section of the Home tab.
Count Cells Containing Any Text
![Key Function For Wrap Text Powerpoint Mac Key Function For Wrap Text Powerpoint Mac](/uploads/1/2/6/1/126100279/146853244.png)
If you want to know how many cells in a range on your worksheet contains text (not numbers, errors, formulas, or blank cells), you can use the COUNTIF functionMini Excel Tutorial: Using Advanced Counting and Adding Functions in ExcelMini Excel Tutorial: Using Advanced Counting and Adding Functions in ExcelCounting and adding formulas may appear mundane compared to more advanced Excel formulas. But they can help you save a lot of time when you need to collect information about the data in your spreadsheet.Read More.
The generic form of the COUNTIF function for counting any number of text characters is:
The cellrange represents any range of cells like B2:B9. The asterisk between the quotes is a wildcard character that represents any matching number of text characters. There are a few things to note about what are considered text characters:
- The logical values TRUE and FALSE are not counted as text.
- Numbers that are entered as text are counted in the wildcard character (*).
- A blank cell that begins with an apostrophe (‘) is counted.
For example, to count the number of cells containing text in the cell range A2:G9 in the following worksheet, we enter “=COUNTIF(“. Then, to enter the cell range, we select the cells we want to include in the count.
The COUNTIF function is not case sensitive.
Then, we type a comma (,) and the wildcard character (*) surrounded by double quotes.
Press Enter to complete the function entry and view the result in the cell.
Count Cells Containing Specific Text
You can also use the COUNTIF function to count how many cells contain specific text characters.
The generic function for counting the occurrences of a specific string text characters is:
Just like in the previous section, the cellrange represents any range of cells like B2:B9. We put the string of text characters we want to find between double quotes.
For example, to count the number of cells containing “Pencil” in the cell range A2:G9 on following worksheet, we enter the following function:
This finds all the cells containing just the word “Pencil” with no other text in the cell. Because the COUNTIF function is not case sensitive, it will find all cells containing “Pencil” or “pencil”.
The COUNTIFS function allows you to count cells with text but exclude cells with specific text characters.
For example, we use COUNTIFS in the following way to find all cells containing any text except for “Pencil”.
For the COUNTIFS function, you first give it the range and the text you want to find. Then, give it the same range again and the text you want excluded. The “<>” is used to exclude whatever text follows.
When using either the COUNTIF or COUNTIFS function, you can add an asterisk on one or both sides of the string to find cells that contain that string surrounded by any number of text characters (or none).
For example, to find all cells containing the letter “j”, we use the following function:
Again, because the COUNTIF function is not case sensitive, cells containing “j” or “J” will be counted.
Convert Text to Numbers
If you have a lot of cells that contain numbers stored as text, there are a few ways you can convert the text to numbers.
You can tell if a number is formatted as text when it’s left-aligned in the cell instead of right-aligned. Also, if a number has been forcefully formatted as text using an apostrophe (‘) at the beginning, there will be a green triangle in the upper-left corner of the cell.
To convert text to numbers you can use the Convert to Number option, the Text to Columns feature, or Paste Special. We discuss each of these methods in our article about extracting numbers and text in Excel.
Convert a Number to Text
There may be times when you want to store numbers as text. Maybe you’re performing an action on a range of cells and there are certain cells you don’t want to read as numbers, even though they are.
Typing an apostrophe (‘) at the beginning of a number converts it to text. But if you have a lot of cells with numbers you want to convert to text, you can use the TEXT function.
For example, we want to convert the numbers in the B column shown below to text. We type the following function into the cell to the right of the first number.
You give the function the cell reference for the number to convert and then the number format you want. We’re just converting to a number with no special formatting (not currency or a date, for example). So we use “0” (zero).
Use the AutoFill featureHow to Use Excel's Flash Fill and Auto Fill to Automate Data EntryHow to Use Excel's Flash Fill and Auto Fill to Automate Data EntryWhen you regularly create Excel spreadsheets and populate them with data, you have to know about Auto Fill and Flash Fill. Let us show you what these features do and how they can help you.Read More to copy the TEXT function to the rest of the cells. The numbers become text and are left-aligned.
You can copy and paste the converted values into the original column. Select the cells containing the TEXT function and press Ctrl + C to copy them. Select the first cell in the original column. On the Home tab, click the arrow on the Paste button and go to Paste Special > Values.
You can find examples of the different text formatting available for use in the TEXT function on Microsoft’s support site.
Convert Text to a Date
Have you ever gotten a workbook from someone else in which they entered dates as text, as numbers, or in a format not recognizable as dates? You can convert text to dates using the DATE function.
Here’s the generic format of the DATE function:
For the year, month, and day, we’re going to use the LEFT, MID, and RIGHT string functions to extract the appropriate parts of the text or number we want to convert. We’ll explain the four examples in the image below.
To convert “20171024” in cell C2 to a date, we used the LEFT function to extract the first four characters for the year (2017). Then, we used the MID function to extract the two characters starting at the fifth position as the month (10). Finally, we used the RIGHT function to extract the last two characters as the day (24).
The next example, “2102018” in cell C3, is in a different order. We still use the string functions but in a different order. We used the RIGHT function to extract the last four characters for the year (2018). The month is only one digit in this case, so we used the LEFT function to extract the first character as the month (2). Finally, we used the MID function to extract the two characters starting at the second position as the day (10).
The dates in cells C4 and C5 look like normal dates, but Excel doesn’t recognize them as dates. In cell C4, the format is day, month, year. So we use the RIGHT, MID, and LEFT functions in the following way:
In cell C5, the format is month, day, and year, using two a zero in front of a single-digit month. So we use the RIGHT, LEFT, and MID functions in the following way:
Using the DATE function may seem like just as much work as retyping the text as dates. But it’s a good likelihood that the same format was used throughout your workbook if one person worked on it.
In that case, you can copy and paste the function and the cell references will adjust to the correct cells. If they don’t, simply enter the correct cell references. You can highlight a cell reference in a function and then select the cell you want to enter that reference.
Combine Text From Multiple Cells
If you have a large amount of data on a worksheet and you need to combine text from multiple cells, there’s an easy way to do so. You don’t have to retype all that text.
For example, we have a worksheet containing names of employees and their contact information, as shown below. We want to separate the First Name and Last Name and then combine them into a Full Name column. We can also create an Email Address automatically by combining the first and last name.
To do this, we use the CONCATENATE function16 Excel Formulas that Will Help You Solve Real Life Problems16 Excel Formulas that Will Help You Solve Real Life ProblemsThe right tool is half the work. Excel can solve calculations and process data faster than you can find your calculator. We show you key Excel formulas and demonstrate how to use them.Read More. To “concatenate” simply means “to combine” or “to join together.” This function allows you to combine text from different cells into one cell. You can also add any other text to the text from other cells.
To combine the Last Name and First Name in one row into the Full Name column, we use the CONCATENATE function in the following way:
Give the CONCATENATE function the text to combine in the order you want it put together. So we gave the function the First Name (B2), a space in double quotes (” “), then the Last Name (A2).
We can also build the email address in the same way. We use the First Name (B2), the Last Name (A2), and then the rest of the email address (@email.com) in double quotes.
Always put any specific text in double quotes, but do not put quotes around cell references.
Separate Text Into Multiple Cells
Do you have some cells with mixed format content that you want to separate? For example, if you have a cell containing “14 turkey sandwiches”, you can separate that into the number (14) and the text (turkey sandwiches). That way, you can use the number in functions and formulas.
To get the number out of “14 turkey sandwiches”, we use the LEFT string function.
First, we give the function the cell reference for the text from which we want to extract the number (B2). Then, we use the SEARCH function to find the first space after the first character in the string.
To get the text out of “14 turkey sandwiches”, we use the RIGHT string function.
First, we give the RIGHT function the cell reference from which we want to extract the text (B2). Then, we use the LEN and SEARCH functions to determine how many characters in from the right we want to get. We’re subtracting the number of characters from the first space after the first character in the string to the end of the string from the total length of the string.
Get more details about separating text into multiple cells in our article about extracting text or numbers from mixed format cells.
More on Working With Text Functions in Excel
Sometimes the spreadsheet you are working on will have too much of text. These will help you simplify it.
You can find more details about the functions we discussed here in our article about text operationsSaving Time with Text Operations in ExcelSaving Time with Text Operations in ExcelExcel can do magic with numbers and it can handle characters equally well. This manual demonstrates how to analyze, convert, replace, and edit text within spreadsheets. These basics will allow you to perform complex transformations.Read More, as well as information about some additional related functions we didn’t mention here.
Explore more about: Microsoft Excel, Microsoft Office 2016.
-
Well written, clear explanations, good examples.
Need to create and share a presentation? If so, you probably turn to the most popular presentation application in the world, Microsoft PowerPoint for Windows. Although Microsoft has just announced the availability of Office 2019 to commercial users, many businesses will stick with Office 2016 (and thus PowerPoint 2016) for some time to come — especially because the company is now saying that Office 2016 users can connect to Microsoft’s online services until 2023.
Although you might have been using PowerPoint 2016 for some time now, you might be missing out on some of its worthwhile features. In this story, we’ll clue you in on the most important features introduced in PowerPoint 2016 for Windows.
Your copy of PowerPoint 2016 may have been purchased as standalone software or as part of an Office 365 subscription. The subscription version gets continually updated, while the standalone version (which Microsoft calls the perpetual version) stays static. But fear not, we’ve got help for whichever version you use. The first part of the article covers features available in both versions, while the later sections focus on features available only to Office 365 subscribers. Then we wrap things up with a list of handy keyboard shortcuts for all PowerPoint 2016 users.
Share this story: IT folks, we hope you'll pass this guide on to your users to help them learn to get the most from PowerPoint 2016.
Use the Ribbon
The Ribbon interface that you came to know and love (or perhaps hate) in earlier versions of PowerPoint hasn't changed much in PowerPoint 2016. Because the Ribbon has been included in Office suite applications since Office 2007, we assume you're familiar with how it works. If you need a refresher, see our PowerPoint 2010 cheat sheet.
As in PowerPoint 2013, the Ribbon in PowerPoint 2016 has a flattened look that's cleaner and less cluttered than in PowerPoint 2010 and 2007. The 2016 Ribbon is smaller than it was in PowerPoint 2013, the title bar now is now red rather than the previous white, and the text for the Ribbon tabs (File, Home, Insert and so on) is now a mix of upper- and lowercase rather than all caps. But it still works in the same way, and you'll find most of the commands in the same locations as in PowerPoint 2013.
To find out which commands live on which tabs on the Ribbon, download our PowerPoint 2016 Ribbon quick reference. Also see the nifty new Tell Me feature described below.
As in previous versions of PowerPoint, if you want the Ribbon commands to go away, press Ctrl-F1. (Note that the tabs above the Ribbon — File, Home, Insert and so on — stay visible.) To make them appear again, press Ctrl-F1.
You’ve got other options for displaying the Ribbon as well. To get to them, click the Ribbon Display Options icon at the top right of the screen, just to the left of the icons for minimizing and maximizing PowerPoint. A dropdown menu appears with these three options:
- Auto-hide Ribbon: This hides the entire Ribbon, both the tabs and commands underneath them. To show the Ribbon again, click at the top of PowerPoint.
- Show Tabs: This shows the tabs but hides the commands underneath them. It’s the same as pressing Ctrl-F1. To display the commands underneath the tabs when they’re hidden, press Ctrl-F1, click a tab, or click the Ribbon display icon and select “Show Tabs and Commands.”
- Show Tabs and Commands: Selecting this shows both the tabs and commands.
And if for some reason that nice red color on the title bar is just too much for you, you can turn it white, gray or black. To do it, select File > Options > General. In the 'Personalize your copy of Microsoft Office' section, click the down arrow next to Office Theme, and select Dark Gray, Black or White from the dropdown menu. To make the title bar red again, instead choose the 'Colorful' option from the dropdown list. Just above the Office Theme menu is an Office Background dropdown menu — here you can choose to display a pattern such as a circuit board or circles and stripes in the title bar.
If you're working in a presentation you've saved in OneDrive or SharePoint, you'll see a new button on the Ribbon, just to the right of the Share button. It's the Activity button, and it's particularly handy for shared presentations. Click it and you'll see the history of what's been done to the presentation, notably who has saved it and when. To see a previous version, click the 'Open version' link underneath when someone has saved it, and the older version will appear.
There’s also a very useful difference in what Microsoft calls the backstage area that appears when you click File on the Ribbon: If you click Open, Save a Copy, Save or Save As from the menu on the left, you can see the cloud-based services you've connected to your Office account, such as SharePoint and OneDrive. Each location now displays its associated email address underneath it. This is quite helpful if you use a cloud service with more than one account, such as if you have one OneDrive account for personal use and another one for business. You'll be able to see at a glance which is which.
You can also easily add new cloud-based services. From the screen that shows you your online locations, click “Add a Place,” and choose which service to add. Note, though, that you’re limited to SharePoint and OneDrive.
Use Tell Me to accomplish tasks quickly
PowerPoint is so chock-full of powerful features that it can be tough to remember where to find them all. PowerPoint 2016 has made it easier with a new feature called Tell Me, which puts even buried tools or those you rarely use in easy reach.
To use it, click the 'Tell me what you want to do' text to the right of the Help tab on the Ribbon. (Those who prefer keyboard shortcuts can instead press Alt-Q.) Then type in a task you want to do, such as 'change handout orientation.' You'll get a menu showing potential matches for the task.
In this instance, the top result is a Handout Orientation listing that when clicked gives you two options — one to set the orientation to horizontal and the other to vertical. Just click the one you want to use. If you'd like more information about your task, the last two items that appear in the Tell Me menu let you select from related Help topics or search for your phrase using Smart Lookup. (More on Smart Lookup below.)
Even if you consider yourself a PowerPoint pro, give Tell Me a try. It'll save you lots of time and is much more efficient than hunting through the Ribbon to find a command. It also remembers the features you've previously clicked on in the box, so when you click in it, you first see a list of previous tasks you've searched for. That makes sure that tasks that you frequently perform are always within easy reach, while at the same time making tasks you rarely do easily accessible.
Try Smart Lookup for online research
If you do research to gather information for presentations, you’ll want to check out another new feature, Smart Lookup. It lets you do online research from right within PowerPoint while you're working on a presentation, so there’s no need to fire up your browser, search the web, and then copy the information to your presentation.
Shortcut Key For Wrap Text In Excel
To use Smart Lookup, right-click a word or group of words and select Smart Lookup from the menu that appears. PowerPoint 2016 then uses Bing to do a web search on the word or phrase and displays definitions, any related Wikipedia entries, and other results from the web in the Smart Lookup pane that appears on the right. If you just want a definition of the word, click the Define tab in the pane.
Smart Lookup has been getting smarter over time. When the feature first launched, it wasn’t very good at finding specific, timely information such as the current inflation rate in the United States. It was much better at finding more general information, such as a biography of the artificial intelligence pioneer Arthur Samuel. But Microsoft has done a lot of work on it, and it now works well when finding granular information as well.
Keep in mind that in order to use Smart Lookup in PowerPoint or any other Office 2016 app, you might first need to enable Microsoft's intelligent services feature, which collects your search terms and some content from your presentations and other documents. (If you're concerned about privacy, you'll need to decide whether the privacy hit is worth the convenience of doing research from right within the app.) If you haven't enabled it, you'll see a screen when you click Smart Lookup asking you to turn it on. Once you do so, it will be turned on across all your Office 2016 applications.
Key Function For Wrap Text Powerpoint Macros
Collaborate in real time
The most important feature in PowerPoint 2016 for those who work with others is real-time collaboration that lets people work on presentations together from anywhere in the world with an internet connection. To do it, you must be logged into your Microsoft or Office 365 account, and the document must be stored in OneDrive, OneDrive for Business or SharePoint Online.
To collaborate on a document, open it, then click the Share icon in the upper-right part of the screen. If you haven’t yet saved your file in OneDrive, OneDrive for Business or SharePoint Online, you’ll be prompted to do so. If you’re an Office subscriber, make sure the AutoSave button on the upper right of the screen is switched to On. If it isn’t, you won’t be able to work live on documents with other people.
What happens next depends on whether your document is stored in your own OneDrive or with OneDrive for Business or SharePoint Online. In May 2017, Microsoft rolled out a new sharing interface to enterprise Office 365 users that it says is simpler and gives greater control over who has access to your content. A Microsoft representative told us that the company intends to roll out the newer interface to consumers with an Office 365 subscription at some point, but it hasn’t announced timing yet. The new interface isn’t planned for non-subscription versions of Office 2016 or earlier. So we’ll give instructions for both interfaces below.
If your document is stored in your personal OneDrive: After you’ve saved your document to OneDrive and clicked the Share button, the Share pane opens on the right-hand side of the screen. Think of the pane as command central for collaboration. At the top of the pane, type in the email addresses of the people with whom you want to collaborate on the document, separated by commas. As you type, PowerPoint looks through your address book and displays the matches it finds; click the person you want to invite. If you’re on a corporate network, you can click the address book on the right to search through your corporate email address book. If a person isn’t in your address book, type in the complete email address.
After you enter the addresses, select either 'Can edit' or 'Can view' in the dropdown to allow collaborators full editing or read-only privileges. (If you want to assign different rights to different users, send separate emails, or you can change any collaborator’s permissions later by right-clicking their name in the Share pane.) Type a message in the text box if you want. When you’re done, click Share. An email is sent out to everyone with whom you’ve shared the file, showing a “View in OneDrive” button that they can click to open the document.
There’s another way to share a file stored in a personal OneDrive for collaboration: At the bottom of the Share pane, click “Get a sharing link,” and from the screen that appears, choose “Create an edit link” if you want to create a link to the file that will allow people to edit the file, or “Create a view-only link” if you want to create a link that will allow them to view the file only. Then create an email using any email program, copy the link and send it.
If you want to instead send the file but don’t want to let people collaborate on it, at the bottom of the Share pane click “Send as attachment.” You can then send the file either in PowerPoint format or else as a PDF. When you do this, it won’t reflect any changes you make to it after you send the file.
If your document is stored in SharePoint Online or OneDrive for Business: Click the Share button. That pops up a Send Link window. From here you can send an email with a link where others can access the document.
By default, only the people whose email addresses you enter will be able to edit the document, but you can click the permission box to expand access to anyone who already has access to the file, anyone in your organization, or anyone at all. (You can uncheck the “Allow editing” box to set any of those permissions to read-only.)
Back in the main Send Link window, enter the recipients’ email addresses (as you type, Excel will suggest people from your address book whom you can select), optionally type in a message, and click Send. An email is sent to all the recipients, with a link they can click to open the document.
To begin collaboration: Whether the email recipients get is associated with a personal or business OneDrive account, they click a button or link to open the document, which opens in PowerPoint Online in a web browser rather than in the PowerPoint desktop client. In order to collaborate, they’ll need to click the Edit Presentation button at the top of the screen. From the dropdown list, they can then choose to open the file either in the client version of PowerPoint or in the free web version. (OneDrive for Business and SharePoint users with Office 365 subscriptions see something slightly different — they can begin editing immediately in the web version or else click the “Open in PowerPoint” link to work in the client version.)
Wrap Text Powerpoint
The web version isn’t as fully featured as the client version — for instance, there aren’t as many transitions and animations, you can’t record your screen from inside PowerPoint, and you can’t give slideshows or use several other features. But for basic editing, it works fine.
When you're working on a presentation with other people in real time, each person gets a cursor with a unique color. You can see what they do as they do it, including deleting, editing and adding text. They see what you do as well.
You can do more than see each other’s work. You can communicate as well. The Share pane shows a list of people who have editing access to the document. Those who are currently in the document have a colored bar next to their icon. That bar matches the color of the cursor you'll see as they move around in the document.
Hover your cursor over the icon of anyone currently working on the document, and a screen pops out with the various ways you can contact that person, including text chat, phone and video via Skype (if the person has Skype) and email. That lets you talk or text while you're working on the document together, making collaboration that much more effective.
Be aware that how well real-time collaboration works depends on the strength of your internet connection. On slow or flaky connections, you won’t immediately see edits that other people make and they won’t see yours immediately — there will be a lag. So it’s always best, when possible, to have the strongest connection possible when collaborating.