split screen

Mock spreadsheet as per below. 1. I have a power query which has over 500 lines. (Column A - C) I have set conditional formatting to highlight specific cells containing the word "CANCELLED". The user of this report will need to scroll through 500 lines to identify any "cancelled" transactions...

Is it possible to split the screen between columns G and H in the example above? I want Columns A:G to scroll up and down but H: onwards to remain. The list in the pivot table won't always be this short, so putting the PT above Row 10 and Freezing won't work as the PT may extend too far down. At...

I have an Excel workbook with one WorkSheet with room numbers and names, then inventory worksheets of computer, printers, projectors...Column A is room number, I have a split screen where column A and title row 1 are split off. If I want to jump from computer inventory to the printer I have to...

okay, we migrated to 2010, which although has some nice features, has been a nightmare, primarily because we have to use shared excel files (about 5 people), but that is another post. I have been told that if I use a split screen instead of a freeze pane, it can cause the filters (used in the...

I would like to freeze the top 30 rows via split screen and then be able to scroll the top panel left to right while the bottom panel remains justified to the left (A column). When I split the screen at row 31, I can scroll the top panel and the bottom panel up and down independently but I...