Excel Shortcuts

    Hi there, Welcome to " The Civil Engineer", in this article we are going to share with you a shortcut of a versatile yet simple software "The Excel" and its shortcut keys to increase your productivity by efficiently doing your work in less time. Excel was first released by Microsoft under the name "Mulltiplan", which is actually not Excel but it is the base for the formation of Excel. Microsoft launched the software with its present name "Excel" in 1985 for MAC(Apple computers), then in 1987 for Windows. After that, they started releasing newer versions of Excel once every two years interval or based on the requirement.

    So, we are going to see the shortcuts of this software because in civil engineering especially in construction the use of Excel is tremendous, and it forms the base for so many advanced software. So once you master this you can easily understand other software. Even Startups at the beginning stage use Excel. So, Wherever you go you can't avoid Excel in construction because construction involves various, mathematical calculations.
    Note, if we say "Ctrl + N" means, here + refers to pressing both buttons simultaneously. And comma(,) symbol means you need to press multiple keys to achieve the required function.
Basic Shortcuts
Ctrl Series Shortcut
    Ctrl + 9            -    To Hide the Selected Row
    Ctrl + 0            -    To Hide the selected Column  
    Ctrl + N           -   To open New Workbook
    Ctrl + O           -    To open an existing Workbook
    Ctrl + S            -    To save a Workbook
    Ctrl + C            -    To Copy the Selected items
    Ctrl + V            -    To Paste the Copied items
    Ctrl + Z            -    To undo the Previous command/action
    Ctrl + X            -    To Cut the selected part
    Ctrl + B            -    To Apply Bold Format in text
    Ctrl + F1           -    Expand or collapse Ribbon
Alt Series Shortcut
    Alt + H            -    Go to Home Tab
    Alt + H, H        -    To Choose fill color
    Alt + N            -    To go to the Insert Tab
    Alt + H, A, C     -    To Center align cell content
    Alt + P             -    Go to Page Layout
    Alt + A            -    Go to the Data Tab 
    Alt + W           -     Go to View Tab
    Alt + H, B        -     Use this to Add Borders
    Alt + H, D, C    -     Use this to Delete a Column
    Alt + M           -    Go the the Formula Tab
    Alt + Q            -    Go to Search Tab
Shift Series Shortcuts

    Shift + F10     -    Open the Context Menu
    Shift + Tab     -     Move to the Previous cell
    Shift + F2       -     Insert a note
    Shift + F9       -    Calculate the active Worksheet
    Shift + F3       -     Insert a Function
    Shift + F10     -    Open the context menu for the selected cell                        

Ctrl & Shift Combination Shortcuts

    Ctrl + Shift + End                 -     Use this to Select the cells
    Ctrl + Shift + Mouse Scroll  -     To Move in the spreadsheet horizontally


Popular Posts