When you select a CELL the data you input is fed through the FORMULA BAR, so if you wanted to edit a CELL with data already in it, if you click the CELL you ll find that data in the FORMULA BAR and can edit it just like it was a typical text box, like the address bar in Internet Explorer. Heggan Free Public Library Last Revised THE FORMULA BAR Just above the SPREADSHEET you ll find a long text box that has fx to the left of it. Drag and Drop the line in order to adjust the size.Ĥ INTRODUCTION to MICROSOFT EXCEL Margaret E.
Your mouse should change from an arrow or a plus sign into a bold cross with two arrows pointing in opposite directions. A, B, C, 1, 2, 3) where a faint blue line separates the adjacent label. To stretch/shrink a COLUMN or ROW hover your mouse over the label (ex. It will look like a triangle pointing to the bottom right corner. To select all CELLS, click the box in the upper left corner of the SPREADSHEET between A and 1 in your columns and rows. Selecting multiple cells is handy when using SORT, SUM or formatting. To select multiple CELLS, click on a CELL and drag your mouse until the desired set are highlighted.ģ You can also click a CELL once and tap the arrow keys while holding shift for the same result. When you click on a cell you effectively highlight it, so if you want to edit a CELL and not completely retype it, you ll need to take an extra step. You can put anything in the cell, numbers, letters, or punctuation. To enter data, simply click on a CELL and begin typing. In EXCEL the SPREADSHEET stretches out almost indefinitely you ll never run out of CELLS. FOR EXAMPLE The top left CELL is A-1, five spaces below is A-6 and five spaces to the right of A-6 is F-6. ROWS are labeled along the left side of the SPREADSHEET numerically.Ģ These Labels are not part of your end product and will not be seen if you were to print, they only exist to designate CELLS. COLUMNS are labeled along the top of the SPREADSHEET A to Z and then AA to ZZ and so on.
THE SPREADSHEET A SPREADSHEET is a sheet full of rows and columns that make up a great many boxes or CELLS.
This data can be anything, but EXCEL is most useful when managing quantitative, or numerical, data such as for accounting, statistics, or record keeping. Heggan Free Public Library MICROSOFT EXCEL is a SPREADSHEET program used for organizing and managing data.
Heggan Free Public Library Last Revised INTRODUCTION TO MICROSOFT EXCEL Margaret E. 1 INTRODUCTION to MICROSOFT EXCEL Margaret E.