underlines not printing


    Sponsored Links


  • 1. =?Utf-8?Q?SUM_=E2=80=9Cevery_4th_cell=E2=80=9D_in_a_row?=
    I have a spreadsheet which will build up over the next few weeks with each week results adding four columns of data to the sheet sheet1. I then want to perform analysis on the data in another sheet sheet2 eg. In cell A1: SUM(sheet1!B8,sheet1!F8,sheet1!J8,etc, and in cell B1: COUNT(sheet1!B8,sheet1!F8,sheet1!J8,etc, etc Is there a way of calculating very 4th cellin a row. There will be several weeks of data and doing this long-hand (as above) is time consuming. I don yet know how many weeks of data there will be and I don want to have to add extra terms to the COUNT, SUM, etc each time I add a new week. Perhaps there is a way of creating a Range of this nature I clutch at straws. Can you help?
  • 2. Comparing and moving unsorted data in Excel
    Hi I have two columns of data - the first column contains a list of part numbers (Eg: AB100, AB101, AB101/2) and the second contains a filepath to an image for each part number (Eg: D:\Images\ab-100.jpg). Some products use the same image, but different part numbers (An example would be a screwdriver which comes in different lengths SDD8, SDD10 - two different lengths but the same style, hence only one image). Hopefully this isn't coming across as patronising, I'm just trying to make everything clear! :-) What I am trying to do, is for every part number see if it has a corresponding image in the second column. If this is true, then to move the filepath to the relative part number in the corresponding row in the table There are approximately 6000 part numbers and 1932 images, so not an easy manual task! Thanks in advance for any assistance you can provide
  • 3. How do I convert a time format to a double
    I use a function to calculate the hours worked based on time 12:00pm to 4:00pm is 4.0 hours when I get the number for hours worked it is in time format / .27398237 I need the number 4 so that I can do my calculation. How do I convert it to a number?
  • 4. Cell display is 38727.4101273148 Formula Bar is 1/10/2006
    Absolutely Correct! Amazing how line written months ago can haunt. Thanks Dave "Dave Peterson" wrote: > It sounds like you're looking at the formula view: > > Tools|Options|View tab|Uncheck formulas > > Dennis wrote: > > > > Excel 2003 > > > > I populate a cell with Now() (via the VBA line next) > > > > With Sheets("Error Cells").Cells(Rows.count, 1).End(xlUp) _ > > (2, 1).Value = Now() > > > > In the cell itself the display is: 38727.4101273148 > > even though the custom format assigned is: m/d/yyyy h:mm > > > > Interestingly, the presentation in the Formula Bar is: > > 1/10/2006 9:50:35 AM which is exactly want I want in > > the cell presentation; what am I doing wrong? > > > > I have attempted to change the cell format to no avail. > > > > Thanks > > > > Dennis > > -- > > Dave Peterson >

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 98 guest