Is a method to slip label rows to be always above of file?

tesoke · #1 01-25-2016, 09:21 PM

Hi, I have a problem with Excel and hope to find the answer for it here. Thanks for any help.

In the following attached picture of my Excel file, I need to see the first row to distinguish what I should write in different cells, but after row 23, I cannot see first row and obligated to come up for every cell to see first row. It is very hard when the number of rows increases, for example more than 100.

I want to know is there a method to simplify this? For example, if there is a method to slip the first row in above the file, I can find it every time even when I am in row 100. So, I am not obligated to come up to see row 1. Is there such a method?

Thanks for any help.

macropod · #2 01-25-2016, 10:31 PM

Have you never used 'Freeze Panes' on the View tab?

tesoke · #3 01-25-2016, 10:48 PM

Thank you. I had not hear anything about "Freeze Pans" ever. I will try it. Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Avery Label Templates, editing rows/spacing	rainandwind_95448	Word	2	12-13-2015 08:05 AM
Insert slip sheets during a mail merge	mcboats2	Mail Merge	1	12-07-2015 05:01 PM
Userform label bordercolor not controllable if click label	skarden	Word VBA	1	09-29-2013 07:27 PM
Label template for importing csv file	sdunbar	Office	1	01-11-2012 11:11 PM
Trying to merge label data from file	ClayShannon	Mail Merge	0	09-16-2009 10:08 PM