underlines not printing


    Sponsored Links


  • 1. How to get a numbered list of unique words in a column?
    Hi. I have a spreadsheet with almost 5000 rows with about 15 columns of data, 2 columns of which contain sentences, phrases, or paragraphs of comments entered by users. What I need to have as an end result is a list of all unique words found in those two columns, along with the number of occurrences of each word. I will then use this to further analyze the data in the spreadsheet. Right now, I do this manually and it takes a VERY long time for me to do so (over 200 man-hours). So, I really need to automate this somehow. The problem is, I have no idea how to begin, because the words will not be by themselves in their own cell (so I cant use the auto filter functions, pivot tables, or anything else I can think of), but will be part of groups of words or symbols within multiple cells. I think this will need to be done programmatically with code, scripts, macros, or some other method with which I am not familiar, but I am just not sure. Can anyone help me with this? Can anyone point me in the right direction? Is there anything already built in to excel to do this? - James.
  • 2. Prints differently than the display
    I have a large (18mb) dense worksheet, of which I print the first tab which is full of graphs. On set of graphs displays correctly on screen, but when I print, these graphs' lines are slightly off (small but noticeable amounts). It was printing correctly before on earlier drafts of the document. This happens if I print or print to pdf. To troubleshoot I tried using different printers and installing different printer drivers. I tried changing the print processor from RAW to EMF. No luck. Any other suggestions? Thanks
  • 3. Populate Data from Summary Sheet
    I want to use a sheet titled "Summary" to populate data in 100+ existing worksheets within the same workbook. "Summary" contains a list of names and dates. I want the first sheet after "Summary" to pull the first name and date from the list, the second sheet to pull the second name and date, and so on - like this: Sheet titled "Person 1" cell A1 =Summary!$B3 cell E1 =Summary!$A3 Sheet titled "Person 2" cell A1 =Summary!$B4 cell E1 =Summary!$A4 Sheet titled "Person 3" cell A1 =Summary!$B5 cell E1 =Summary!$A5 Is there a way to copy the formula across all 100+ sheets, changing the row referenced on the "Summary" sheet?
  • 4. insert contents of variable cell address
    I have a spreadsheet with same income/expense line items (rows) for each of the 12 months. Each sheet has the same row line items and each sheet has the same 12 columns for months. I have 3 years of data : 2007, 2008, and 2009. Each year is its own sheet. I want to make a summary sheet where a month/year is entered and 3 columns are displayed: the same line items for month A 2009 adjacent to the same line items for month A 2008, and the same line items for month A 2007. Since sheet name and row are set the only real variable is month. I can compute the column portion of cell address by using char(65) + month(selected month/year) but what I get is a cell whose contents are the computed address rather than the contents of the computed cell address. I tried using cell("contents", with computed address but I just get errors). Am I violating an Excel law by computing a cell address and trying to load the contents of that cell into the same cell where the address was computed? Does this require a macro? Our local expert is stumped. Office 2007 Excel Vista
  • 5. how do you have 2 criterias be picked up in a lookup?
    How do you highlight a row where the following 2 criteria are met: There are 2 columns with different numbers in each column, say about 100 rows of data. How to create a lookup/conditioning formatting in order to Highlight the row only if BOTH columns meet the following criteria: 1. Column A value equals 38 AND 2. Column B value is greater than 0.25

underlines not printing

Postby SnVsaWVG » Sat, 05 Apr 2008 02:10:02 GMT

We are having a problem with Excel 2007. Underlines show on the print preview 
of a document, but do not print on paper. Any ideas??

Similar Threads:

1.Underlining does not print out

I just upgraded to Excel 2007.  I can see underlining on my screen and it 
appears in Print Preview, but it doesn't print out on hard copy.  What gives?

2.Borders or Underline in embedded excel table does not print

I have embedded in Word 2003 excel tables with cell borders defined as single 
or double and sometimes formatted with single or double underline.  The 
borders or underline are displayed on the screen in Word.  However, when the 
document is printed, there are some borders or underline in the embedded 
excel tables that are not on the printed copy.  What do I need to do to have 
all borders or underline to print.  I prefer to keep the embedded excel table 
because it is much easier to maintain calculations in excel and there are a 
lot of updates on this document.

3.Double underline button creates a single underline

If you add the "double underline" border button on the Excel 2003 toolbar it 
creates single underlines.  The button seems to be linked to the wrong 
function.  Have others experienced this?

4.Cell Underline problem underlines across width of cell

Need  solution for cell underline problem.  When I warp text in a cell and 
then try to underline only the first word in that cell, it puts an underline 
the width of that cell when I only wanted just the characters of the word 
underline; it continues after the word to underline thereby underlining the 
space after it.  How can I correct this?

5.Printing borders or underline


on my spreadsheet i set up border or under for some cells, when i print  
preview, the file looks OK... but when i print to paper, some borders or 
underline gone.... is there a way to fix it?? 


6. underline in cell prints on word below

7. Underlines print in wrong cell

8. Problem printing underlines

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 97 guest