![]() We already know how to do that, don’t we? Just go to the “Wrap text” button, and click on it twice. ![]() We’ll need to tell Excel to wrap our text to suit the new cell size. But note that we now have a lot of empty space in our table. You can see in the image that column D is now larger. ![]() Click down on the end line of column D, and drag it to your desired size. Step 5: Auto-wrap when the cell size changes Let’s take a quick peek at this example shall we. Similarly if you decide you didn’t quite like say the shape of your table, and wanted to make certain columns larger, or smaller, Excel will again wrap your text to fit the new cell size, with a single click. You don’t have to fiddle with it or remind it or do anything extra. If you later add in more text, Excel will automatically wrap it again and re-adjust the size of your cell. There’s a few side benefits to choosing “Wrap Text” instead of manually adjusting the size of each column. In such a case, you’re not really bothered about reading each description thoroughly. This comes in quite handy if you have a large number of rows, say 40 or 50, and want to scan through them real fast. It’ll unwrap your text in a single click. If you change your mind at a later time and for any reason want to have your text back on a single line, just select the cells, and then go click on the “Wrap text” button. Our table has now been re-sized, and all the elements show up properly inside the table, as they were meant to! Tip: How to “Un-wrap” text It’s that small button, right in the middle of the top line. Just select the “Wrap Text” from the Menu bar. In our case, we want to do it for the entire table, since both our “Office Table” and our “Descriptions” are messed up.Ģ. Select the cells you want to wrap text in. You can wrap the text, display it on multiple lines and re-size the cell, in 2 easy steps. Step 4: Wrapping the text to fit into your cell In one easy click, you can tell Excel to resize your entire Column, Row, or even a select set of cells, so that the text fits inside it. But imagine doing that for say 40 cells! You’d really begin to hate Excel! But no sweat, there’s an easy way to do it.Įxcel provides a way to ‘wrap’ the text. One way to make the text show up better, is to go and re-size the cell. Most spreadsheets will have many more rows and columns. The example we’ve taken in pretty simple. If you have text that extends beyond the size of your cell, you don’t want it to be hanging in mid air and mess up your table. This is where wrapping your text comes in handy. And our descriptions seem to be hanging in air outside the table. Something’s not quite right is it? Some of the text is getting cut away. In the second row of your menu bar, you’ll see table with border, click on that, and then select “All Borders” Just click on B3, and keep your mouse key pressed, drag to D5.Ģ. Select the cells you want included in the table. We want our list to look a bit professional. If you notice, the spreadsheet doesn’t look too good. Now lets take a minute to fill out the details of each item in our spreadsheet. Also note that the cell number and text show up below the menu bar (green highlight) Note how C3 gets a black border when I’m typing in the text. Here, I’ve entered “Item” into B3 (that’s the shorthand for Column B, Row 3) and “Price” into C3. You can enter either text, or data this way. Simply get your mouse cursor to the “cell” that you want to fill in data, single click on it, and start typing. While the huge spreadsheet in front of you may seem like a maze, entering data into it is really simple. Step 2: Entering Text and Data into your spreadsheet Select File->Save As and give your spreadsheet a name and save it to your computer. This will open a new spreadsheet called “Book1.xls”.Ģ. Open Excel by double clicking on the Excel icon on your desktop or Program Menu. You can create a spreadsheet in 2 easy steps.ġ. Let’s assume you want to create a spreadsheet to track big ticket items you plan to buy this month, and we’ll use that for all our examples today. Of course, if you’d like a more visual learning experience, we recommend you take a beginners course on Excel. In this tutorial, we don’t assume any prior knowledge of Excel, and we’ll walk you through all the steps from creating your own spreadsheet, how to enter text and data into it, and then how to format or wrap the text. Once you learn the basics of using Excel, you’ll find that it’s not really that difficult. Working with Excel can be a daunting task for most folks, but it doesn’t need to be that way. Whether it’s about balancing your checkbook, managing your budget, your earnings, or your client list, Excel makes it all easier. Learning how to use spreadsheets, and specifically Excel, is a necessary skill today.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |