Posts

Showing posts from December 9, 2013

WORKING IN CELLS OR THE FORMULA BAR

Image
Paste a name into a formula: F3Define a name: CTRL + F3Calculate all sheets in all open workbooks: F9Calculate the active worksheet: SHIFT + F9Insert the AutoSum formula: ALT + = (EQUAL SIGN)Enter the date: CTRL + ; (SEMICOLON)
Fill the selected cell range with the current entry: CTRL + ENTERComplete a cell entry and move down in the selection: ENTERComplete a cell entry and move up in the selection: SHIFT + ENTERComplete a cell entry and move to the right in the selection: TABComplete a cell entry and move to the left in the selection: SHIFT + TAB