Click in the empty cell below a column of numbers and type the following: Start with simple functions such as SUM, which adds the numbers in a selected row or column. Use functions to build formulas that evaluate your data. If you copy text with tabs that separate series of words or numbers, Excel treats the material like tab-delimited input and separates it into columns where the tabs appear. Paste information from Microsoft Word or another application into your worksheet from the clipboard. If you've prepared your text with delimiters - special characters that signal the divisions among separate items in a string of text - Excel identifies columns of data based on the delimiting characters and walks you through the process of setting up a worksheet. Turn a text file into a worksheet by opening it in Excel. Drag the handle down a column or across a row to fill other cells with repeated or sequenced entries. Place your cursor on the bottom right corner of the last cell in your selection to reveal the fill handle, a solid-black '+' sign. Click in your cell to select it, or select more than one cell to work from a multicell pattern. Enter a value in one cell and press 'Return' to confirm your entry. Speed data entry of numbers, dates, days of the week, times of day and patterns of text. Press the 'Pg Dn' key - use the combination 'Fn-Down Arrow' on a MacBook - to highlight and select an item from the list, and press 'Return' to set the cell's contents to it. Once you type a word or phrase into one cell, you can type its first letter or letters into another cell, and Excel automatically displays a menu below your cursor that shows the text you've typed before. Use autocompletion to add the same text content into many cells in the same column. The slightly bolder cell boundary you see below the column-header cells and at the right edge of the cells that contain your row headers serve as a signal that you've turned on Freeze Panes. When you choose 'Freeze Panes,' your full set of headers becomes fixed in place. Click the 'Window' menu and choose 'Freeze Panes.' To freeze both row and column headers, click in the first cell to the right of your last column of row headers that's also in the row below your column headers. Click on the row number immediately below your headers or below the last line of a header that occupies more than one row, selecting the entire row. Use Freeze Panes to keep your headers visible as you scroll. Some Excel procedures, including data sorting and filtering, use these identifiers to help you select which portions of your worksheet to process.

Type column headers in row 1 and row headers in column A.

Can you get excel on mac