Pages

▼
Tuesday, August 31, 2010

How do you copy and paste cell value only with VBA in Excel?

›
I was recently asked this question: Is there a way in Excel to write a macro to copy a cell's numeric value only and not the formula? Ba...
Tuesday, August 24, 2010

Where can I download the roommate's shared apartment expenses spreadsheet?

›
My shared apartment expenses spreadsheet has become very popular and I have received a lot of positive feedback. Many people have emailed m...
Thursday, August 19, 2010

Some lesser known keyboard shortcuts in Microsoft Excel

›
Here are a few shortcuts in Microsoft Excel that you may not be familiar with: Alt+F11:Open VBE Ctrl+Shift+Enter:Array formula Ctrl+F3:D...
Tuesday, August 10, 2010

Where can I download an Apartment Search Spreadsheet ?

›
My apartment search spreadsheet has become very popular and I have received a lot of positive feedback. Many people have emailed me or com...
8 comments:
Thursday, July 29, 2010

How do you transpose a column into a row with a formula in Excel?

›
It's easy to copy and paste data to turn vertical columns into horizontal rows. But sometimes you may want to automate this task. You ca...
Monday, July 19, 2010

Personal Online Finance Tracker Excel Spreadsheet Template

›
I'm going to try and post more templates seeing how my apartment search spreadsheet has been such a big hit. With economy still in the ...
Monday, July 12, 2010

How do you assign a letter grade to a number in an Excel spreadsheet?

›
A frequently asked question is how do you assign a letter grade to a numeric value.  This is actually very simple.  First, you need to creat...
5 comments: