Skip to main content

MS Excel Shortcut Key



MS Excel Shortcut Key

Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
Ctrl+K - Insert Hyperlink
Ctrl+N - New Workbook
Ctrl+O - Open
Ctrl+P - Print
Ctrl+R - Fill Right
Ctrl+S - Save
Ctrl+U - Underline
Ctrl+V - Paste
Ctrl W - Close
Ctrl+X - Cut
Ctrl+Y - Repeat
Ctrl+Z - Undo
F1 - Help
F2 - Edit
F3 - Paste Name
F4 - Repeat last action
F4 - While typing a formula, switch between absolute/relative refs
F5 - Goto
F6 - Next Pane
F7 - Spell check
F8 - Extend mode
F9 - Recalculate all workbooks
F10 - Activate Menubar
F11 - New Chart
F12 - Save As
Ctrl+: - Insert Current Time
Ctrl+; - Insert Current Date
Ctrl+" - Copy Value from Cell Above
Ctrl+’ - Copy Formula from Cell Above
Shift - Hold down shift for additional functions in Excel’s menu
Shift+F1 - What’s This?
Shift+F2 - Edit cell comment
Shift+F3 - Paste function into formula
Shift+F4 - Find Next
Shift+F5 - Find
Shift+F6 - Previous Pane
Shift+F8 - Add to selection
Shift+F9 - Calculate active worksheet
Shift+F10 - Display shortcut menu
Shift+F11 - New worksheet
Shift+F12 - Save
Ctrl+F3 - Define name
Ctrl+F4 - Close
Ctrl+F5 - XL, Restore window size
Ctrl+F6 - Next workbook window
Shift+Ctrl+F6 - Previous workbook window
Ctrl+F7 - Move window
Ctrl+F8 - Resize window
Ctrl+F9 - Minimize workbook
Ctrl+F10 - Maximize or restore window
Ctrl+F11 - Inset 4.0 Macro sheet
Ctrl+F1 - File Open
Alt+F1 - Insert Chart
Alt+F2 - Save As
Alt+F4 - Exit
Alt+F8 - Macro dialog box
Alt+F11 - Visual Basic Editor
Ctrl+Shift+F3 - Create name by using names of row and column labels
Ctrl+Shift+F6 - Previous Window
Ctrl+Shift+F12 - Print
Alt+Shift+F1 - New worksheet
Alt+Shift+F2 - Save
Alt+= - AutoSum
Ctrl+` - Toggle Value/Formula display
Ctrl+Shift+A - Insert argument names into formula
Alt+Down arrow - Display AutoComplete list
Alt+’ - Format Style dialog box
Ctrl+Shift+~ - General format
Ctrl+Shift+! - Comma format
Ctrl+Shift+@ - Time format

Comments

Post a Comment

Real education enhances the dignity of a human being and increases his or her self-respect. If only the real sense of education could be realized by each individual and carried forward in every field of human activity, the world will be so much a better place to live in.
- A. P. J. Abdul Kalam -

Popular posts from this blog

Autospy

AUTOSPY ☆ Autospy also known as necropsies or post mortem examination. Derived from the Greek word "autopsia" meaning "to see with one's own eyes". It is a procedure wherein anatomic pathologists dissect corpses to determine the cause of death and to add to medical knowledge. The autopsy begins with a complete external examination. The weight and height of the body are recorded, and identifying marks such as scars and tattoos also are recorded. Postmortem Examination ☆Examination of body after death. ☆By law-when death is sudden or occurs within 48 hours of admission. ☆Organs and tissues are examined to establish the exact cause of death and to assist in the accumulation of statistical data. ☆The internal examination begins with the creation of a Y or U- shaped incision from both shoulders joining over the sternum and continuing down to the pubic bone. ☆The skin and underlying tissues are then separated to expose the rib cage and abd...
Post a Comment
Read more

Nursing Laws In Philippines

NURSING LAWS IN PHILIPPINES • R.A. 9173 – The Philippine Nursing Act of 2002 • R.A. 7164 – The Philippine Nursing Act of 1991 • Act 2808 of 1919 – The 1st True Nursing Law; regulated nursing only and established Board of Examiners, the precursor to the Board of Nursing • Act 2493 of 1915 – The 1st Nursing Law; regulated both medicine and nursing • R.A. 877 of 1953 – The 1st Comprehensive Nursing Law; regulated the degree of Bachelor of Science in Nursing and made nursing into a profession • R.A. 4704 of 1966 – increased the number of the Board of Examiners from 3 to 5 • R.A. 6136 of 1970 – allowed nurses to perform IM injections without supervision from doctors • R.A. 349 – Legalizes the use of human organs for surgical, medical and scientific purposes • R.A. 1054 – Free emergency, medical and dental assistance to employees and laborers • R.A. 1080 – Civil Service Eligibility • R.A. 1082 – Rural Health Unit Act • R.A. 1136 – Act recognizing the Division of T...
1 comment
Read more