1. D

    Change borders/gridlines of cells in rows A, B, C & D when cells in row E contains no blanks

    Hello everybody, I am currently sitting with the following material overview file in Excel: I have made some conditional formatting so whenever I enter a number in column E the entire row gets highlighted. Unfortunately, this erases/makes invisible my dark gridlines/borders from before...
  2. J

    axis automatic range and grid line increments

    Hello, Does anyone know the formulas excel uses to develop and show an axis range, major grid lines, minor grid lines, and increments when graphing charts? Not sure if it matters, but I'm specifically trying to figure this our for a scatter chart type. Thanks in advance!
  3. S

    how to fix the Grid lines missing in Excel

    The Grid lines just not visible on a PC. following things I have tried. 1. The Gridlines are check-marked 2. I selected the whole sheet and gave "No fill" to Fill colour. 3. I went to Excel option, went into Advanced section, in Display section, the Gridline colour is black. After all these...
  4. S

    Excel 2010, gridlines not showing - tried everything but still not showing

    Hi, I have excel 2010. Gridlines do not show on the screen. The gridlines box is already checked. background color is set at no fill. border line are set to automatics. in File, Option gridlines are set to black. but still nothing shows. When i highlight the page i can see that grid lines are...
  5. C

    Showing grid lines on the surface of a Surface Chart?

    I've dug through the chart options, but didn't find a way to show the major grid lines on the Surface Chart itself. Anyone know how to do this? THX Chad
  6. richardlevett

    Excel 2010 Print gridlines

    Help i have a large (very!) sheet that used to print gridlines in excel 2003. now we've upgraded to 2010, gridlines show on screen ok but printing seems to have a mind of its own. sometimes every other line prints other times its can be a random selection that print. everything else is ok, just...
  7. K

    Pasting Excel data intoo Outlook Gridlines

    This isn't the least bit important and it really doesn't matter, but I was hoping someone could tell my why it happens anyway. I love to fill my mind with useless knowlege. Sometimes when I paste data from Excel 2007 into an Outlook 2007 message body, faint grid lines appear and other times...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...