Difficulty printing parts of an Excel 2010 spreadsheet

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?
Budget-Test.xls
jon_kershawAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
gowflowConnect With a Mentor Commented:
Hide Col C to R
Select A to W and the area they want to print
Click on Page Layout tab click on Print Area and choose Set Print Area
Press on File choose Print
then you will see the preview in front of you just before printing.

gowflow
0
 
gowflowConnect With a Mentor Commented:
You had a page break there I removed it.
check out the file I hidden C to R

gowflow
Budget-Test.xls
0
 
jon_kershawAuthor Commented:
Thank you for the response. I have relayed the information on to my colleagues for them to test and await their responses.
0
 
gowflowCommented:
ok
gowflow
0
 
frankhelkCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
All Courses

From novice to tech pro — start learning today.