LinkBack URL
About LinkBacks
I have the attached worksheet. I would like to be able to print all 179 rows on one sheet or two. It would be set up in columns. Can someone help me with this?
Thank you all so much in advance!
I have the attached worksheet. I would like to be able to print all 179 rows on one sheet or two. It would be set up in columns. Can someone help me with this?
Thank you all so much in advance!
Use Portrait Instead of Landscape and organise the data by doing cut paste right side of the columns like Column-E to Column-G.
Click View>>Page Break Preview to see and adjust the print ranges.
Clik Click View>>Normal to return to normal view.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
so if I understand correctly, the only way to do what I need it too do is to change my worksheet so that it is in columns. Is that correct?
Yes exactly! since there is unused space in the right side of the page
there isn't really. There are more columns to the spreadsheet, I just didn't attach them. But I have many worksheets this way that are numbered the same way and would like to be able to print it differently than it is set up. I guess I can't, without distorting the worksheet itself but thank you for letting me know that
Good morning,
I changed my summary page like you said and put the columns all on one page. The problem now is that the total due is not working. It gives me a total but it is not the right total, can you tell me how to fix that? It works if I enter a subtotal on each column and then at the end, I put subtotal on the last column, subtotal on the first column, subtotal on the second column, subtotal on the third column and then total all at the end. Isn't there a better way to do that?
Last edited by laurabach; 04-28-2013 at 04:43 PM.
I am attaching a spreadsheet so that you can see what I am talking about....is there a better way to do the subtotals?
Cell B47 formula ends with a cell reference of A47 (i.e.)
Formula:
Please Login or Register to view this content.
In F3 cell change reference E3 to A48 and drag it down..
Formula:Please Login or Register to view this content.
Like this change the J3 and N3 cell start reference with the end references.
I'm sorry. I am very new to excel and isn't the formula already there that you are asking me to change? It is the same formula, right?
When you copy paste the formula to some other location then the cell references of the formula will get changed based on the current location of formula since the formula is constructed to react in that way.
Previously the formula is just flowing in a single column with a continuous cell reference. But now you have moved it to some other Columns/Row so the continuation of the row and column reference gets affected. So just adjust it manually since the formula is applied for 4 to 5 columns
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks