Solved

Excel 2013 and moving cells

Posted on 2014-12-01
2
102 Views
Last Modified: 2014-12-01
I have Excel 2013 and I have a very long list. I have a legend for the assigned colors for the cells. Now as I scroll down the list, I'd like the legend to follow the rows so that I know the meaning of each color. Is it possible to do that? Thanks
0
Comment
Question by:leblanc
2 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40473889
Have it in the first few rows (let's say the first 5 rows), then go to (let's say) cell A6 (i.e. click in that cell), then go to View - Freeze Panes - Freeze Panes.

You will find the first 5 rows are then fixed, wherever you go.

In you want the first 4 columns to be fixed as well, then click in cell E6 before Freezing the Panes.
0
 
LVL 1

Author Comment

by:leblanc
ID: 40474211
Awesome. That is wxactly what I need. Thank you
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question