{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Home Page","Data Table","Smooth Scrolling","Horizontal & Vertical Scrolling","Synchronous Scrolling","Scroll One Row","Repeat Rows","Limit Area","Limit Area (VBA)","Freeze Panes","Scroll Bar"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home Page","index":0,"n_rows":55,"n_cols":3,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Scrolling in Excel"]
[]
[null,"Learn about the Scrolling in Excel with this free workbook. Read the article we provided and practice these in practice section."]
[]
[null,"Prepared By:","Md. Abdur Rahim Rasel"]
[null,"Reviewed By:","Masum Mahdy"]
[null,"Last Update:","2023-12-04"]
[null,"Article Link:","Scrolling in Excel"]
[]
[null,"Methods"]
[]
[null,"Excel Scrolling Options for Vertical and Horizontal Scrolling"]
[null,null,"1. Scrolling Using the Arrow Keys"]
[null,null,"2. Scrolling Using the Vertical and Horizontal Scrollbars"]
[null,null,"3. Using Mouse Wheel"]
[null,"How to Scroll with Arrow Keys Without Moving the Active Cell?"]
[null,"What Is Smooth Scrolling in Excel?"]
[null,"How to Scroll One Row at a Time in Excel?"]
[null,"How to Simultaneously Scroll 2 Workbooks in Excel?"]
[null,"How to Repeat Rows When Scrolling in Excel?"]
[null,"How to Limit Scroll Area in Excel?"]
[null,null,"1. Changing Worksheet Properties from Developer Tab"]
[null,null,"2. Applying a VBA Code"]
[null,"Creating a Custom Scrollbar Within a Sheet to Scroll Through Large Data"]
[null,"What Issues You May Face While Scrolling in Excel?"]
[null,null,"1. Horizontal or Vertical Scroll Bar Not Visible"]
[null,null,"2. Mouse Wheel Zooming In or Out Instead of Scrolling"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"Data Table","index":1,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,"Scrolling in Excel",null,null,null,null,null,0]
[]
[null,"Company Profile List"]
[]
[null,"Company Owner","Product","Number of Employee","Yearly Revenue (M)"]
[null,"Laura","Car",100,10]
[null,"James","Car",120,20]
[null,"Jane","Computer",95,12]
[null,"Peter","Garments",500,10]
[null,"Lara","Garments",700,15]
[null,"William","Oil",250,5]
[null,"Nicolas","Gas",300,20]
[null,"Haddin","Car",110,22]
[null,"Peterson","Chemicals",350,25]
[null,"Rob","Weapons",300,10]
[null,"Flintoff","Weapons",100,10]
[null,"Adam","Weapons",120,20]
[null,"Kiera","Chemicals",95,12]
[null,"Jason","Chemicals",500,10]
[null,"Ashish","Car",250,22]
[null,"Hiran","Car",300,25]
[null,"Dushan","Car",110,10]
[null,"Joy","Computer",350,10]
[null,"Kane","Garments",700,10]
[null,"Beer","Garments",650,15]
[null,"Mike","Weapons",100,10]
[null,"Gray","Weapons",120,10]
[null,"Tison","Chemicals",95,20]
[null,"Erikson","Chemicals",500,12]
[null,"Nicles","Car",350,10]
[null,"Brek","Car",700,10]
[null,"Drek","Computer",650,15]
[null,"Laren","Oil",300,20]
[null,"Jovan","Gas",110,22]
[null,"Flintar","Car",350,25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Smooth Scrolling","index":2,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,"Scrolling in Excel",null,null,null,null,null,null,9]
[]
[null,"Company Profile List"]
[]
[null,"Employee","Product","Quantity","Sales","Remark"]
[null,"Laura","Car",100,1542000,"Laura, an outstanding sales professional, has proven herself as a top performer in the automotive industry. With an impressive sales quantity of 100 cars, she showcases exceptional expertise in understanding customer needs, presenting vehicles persuasively, and closing deals effectively. Laura's commitment and skill contribute significantly to the success of the dealership, making her a valuable asset to the team."]
[null,"James","Car",120,2512000,"James, an exceptional sales representative in the automotive industry, boasts a commendable sales quantity of 120 cars. His prowess in understanding client needs, coupled with effective communication and negotiation skills, has propelled him to remarkable success. James is a valuable asset to the sales team, consistently exceeding targets and contributing significantly to the overall success of the dealership."]
[null,"Jane","Computer",300,1210000,"Jane stands out as a stellar performer in computer sales, achieving an impressive sales quantity of 300 units. Her exceptional sales acumen, deep product knowledge, and customer-centric approach have made her a driving force in the team. Jane consistently exceeds expectations, showcasing a remarkable ability to connect with customers and meet their computing needs. Her dedication and results-oriented approach contribute significantly to the success of the company's computer sales department."]
[null,"Peter","Garments",500,3214000,"Peter is an outstanding sales professional in the garment industry, demonstrating remarkable success with a sales quantity of 500 units. His keen understanding of fashion trends, excellent customer relations, and effective communication skills contribute to his exceptional performance. Peter's dedication to meeting customer needs and surpassing sales targets makes him a valuable asset to the team, playing a pivotal role in the success of the garment sales department."]
[null,"Lara","Gas",750,2501000,"Lara is an exceptional sales professional in the gas industry, showcasing unparalleled success with a remarkable sales quantity of 750 units. Her profound knowledge of the gas market, coupled with excellent customer relationship skills, positions her as a leader in the field. Lara consistently surpasses sales targets, emphasizing a strategic and customer-centric approach. Her commitment and expertise make Lara an invaluable asset to the team, significantly contributing to the success of the gas sales department."]
[null,"William","Oil",250,3521000,"William shines as a standout performer in the oil sales sector, achieving a notable sales quantity of 250 units. His deep industry knowledge, strategic approach to client relationships, and effective negotiation skills set him apart. William consistently exceeds sales targets, showcasing a keen ability to navigate the complexities of the oil market. His dedication and results-driven mindset make him a key contributor to the success of the company's oil sales division."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Horizontal & Vertical Scrolling","index":3,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"Scrolling in Excel"]
[]
[null,"Horizontal and Vertical Scrolling Using Keyboard & Mouse"]
[]
[null,"Company Owner","Product","Number of Employee","Yearly Revenue (M)","Production Unit"]
[null,"Laura","Car",100,10,574]
[null,"James","Car",120,20,318]
[null,"Jane","Computer",95,12,484]
[null,"Peter","Garments",500,10,363]
[null,"Lara","Garments",700,15,558]
[null,"William","Oil",250,5,577]
[null,"Nicolas","Gas",300,20,520]
[null,"Haddin","Car",110,22,586]
[null,"Peterson","Chemicals",350,25,327]
[null,"Rob","Weapons",300,10,309]
[null,"Flintoff","Weapons",100,10,306]
[null,"Adam","Weapons",120,20,511]
[null,"Kiera","Chemicals",95,12,483]
[null,"Jason","Chemicals",500,10,353]
[null,"Ashish","Car",250,22,353]
[null,"Hiran","Car",300,25,439]
[null,"Dushan","Car",110,10,460]
[null,"Joy","Computer",350,10,535]
[null,"Kane","Garments",700,10,347]
[null,"Beer","Garments",650,15,408]
[null,"Mike","Weapons",100,10,312]
[null,"Gray","Weapons",120,10,528]
[null,"Tison","Chemicals",95,20,514]
[null,"Erikson","Chemicals",500,12,533]
[null,"Nicles","Car",350,10,422]
[null,"Brek","Car",700,10,373]
[null,"Drek","Computer",650,15,385]
[null,"Laren","Oil",300,20,486]
[null,"Jovan","Gas",110,22,343]
[null,"Flintar","Car",350,25,546]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Synchronous Scrolling","index":4,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"Scrolling in Excel"]
[]
[null,"Synchronous Scrolling in Excel"]
[]
[null,"Company Owner","Product","Number of Employee","Yearly Revenue (M)"]
[null,"Laura","Car",100,10]
[null,"James","Car",120,20]
[null,"Jane","Computer",95,12]
[null,"Peter","Garments",500,10]
[null,"Lara","Garments",700,15]
[null,"William","Oil",250,5]
[null,"Nicolas","Gas",300,20]
[null,"Haddin","Car",110,22]
[null,"Peterson","Chemicals",350,25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Scroll One Row","index":5,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"Scrolling in Excel"]
[]
[null,"Using the Vertical Scroll Bar Slider to Scroll One Row at a Time"]
[]
[null,"Company Owner","Product","Number of Employee","Yearly Revenue (M)"]
[null,"Laura","Car",100,10]
[null,"James","Car",120,20]
[null,"Jane","Computer",95,12]
[null,"Peter","Garments",500,10]
[null,"Lara","Garments",700,15]
[null,"William","Oil",250,5]
[null,"Nicolas","Gas",300,20]
[null,"Haddin","Car",110,22]
[null,"Peterson","Chemicals",350,25]
[null,"Rob","Weapons",300,10]
[null,"Flintoff","Weapons",100,10]
[null,"Adam","Weapons",120,20]
[null,"Kiera","Chemicals",95,12]
[null,"Jason","Chemicals",500,10]
[null,"Ashish","Car",250,22]
[null,"Hiran","Car",300,25]
[null,"Dushan","Car",110,10]
[null,"Joy","Computer",350,10]
[null,"Kane","Garments",700,10]
[null,"Beer","Garments",650,15]
[null,"Mike","Weapons",100,10]
[null,"Gray","Weapons",120,10]
[null,"Tison","Chemicals",95,20]
[null,"Erikson","Chemicals",500,12]
[null,"Nicles","Car",350,10]
[null,"Brek","Car",700,10]
[null,"Drek","Computer",650,15]
[null,"Laren","Oil",300,20]
[null,"Jovan","Gas",110,22]
[null,"Flintar","Car",350,25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Repeat Rows","index":6,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"Scrolling in Excel"]
[]
[null,"Using Freeze Panes Feature  to Repeat Rows"]
[]
[null,"Company Owner","Product","Number of Employee","Yearly Revenue (M)"]
[null,"Laura","Car",100,10]
[null,"James","Car",120,20]
[null,"Jane","Computer",95,12]
[null,"Peter","Garments",500,10]
[null,"Lara","Garments",700,15]
[null,"William","Oil",250,5]
[null,"Nicolas","Gas",300,20]
[null,"Haddin","Car",110,22]
[null,"Peterson","Chemicals",350,25]
[null,"Rob","Weapons",300,10]
[null,"Flintoff","Weapons",100,10]
[null,"Adam","Weapons",120,20]
[null,"Kiera","Chemicals",95,12]
[null,"Jason","Chemicals",500,10]
[null,"Ashish","Car",250,22]
[null,"Hiran","Car",300,25]
[null,"Dushan","Car",110,10]
[null,"Joy","Computer",350,10]
[null,"Kane","Garments",700,10]
[null,"Beer","Garments",650,15]
[null,"Mike","Weapons",100,10]
[null,"Gray","Weapons",120,10]
[null,"Tison","Chemicals",95,20]
[null,"Erikson","Chemicals",500,12]
[null,"Nicles","Car",350,10]
[null,"Brek","Car",700,10]
[null,"Drek","Computer",650,15]
[null,"Laren","Oil",300,20]
[null,"Jovan","Gas",110,22]
[null,"Flintar","Car",350,25]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Limit Area","index":7,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"Scrolling in Excel"]
[]
[null,"Using Developer Property Command to Limit Scroll Area (Stop Infinity Scrolling)"]
[]
[null,"Company Owner","Product","No of Employee","Yearly Revenue (M)","Production Unit"]
[null,"Laura","Car",100,10,574]
[null,"James","Car",120,20,318]
[null,"Jane","Computer",95,12,484]
[null,"Peter","Garments",500,10,363]
[null,"Lara","Garments",700,15,558]
[null,"William","Oil",250,5,577]
[null,"Nicolas","Gas",300,20,520]
[null,"Haddin","Car",110,22,586]
[null,"Peterson","Chemicals",350,25,327]
[null,"Rob","Weapons",300,10,309]
[null,"Flintoff","Weapons",100,10,306]
[null,"Adam","Weapons",120,20,511]
[null,"Kiera","Chemicals",95,12,558]
[null,"Jason","Chemicals",500,10,577]
[null,"Ashish","Car",250,22,520]
[null,"Hiran","Car",300,25,586]
[null,"Dushan","Car",110,10,327]
[null,"Joy","Computer",350,10,309]
[null,"Kane","Garments",700,10,306]
[null,"Beer","Garments",650,15,511]
[null,"Mike","Weapons",100,10,558]
[null,"Gray","Weapons",120,10,577]
[null,"Tison","Chemicals",95,20,520]
[null,"Erikson","Chemicals",500,12,586]
[null,"Nicles","Car",350,10,327]
[null,"Brek","Car",700,10,309]
[null,"Drek","Computer",650,15,306]
[null,"Laren","Oil",300,20,511]
[null,"Jovan","Gas",110,22,586]
[null,"Flintar","Car",350,25,327]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Limit Area (VBA)","index":8,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Scrolling in Excel"]
[]
[null,"Applying VBA Code to Limit Scroll Area"]
[]
[null,"Company Owner","Product","Number of Employee","Yearly Revenue (M)"]
[null,"Laura","Car",100,10]
[null,"James","Car",120,20]
[null,"Jane","Computer",95,12]
[null,"Peter","Garments",500,10]
[null,"Lara","Garments",700,15]
[null,"William","Oil",250,5]
[null,"Nicolas","Gas",300,20]
[null,"Haddin","Car",110,22]
[null,"Peterson","Chemicals",350,25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Freeze Panes","index":9,"n_rows":76,"n_cols":6,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[null,"Scrolling in Excel"]
[]
[null,"Showing Row and Column Labels"]
[]
[null,"Company Owner","Product","Number of Employee","Yearly Revenue (M)","Production Unit"]
[null,"Laura","Car",100,10,574]
[null,"James","Car",120,20,318]
[null,"Jane","Computer",95,12,484]
[null,"Peter","Garments",500,10,363]
[null,"Lara","Garments",700,15,558]
[null,"William","Oil",250,5,577]
[null,"Nicolas","Gas",300,20,520]
[null,"Haddin","Car",110,22,586]
[null,"Peterson","Chemicals",350,25,327]
[null,"Rob","Weapons",300,10,309]
[null,"Flintoff","Weapons",100,10,306]
[null,"Adam","Weapons",120,20,511]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Scroll Bar","index":10,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"Scrolling in Excel",null,null,null,null,null,null,null,null,null,10,null,"Scrolling in Excel"]
[]
[null,"Creating and Using Customized Scroll Bar in Excel",null,null,null,null,null,null,null,null,null,null,null,">>  Try Yourself  <<"]
[]
[null,"Company Owner","Product","No of Employee","Yearly Revenue (M)",null,"Company Owner","Product","No of Employee","Yearly Revenue (M)",null,null,null,"Company Owner","Product","No of Employee","Yearly Revenue (M)"]
[null,"Laura","Car",100,10,null,{"$f":"OFFSET(B6,$L$1,0)","v":"Flintoff"},{"$f":"OFFSET(C6,$L$1,0)","v":"Weapons"},100,10]
[null,"James","Car",120,20,null,{"$f":"OFFSET(B7,$L$1,0)","v":"Adam"},"Weapons",120,20]
[null,"Jane","Computer",95,12,null,"Kiera","Chemicals",95,12]
[null,"Peter","Garments",500,10,null,"Jason","Chemicals",500,10]
[null,"Lara","Garments",700,15,null,"Ashish","Car",250,22]
[null,"William","Oil",250,5,null,"Hiran","Car",300,25]
[null,"Nicolas","Gas",300,20,null,"Dushan","Car",110,10]
[null,"Haddin","Car",110,22,null,"Joy","Computer",350,10]
[null,"Peterson","Chemicals",350,25,null,"Kane","Garments",700,10]
[null,"Rob","Weapons",300,10,null,"Beer","Garments",650,15]
[null,"Flintoff","Weapons",100,10]
[null,"Adam","Weapons",120,20]
[null,"Kiera","Chemicals",95,12]
[null,"Jason","Chemicals",500,10]
[null,"Ashish","Car",250,22]
[null,"Hiran","Car",300,25]
[null,"Dushan","Car",110,10]
[null,"Joy","Computer",350,10]
[null,"Kane","Garments",700,10]
[null,"Beer","Garments",650,15]
[null,"Mike","Weapons",100,10]
[null,"Gray","Weapons",120,10]
[null,"Tison","Chemicals",95,20]
[null,"Erikson","Chemicals",500,12]
[null,"Nicles","Car",350,10]
[null,"Brek","Car",700,10]
[null,"Drek","Computer",650,15]
[null,"Laren","Oil",300,20]
[null,"Jovan","Gas",110,22]
[null,"Flintar","Car",350,25]