Posts Tagged tab name

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 »

• 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......
• Consistently Excellent My cousin used to take on various side jobs to help pay the bills.  When I was a teenager, he would recruit me to help out.  In most cases, I didn't have any skills required for the job, be it roofing, or putting up drywall.  He used to joke,......
• Corporate Barbarian Links: Chainsaw Massacre Edition Photo by lancefisher No, that's not me in the picture.  But I did take the chainsaw out this week, and cleaned up the look of the website a bit.  I got rid of the big, ugly ad in the sidebar, and reduced the amount of categories.  Hopefully this will......

• Rare Books Many people who collect rare books have relationships with a number of booksellers who handle these types of books, and have lists of the books they'd like to own. The seller, when that book becomes available, will contact the customer and then they negotiate on a price. Some online rare......
• How to save money during the days AFTER Christmas and the holidays. Ok, so the holidays are going to be over soon..and whether you like that or not, it's going to happen and life will return to normal. But before it all settles down, how can you best spend some of your after-holiday dough? (that is, if you have any left!) By......
• Stealth Startups, Get Over Yourselves: Nobody Cares About Your Secrets When Preetam Mukherjee started Marcellus.tv in March 2007, his company was one of the very few players in the professional online video hosting space. He believed he was building a killer product that would become a blockbuster and would compete handily with the one established player in the space,......