Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel training - Window
Hi Thomas
Thanks for your question.
Click on the row number of the row containing the data you would like to freeze on the screen and go to the window menu choose Freeze pane.
Hope this helps - let us know if you need any further assistance.
Kind regards,
Andrew
To move data from one worksheet to another, highlight the data.
Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.
Drag the selection down to the destination worksheet tab.
When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.
To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
