If you are not familiar with the VBA codes here is a powerful tool- Kutools for Excel its Freeze panes multiple worksheets and Unfreeze panes multiple worksheets utilities can help you to freeze or unfreeze all worksheets of current workbook at once. Learn how to Restrict work Area to few columns and rows in an excel workbook Lock Formula Cells And Protect The Worksheet Freeze Panes Hide rows columns sheets Include Cell – Comments Help Messages Data Validations using color and cell styles. Tgood37 Asked The Answer Line Forum How To Add Checkboxes To Excel Spreadsheets And Make Sure That Checking A Box Wil Microsoft Excel Excel Spreadsheets Excel Then select the VIEW tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window groupThen click on the Freeze Panes option in the popup menu. ![]() Right-click the selected row headers and pick Unhide Rows. ![]() Now when you scroll you should still continue to see row 1 and column A.
0 Comments
Leave a Reply. |