Free Microsoft Excel 2013 Quick Reference

print 2 long columns on 1 A4 page

I have a long document with only 2 narrow columns per page. I have tried to print these out so that 8 columns will fit onto one A4 page.

i can do this using cut and paste but that is not satisfactory as I constantly need to add data to the columns.

I have looked in the print setup and then page setup section where it refers to 'over then down' and also 'down then over' but it just won't do it.

I'm a novice user and have read through these help sections and Excel help but it gives me code options which I don't know how to use. Is there a simple way that I am missing?

thanks for any help


Post your answer or comment

comments powered by Disqus
I have a long (700 rows) list in an Excel worksheeet. I would like to print
the whole list on one page by making the font smaller and by printing it on
multiple columns on the page. How can I set this up?

Thanks

I am trying to print 3 page worksheets on 1 single page.

What am I doing wrong?

I went to Print and I FIRST select Entire Workbook.

But when I CLICK on the Properties dialog box it takes me out meaning it
won't allow for me to go to Properties to complete the final step which is
for me to select 4 that is located on the Pages Per Sheet drop down menu.

Do anyone know what I am doing wrong? Please let me know.

Thanks in advance.

how can i paste 2 text columns into 1 column ie:first name column and last name column to third column which will include first and last name?

I currently have 2 pivot tables on 1 sheet directly above each other, with
all the total hidden so that it looks continuos. The reason I am using 2
pivot tables is as the data comes from different sheets.

The problem I have got is when I refresh the top pivot table as the contents
of the sheet it is pulling from is populated with more data it says that 'A
Pivot Table report cannont overlap another PivotTable report'

Is there anyway that I can prevent this from happening?

Can you set the format like on a chart where the pivot table will move if
more cells are inserted.

I hope that I have explained this well enough!

The Rook

I have Excel 2002. I have a spreadsheet with 250 entries all in column A
with info for each in column B. When printed out, this uses several
pages with just a small portion to the left of the page being printed
on. If possible, I would like the columns to automatically wrap across
the page. For example, the 2 columns that print on page 2 and 3 would
automatically print to the right of the columns on page 1. Is this
possible? Thanks in advance for any help.
Robin

--
craftygramma
------------------------------------------------------------------------
craftygramma's Profile: http://www.excelforum.com/member.php...o&userid=30484
View this thread: http://www.excelforum.com/showthread...hreadid=501403

I have Excel 2002. I have a spreadsheet with 250 entries all in column A with info for each in column B. When printed out, this uses several pages with just a small portion to the left of the page being printed on. If possible, I would like the columns to automatically wrap across the page. For example, the 2 columns that print on page 2 and 3 would automatically print to the right of the columns on page 1. Is this possible? Thanks in advance for any help.
Robin

Hi you'll,

I have great printing macro that prints an area based on 1 cell.
Sub SetPrintRangeStudent1()
    Dim PrintRange As Range
    Dim FindRange As Range
'this line finds the location of the student in row 7
    Set FindRange = ActiveSheet.Rows(7).Cells.Find(Range("D1"), , xlValues, xlWhole, xlByRows, xlNext, False)
        If Not FindRange Is Nothing Then
'this line set the print range to 2 rows above the FindRange and 10 columns to the right
'it finds the bottom row automatically
Set PrintRange = Range(FindRange.Offset(-2, -3), Cells(65000, FindRange.Column).End(xlUp)).Resize(, 10)
ActiveSheet.PageSetup.PrintArea = PrintRange.Address
ActiveWindow.SelectedSheets.PrintPreview
    End If
End Sub
I like to adjust this, so that on every page it also prints C9:C20.
Do I set a second print range for this?

Every suggestion is helpful.

Marco.

I have a list of information, each row may go to a different person once it is printed. The problem is each copy needs a title header. My solution currently is to use print title to appear at the top of each page and make the rows very tall so that only the title row and 1 other row of information show on each page.

To be a bit more environmentally conscious (and to avoid way too much empty space on each page) I'd like to print out multiple columns on each page but have the title header appear after each cell, any ideas how to make this happen?

Currently
Header
Information
---page break ---
Header
Information

Goal
Header
Information

Header
Information

Header
Information

Header
Information

Header
Information
---page break ---
Header
Information

Header
Information

Header
Information

Header
Information

Header
Information

I have 20 columns going across the page but I am struggling to print on1 page I have put to landscape and fit 1 to 1 but the text is too small.I then increased text but it still looks off balanceAny advide?

I am currently printing selected records to another worksheet which prints one page for each record. Please help me print all selected records on one page.
Your help and any other useful tips are greatly appreciated.


	VB:
	
 cmdPrintSelected_Click() 
    Dim DataWks As Worksheet 
    Dim RptWks As Worksheet 
    Dim myRng As Range 
    Dim myCell As Range 
    Dim iCtr As Long 
    Dim myAddresses As Variant 
    Dim Records As Long 
    Set DataWks = Worksheets("Log") 
    Set RptWks = Worksheets("Report1") 
     
    myAddresses = Array("D1", "F2", "F3", "F1", "A1", "A2", "A3", "B3", "C3", "D2", _ 
    "D3", "A5", "F5", "A7") 
    With DataWks 
        Set myRng = .Range("B4", .Cells(.Rows.Count, "B").End(xlUp)) 
    End With 
     
    For Each myCell In myRng.Cells 
        With myCell 
            If IsEmpty(.Offset(0, -1)) Then 
            Else 
                .Offset(0, -1).ClearContents 
                For iCtr = LBound(myAddresses) To UBound(myAddresses) 
                    RptWks.Range(myAddresses(iCtr)).Value _ 
                    = myCell.Offset(0, iCtr).Value 
                Next iCtr 
                Application.Calculate 
                RptWks.PrintOut Preview:=True 
                Records = Records + 1 
                 'RptWks.Range("A1:G50").ClearContents
            End If 
        End With 
    Next myCell 
     
    MsgBox Records & " Record(s) Printed." 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


I've been searching for ages, honest. I have one long column that prints out over 4 pages. How can I make it print the columns out side by side over one page (they are narrow enough to fit). I don't want to 'move' them into the right position because I'm adding data constantly.

I've tried the "over then down" and "down then over" in the page setup but it still prints out over 4 pages.

I CAN’T SEEM TO ADJUST ROWS AND COLUMNS SO THAT SPREADSHEET WILL PRINT NICELY
AND LEGIBLY ON 1 PAGE - LEGAL SIZE PAPER – LANDSCAPE.

I CAN’T SEEM TO ADJUST ROWS AND COLUMNS SO THAT SPREADSHEET WILL PRINT NICELY
AND LEGIBLY ON 1 PAGE - LEGAL SIZE PAPER – LANDSCAPE.

I CAN’T SEEM TO ADJUST ROWS AND COLUMNS SO THAT SPREADSHEET WILL PRINT NICELY
AND LEGIBLY ON 1 PAGE - LEGAL SIZE PAPER – LANDSCAPE.

Thanks,
Pam

Within VBA, I know how to print non-contiguous ranges. I simply set up the range as (a1:a30,c5:c35,q1:a30).select. This works fine, BUT, each range is printed on a separate page even though there is plenty of room to print the 3 selections on 1 page. I have searched and searched and still have not found an answer. Does anyone know? Thank You Kindly.

I want to write a procedure to print non-contagious print areas on the same
page. For example, I want to print range A1:I8 and range A58:I66 on the
same page.

I tried the following
......
Sheets("Sheet1").Select
Union(Range("A4:I8"), Range("A58:I66")).Select
Selection.PrintOut Copies:=1, Collate:=True

but the two ranges are printed on two pages.

Regards

Basharat.

I want to be able to print the last column of my spreadsheet (Total column)
on every page that is printed from this workbook. How can I do this? I'm
stumped...

Thanks for your help!

Hi,

I am trying to reduce the calculation speed of my growing workbook and would like to know which of the below formulae would be more efficient speedwise (if I were to replace all the source data with new data)

Note that while the table below is 3x3, in reality it is closer to 100x3.
The arrays in Sheet 1 that are being referred to are usually 4000-5000 rows long but may later on grow to 10000 rows.

Scenario1:
Sheet "Rank"
ActorID	Valid	Cases6M
20	TRUE	  217
11	TRUE	  215
45	TRUE	  155
Where:
ActorID is a simple value
Valid is =COUNTIFS(Sheet1!$AC:$AC,$T2,Sheet1!$AI:$AI,">"&Output!$B$2+11)>0
Cases6M is =IF($U2=TRUE,COUNTIFS(Sheet1!$AC:$AC,$T2,Sheet1!$AI:$AI,">"&Output!$B$2+11),"")

Sheet "Output"
=VLOOKUP($J$2,Rank!$T:$V,3,FALSE)

OR

Scenario 2:
Same as Scenario 1, but in Sheet "Output"
=COUNTIFS(Sheet1!$AC:$AC,$J$2,Sheet1!$AI:$AI,">"&$B$2+11)

My creeping suspicion is that Scenario 2 would be more efficient, though I was hoping to maximize efficency by not having to calculate the same thing over and over again and instead have it calculate once and everything else draw from it.

Is it poosible to have Excel print a single column spreadsheet as multiple
columns? If I have a spreadsheet with 1500 entries and let's say that a
printed page could print 50 rows before going to the next page. Can you set
up Excel to print multiple columns on the same printed page? If I was able to
fit 3 columns on 1 page I could print the same spreadsheet on 10 pages
instead of 30. Does that make sense?

is it possible to have 2 pivot tables on one page? i want them to auto update so i use this code

Private Sub Worksheet_Activate()
ActiveSheet.PivotTables("PivotTable1").RefreshTable
End Sub

but what code do i use for a second table on the same page? i tried changing the table number to 2 but no luck.

thanks for your help

Hi all, this might be a basic question to some, but I would like to know how to add 2 differnt sized columns on 1 excel sheet. For example, I have set the column widths for data entry at the top of the page. I want to add another set of column widths (different sized) to the bottom of the page for different data. The boxes at the top will be different widths to the boxes at the bottom of the same page. Is there a way of locking the columns on the boxes at the top of the page, so I can move the columns at the bottom of the page to make a new box without the top ones moving....I hope I have explained myself clearly enough. Basically I want 2 different column sized boxes on the 1 excel sheet.
Thanks in advance for your help....but what I found, wasn't really what I am looking for. I am using Excel 2003
Cheers,
Matthew

Hi - I have just picked up Excel from daily use, but am trying to set up
2 identical forms on 1 page, with the 2nd filling in from same data as
entered in 1st - - saving time, as it were! everything works fine, but
when I backspaced out of each field in 1st form (had set up data to
check transfer) - - it leaves a 'zero' in the field on the 2nd form. How
do I get it to be blank, when there is nothing in that particular
field (sometimes there will be nothing in a certain field, and they are a
mix of date/text/number fields).

'fill' is not really what I want, and not feasible for the person who will
be doing the data entry, at least I do not believe so . . .

THANKS to anyone who can fill me in . . . put me on the right track . . .etc
:-)

Hi everyone.

I am trying to take a spreadsheet and have each row print on a seperate page - without having to do the print area thing on each row.

Is there a way to automate this process?

Thank you.

Hi all,

I searched the archives, but am searching no good I think.

Is it possible to enter 2 independent graphs on 1 chart sheet?
I'm not referring to overlay charts.
I thought to remember I read about it, but can't find it back.

I like to have 2 graphs on top of one another in the same chart sheet.
Is there a manner to accomplish this or is this just wishfull thinking?

I know I can embed them in a standard worksheet, but the file is existing
already.

Many thanks in advance.
If not possible, that's an as valid reply as well.

TIA

Eric


No luck finding an answer? You could always try Google.