Solved

Difficulty printing parts of an Excel 2010 spreadsheet

Posted on 2014-03-12
6
39 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 30

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 30

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 30

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

732 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