Posts Tagged tab name
Excel Tip: Have Your Cell Contents = Tab Names
Posted by enrique s in Excel, Productivity on July 8th, 2009
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
|
|
|
|
|
 |
Related Posts -
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...... -
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,...... -
Excel How-to: The SUMIF Function The SUMIF function is an easy way to get a subtotal of specific data that meets a certain condition, without going through the trouble of producing a Pivot Table. It's most useful when working with long arrays of diverse data: Note: You can follow along with this how-to by opening......
Related Websites -
Fallene Cotz SPF 58 Water Resistant UVB/UVA Sunscreen for Sensitive Skin, 2.5-Ounce Tube User Reviews Send this to a friend Fallene Cotz SPF 58 Water Resistant UVB/UVA Sunscreen for Sensitive Skin, 2.5-Ounce Tube Manufacturer: Fallene Customer Rating: List Price: $26.00 Sale Price: $16.50 Availibility: Usually ships in 24 hours Free Shipping Available Buy Now Product Description Fallene Cotz SPF 58 is a...... -
Research shows how snorting can deliver stem cells to the brain [/caption] Scientists have pioneered a unique delivery system to administer therapeutic stem cells to the brain, by way of a simple nasal spray. Once the droplets containing the stem cells are snorted through the nose, the solution breaks through the blood-brain barrier, seeding the brain with the stem cells (...)...... - 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......
