Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to printout only selected rows and columns
Hi all.
here's my problem: I have a sheet with headers: first name, surname, address1, address2, someotherstuff I would like to select some rows (continous) and appropriate columns (continous) and get a simple printout of the selected data. ... for now Later I would like to fomat this data in order to get proper labels as prints. I am sorry ... I haven't a clou how to start this reasonably and would appreciate your help !! TIA Gina |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to printout only selected rows and columns
Under FILE on the menu, choose PAGE SETUP Sheet. You should see two
options: "Rows to repeat at top" & "Columns to repeat at left" I have not used the row option, buth if the headers were in column A, I would put A:A in the Column option. Then highlight what continues columns I wanted to print and the appropriote headers in column A would print. Maybe you just have to enter 1 for the Row if you want row 1 to print as stated. Les "Gina Meyer" wrote: Hi all. here's my problem: I have a sheet with headers: first name, surname, address1, address2, someotherstuff I would like to select some rows (continous) and appropriate columns (continous) and get a simple printout of the selected data. ... for now Later I would like to fomat this data in order to get proper labels as prints. I am sorry ... I haven't a clou how to start this reasonably and would appreciate your help !! TIA Gina |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to printout only selected rows and columns
Hi Pilot.
Thanks for your answer .... but unfortunately it is not what I need in this case, I think what I have tried so far is: *********** Sub PrintMySelection() Dim strTopLeft, strEndRight As String strTopLeft = "$A$2" strEndRight = "$E$3" ActiveSheet.PageSetup.PrintArea = strTopLeft & ":" & strEndRight ActiveSheet.PrintOut ActiveSheet.PageSetup.PrintArea = Null End Sub ************ What I would rather like to have is a more dynamic approach .... whatever rows and columns I select say next time ... I would like to have row 5-15 ( because I have selected them) .... same number of columns though maybe someone can point me to right direction (I am using Access 2000) Thanks, Gina "WLMPilot" schrieb im Newsbeitrag ... Under FILE on the menu, choose PAGE SETUP Sheet. You should see two options: "Rows to repeat at top" & "Columns to repeat at left" I have not used the row option, buth if the headers were in column A, I would put A:A in the Column option. Then highlight what continues columns I wanted to and the appropriote headers in column A would print. Maybe you just have to enter 1 for the Row if you want row 1 to print as stated. Les "Gina Meyer" wrote: Hi all. here's my problem: I have a sheet with headers: first name, surname, address1, address2, someotherstuff I would like to select some rows (continous) and appropriate columns (continous) and get a simple printout of the selected data. ... for now Later I would like to fomat this data in order to get proper labels as prints. I am sorry ... I haven't a clou how to start this reasonably and would appreciate your help !! TIA Gina |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to printout only selected rows and columns
This is an Excel forum :)
Pilot's answer assumed you wanted the headers printed - because you mentioned them. Steve On Thu, 31 Aug 2006 13:07:16 +0100, Gina M. wrote: Hi Pilot. Thanks for your answer .... but unfortunately it is not what I need in this case, I think what I have tried so far is: *********** Sub PrintMySelection() Dim strTopLeft, strEndRight As String strTopLeft = "$A$2" strEndRight = "$E$3" ActiveSheet.PageSetup.PrintArea = strTopLeft & ":" & strEndRight ActiveSheet.PrintOut ActiveSheet.PageSetup.PrintArea = Null End Sub ************ What I would rather like to have is a more dynamic approach .... whatever rows and columns I select say next time ... I would like to have row 5-15 ( because I have selected them) ... same number of columns though maybe someone can point me to right direction (I am using Access 2000) Thanks, Gina "WLMPilot" schrieb im Newsbeitrag ... Under FILE on the menu, choose PAGE SETUP Sheet. You should see two options: "Rows to repeat at top" & "Columns to repeat at left" I have not used the row option, buth if the headers were in column A, I would put A:A in the Column option. Then highlight what continues columns I wanted to and the appropriote headers in column A would print. Maybe you just have to enter 1 for the Row if you want row 1 to print as stated. Les "Gina Meyer" wrote: Hi all. here's my problem: I have a sheet with headers: first name, surname, address1, address2, someotherstuff I would like to select some rows (continous) and appropriate columns (continous) and get a simple printout of the selected data. ... for now Later I would like to fomat this data in order to get proper labels as prints. I am sorry ... I haven't a clou how to start this reasonably and would appreciate your help !! TIA Gina -- Steve (3) |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to printout only selected rows and columns
sorry ... I may then have to find a different forum ?
I am too new to even find my way through here thanks anyway Gina "SteveW" schrieb im Newsbeitrag news:op.te5o2smtevjsnp@enigma03... This is an Excel forum :) Pilot's answer assumed you wanted the headers printed - because you mentioned them. Steve On Thu, 31 Aug 2006 13:07:16 +0100, Gina M. wrote: Hi Pilot. Thanks for your answer .... but unfortunately it is not what I need in this case, I think what I have tried so far is: *********** Sub PrintMySelection() Dim strTopLeft, strEndRight As String strTopLeft = "$A$2" strEndRight = "$E$3" ActiveSheet.PageSetup.PrintArea = strTopLeft & ":" & strEndRight ActiveSheet.PrintOut ActiveSheet.PageSetup.PrintArea = Null End Sub ************ What I would rather like to have is a more dynamic approach .... whatever rows and columns I select say next time ... I would like to have row 5-15 ( because I have selected them) ... same number of columns though maybe someone can point me to right direction (I am using Access 2000) Thanks, Gina "WLMPilot" schrieb im Newsbeitrag ... Under FILE on the menu, choose PAGE SETUP Sheet. You should see two options: "Rows to repeat at top" & "Columns to repeat at left" I have not used the row option, buth if the headers were in column A, I would put A:A in the Column option. Then highlight what continues columns I wanted to and the appropriote headers in column A would print. Maybe you just have to enter 1 for the Row if you want row 1 to print as stated. Les "Gina Meyer" wrote: Hi all. here's my problem: I have a sheet with headers: first name, surname, address1, address2, someotherstuff I would like to select some rows (continous) and appropriate columns (continous) and get a simple printout of the selected data. ... for now Later I would like to fomat this data in order to get proper labels as prints. I am sorry ... I haven't a clou how to start this reasonably and would appreciate your help !! TIA Gina -- Steve (3) |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to printout only selected rows and columns
I'd answer, but I don't use Acess so can't quite help
Steve On Thu, 31 Aug 2006 17:32:39 +0100, Gina M. wrote: sorry ... I may then have to find a different forum ? I am too new to even find my way through here thanks anyway Gina "SteveW" schrieb im Newsbeitrag news:op.te5o2smtevjsnp@enigma03... This is an Excel forum :) Pilot's answer assumed you wanted the headers printed - because you mentioned them. Steve On Thu, 31 Aug 2006 13:07:16 +0100, Gina M. wrote: Hi Pilot. Thanks for your answer .... but unfortunately it is not what I need in this case, I think what I have tried so far is: *********** Sub PrintMySelection() Dim strTopLeft, strEndRight As String strTopLeft = "$A$2" strEndRight = "$E$3" ActiveSheet.PageSetup.PrintArea = strTopLeft & ":" & strEndRight ActiveSheet.PrintOut ActiveSheet.PageSetup.PrintArea = Null End Sub ************ What I would rather like to have is a more dynamic approach .... whatever rows and columns I select say next time ... I would like to have row 5-15 ( because I have selected them) ... same number of columns though maybe someone can point me to right direction (I am using Access 2000) Thanks, Gina "WLMPilot" schrieb im Newsbeitrag ... Under FILE on the menu, choose PAGE SETUP Sheet. You should see two options: "Rows to repeat at top" & "Columns to repeat at left" I have not used the row option, buth if the headers were in column A, I would put A:A in the Column option. Then highlight what continues columns I wanted to and the appropriote headers in column A would print. Maybe you just have to enter 1 for the Row if you want row 1 to print as stated. Les "Gina Meyer" wrote: Hi all. here's my problem: I have a sheet with headers: first name, surname, address1, address2, someotherstuff I would like to select some rows (continous) and appropriate columns (continous) and get a simple printout of the selected data. ... for now Later I would like to fomat this data in order to get proper labels as prints. I am sorry ... I haven't a clou how to start this reasonably and would appreciate your help !! TIA Gina -- Steve (3) |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to printout only selected rows and columns
Steve
unbelievable ... I meant Excel .... 2000 ... I was probably thinking about better using access and wrote ... ashes on my head Gina "SteveW" schrieb im Newsbeitrag news:op.te5p74flevjsnp@enigma03... I'd answer, but I don't use Acess so can't quite help Steve On Thu, 31 Aug 2006 17:32:39 +0100, Gina M. wrote: sorry ... I may then have to find a different forum ? I am too new to even find my way through here thanks anyway Gina "SteveW" schrieb im Newsbeitrag news:op.te5o2smtevjsnp@enigma03... This is an Excel forum :) Pilot's answer assumed you wanted the headers printed - because you mentioned them. Steve On Thu, 31 Aug 2006 13:07:16 +0100, Gina M. wrote: Hi Pilot. Thanks for your answer .... but unfortunately it is not what I need in this case, I think what I have tried so far is: *********** Sub PrintMySelection() Dim strTopLeft, strEndRight As String strTopLeft = "$A$2" strEndRight = "$E$3" ActiveSheet.PageSetup.PrintArea = strTopLeft & ":" & strEndRight ActiveSheet.PrintOut ActiveSheet.PageSetup.PrintArea = Null End Sub ************ What I would rather like to have is a more dynamic approach .... whatever rows and columns I select say next time ... I would like to have row 5-15 ( because I have selected them) ... same number of columns though maybe someone can point me to right direction (I am using Access 2000) Thanks, Gina "WLMPilot" schrieb im Newsbeitrag ... Under FILE on the menu, choose PAGE SETUP Sheet. You should see two options: "Rows to repeat at top" & "Columns to repeat at left" I have not used the row option, buth if the headers were in column A, I would put A:A in the Column option. Then highlight what continues columns I wanted to and the appropriote headers in column A would print. Maybe you just have to enter 1 for the Row if you want row 1 to print as stated. Les "Gina Meyer" wrote: Hi all. here's my problem: I have a sheet with headers: first name, surname, address1, address2, someotherstuff I would like to select some rows (continous) and appropriate columns (continous) and get a simple printout of the selected data. ... for now Later I would like to fomat this data in order to get proper labels as prints. I am sorry ... I haven't a clou how to start this reasonably and would appreciate your help !! TIA Gina -- Steve (3) |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to printout only selected rows and columns
Mmmmm.
So the gist is that you want to select an area and print it from a macro (button I guess) 2nd bit, was to remember the columns and on subsequent range selections just alter the rows (using the previous columns) Your macro works - but only for the area you hard-coded in. Off to think - sorry Steve On Thu, 31 Aug 2006 18:51:44 +0100, Gina M. wrote: Steve unbelievable ... I meant Excel .... 2000 ... I was probably thinking about better using access and wrote .... ashes on my head Gina "SteveW" schrieb im Newsbeitrag news:op.te5p74flevjsnp@enigma03... I'd answer, but I don't use Acess so can't quite help Steve On Thu, 31 Aug 2006 17:32:39 +0100, Gina M. wrote: sorry ... I may then have to find a different forum ? I am too new to even find my way through here thanks anyway Gina "SteveW" schrieb im Newsbeitrag news:op.te5o2smtevjsnp@enigma03... This is an Excel forum :) Pilot's answer assumed you wanted the headers printed - because you mentioned them. Steve On Thu, 31 Aug 2006 13:07:16 +0100, Gina M. wrote: Hi Pilot. Thanks for your answer .... but unfortunately it is not what I need in this case, I think what I have tried so far is: *********** Sub PrintMySelection() Dim strTopLeft, strEndRight As String strTopLeft = "$A$2" strEndRight = "$E$3" ActiveSheet.PageSetup.PrintArea = strTopLeft & ":" & strEndRight ActiveSheet.PrintOut ActiveSheet.PageSetup.PrintArea = Null End Sub ************ What I would rather like to have is a more dynamic approach .... whatever rows and columns I select say next time ... I would like to have row 5-15 ( because I have selected them) ... same number of columns though maybe someone can point me to right direction (I am using Access 2000) Thanks, Gina "WLMPilot" schrieb im Newsbeitrag ... Under FILE on the menu, choose PAGE SETUP Sheet. You should see two options: "Rows to repeat at top" & "Columns to repeat at left" I have not used the row option, buth if the headers were in column A, I would put A:A in the Column option. Then highlight what continues columns I wanted to and the appropriote headers in column A would print. Maybe you just have to enter 1 for the Row if you want row 1 to print as stated. Les "Gina Meyer" wrote: Hi all. here's my problem: I have a sheet with headers: first name, surname, address1, address2, someotherstuff I would like to select some rows (continous) and appropriate columns (continous) and get a simple printout of the selected data. ... for now Later I would like to fomat this data in order to get proper labels as prints. I am sorry ... I haven't a clou how to start this reasonably and would appreciate your help !! TIA Gina |
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to printout only selected rows and columns
How about:
Sub PrintSelection() Selection.PrintOut Copies:=1 End Sub That will send whatever you have currently selected to the default printer. "Gina M." wrote: Steve unbelievable ... I meant Excel .... 2000 ... I was probably thinking about better using access and wrote ... ashes on my head Gina "SteveW" schrieb im Newsbeitrag news:op.te5p74flevjsnp@enigma03... I'd answer, but I don't use Acess so can't quite help Steve On Thu, 31 Aug 2006 17:32:39 +0100, Gina M. wrote: sorry ... I may then have to find a different forum ? I am too new to even find my way through here thanks anyway Gina "SteveW" schrieb im Newsbeitrag news:op.te5o2smtevjsnp@enigma03... This is an Excel forum :) Pilot's answer assumed you wanted the headers printed - because you mentioned them. Steve On Thu, 31 Aug 2006 13:07:16 +0100, Gina M. wrote: Hi Pilot. Thanks for your answer .... but unfortunately it is not what I need in this case, I think what I have tried so far is: *********** Sub PrintMySelection() Dim strTopLeft, strEndRight As String strTopLeft = "$A$2" strEndRight = "$E$3" ActiveSheet.PageSetup.PrintArea = strTopLeft & ":" & strEndRight ActiveSheet.PrintOut ActiveSheet.PageSetup.PrintArea = Null End Sub ************ What I would rather like to have is a more dynamic approach .... whatever rows and columns I select say next time ... I would like to have row 5-15 ( because I have selected them) ... same number of columns though maybe someone can point me to right direction (I am using Access 2000) Thanks, Gina "WLMPilot" schrieb im Newsbeitrag ... Under FILE on the menu, choose PAGE SETUP Sheet. You should see two options: "Rows to repeat at top" & "Columns to repeat at left" I have not used the row option, buth if the headers were in column A, I would put A:A in the Column option. Then highlight what continues columns I wanted to and the appropriote headers in column A would print. Maybe you just have to enter 1 for the Row if you want row 1 to print as stated. Les "Gina Meyer" wrote: Hi all. here's my problem: I have a sheet with headers: first name, surname, address1, address2, someotherstuff I would like to select some rows (continous) and appropriate columns (continous) and get a simple printout of the selected data. ... for now Later I would like to fomat this data in order to get proper labels as prints. I am sorry ... I haven't a clou how to start this reasonably and would appreciate your help !! TIA Gina -- Steve (3) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should high-light Rows & Columns when cell selected. | Setting up and Configuration of Excel | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |