Thursday, September 27, 2007

for those in need of time and meddling with excel

after figuring out how to create discrete distribution without coding macros, filling in bins of data using frequency, i've found out how to do:
  1. fill a range of data for cumulative prob in one key! use ctrl+d to fill a selected range down a cell or ctrl+r to fill a selected range to the right of a cell (okay, that's 2 keys.)
  2. construct a chart in one key! select the data range, use ctrl+f11
  3. ctrl+page up/down moves to previous/next sheet in the same workbook (i so need this.)

Other trivial keys:

  1. ctrl+shift+& applies the outline borders to a cell
  2. ctrl+shift+_ removes those borders. (you can imagine me holding on to ctrl+shift and playing between & and _ =p)
  3. ctrl+shift+F or ctrl+1 opens the format cell options with font tab; i need this to do the subscript and superscript. the ise laptop kings guo jun and jordan once taught me the shortcut keys to subscript and superscript - but yes, it slipped the mind of miss scatterbrain. grrs.

i want to find the shortcut keys for:

subscript/superscript as mentioned;

left/centre/right/justified alignment

merge cells

(and/or) wrap text

(maybe) apply inside borders for the numerous tables for the problems i'm creating too.

(back to simulation assignment. wish me luck, i so need it.)

No comments: