Tag Keywords :excel tips.
Excel Tricks : Hide Those %&@# Formula Errors
Just want to share some excel tips for you Problem : You are making a calculation on Your Excel Sheet and suddenly when you remove your Fixed Values, Your calculated answers returns the value ( #VALUE or #DIV/0 ). This is because a certain number ort any number has been divided by Zero. Solution : [...]
Another Excel Control Hot Keys Part 2 of 3
Below are additional Function keys which I consider an another excel Hot Keys. If you love my first part definitely this part will be of interest to you also. Key Description F1 Displays the Help task pane. CTRL+F1 closes and reopens the current task pane. ALT+F1 creates a chart of the data in the current [...]
Another Excel Control Hot Keys Part 1 of 3
The following lists contain CTRL combination shortcut keys, function keys, and some other common shortcut keys, along with descriptions of their functionality. For more extensive reference information on all available shortcuts and their specific uses Note If an action you use often does not have a shortcut key, you can record a macro to create [...]
Microsoft Excel Hot Keys Using Numbers ( CTRL Keys )
Shortcut codes in excel are really helpful if you are a keyboard user in Microsoft Excel. Hope this post on how to use the CTRL+Numbers keys in Microsoft Excel will help you to be more productive in your works. If you love my earlier post about Hot keys for Excel and the Different Shortcut using [...]
CTRL combination shortcut keys for Microsoft Excel
If you like my earlier post about the Microsoft Excel Hot key, I think you will also like this one. The following lists contain CTRL combination shortcut keys, function keys, and some other common Microsoft Excel shortcut keys, along with descriptions of their functionality. Microsoft Excel CTRL Key Description CTRL+( Unhides any hidden rows within [...]
Commonly Used Alt Keys in Microsoft Excel
Often times, we are encountering unusual codes that we want to insert in the Microsoft excel documents such us degrees character, diameter symbols for mathematical calculation , exponents , fractional numbers and more. This post could help you on how to use alt key codes in your Microsoft excel worksheet. Below are some useful Alt [...]
Microsoft Excel and Microsoft Word Hot Keys
Below is the Table that I would like to share regarding the hot keys or Control keys used in Microsoft Excel and Microsoft Word. Ctrl Keys Microsoft EXCEL Microsoft WORD A Select All Select All B Bold Bold C Copy Copy D Same as above Font E – Center F Find Find and Replace G [...]
Excel Trick : What is the use of $ sign?
Did you know “$” sign is an important part of excel formula? I would try to teach how you could use this sign. Problem : How can I fix the pick up point in one Excel Cell reference only? ( For this example it is Cell reference A1 ) See it here Technorati tags: Excel [...]
How to join Excel data in Cell
Objective : To be able to join Text data in Excel cell. Have you encountered a task in excel where you need to connect the data content of A1,B1,C1 & D1 as shown in the picture. Well it is easy if it is only 1 or two but what if you have a thousand of [...]
Spot Duplicate Entries
This is another excel tip I Copied from my files. This excel tips describes a way to use the Conditional Formatting feature to quickly identify dupes (duplicates) in a range. Say that you’ve been saddled with the job of organizing the seating list for the company dinner party. You have the list of assignments in [...]



