I do not want Excel on-screen lines to print
I am using Office 2007. I create Excel spreadsheets in Word and the on-screen guide lines print. How do I keep the lines on screen but not print them?
MAB
excel.charting
18370 articles. 
0 followers.
2 Replies
570 Views
In Excel: File | Page Setup | Sheet and uncheck Print Gridlines best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MAB" <MAB@discussions.microsoft.com> wrote in message news:AB5E7ED4-80DB-4BD6-9331-74CD884B9EF8@microsoft.com... >I am using Office 2007. I create Excel spreadsheets in Word and the > on-screen guide lines print. How do I keep the lines on screen but not > print > them?
bliengme5824MAB - In Excel 2007, Page Layout tab in the Ribbon, Sheet Options section, uncheck Print Gridlines. Or, more indirectly, in Excel 2007, Office Button | Print | Print Preview | Page Setup | Sheet | uncheck Gridlines. - Mike http://www.mikemiddleton.com "MAB" <MAB@discussions.microsoft.com> wrote in message news:AB5E7ED4-80DB-4BD6-9331-74CD884B9EF8@microsoft.com... >I am using Office 2007. I create Excel spreadsheets in Word and the > on-screen guide lines print. How do I keep the lines on screen but not > print > them?
mike5208
Similar Artilces:
How to use outlook address in Excel
Hello, I have an Excel sheet which I use as an invoicing-application. I would like to retrieve address-data from Outlook where I keep all my contact-data of my customers. So, I want to select a customer from my Outlook contactlist when I am writing a new invoice in Excel. In Word, I have a macro which does this, but unfortunately the Application.GetAddress does not work in Excel. Can somebody help me ? "Henny Slokker" wrote: > Hello, > > I have an Excel sheet which I use as an invoicing-application. I would like > to retrieve address-data from Outlook where I...
Excel Drop Down Box
I'm trying to edit an excel worksheet that has drop down boxes. However, the drop down boxes are not typical forms. These drop dow boxes appear to be normal cells (They contain text). When I click o the box, a little gray box shows up w/ a down arrow to the right of th cell. However, if you right click on the cell, there aren't an property options that are displayed. I was wondering if anybody had any idea what kind of drop down box thi is. How can I edit or create one -- Message posted from http://www.ExcelForum.com It sounds like it's under Data|Validation. chris313 wr...
Pasting data from Excel
Hello everyone, I'm not sure if I should be posting this question here or in the Excel forum but here goes. Is it possible to copy data from multiple cells in Excel and then paste them into multiple lines of the criteria section of an Access query? For example, Given cells and values: A1- 1 A2- 2 A3- 3 I would like to be able to copy this data from Excel and paste it into an Access query like : Criteria: 1 or: 2 3 I am using Access 2002 SP3 and Exc...
how to select multiple text boxes in excel for formatting
I am trying to select multiple text boxes for formatting the font but seem unable to select all of them other than to click on each one individually. Is there an easy way to select all of the text boxes at once? To select multiple objects on the sheet -- Click on one object Hold the Ctrl key, and click on additional objects To select all the objects on the sheet -- Choose Edit>Go To, click Special Select Objects, click OK Or, to work with specific objects, you can add the 'Select Multiple Objects' tool to one of your toolbars: Choose Tools>Customize Select the Commands tab...
How do I add vertical lines to separate columns in Outlook 2003 #2
In Outlook 2000, all columns were separated by a gray vertical line. I can't seem to set this up in Outlook 2003. Any help would be appreciated ARe you using Word as the message editor? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, mschwartz asked: | In Outlook 2000, all columns were separated by a gray | vertical line. I can't seem to set this up in O...
excel margin issues on landscape
When I print a spreadsheet I cant get it to print to the full page - it prints smaller unlike older excel program. Also when i set the margins for a spreadsheet the left hand margin wont move over to the edge of page like right hand side? In Page Setup: If you are using the Scaling option to print to a certain number of pages wide by pages tall and/or you are using the columns to repeat at left, try: - clearing the number of pages tall value (so that it is blank), and/or - if you are printing to one page wide, remove the columns to repeat at left Simon "Peter MB" wrote: >...
Printing data forms
I would like to be able to print Excel data forms. Is there a way? In some event of the form (a button, a click of the form itself, whatever): Me.PrintForm "Curious" <anonymous@discussions.microsoft.com> wrote in message news:170101c47bf9$f9191420$a301280a@phx.gbl... >I would like to be able to print Excel data forms. Is > there a way? If you mean the form you get when you do Data=>Form with the form displayed, do Alt+Print Screen. then drop the form and go to a new worksheet and do Edit=>Paste This will put an image of the form on the worksheet and yo...
Excel macro list
In Excel 2003 I used to be able to list all macros in a workbook by pressing Alt+F8. Now all I get is a series of ribbon help letters... What's changed? Is there still a way of accessing macros via Alt+F8? Any suggestions appreciated. Hi, ALT+F8 works for me in E2007. What do you mean by 'I get is a series of ribbon help letters' Mike "pbaker6" wrote: > In Excel 2003 I used to be able to list all macros in a workbook by pressing > Alt+F8. Now all I get is a series of ribbon help letters... What's changed? > Is there still a way of...
Can I only allow printing to pdf in Excel?
I have created a template in Excel which has been set up so that the layout is perfect when printing to pdf (which is how the document will mostly be used) but the layout changes if printing direct to our printer. Is there a way that I can ONLY allow printing to pdf from this document? Hello You may consider using some VBA to achieve this. One way is to use the Workbook_BeforePrint event and specify the pdf printer in the PrintOut method, eg: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PrintOut copies:=1, ActivePrinter:="CutePDF Writer on CPW2:" End Sub Pl...
"Print Quote For Customer"
Using the Outlook client this option is under the file menu when you have a quote open. What template does this use and where do I download it from? ...
Print 2 receipts when selling item with rebate?
Is there any way to program rms to print multiple receipts on particullar items, for example I sell an automatic pool cleaner that has two differant mail in rebates and we always supply the customer with duplicate receipts Victor Out of the box, no. The easiest way is to train cashiers to use the Reprint function when they need a second copy. The other option is to configure the receipts to print 2 copies every time, but that's probably a waste of paper. I'm pretty sure this could be accomplished as a customization using the HTML status bar and QSBridge, but you would need a ...
query will not write to excel
I have set up a query to a Foxpro .dbf file in a database from excel. When I tell Excel to import the data it it appears to be working but never seems to return the data. Running the same query via msquery.exe returns the data with no problem. Can anyone tell me what the problem is ? ...
End user wants to create items in Global Address List
I have an end user who wants to be able to create distribution lists and entries in the global address list. Any idea how I can configure him to do this? Douglas he would have to have Exchange permissions, and that isn't a particularly good idea... "Douglas McIver" <douglas@nospam.com> wrote in message news:OFGd$QhiEHA.1104@TK2MSFTNGP10.phx.gbl... > I have an end user who wants to be able to create distribution lists and > entries in the global address list. Any idea how I can configure him to do > this? > > Douglas > > ...
I want to be able to scroll smoothly rather than one cell at a ti.
I want to be able to view my Excel file a certain way, but when I use the scrollbar, it only lets me scroll based on the widths of the cells. I want to be able to scroll smoothly. I want to be able to view partial cells, without being forced to view the entire cell. If i want to have some border cells surrounding the information of interest, it doesn;t let me partially exclude them from view. Please fix this so that I can view my files the way I want to view them. I can scroll "smoothly" ... using my mouse! *Clicking* the scroll wheel brings up a 4 headed arrow "thi...
Print preview anomoly
I have an application that was created in excel which has command buttons, drop down input fields, and Labels. Whenever I go to print preview all of the Visaul Basic command buttons, drop down input fields and labels move to the left of the paage being previewed. Closing the print preview window and the buttons stay to the left. Can anyone help. I have reloaded Office and I am using WIndows XP. This is an Excel 2002 SP3 bug: http://support.microsoft.com/default.aspx?scid=kb;en-us;838910&Product=xl2002 -- Jim Rech Excel MVP "Jerry Sanner" <anonymous@discussions.m...
EXCEL FORMULA #28
Good afternoon, I'm trying to fine a formula which would show me how much money I would save on a mortgage if I were to pay additional principal each month--in addition to paying the additional principal how long would it take to pay off. I'm looking at a 160k mortgage at 7.5 for 30 years. I'll like to pay this off as soon as possible by paying additional principal each month. There are tons of free templates at: http://office.microsoft.com/en-us/default.aspx Maybe you'll find something you like. Kam1999i wrote: > > Good afternoon, > > I'm ...
OLE: Excel.Application
Hello, in VB.Net, I use Excel to display results : dim xl as new Excel.Application // creates an Excel process // snip (putting values into cells) xl.Visible = true If the user closes the Excel file and then my program, the Excel process is killed in memory, which is good. If the user closes my program first and then the Excel file, the Excel process remains in memory ! How can I make sure the process will be killed ? Thanks ! Hi You need to set xl.quit (and before that ensure that excel doesn't halt and ask things like "save changes?" on quitting) somewhere in your p...
Export relationship information from Visio to Excel
Hello all, Is there a way to export information regarding relationships from a visio diagram to an excel spreadsheet? In addition, is there a way to tell the excel spreadsheet to eliminate or change a relationship and for that action to be applied onto the visio diagram? thanks, ivan as a general answer I'd have to say "no, not without custom code". You didn't define what you meant as a relationship. al "Ivan Salas" <IvanSalas@discussions.microsoft.com> wrote in message news:6332A594-E4AF-4E8B-BA2D-7A4BC17962B3@microsoft.com... > Hello all, > &...
startup excel euro symbol
when i digit € symbol inside any application excel 2007 automacic startup and for me is impossible to use this symbol anywhere, i use windows xp professional ..have you a response to solve this problem? thanks ...
Excel 2003 Print Issue
I have created a spreadsheet to help with a university engineering assignment and I have added a worksheet that is basically an automatically generated report of all the calculations. I have set the Print Area up in such a way so that the results are printed out in well defined pages (e.g. page 1: title page, page 2: summary of input variables, page 3: summary of calculation results etc). The report is arranged vertically in the worksheet, so the pages are 'stacked' on top of each other. It prints out fine in Excel 2000 and 2002 but I recently upgraded to Excel 2003 and now find tha...
How do i locate the point of intersection of two lines graphs
I have a plot of two lines using excell which intersect at a point. I want to locate the point of their intersection using excell and show the co-ordinates of that point so that any body can see that i read that point from it. Step by step procedurewould be helpful and i am using microsoft excel 2007. Thanks. I will assume you have two straight lines - if not please tell me what they are. Let the lines follow the two functions y1=m1x1+b1 and y2=m2x2+b2 Let the point of intersection be Y and X Then m1X+b1=m2X+b2, giving X=(b2-b1)/(m1-m2) In Excel terms, X=(INTERCEPT(y-values2,x-values2)...
Printing Externally #2
That works great...except it word brings up a message box stating tha Word is currently printing, if you exit, you will cancel you print.....and if i click no, so i dont close word, it still doesnt wan to print...any suggestions???Thank -- tess45 ----------------------------------------------------------------------- tess457's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1393 View this thread: http://www.excelforum.com/showthread.php?threadid=26662 There's a setting in MSWord that allows you to do background printing. I've turned this off--so Word do...
How to print Directly from Dialog based application
HI all, I am writing MFC Extension DLl which has dialog in it. It has list of documents ( like .doc,.xls,.pdf etc....) When user double clicks the document I do ShellExecute to open it..... Now i have print button . When user clicks Print button Selected document in the list should be printed...... I want to print that document directly ( that is without opening corresponding application....e.g. want to print 1.doc without opening MSWord) How can i achive this? Will DDE command will help ? How? Any Guidence Or Link for that? I have tried with ShellexecuteEx with "print" as verb ...
excel 2000 message
excel 2000 message - 'cannot use object linking and embedding' Were they hit by the MSBlast worm? One poster (Lutz Meyer) guessed that this was the cause of his problems. I haven't seen any confirmation/denial, but you may want to read his post: http://groups.google.com/groups?threadm=3F3971AF.FA4490F5%40msn.com Post back with your results. I'm curious if that was the problem. (It's come up quite a few times since MSBlast hit.) bill bootle wrote: > > excel 2000 message - 'cannot use object linking and > embedding' -- Dave Peterson ec35720@msn.c...
Excel Graphing Line References off when chart is a sheet.
I have noticed that when any graph is created in EXCEL and you hover you mouse over the dataline you receive that corect response. If you convert the chart to a sheet, the hover of the data line is now not representative of the the y axis directly below it. The data being graphed is correct now the hover represents the "series" (x-Axis) correctly but does not represent the "Point" (y-axis) correctly at all. Tne Y-axis datapoint reference is wrong. Any help? ...
Hello, I have an Excel sheet which I use as an invoicing-application. I would like to retrieve address-data from Outlook where I keep all my contact-data of my customers. So, I want to select a customer from my Outlook contactlist when I am writing a new invoice in Excel. In Word, I have a macro which does this, but unfortunately the Application.GetAddress does not work in Excel. Can somebody help me ? "Henny Slokker" wrote: > Hello, > > I have an Excel sheet which I use as an invoicing-application. I would like > to retrieve address-data from Outlook where I...
Excel Drop Down Box
I'm trying to edit an excel worksheet that has drop down boxes. However, the drop down boxes are not typical forms. These drop dow boxes appear to be normal cells (They contain text). When I click o the box, a little gray box shows up w/ a down arrow to the right of th cell. However, if you right click on the cell, there aren't an property options that are displayed. I was wondering if anybody had any idea what kind of drop down box thi is. How can I edit or create one -- Message posted from http://www.ExcelForum.com It sounds like it's under Data|Validation. chris313 wr...
Pasting data from Excel
Hello everyone, I'm not sure if I should be posting this question here or in the Excel forum but here goes. Is it possible to copy data from multiple cells in Excel and then paste them into multiple lines of the criteria section of an Access query? For example, Given cells and values: A1- 1 A2- 2 A3- 3 I would like to be able to copy this data from Excel and paste it into an Access query like : Criteria: 1 or: 2 3 I am using Access 2002 SP3 and Exc...
how to select multiple text boxes in excel for formatting
I am trying to select multiple text boxes for formatting the font but seem unable to select all of them other than to click on each one individually. Is there an easy way to select all of the text boxes at once? To select multiple objects on the sheet -- Click on one object Hold the Ctrl key, and click on additional objects To select all the objects on the sheet -- Choose Edit>Go To, click Special Select Objects, click OK Or, to work with specific objects, you can add the 'Select Multiple Objects' tool to one of your toolbars: Choose Tools>Customize Select the Commands tab...
How do I add vertical lines to separate columns in Outlook 2003 #2
In Outlook 2000, all columns were separated by a gray vertical line. I can't seem to set this up in Outlook 2003. Any help would be appreciated ARe you using Word as the message editor? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, mschwartz asked: | In Outlook 2000, all columns were separated by a gray | vertical line. I can't seem to set this up in O...
excel margin issues on landscape
When I print a spreadsheet I cant get it to print to the full page - it prints smaller unlike older excel program. Also when i set the margins for a spreadsheet the left hand margin wont move over to the edge of page like right hand side? In Page Setup: If you are using the Scaling option to print to a certain number of pages wide by pages tall and/or you are using the columns to repeat at left, try: - clearing the number of pages tall value (so that it is blank), and/or - if you are printing to one page wide, remove the columns to repeat at left Simon "Peter MB" wrote: >...
Printing data forms
I would like to be able to print Excel data forms. Is there a way? In some event of the form (a button, a click of the form itself, whatever): Me.PrintForm "Curious" <anonymous@discussions.microsoft.com> wrote in message news:170101c47bf9$f9191420$a301280a@phx.gbl... >I would like to be able to print Excel data forms. Is > there a way? If you mean the form you get when you do Data=>Form with the form displayed, do Alt+Print Screen. then drop the form and go to a new worksheet and do Edit=>Paste This will put an image of the form on the worksheet and yo...
Excel macro list
In Excel 2003 I used to be able to list all macros in a workbook by pressing Alt+F8. Now all I get is a series of ribbon help letters... What's changed? Is there still a way of accessing macros via Alt+F8? Any suggestions appreciated. Hi, ALT+F8 works for me in E2007. What do you mean by 'I get is a series of ribbon help letters' Mike "pbaker6" wrote: > In Excel 2003 I used to be able to list all macros in a workbook by pressing > Alt+F8. Now all I get is a series of ribbon help letters... What's changed? > Is there still a way of...
Can I only allow printing to pdf in Excel?
I have created a template in Excel which has been set up so that the layout is perfect when printing to pdf (which is how the document will mostly be used) but the layout changes if printing direct to our printer. Is there a way that I can ONLY allow printing to pdf from this document? Hello You may consider using some VBA to achieve this. One way is to use the Workbook_BeforePrint event and specify the pdf printer in the PrintOut method, eg: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PrintOut copies:=1, ActivePrinter:="CutePDF Writer on CPW2:" End Sub Pl...
"Print Quote For Customer"
Using the Outlook client this option is under the file menu when you have a quote open. What template does this use and where do I download it from? ...
Print 2 receipts when selling item with rebate?
Is there any way to program rms to print multiple receipts on particullar items, for example I sell an automatic pool cleaner that has two differant mail in rebates and we always supply the customer with duplicate receipts Victor Out of the box, no. The easiest way is to train cashiers to use the Reprint function when they need a second copy. The other option is to configure the receipts to print 2 copies every time, but that's probably a waste of paper. I'm pretty sure this could be accomplished as a customization using the HTML status bar and QSBridge, but you would need a ...
query will not write to excel
I have set up a query to a Foxpro .dbf file in a database from excel. When I tell Excel to import the data it it appears to be working but never seems to return the data. Running the same query via msquery.exe returns the data with no problem. Can anyone tell me what the problem is ? ...
End user wants to create items in Global Address List
I have an end user who wants to be able to create distribution lists and entries in the global address list. Any idea how I can configure him to do this? Douglas he would have to have Exchange permissions, and that isn't a particularly good idea... "Douglas McIver" <douglas@nospam.com> wrote in message news:OFGd$QhiEHA.1104@TK2MSFTNGP10.phx.gbl... > I have an end user who wants to be able to create distribution lists and > entries in the global address list. Any idea how I can configure him to do > this? > > Douglas > > ...
I want to be able to scroll smoothly rather than one cell at a ti.
I want to be able to view my Excel file a certain way, but when I use the scrollbar, it only lets me scroll based on the widths of the cells. I want to be able to scroll smoothly. I want to be able to view partial cells, without being forced to view the entire cell. If i want to have some border cells surrounding the information of interest, it doesn;t let me partially exclude them from view. Please fix this so that I can view my files the way I want to view them. I can scroll "smoothly" ... using my mouse! *Clicking* the scroll wheel brings up a 4 headed arrow "thi...
Print preview anomoly
I have an application that was created in excel which has command buttons, drop down input fields, and Labels. Whenever I go to print preview all of the Visaul Basic command buttons, drop down input fields and labels move to the left of the paage being previewed. Closing the print preview window and the buttons stay to the left. Can anyone help. I have reloaded Office and I am using WIndows XP. This is an Excel 2002 SP3 bug: http://support.microsoft.com/default.aspx?scid=kb;en-us;838910&Product=xl2002 -- Jim Rech Excel MVP "Jerry Sanner" <anonymous@discussions.m...
EXCEL FORMULA #28
Good afternoon, I'm trying to fine a formula which would show me how much money I would save on a mortgage if I were to pay additional principal each month--in addition to paying the additional principal how long would it take to pay off. I'm looking at a 160k mortgage at 7.5 for 30 years. I'll like to pay this off as soon as possible by paying additional principal each month. There are tons of free templates at: http://office.microsoft.com/en-us/default.aspx Maybe you'll find something you like. Kam1999i wrote: > > Good afternoon, > > I'm ...
OLE: Excel.Application
Hello, in VB.Net, I use Excel to display results : dim xl as new Excel.Application // creates an Excel process // snip (putting values into cells) xl.Visible = true If the user closes the Excel file and then my program, the Excel process is killed in memory, which is good. If the user closes my program first and then the Excel file, the Excel process remains in memory ! How can I make sure the process will be killed ? Thanks ! Hi You need to set xl.quit (and before that ensure that excel doesn't halt and ask things like "save changes?" on quitting) somewhere in your p...
Export relationship information from Visio to Excel
Hello all, Is there a way to export information regarding relationships from a visio diagram to an excel spreadsheet? In addition, is there a way to tell the excel spreadsheet to eliminate or change a relationship and for that action to be applied onto the visio diagram? thanks, ivan as a general answer I'd have to say "no, not without custom code". You didn't define what you meant as a relationship. al "Ivan Salas" <IvanSalas@discussions.microsoft.com> wrote in message news:6332A594-E4AF-4E8B-BA2D-7A4BC17962B3@microsoft.com... > Hello all, > &...
startup excel euro symbol
when i digit € symbol inside any application excel 2007 automacic startup and for me is impossible to use this symbol anywhere, i use windows xp professional ..have you a response to solve this problem? thanks ...
Excel 2003 Print Issue
I have created a spreadsheet to help with a university engineering assignment and I have added a worksheet that is basically an automatically generated report of all the calculations. I have set the Print Area up in such a way so that the results are printed out in well defined pages (e.g. page 1: title page, page 2: summary of input variables, page 3: summary of calculation results etc). The report is arranged vertically in the worksheet, so the pages are 'stacked' on top of each other. It prints out fine in Excel 2000 and 2002 but I recently upgraded to Excel 2003 and now find tha...
How do i locate the point of intersection of two lines graphs
I have a plot of two lines using excell which intersect at a point. I want to locate the point of their intersection using excell and show the co-ordinates of that point so that any body can see that i read that point from it. Step by step procedurewould be helpful and i am using microsoft excel 2007. Thanks. I will assume you have two straight lines - if not please tell me what they are. Let the lines follow the two functions y1=m1x1+b1 and y2=m2x2+b2 Let the point of intersection be Y and X Then m1X+b1=m2X+b2, giving X=(b2-b1)/(m1-m2) In Excel terms, X=(INTERCEPT(y-values2,x-values2)...
Printing Externally #2
That works great...except it word brings up a message box stating tha Word is currently printing, if you exit, you will cancel you print.....and if i click no, so i dont close word, it still doesnt wan to print...any suggestions???Thank -- tess45 ----------------------------------------------------------------------- tess457's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1393 View this thread: http://www.excelforum.com/showthread.php?threadid=26662 There's a setting in MSWord that allows you to do background printing. I've turned this off--so Word do...
How to print Directly from Dialog based application
HI all, I am writing MFC Extension DLl which has dialog in it. It has list of documents ( like .doc,.xls,.pdf etc....) When user double clicks the document I do ShellExecute to open it..... Now i have print button . When user clicks Print button Selected document in the list should be printed...... I want to print that document directly ( that is without opening corresponding application....e.g. want to print 1.doc without opening MSWord) How can i achive this? Will DDE command will help ? How? Any Guidence Or Link for that? I have tried with ShellexecuteEx with "print" as verb ...
excel 2000 message
excel 2000 message - 'cannot use object linking and embedding' Were they hit by the MSBlast worm? One poster (Lutz Meyer) guessed that this was the cause of his problems. I haven't seen any confirmation/denial, but you may want to read his post: http://groups.google.com/groups?threadm=3F3971AF.FA4490F5%40msn.com Post back with your results. I'm curious if that was the problem. (It's come up quite a few times since MSBlast hit.) bill bootle wrote: > > excel 2000 message - 'cannot use object linking and > embedding' -- Dave Peterson ec35720@msn.c...
Excel Graphing Line References off when chart is a sheet.
I have noticed that when any graph is created in EXCEL and you hover you mouse over the dataline you receive that corect response. If you convert the chart to a sheet, the hover of the data line is now not representative of the the y axis directly below it. The data being graphed is correct now the hover represents the "series" (x-Axis) correctly but does not represent the "Point" (y-axis) correctly at all. Tne Y-axis datapoint reference is wrong. Any help? ...