![]() Press, then type numeric information.Įntering Numbers Formatted as Text: Dialog Box Select the cell you want to enter information into. Entering Numbers Formatted as Text: Apostrophe Character There are two ways to enter numbers as text. Information is displayed exactly as it is entered. When cells are formatted for text, all cell contents-letters, numerals, or alpha-numeric combinations-are treated as text. Įxcel automatically right-aligns numerical values and left-aligns text.ĭo not include spaces or alphabetical characters in a calculation cell. HINT: To enter a fraction, type 0 and press before the fraction otherwise, Excel will interpret the fraction as a date. Type the numeric information that should be in the cell. Select the cell where you want to enter numbers. A numeric cell may contain numbers, a decimal point (.), plus (+) or minus (-) signs, and currency ($). Numeric cells can be used for calculations and functions. To force text to wrap at a specific point in a cell, press +. Select the cell where you want to enter text. Under New Blank, double click Blank Workbook.Įxcel allows you to enter text into cells. In the top left corner of the Excel window, click File. Worksheets can contain data, charts, or both.įor more information on Excel terminology, refer to Worksheet Terms. The advantage of having multiple worksheets, or layers, is that a variety of data can be compiled, analyzed, and integrated in a single file. By default, workbooks open with three blank worksheets, although you can add or delete worksheets at any time. ![]() To open Excel 2007, from the Start menu, select All Programs » Microsoft Office » Microsoft Office Excel 2007.Īn Excel file is called a workbook. This document introduces some of the essential concepts that will help you design effective workbooks in Excel. When used optimally, Excel saves a great deal of time performing a multitude of tasks. Microsoft Excel combines the column-row layout of traditional paper spreadsheets with powerful tools for data calculation, analysis, and formatting. This article is based on legacy software. You can always ask an expert in the Excel Tech Community or get support in the Answers community.(Legacy) Microsoft Excel 2007: Getting Started with Excel In the Unhide dialog box, click the sheet you want to unhide and then click OK. To unhide a worksheet, right-click on any visible tab and then click Unhide. Click-and-drag the arrow to the right, until you see the complete tab name and any other tabs. Hover the mouse pointer at the edge of the scrollbar until you see the double-headed arrow (see the figure). The horizontal scroll bar obscures the tabs. To do this,įor all other Excel versions, click File > Options > Advanced-in under Display options for this workbook-and then ensure that there is a check in the Show sheet tabs box. The Show sheet tabs setting is turned off.įirst ensure that the Show sheet tabs is enabled. If you still don't see the tabs, click View > Arrange All > Tiled > OK. Simply double-click the window title bar. Try maximizing the window to reveal the tabs. Tabs can also disappear if your computer screen resolution is higher than that of the person who last saved the workbook. The status bar has been moved all the way up to the Formula Bar. Perhaps the top of an Excel window is covering the worksheet tabs of another window. If you restore multiple windows in Excel, ensure that the windows are not overlapping. The window sizing is keeping the tabs hidden. Your view might be slightly different if you have a different version, but the functionality is the same (unless otherwise noted). ![]() Note: The image in this article are from Excel 2016. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |