troubleshooting Question

Excel question

Avatar of wfcrr
wfcrrFlag for United States of America asked on
Microsoft Excel
7 Comments2 Solutions265 ViewsLast Modified:
How do I ask this question? I have very little expertise with Excel. I want to have headings down the left side of the sheet where the rows have names. Similar to what I usually see at the top where the columns have names, I want the rows to have names so that when I put something in Column A, Row 1 is names Time of day and COlumn A is named Trade 1 and Row 2 is named Area from MP and Column B is named Trade 2 and Row 3 is named Globex hi/low. The idea being the columns are individual trades and the rows are the various data points I looked at while making and managing that trade.  So, trade 1 is represented in Column A and all it's varous data points are listed in the rows and those rows have names like Time of Day, Area from MP, Globex hi/low, etc.... How do I set row names and then freeze them like i do on the top?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros