Sunday, 24 April 2016

How to Repeat Rows & Column on All Excel Pages (Top, Left)

How to Repeat Rows & Column on All Excel Pages (Row on Top),top row repeat on all pages,repeat row on all page,Rows to repeat at top,sheet row repeat,repeat colum on every page,repeat row on top of every page,every page top row,repeat row,excel row,excel column,repeat cell to all pages,add row on top of all pages,column,excel 2007,ms excel,excel 2016,how to repeat,page setup,add rows on top,insert rows on every page How to Repeat Rows & Column on All Excel Pages (Row on Top)Hello everyone welcome back again, in this post I will show you how to repeat rows and column to all Excel pages, sometime we work on same format and want to repeat title row on every excel page, if you try to copy paste each and every page it will take lot of time and will disturb the setting, so lets see how to repeat automatic rows on every page in excel.

1.       Go to “Page setup” click on “Sheet” and put the cursor on “Rows to repeat at top” box
How to Repeat Rows & Column on All Excel Pages (Row on Top),top row repeat on all pages,repeat row on all page,Rows to repeat at top,sheet row repeat,repeat colum on every page,repeat row on top of every page,every page top row,repeat row,excel row,excel column,repeat cell to all pages,add row on top of all pages,column,excel 2007,ms excel,excel 2016,how to repeat,page setup,add rows on top,insert rows on every page How to Repeat Rows & Column on All Excel Pages (Row on Top)

2.       Now select rows from start to end by using mouse or keyboard, and click on “Ok” now the selected rows will automatic add on top of all excel page.
How to Repeat Rows & Column on All Excel Pages (Row on Top),top row repeat on all pages,repeat row on all page,Rows to repeat at top,sheet row repeat,repeat colum on every page,repeat row on top of every page,every page top row,repeat row,excel row,excel column,repeat cell to all pages,add row on top of all pages,column,excel 2007,ms excel,excel 2016,how to repeat,page setup,add rows on top,insert rows on every page How to Repeat Rows & Column on All Excel Pages (Row on Top)


Watch video tutorial.. Please like, share & subscribe  

No comments:

Popular Posts