Printing question in Excel

[Crewman47]

This is for a work colleague who uses a large spreadsheet for financial stuff where I work (College) and when she prints them off they usually print over two pages and it was just to see how you could have columns from the start of the sheet show in the 2nd page but not be continous columns, eg 1, 3&4, missing out column 2.

Just a quick simple method that doesn't involve Macros or whatever.

Thanks

 

[Alpha_Geek]

So you're wanting to hide column 2? Then hide column 2.

You can also change the font to something like Arial Narrow to reduce column width.

 

[Crewman47]

So you're wanting to hide column 2? Then hide column 2.

You can also change the font to something like Arial Narrow to reduce column width.

No, all the columns in the print area need to be shown but for reference, when following onto the 2nd page, only certain columns need to be shown from the start. I don't deal with the spreadsheet myself so I don't much about it other than what I was asked.

 

[Ar-Pharazon]

Viewing in Page Break Preview allows you to decide where the L-R & Top-Bottom breaks are regardless of how much info is there.

 

[Jadzia]

if I was setting this up, I'd define a second sheet which duplicates the data from the first sheet (writing "=sheet1.a1" or whatever, into the first column). Setting column widths and column breaks so it prints nicely. One could use print preview to refine the appearance of that.

For the second (and third) printing pages, I'd duplicate the first column again (writing "=sheet1.a1" or whatever, into the next column.)

Then always edit the data in sheet 1, and always print from sheet 2.

 

[JohnChod]

Unfortunately, if you choose rows or columns to repeat on all pages, they must be contiguous (continuous). The easiest way to fix may be to move column 2 (if that doesn't botch things up) so that it becomes column 4 and then print columns 1 through 3 on each page.

 

[Alpha_Geek]

...or import the sheet into ms access and generate a real report.

 

[farmkid]

If all you want is to print columns 1 and 2 on page 1, and columns 1, 3, and 4 on page two, then the suggestions above are the simplest way. If, however, there are several pages and you want column 1 to print on all of the pages, I think there is a way to do that. When I printed my dissertation last year, I had some tables (Excel spreadsheets) that spanned many pages. I found some setting somewhere that allowed me to set the first row as a header to be printed on every page. You can probably do the same thing with the first column. I don't remember now where that setting was, but as I remember it didn't take me long to find it. I'm sure you could find it with a little quality time spent with our buddy Google or the help files.

 

[Ar-Pharazon]

^ I think what you're referring to is under File > Page Setup. It's mainly for getting the row/column repeated on printed sheets.
It goes as follows (example for rows):

Click on the red/black checkered square to the right of either "Rows to repeat.." or "Columns to repeat.."



When it changes to this, choose the row(s) or column(s) you want to repeat. Then hit the square again.



Then (for row 1) this is what it would look like. Then hit OK. Row 1 will repeat on all printed pages on the same "Sheet".




To keep the row visible during scrolling, select the row then under Window, click Freeze Pane.

Columns look a little trickier, there's some help here.