Org-Mode Reference Card (1/2) Tables Formula Editor

(for version 7.6) edit formulas in separate buffer C-c ’

Creating a table exit and install new formulas C-c C-c
just start typing, e.g. |Name|Phone|Age RET |- TAB exit, install, and apply new formulas C-u C-c C-c
Getting Started convert region to table C-c | abort
toggle reference style
C-c C-q
C-c C-r
... separator at least 3 spaces C-3 C-c |
pretty-print Lisp formula TAB
To read the on-line documentation try M-x org-info Commands available inside tables complete Lisp symbol M-TAB
The following commands work when the cursor is inside a table. shift reference point S-cursor
Outside of tables, the same keys may have other functionality. shift test line for column references M-up/down
Visibility Cycling scroll the window showing the table M-S-up/down
Re-aligning and field motion
toggle table coordinate grid C-c }
rotate current subtree between states TAB re-align the table without moving the cursor C-c C-c
rotate entire buffer between states S-TAB re-align the table, move to next field TAB
restore property-dependent startup visibility C-u C-u TAB move to previous field S-TAB Links
show the whole file, including drawers C-u C-u C-u TAB re-align the table, move to next row RET
reveal context around point C-c C-r move to beginning/end of field M-a/e globally store link to the current location C-c l [1]
Row and column editing insert a link (TAB completes stored links) C-c C-l
insert file link with file name completion C-u C-c C-l
Motion move the current column left M-LEFT/RIGHT edit (also hidden part of) link at point C-c C-l
kill the current column M-S-LEFT
insert new column to left of cursor position M-S-RIGHT open file links in emacs C-c C-o
next/previous heading C-c C-n/p
...force open in emacs/other window C-u C-c C-o
next/previous heading, same level C-c C-f/b move the current row up/down M-UP/DOWN open link at point mouse-1/2
backward to higher level heading C-c C-u kill the current row or horizontal line M-S-UP ...force open in emacs/other window mouse-3
jump to another place in document C-c C-j insert new row above the current row M-S-DOWN record a position in mark ring C-c %
previous/next plain list item S-UP/DOWN [2] insert hline below (C-u : above) current row C-c - jump back to last followed link(s) C-c &
insert hline and move to line below it C-c RET find next link C-c C-x C-n
sort lines in region C-c ^ find previous link C-c C-x C-p
Structure Editing Regions edit code snippet of file at point C-c ’
toggle inline display of linked images C-c C-x C-v
insert new heading/item at current level M-RET cut/copy/paste rectangular region C-c C-x C-w/M-w/C-y
insert new heading after subtree C-RET fill paragraph across selected cells C-c C-q
insert new TODO entry/checkbox item M-S-RET Miscellaneous Working with Code (Babel)
insert TODO entry/ckbx after subtree C-S-RET
turn (head)line into item, cycle item type C-c - to limit column width to N characters, use ...| <N> |...
edit the current field in a separate window C-c ‘ execute code block at point C-c C-c
turn item/line into headline C-c * open results of code block at point C-c C-o
promote/demote heading M-LEFT/RIGHT make current field fully visible C-u TAB
export as tab-separated file M-x org-table-export check code block at point for errors C-c C-v c
promote/demote current subtree M-S-LEFT/RIGHT view expanded body of code block at point C-c C-v v
move subtree/list item up/down M-S-UP/DOWN import tab-separated file M-x org-table-import
sum numbers in current column/rectangle C-c + view information about code block at point C-c C-v I
sort subtree/region/plain-list C-c ^ go to named code block C-c C-v g
clone a subtree C-c C-x c Tables created with the table.el package go to named result C-c C-v r
copy visible text C-c C-x v go to the head of the current code block
kill/copy subtree C-c C-x C-w/M-w insert a new table.el table C-c ~ C-c C-v u
recognize existing table.el table C-c C-c go to the next code block C-c C-v n
yank subtree C-c C-x C-y or C-y go to the previous code block
narrow buffer to subtree / widen C-x n s/w convert table (Org-mode ↔ table.el) C-c ~ C-c C-v p
demarcate a code block C-c C-v d
Spreadsheet
execute the next key sequence in the code C-c C-v x
Formulas typed in field are executed by TAB, RET and C-c C-c. edit buffer
Capture - Refile - Archiving = introduces a column formula, := a field formula. execute all code blocks in current buffer C-c C-v b
execute all code blocks in current subtree C-c C-v s
capture a new item (C-u C-u = goto last) C-c c [1]
Example: Add Col1 and Col2 |=$1+$2 | tangle code blocks in current file C-c C-v t
refile subtree (C-u C-u = goto last) C-c C-w ... with printf format specification |=$1+$2;%.2f| tangle code blocks in supplied file C-c C-v f
archive subtree using the default command C-c C-x C-a ... with constants from constants.el |=$1/$c/$cm | ingest all code blocks in supplied file into the C-c C-v i
move subtree to archive file C-c C-x C-s sum from 2nd to 3rd hline |:=vsum(@II..@III)| Library of Babel
toggle ARCHIVE tag / to ARCHIVE sibling C-c C-x a/A apply current column formula | = | switch to the session of the current code block C-c C-v z
force cycling of an ARCHIVEd tree C-TAB set and eval column formula C-c = load expanded body of the current code block C-c C-v l
set and eval field formula C-u C-c = into a session
re-apply all stored equations to current line C-c * view sha1 hash of the current code block C-c C-v a
Filtering and Sparse Trees re-apply all stored equations to entire table C-u C-c *
iterate table to stability
rotate calculation mark through # * ! ˆ $
C-u C-u C-c *
C-#
Completion
construct a sparse tree by various criteria C-c /
view TODO’s in sparse tree C-c / t/T show line, column, formula reference C-c ? In-buffer completion completes TODO keywords at headline
global TODO list in agenda mode C-c a t [1] toggle grid / debugger C-c }/{ start, TeX macros after “\”, option keywords after “#-”, TAGS
time sorted view of current org file C-c a L after “:”, and dictionary words elsewhere.
complete word at point M-TAB
Org-Mode Reference Card (2/2) Clocking time start/stop/cancel the clock on current item I / O / X
start clock on current item C-c C-x C-i jump to running clock entry J
(for version 7.6) mark / unmark / execute bulk action m / u / B
stop/cancel clock on current item C-c C-x C-o/x
display total subtree times C-c C-x C-d Misc
TODO Items and Checkboxes remove displayed times
insert/update table with clock report
C-c
C-c
C-c
C-x C-r
follow one or offer all links in current entry C-c C-o
Calendar commands
rotate the state of the current item C-c C-t
select next/previous state S-LEFT/RIGHT find agenda cursor date in calendar c
select next/previous set C-S-LEFT/RIGHT
Agenda Views compute agenda for calendar cursor date c
toggle ORDERED property C-c C-x o show phases of the moon M
view TODO items in a sparse tree C-c C-v add/move current file to front of agenda C-c [ show sunrise/sunset times S
view 3rd TODO keyword’s sparse tree C-3 C-c C-v remove current file from your agenda C-c ] show holidays H
cycle through agenda file list C-’ convert date to other calendars C
set the priority of the current item C-c , [ABC] set/remove restriction lock C-c C-x </>
remove priority cookie from current item C-c , SPC Quit and Exit
raise/lower priority of current item S-UP/DOWN [2] compile agenda for the current week C-c a a [1]
quit agenda, remove agenda buffer q
compile global TODO list C-c a t [1]
exit agenda, remove all agenda buffers x
insert new checkbox item in plain list M-S-RET compile TODO list for specific keyword C-c a T [1]
toggle checkbox(es) in region/entry/at point C-c C-x C-b match tags, TODO kwds, properties C-c a m [1]
toggle checkbox at point C-c C-c match only in TODO entries
update checkbox statistics (C-u : whole file) C-c # find stuck projects
C-c a M
C-c a #
[1]
[1]
LaTeX and cdlatex-mode
show timeline of current org file C-c a L [1]
configure custom commands C-c a C [1]
preview LaTeX fragment C-c C-x C-l
Tags agenda for date at cursor C-c C-o expand abbreviation (cdlatex-mode) TAB
insert/modify math symbol (cdlatex-mode) ‘ / ’
Commands available in an agenda buffer insert citation using RefTeX C-c C-x [
set tags for current heading C-c C-q
realign tags in all headings C-u C-c C-q View Org file
create sparse tree with matching tags C-c \
globally (agenda) match tags at cursor C-c C-o
show original location of item SPC/mouse-3 Exporting and Publishing
show and recenter window L
goto original location in other window TAB/mouse-2
Exporting creates files with extensions .txt and .html in the
goto original location, delete other windows RET
Properties and Column View show subtree in indirect buffer, ded. frame C-c C-x b
current directory. Publishing puts the resulting file into some
other place.
toggle follow-mode F
set property/effort C-c C-x p/e export/publish dispatcher C-c C-e
special commands in property lines C-c C-c Change display
export visible part only C-c C-e v
next/previous allowed value S-left/right delete other windows o
insert template of export options C-c C-e t
turn on column view C-c C-x C-c view mode dispatcher v
toggle fixed width for entry or region C-c :
capture columns view in dynamic block C-c C-x i switch to day/week/month/year/def view d w vm vy vSP
toggle pretty display of scripts, entities C-c C-x \
quit column view q toggle diary entries / time grid / habits D / G / K
toggle entry text / clock report E / R Comments: Text not being exported
show full value v
edit value e toggle display of logbook entries l / v l/L/c Lines starting with # and subtrees starting with COMMENT
next/previous allowed value n/p or S-left/right toggle inclusion of archived trees/files v a/A are never exported.
edit allowed values list a refresh agenda buffer with any changes r / g
filter with respect to a tag / toggle COMMENT keyword on entry C-c ;
make column wider/narrower > / <
move column left/right M-left/right save all org-mode buffers s
display next/previous day,week,... f / b
add new column M-S-right
goto today / some date (prompt) . / j Dynamic Blocks
Delete current column M-S-left
Remote editing update dynamic block at point C-c C-x C-u
Timestamps digit argument 0-9 update all dynamic blocks C-u C-c C-x C-u
change state of current TODO item t
kill item and source C-k
prompt for date and insert timestamp C-c . Notes
archive default $ / a
like C-c . but insert date and time format C-u C-c .
refile the subtree C-c C-w
like C-c . but make stamp inactive C-c !
set/show tags of current headline : / T [1] This is only a suggestion for a binding of this command.
insert DEADLINE timestamp C-c C-d
set effort property (prefix=nth) e Choose your own key as shown under INSTALLATION.
insert SCHEDULED timestamp C-c C-s
set / compute priority of current item , / P
create sparse tree with all deadlines due C-c / d [2] Keybinding affected by org-support-shift-select and also
raise/lower priority of current item S-UP/DOWN [2]
the time between 2 dates in a time range C-c C-y org-replace-disputed-keys.
run an attachment command C-c C-a
change timestamp at cursor ±1 day S-RIGHT/LEFT [2]
schedule/set deadline for this item C-c C-s/d
change year/month/day at cursor by ±1 S-UP/DOWN [2] Copyright c 2011 Free Software Foundation, Inc.
change timestamp one day earlier/later S-LEFT/RIGHT [2] v7.6 for Org-Mode 7.6, 2011
access the calendar for the current date C-c >
change timestamp to today > Author: Philip Rooke
insert timestamp matching date in calendar C-c < based on refcard design and format by Stephen Gildea
insert new entry into diary i
access agenda for current date C-c C-o
Permission is granted to make and distribute copies of this card pro-
select date while prompted mouse-1/RET vided the copyright notice and this permission notice are preserved on
toggle custom format display for dates/times C-c C-x C-t all copies.