campustuta.blogg.se

• Where is the borders button in excel for mac how to#

Just type the cell you want to go to in the Name box and then press Enter.Ģ. You can also use the Name box to go to a specific cell. Hold down the Ctrl key while you press "g" (Ctrl+g).

You can also use Ctrl+G to go to a specific cell.ġ. If you press the F5 key, you are prompted for the cell to which you wish to go.Įnter the cell address, and the cursor jumps to that cell. The following are shortcuts for moving quickly from one cell in a worksheet to a cell in a different part of the worksheet. If you hold down the Ctrl key and then press the Home key, you move to the beginning of the worksheet. The Page Up and Page Down keys move up and down one page at a time. You can use the right and left arrow keys to move right or left one cell at a time. You can hold down the Shift key and then press the Tab key to move to the left, one cell at a time. You can use the Tab key to move across the page to the right, one cell at a time. You can use the up arrow key to move upward one cell at a time. You can use the down arrow key to move downward one cell at a time. Move Around a Worksheetīy using the arrow keys, you can move around your worksheet. A check mark next to an item means the item is selected. You can change what displays on the Status bar by right-clicking on the Status bar and selecting the options you want from the Customize Status Bar menu. The Status bar appears at the very bottom of the Excel window and provides such information as the sum, average, minimum, and maximum value of selected numbers. Note: The current cell address displays on the left side of the Formula bar. Click Formula Bar in the Show/Hide group. If you do not see the Formula bar in your window, perform the following steps:Ģ. Cell entries display on the right side of the Formula bar. If the Formula bar is turned on, the cell address of the cell you are in displays in the Name box which is located on the left side of the Formula bar. You enter your data into the cells on the worksheet. Cell E10 is located under column E on row 10. For example, the cell located in the upper-left corner of the worksheet is cell A1, meaning column A, row 1. The combination of a column coordinate and a row coordinate make up a cell address. The number of columns and rows you can have in a worksheet is limited by your computer memory and your system resources. The columns are lettered A to Z and then continuing with AA, AB, AC and so on the rows are numbered 1 to 1,048,576. Each worksheet contains columns and rows. When you click the dialog box launcher, a dialog box makes additional commands available. You may also find a dialog box launcher in the bottom-right corner of a group. You click buttons to issue commands or to access menus and dialog boxes. Within each group are related command buttons. At the top of the Ribbon are several tabs clicking a tab displays several related command groups. The Ribbon is located near the top of the Excel window, below the Quick Access toolbar. In Microsoft Excel 2007, you use the Ribbon to issue commands. You use commands to tell Microsoft Excel what to do. At the top of the Excel window, you should see "Microsoft Excel - Book1" or a similar name. On the Title bar, Microsoft Excel displays the name of the workbook you are currently using. Next to the Quick Access toolbar is the Title bar. You can use Save to save your file, Undo to roll back an action you have taken, and Redo to reapply an action you have rolled back. By default, Save, Undo, and Redo appear on the Quick Access toolbar. The Quick Access toolbar gives you with access to commands you frequently use. Next to the Microsoft Office button is the Quick Access toolbar. You can use the menu to create a new file, open an existing file, save a file, and perform many other tasks. When you click the button, a menu appears. In the upper-left corner of the Excel 2007 window is the Microsoft Office button. The Microsoft Excel window appears and your screen looks similar to the one shown here. To begin this lesson, start Microsoft Excel 2007. You use the window to interact with Excel. This lesson will introduce you to the Excel window.

Where is the borders button in excel for mac how to#

Although knowledge of how to navigate in a Windows environment is helpful, this tutorial was created for the computer novice. This tutorial teaches Microsoft Excel basics. You can also use it to perform mathematical calculations quickly. You can use it to organize your data into rows and columns. Microsoft Excel is an electronic spreadsheet. Lesson 1: Entering Text and Numbers The Microsoft Excel Window