Some of my colleagues work with large Excel financial spreadsheets, used for budget planning. The spreadsheets are all .xls files, created in Excel 2003 and modified over a number of years.
Sections of a spreadsheet are reqularly selected and printed, for example when a print is required by a particular department. Typically, columns A and B are used to provide row titles and then the relevant columns (such as S to W) need to be printed to the right of columns A and B on A4 paper. Please see the attached attached .xls file.
This has always been a simple task with Excel 2003, but my colleagues are unable to work out how to do this with Excel 2010. The process has always been hit and miss, sometimes the print is ok and at other times, the columns are printed on separate pages.
What process should be followed to achieve the desired results e.g. Columns A and B, follwed immediately by (for example) colums S to W?