Excelhints - excelhints.com - Excel Hints
General Information:
Latest News:
Change Case of Text in Excel 3 Mar 2012 | 04:52 pm
One question I get all the time is how to change the case of text in Excel. Some applications require case-specific text to make a match with its data. Or you may just want to clean up your data to ma...
How to Make a Worksheet Very Hidden 10 Oct 2011 | 05:16 am
Today we will review two ways that you can hide a worksheet in your workbook. The simple way is very easy for the end user to unhide the worksheet; the same spreadsheet that you didn’t want them to s...
Calculate Age in Excel 3 Aug 2011 | 03:40 pm
Using a combination of built-in functions in Excel, you can quickly calculate a person’s age. There are a couple different ways this method can be used, and we’ll go through both below. Functions Used...
Excel Keyboard Shortcuts from Microsoft 27 Jul 2011 | 02:52 am
A few years ago, I wrote a post listing many of the keyboard shortcuts that are available in Microsoft Excel. They included anything from copy & paste shortcuts to formatting shortcuts that could incr...
Date Expire and Password Protect Your Excel Project 13 Jun 2011 | 02:39 pm
When building your Excel projects, you may want to demo a trial version of the work you have completed without giving full access to the working program. There are a couple things you can do to the pr...
How to Use Your Personal Macro Workbook 29 Nov 2010 | 11:00 pm
For any of the repeating tasks that you do through macros, Excel provides a way to have those commonly used actions always available to you. Instead of copying the macros you use frequently to every w...
View Two Workbooks at the Same Time 22 Sep 2010 | 06:45 am
Excel has a built-in way to be able to view two workbooks at the same time side by side. This can be useful when comparing similar values or graphs between workbooks without having to flip back and fo...
Adjust the Security Level in Excel 7 Aug 2010 | 02:17 am
If you’ve ever used any Excel files that had macros included, you’ve probably come across the security settings in Microsoft Excel. There are multiple levels of security that Excel provides depending ...
Quick Formatting Using Excel’s Format Painter 9 Jul 2010 | 06:04 am
Formatting an entire spreadsheet to look just the way you desire can take longer than you’d expect. Clicking back and forth between the formatting options, usually repetitively, can possibly move the ...
Find (and Delete) External Links 27 May 2010 | 06:17 am
I’ve talked with many people that express frustration about having external links in their spreadsheet, but not being able to find them. If this has affected you, you’ve most likely noticed the warnin...
