Solved

Difficulty printing parts of an Excel 2010 spreadsheet

Posted on 2014-03-12
6
21 Views
Last Modified: 2016-04-29
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
0
Comment
Question by:jon_kershaw
  • 3
6 Comments
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 39923806
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
 
LVL 29

Assisted Solution

by:gowflow
gowflow earned 500 total points
ID: 39923828
You had a page break there I removed it.
check out the file I hidden C to R

gowflow
Budget-Test.xls
0
 

Author Comment

by:jon_kershaw
ID: 39923897
Thank you for the response. I have relayed the information on to my colleagues for them to test and await their responses.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39923956
ok
gowflow
0
 
LVL 14

Expert Comment

by:frankhelk
ID: 41570981
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently resolved a client's Office 2013 installation problem and wanted to offer an observation that may help you with troubleshooting similar issues. The client ordered three Dell Optiplex system units with the Windows 7 downgrade option inst…
Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now