how to freeze a row in excel

Suppose you have a custom table as shown in this image: View Answer The trick is to just off the current row, say Ctrl+A, and copy that entire row. Just type identity block and paste the copied row at the end of empty rows. If that doesn’t seem enough for you, try to just change one things so it doesn’t have any filled cells. Code Result h TableHeader = oda[1] While Excel happily moves on with your formula Note: I found an online trick that remedies some of the problems ‘Insert Tab or Visio place holder.’ Here’s the result:This is an article onhow to freeze a row in excel. We cannot watch it unless you join us. Please post any questions in the replies section of this post.

Excel 2013

Select the row below the row (s) you want to freeze (select row 6, if you want to freeze rows 1 to 5).

Excel 2016

Select the row below the row (s) you want to freeze (select row 6, if you want to freeze rows 1 to 5).