Handyexceltips - handyexceltips.com - Handy Excel Tips
General Information:
Latest News:
Custom Right Click Menu 24 Sep 2009 | 07:16 am
Isn’t it exciting to have the ability to create your own right-click menu and customize it according to your needs. The default right-click menu doesn’t give much options. Let’s add some frills to it...
Reader’s Questions - Performing two-way look up 17 Mar 2009 | 07:08 am
Question: I have - Table 1 and Table 2 How can I bring salary information in table 2 from table 1 for corresponding dept and jobcode? Thanks Bob Lee Our take on this excel problem You can join D...
How to copy and paste values in filtered data? 12 Nov 2008 | 02:57 am
If you copy and paste values from one column to another, when the filter is on and the range is discontinuous, then it won’t work and will paste the data into non-visible cells as well. As an exampl...
Save a new worksheet directly in the desired folder 21 Oct 2008 | 04:17 pm
If you want to create a new workbook in some folder and you are already there, then instead of clicking on excel icon and then making your way to the folder by clicking down through the folders until ...
Freezing Formulas 5 Sep 2008 | 09:27 pm
This article gives you an example of where we may need to keep our formulas intact. Suppose there are two tabs- Jan and Feb. And they both contain the same fields with exactly the same location. For ...
Finding external links 16 Jul 2008 | 12:18 am
This article shows how to locate cells in active workbook which contain links to external workbooks. If your workbook contains links to other workbooks, you can locate the source files in the “Links”...
Indirect Function 3 Jul 2008 | 05:44 am
Sometimes we want to pull out data on one sheet from different worksheets, all of them having the same structure.We can do that using the vlookup or hlookup function as the case may be. However, while...
Choosing your own “Save File” location 27 Jun 2008 | 09:56 pm
If we save some file without giving the path, then it will automatically get saved at the default location. We can change the Default File Location as: 1.Click on the Tools menu 2.Choose Options 3....
Alphabetic Series on Excel 4 Jun 2008 | 10:35 pm
This article explains how we can have A-Z letters on a column without typing them in manually. If we want a number series say 1-100, we can simply drag the cursor to expand the series. But if we inst...
How to unlock keyboard?? 1 May 2008 | 02:37 am
This article explains how to deal with a situation when your keyboard gets locked without you even knowing it. Holding down shift key for more than 8 seconds will lock the keyboard and it will stop r...
