You can see a Format Shape pane is displayed on the right side of the worksheet, under the Size and Properties tab, check the Resize shape to fit text box in the Text Box section, and then close the Format Shape pane. After inserting the text box, right click the border of the text box, and then click Size and Properties from the right-clicking menu. You can change the property of the text box as follows to make it automatically resize with the text you entered or deleted.ġ.
In the Save in drop-down list box, select the drive on which to save the workbook.Click the FILE button and choose Save As.
To save an already named workbook with a different name: On the Quick Access Toolbar, click the Save button.Click the FILE button and choose Save or.Method To save a named workbook with its current name: One benefit of doing this is that it gives you two copies of the same workbook you can modify the copy all you want without affecting the "original," allowing you greater freedom for experimentation with formatting and other features. To give you more flexibility, you can also save a named workbook under a different name using the Save As command. Excel automatically saves it under its current file name. Once you have named your workbook, you can save subsequent changes by simply using the Save command. In the File name drop-down list box, type Brian's Orchard 2009 Report.Should the correct directory not appear click the Browse button to locate it. In the list of folders, double-click the Data folder.Under Save choose computer (Figure 1.14).Click the FILE button and choose Save.In the File name drop-down list box, type the document name.Įxercise In the following exercise, you will save your new workbook in Excel.In the list of folders, double-click the desired folder.In the Save As dialog box, in the Save in drop-down list box, select the desired drive.On the Quick Access Toolbar (looks like a floppy disk). From then on, Excel saves your workbook under that name unless you specify otherwise. If you invoke the Save command in an unnamed workbook, Excel prompts you to name the workbook before it will save it to disk. That way, if there's a power outage or surge, you will lose only a few minutes of work. It's a good idea to save frequently, especially when you enter a lot of data or make major changes. When you save a workbook in Excel, you tell it to accept every change you've made since the last time the workbook was saved. In addition, you may want to make a printout of your worksheet to view the latest additions on paper or to share your worksheet with others. You can save your workbook in Excel a number of ways, even as an Internet-compatible HTML document. Double-click the right border of the column heading for column A.Īt the end of the day, or when you have completed your work on a particular workbook, you need to ensure that your work is safely stored.Double-click the right border of the column heading.Įxercise In the following exercise, you will adjust a column width in Excel.Method To quickly adjust a column width in Excel: If the text or value appears cut off or overflows into a totally different column which will have its own data, you can quickly adjust the column width so you can view the entire cell entry. In the example, the entries in cells A1 and A2 appear just fine, because there are no entries to the right in cells B1 and B2. This will occur when the number of characters entered exceeds the width of the column and when data appears in the cell to its right, as shown in column B of Figure 1-8. On occasion, you will discover that the text or values you have entered into a cell are not completely visible.
0 kommentar(er)
