Skip To Content
    This post has not been vetted or endorsed by BuzzFeed's editorial staff. BuzzFeed Community is a place where anyone can create a post or quiz. Try making your own!

    Top 5 Tips For Excel

    Excel a Microsoft application, has a plethora of shortcuts and numerous uses which are yet to be discovered. To master this secret Microsoft Application, I would suggest you to checkout Microsoft Office Tutorials. Its lengthy but its hell effective. Or else you may checkout this article for some good Tips for Excel.

    1. Converting Excel Into PDF

    There are certain times when we are in dire need of PDF format. So that no one can manipulate or edit my stuffs. SO when working on Excel, if you need to send a document in PDF format and you don’t have Acrobat reader then you can simply turn your Excel document into a PDF file.

    For that you can save your Excel files into a PDF format or you can mail your Excel file as an PDF attachment.

    2. Call Log Creation

    One of the best feature MS Excel is known for, Is for its amazing ability to organize data. With the help of this application you can easily create and work on huge data. If your main job profile is to make or receive calls and you have a huge data to work on then Excel is the application you would be looking for. Making call logs on Excel is very easy. Just create a new excel sheet with these three simple heading:

    •Name

    •Time of call

    •Reason for call

    3. Summation

    If one of your client have sent you an Excel file and you don’t have MS Excel to read it. Then no worries, you can still read it by using Microsoft Excel Viewer. This is an awesome tool to view your Excel files without downloading or having MS Excel.

    4. No Excel

    If one of your client have sent you an Excel file and you don’t have MS Excel to read it. Then no worries, you can still read it by using Microsoft Excel Viewer. This is an awesome tool to view your Excel files without downloading or having MS Excel.

    5. Keyboard Shortcuts

    Keyboard shortcuts is kind of a must know for every Excel user. Just knowing copy and paste will not work. So sharing with you some keyboard shortcuts which you can use in your daily life:

    •Ctrl + 2: Bold

    •Ctrl+A: Select All

    •Ctrl+B: Format, Cells, Font, Font Style, Bold

    •Ctrl + 3: Italic

    •Ctrl+H: Replace

    •Ctrl + 4: Underline

    •Ctrl + 5: Strikethrough

    •Ctrl+K: Insert Hyperlink

    •Shift + Ctrl + F: Font dropdown list

    •Shift+F10: Display Shortcut Menu

    •Ctrl+Shift+@: Time Format

    •Ctrl+Shift+# : Date format

    •Ctrl + 9: Hide rows

    •Ctrl + 0: Hide columns

    •F7: Spell Check

    •F10: Activate Menubar

    •Ctrl + Shift + (: Unhide rows

    •Ctrl + Shift +): Unhide columns

    •Ctrl+Shift+$: Currency format

    •Shift + Space: Select entire row

    •Ctrl + Space: Select entire column

    •Tab: Next Tool

    •Shift + tab: Previous Tool

    Hope you guys liked this article… For more details you may follow me.

    Create your own post!

    This post was created by a member of the BuzzFeed Community.You can join and make your own posts and quizzes.

    Sign up to create your first post!