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. If successful, a Column Width box displays the numerical value of the cell width, and increasing or decreasing this value increases or decreases the size of the column.On occasion, you will discover that the text or values you have entered into a cell are not completely visible. Next, you would press O (the letter o) to get the Format options.įinally, you would press the W key to adjust the cell column width. Once in this cell, you would press the Alt and H at the same time to get the Home tab keyboard options. Press O (the letter o) to access the format options.Īs seen in the picture, the Format section gives you the option to adjust the Row Height (H), AutoFit Row Height (A), Column Width (W), AutoFit Column Width (I), and Default Width (D).įor example, to adjust the width of B10, press the right arrow to move to column B and then the down arrow nine times to get to cell B10. Once this keyboard shortcut is pressed all options in the Home tab will be highlighted. Once the cell is selected, access the Home tab by pressing the keyboard shortcut Alt+ H. Move to the cell you want to adjust the width or height of using your keyboard arrow keys. However, you can do the following steps to adjust the cell size using only your keyboard and not the mouse. Unfortunately, there are no single key Excel or other spreadsheet keyboard shortcuts for adjusting the width or height of a cell. How can I adjust a cell size using a keyboard shortcut? If the cell to the right is not empty, the text appears to be cut off. If Wrap text is not enabled, any text that is larger than the cell overflows into empty cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |