Print this page
Excell how to
 

Excel How To

    Here are a few trick for Excel users.
    (This is part of the excel assessment book)


     

    Freeze Panes.
    Like in the basic facts test sheet I have frezzed the criteria at the top so you are able to scroll down the names but retain the criteria at the top. To do this you click on the column or row you want to lock and go to "VIEW", "FREEZE PANE" http://office.microsoft.com/en-us/excel/HP012170481033.aspx?pid=CH100648381033

     

    Adding colour coding.
    Go to the "Home" (excel 2007) and look for "Conditional Formating" in there you can add in vales and their colour.

     

    Drop down lists
    click here: http://office.microsoft.com/en-us/excel/HP052022151033.aspx

     

    Multi lines in a cell
    To drop down one line in a cell (bullet point) click ALT ENTER

     

    Call Data/info from another sheet.
    ='I Can CA'!D4  
    click = where you wan t data to appear. click sheet that data is on. Click first cell of data wanted. Hit enter(brings you back to sheet you are creating). Then drag right bottom of cell to get the rest of the data.

  


 

Click Here To

Add A Comment

Add A Comment

Title:
Your Name(*):
Email:
Notify me of any further comments to this thread:
Website:
Comment(*):
 


Hit Counter 2172