Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Assigning a Macro to a Keyboard Combination
Hiding Rows Based on a Cell Value
As you analyze your data in a worksheet, one common task is to look for ways to simplify the amount of data in a worksheet. For instance, you might want to "merge" several consecutive cells together in an Excel worksheet, leaving only the sum of the original cells as a value. For instance, if you have values in the rangeB3:F3, how would you collapse the range into a single cell that contains just the sum of that range?
The easiest way I have found to accomplish this task is as follows:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3026) applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Organize Your Data! Using the powerful sorting capabilities of Excel can help you get your data into just the order you need. Find out how you can use the full capabilities of sorting to your benefit.