back to top
Community

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.

Posted on

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.

This post was created by a member of BuzzFeed Community, where anyone can post awesome lists and creations. Learn more or post your buzz!

Every. Tasty. Video. EVER. The new Tasty app is here!

Dismiss