I have a spreadsheet where i have values in loads of columns at the top the page.as i scroll down the page these disappear so when i come to input data further down i don't know what column to put it in unless i scroll up again.how can i keep the headings to float down with me as i scroll?
Click in A2 (or wherever your headings end).Window > Freeze Panes.
Click the first data Row number on the left hand side so that it highlights the full Row.The click 'Freeze Panes' under the Windows Menu in Excel
Ah thats it, I knew i could count on this forum for answers.Thanks buddy
This thread is now locked and can not be replied to.
iMac Pro review
25 book design and illustration tips
Idées cadeaux pour geeks et tech addicts
© Copyright 2018 IDG UK. All Rights Reserved.