ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

Shortcuts & functions

•Download as XLSX, PDF•
•
R
Richard Wood

This document provides shortcuts and features for working with documents and spreadsheets. It lists shortcuts for common editing tasks like cutting, copying, pasting and formatting text. It also lists useful spreadsheet functions such as today(), now(), sum(), average(), min(), max() and conditional functions like if(), and(), or().

1 of 1
Downloaded 11 times
Working in Documents Selections Feature Shortcut Feature Shortcut help F1 Cut Ctrl+X file open ctrl+O Copy Ctrl+C new file ctrl+N Paste Ctrl+V save ctrl+S Select Cell Group Shift+Cursors print Ctrl+P Multiselect Cells Alt+Left Click search Ctrl+F Del Row/Col Ctrl+K replace Ctrl+H Select Column Ctrl+Space first cell Ctrl+Home Select Row Shift+Space last cell Ctrl+End Select All Ctrl+A start of row Home Select Range Ctrl+* next sheet Ctrl+Page Down Go To Corner Ctrl+, next workbook Ctrl+F6 Edit Selected Ctrl+Enter prev workbook Ctrl+Shift+F6 Fill Down Ctrl+D prevsheet Ctrl+Page Up Fill Right Ctrl+R goto F5 Copy Prev Formula Ctrl+' close Ctrl+W Copy Above Val Ctrl+" spellcheck F7 Sum Alt+= Editing and Formating Usefull Functions Feature Shortcut Function Result Edit Cell F2 today() today's date Set Currency Shift+Ctrl+$ now() date & time Set Percent Shift+Ctrl+% sum() total of values Set Number Ctrl+Shift+~ average() average of values Set Date Ctrl+Shift+# min() lowest value Insert Line Bar Alt+Enter max() highest value Bold Ctrl+B count() number of values Underline Ctrl+U counta() count non-blank Italic Ctrl+I countif() count matches Repeat Action F4 if(this,then,else)and() / or() return value if condition met Format Cell Ctrl+1 rand() random number Insert Date Ctrl+; round() round the value Insert Time Ctrl+: ceiling() round up Font Ctrl+Shift+F floor() round down Remove Border Ctrl+Shift+_ sqrt() square root Border Cells Ctrl+Shift+&

More Related Content

Shortcuts & functions

  • 1. Working in Documents Selections Feature Shortcut Feature Shortcut help F1 Cut Ctrl+X file open ctrl+O Copy Ctrl+C new file ctrl+N Paste Ctrl+V save ctrl+S Select Cell Group Shift+Cursors print Ctrl+P Multiselect Cells Alt+Left Click search Ctrl+F Del Row/Col Ctrl+K replace Ctrl+H Select Column Ctrl+Space first cell Ctrl+Home Select Row Shift+Space last cell Ctrl+End Select All Ctrl+A start of row Home Select Range Ctrl+* next sheet Ctrl+Page Down Go To Corner Ctrl+, next workbook Ctrl+F6 Edit Selected Ctrl+Enter prev workbook Ctrl+Shift+F6 Fill Down Ctrl+D prevsheet Ctrl+Page Up Fill Right Ctrl+R goto F5 Copy Prev Formula Ctrl+' close Ctrl+W Copy Above Val Ctrl+" spellcheck F7 Sum Alt+= Editing and Formating Usefull Functions Feature Shortcut Function Result Edit Cell F2 today() today's date Set Currency Shift+Ctrl+$ now() date & time Set Percent Shift+Ctrl+% sum() total of values Set Number Ctrl+Shift+~ average() average of values Set Date Ctrl+Shift+# min() lowest value Insert Line Bar Alt+Enter max() highest value Bold Ctrl+B count() number of values Underline Ctrl+U counta() count non-blank Italic Ctrl+I countif() count matches Repeat Action F4 if(this,then,else)and() / or() return value if condition met Format Cell Ctrl+1 rand() random number Insert Date Ctrl+; round() round the value Insert Time Ctrl+: ceiling() round up Font Ctrl+Shift+F floor() round down Remove Border Ctrl+Shift+_ sqrt() square root Border Cells Ctrl+Shift+&