Posts Tagged time saving

It’s time for another edition of Stupid Excel Tricks!

One of my coworkers recently asked me an Excel question.  He had a spreadsheet with multiple tabs, and wanted to have the value in cell A1 on the respective worksheets to be the name of each tab.  I knew that it could be done, so I searched the deep recesses of my memory for the answer.  When it didn’t turn up there, I went to Plan B.  It’s a good thing that I save everything to my computer using my foolproof file naming system, otherwise this fool would have never found it.

This formula can save you the time of not having to type a heading on each tab.  I’m not sure exactly how this formula works, but I do know the basics.  First, rename your tab by right-clicking on the tab and then left-clicking on Rename (you can give it any name that you’d like; I called mine SALES).

Just right-click on the tab name, and left-click on Rename

Read the rest of this entry »

• The Economics of Lawn Care pfala I'm not an envious person.  When someone experiences some good fortune, I'm genuinely happy for them.  I compliment people if they have nice stuff, or if their houses look nice.  But I think that my neighbor, The Lawn Freak, has finally gone overboard. What the heck is THAT......
• A Simple Mortgage Amortization Table Kevin over at the No Debt Plan blog recently advised his readers to avoid mortgage accelerator programs like the plague.  He reasoned that you could set up your own mortgage accelerator program by adding 1/12 of a payment as additional principal to each month's payment.  I agree with Kevin. You......
• Excel How-to: A Macro to Hide Blank Rows on a Spreadsheet Today, a coworker asked me how to hide a row on his Excel spreadsheet.  This was a fairly large spreadsheet, with about 150 rows and 30 columns.  After showing him, he started to hide every other row, which would be an incredible waste of time for someone in his salary......

• The Number ONE Thing Every Online Business Needs Can you guess what every Internet business needs more the most? Although I am sure we would get a variety of different answers many people probably could get this right. For example some people probably think the product is the most crucial thing. I would certainly agree that without a......
• Crystal Color Fire Sticks & Pinecones, Crystal Color Sticks User Reviews Send this to a friend Crystal Color Fire Sticks & Pinecones, Crystal Color Sticks Manufacturer: Winter Woods Customer Rating: List Price: Varies based on product options Sale Price: $5.99 Availibility: Usually ships in 1-2 business days Buy Now Product Description Anyone that's been around one of our......
• SEO Can Either Make Or Break Your Company One thing that you should always take into consideration about your website is search engine optimization. Marketing on the internet is a viciously competitive area. You have to be up-to-date on all your knowledge and resources to make your web site better than the rest. All the other sites are......