|
Move to next cell in row - Tab Move to previous cell in row - Shift + Tab Up one screen - Page Up Down one screen - Page Down Move to next worksheet - Ctrl + Page Down Move to previous worksheet - Ctrl + Page Up Go to first cell in data region - Ctrl + Home Go to last cell in data region - Ctrl + End Bold toggle for selection - Ctrl + B Italic toggle for selection - Ctrl + I Underline toggle for selection - Ctrl + U Strikethrough for selection - Ctrl + 5 Change the font - Ctrl + Shift + F Change the font size - Ctrl + Shift + P Apply outline borders - Ctrl + Shift + 7 Remove all borders - Ctrl + Shift + Underline Wrap text in same cell - Alt + Enter Format cells - Ctrl + 1 Select font - Ctrl + Shift + F Select point size - Ctrl + Shift + P Format as currency - Ctrl + Shift + 4 Format as general - Ctrl + Shift + # (hash sign) Format as percentage - Ctrl + Shift + 5 Format as number - Ctrl + Shift + 1 Autosum a range of cells - Alt + Equals Sign Insert the date - Ctrl +; (semi-colon) Insert the time - Ctrl + Shift +; (semi-colon) Insert columns/rows - Ctrl + Shift + + (plus sign) Insert a new worksheet - Shift + F11 Read Monitor Cell One - Alt + Shift + 1 Read Monitor Cell Two - Alt + Shift + 2 Read Monitor Cell Three - Alt + Shift + 3 Read Monitor Cell Four - Alt + Shift + 4 List Visible Cells With Data - Ctrl + Shift + D Lists Data In Current Column - Ctrl + Shift + C List Data In Current Row - Ctrl + Shift + R Select Hyperlink - Ctrl + Shift + H Move To Worksheet Listbox - Ctrl + Shift + S Move To Monitor Cell - Ctrl + Shift + M Select Worksheet Objects - Ctrl + Shift + O List Cells At Page Breaks - Ctrl + Shift + B Options Listbox - Insert + V |
Thursday, December 10, 2009
Excel Time saving Shortcuts
Subscribe to:
Post Comments (Atom)
Labels
3D-2D Translation
Algorithms
Batch Programming
C language
C world
C++
DBMS
Ebook
Games
JAVA
Java Programs
JNTU MATERIALS
JNTU PREVIOUS QUESTION PAPERS
JNTU SYLLABUS BOOKS
LAB MANUALS
Linux
Mobile softwares
Networking
Online Programs
PC TIPS
Software Diagrams
Software Engineering
Softwares
System Software
Visual Basic
0 comments:
Post a Comment