I would like to thank those people firstly, who helped me out of the issue with my spreadsheet returning incorrect values for the “IF” function… in the end, I changed the format of each cell individually…
I have one more question to ask, if anyone knows how I can do it…
I have opften used the “Freeze pane” function to lock the headings of each column, while I scroll through the results underneath… BUT… is it possible to freeze one side of the spreadsheet and leave the other able to scroll?
My spreadsheet now shows all of the sports matches taking place in a table on the left hand side of the sheet, and the current league table on the right… it would be lovely to scroll through the matches, while the league table remains visible… image below will show what I mean…
When I use the scrollng wheel, I’d like it to scroill columns A-J, While columns L-Q remain unaffected… can it be done?
