In Microsoft Excel, How do I

In Microsoft Excel, How do I… Add a column • Left click on top of column, on the column letter where you wish to add the extra column • The whole column will go black • On menu bar, click on insert then click on Columns • The Column will be added at this point, and data previously in this column and to the right of it, will move across, the column letters increasing by 1 • All formulae should be amended automatically Or Right click mouse in column where you wish to add new column Select Insert Select Entire Column Click OK • • • • Left click on far left, on the row number where you wish to add the row The whole row will go black On menu bar, click on insert then click on Rows The row will be added at this point, and data previously on this row and below it, will move down, the row numbers increasing by 1 • All formulae should be amended automatically Or Right click mouse in row where you wish to add new row Select Insert Select Entire row Click OK Add a row Adjust cell width Either manually: • Go to top of column • Place cursor in grey area between the column to be widened and the next one • The cursor will acquire a symbol consisting of 2 vertical lines and 2 horizontal arrows • Using Left mouse button, hold it down and drag until appropriate width has been reached OR Use Autofit • Highlight cell(s) required • From the menu bar- select Format • Select Column from the drop down box • Select Autofit selection from the drop down box 1 Brian Philpott 25 July 2000 Align my text • Highlight Cell(s) in which text is to be aligned • Click on either Left, Centre, Right or Fully Justify on toolbar See “Adjust Cell width” See “Align my text” See “Save my document” • • • • • From the menu bar select File Select Page Setup Page tab is usually showing, select it if it is not Check Landscape option Click OK Auto adjust cell width Centre my text Change file Name Change my document to Landscape Change my font size • Highlight Text • Click on Font size menu on toolbar, and select new size Change my text to bold, • Highlight text Italic or Underline • Click on B, I or U on toolbar • • • • • • Copy and paste Highlight cell(s) to be copied Select Copy icon on toolbar Place cursor where you wish to insert copied cell(s) Left click mouse - The cell will have a thicker border around it Select Paste Icon on toolbar The copied cell will retain a flashing dotted line around it indicating is is still on the “Clip Board” Copy cell contents down a column or along a row • Click Left Mouse on cell containing data you wish to copy • Move cursor to bottom right hand corner of cell, a small black cross will appear • Hold down left mouse button and drag mouse either down column or along row as required • Release left mouse button • Highlight cell(s) be cut • Select Cut icon on • Place cursor where you wish to insert cut out cells • Left click mouse - The cell will have a thicker border around it • Select Paste Icon on toolbar • Or • Click Right mouse on cell to be cut • Click Right mouse on cell to be pasted to Cut and paste 2 Brian Philpott 25 July 2000 Delete a column Delete a row • Left click on top of columns, on the letter where you wish to delete the column • The whole column will go black • On menu bar, click on Edit then click on Delete • The Column will be deleted at this point, and data to the right of it, will move back to the left, the column letters decreasing by 1 All formulae should be amended automatically • Left click on far left, on the number where you wish to delete the row • The whole row will go black • On menu bar, click on Edit then click on Delete • The row will be deleted at this point, and data previously below it, will move up, the row numbers decreasing by 1 • All formulae should be amended automatically • Highlight cell(s)to be deleted • Press Delete Key (See also “Edit cells”) • • • • Double click using left mouse on cell to be edited A flashing cursor will appear Place cursor where required using either the mouse or cursor keys Insert or amend contents as appropriate Delete Text or numbers Edit Cells Enter a formula Font Size Format a cell • Click left mouse button on cell in which the formula is to be entered • The cell will have a black border around it • Enter formula starting with an equals sign (=) • Press enter when finished • Amend any errors using backspace or delete keys as appropriate The formula can be cancelled prior to pressing the enter key by clicking on the red cross in the formula bar • Highlight Text Click on Font size menu on toolbar • Click left mouse button on cell(s) to be formatted • From the menu bar select Format • From the drop down menu select Cells • From the box displayed, if it is not already showing select the Number tab at the top • From the category menu select what is required (Number or Currency) • Check number of decimal places to be shown (Usually 2 but none if an integer) • Check £ sign is selected if required • Click OK Or • Click Right mouse on cell to be formatted • Select Format Cells Note - Later versions of Excel may have more options here, but usually £ (Optional) and/or 2 decimal places are all that is required 3 Brian Philpott 25 July 2000 Highlight cells • • • • Place cursor on first cell to be highlighted Click left mouse button Hold left mouse button down and drag over cells to be highlighted They will then have a black background apart from the first cell selected Integer Landscape Print my document Format cell(s) to a Number with zero decimal places (see Format a Cell) See “Change my document to Landscape” • Click on Print icon on toolbar Or • Click on File on the menu bar and select Print (This will give other printing options if required) • Click Left Mouse on cell containing formula you wish to replicate • Move cursor to bottom right hand corner of cell, a small black cross will appear • Hold down left mouse button and drag mouse either down column or along row as required • Release left mouse button • Select Cell(s) to be right aligned • Click on Right align on toolbar • On the menu bar click left mouse button on File • From drop-down menu select Save as • From the box shown, at the top select where document is to be saved for example 3 ½” Floppy A, My work or My documents as appropriate • The suggested name will appear at the bottom of this box, change it if required • Click on Tools on the menu bar • From the Drop down Menu select options • Select View from the tabs • In Window Options Tick formulas Widen columns if appropriate see “adjust cell width” • Select File from toolbar • Select Page Setup (Page Tab if not already showing) Scaling-click on- Adjust to fit to 1 page wide and 1 page tall • Highlight cell(s) required • From the menu bar select Format • Select Cells • Select Alignment tab • From the Vertical selection check Top • Check Wrap Text selection • Click OK Replicate a formula Right align my cell contents Save my document Show my formulae when I Print Shrink a print when showing formulas Word Wrap 4 Brian Philpott 25 July 2000