From: Claire on 25 Mar 2010 07:02 Hi, I'm using Excel 2003 and I have a spreadsheet which I have set up so that 'gridlines', 'black and white' and 'draft' are unchecked. The cells where information is to be entered have black borders. When I select print preview, most of the cells are fine but there are 5 rows where the borders aren't showing at all. They're not even together, they're throughout the spreadsheet! I've tried manually drawing each border, I've tried changing the colour but it doesn't seem to work. Does anyone have any ideas? Thanks in advance Claire
From: Sam H on 25 Mar 2010 07:42 Hi, Just a thought, have you actually printed it off, or are you just looking at print preview. As sometimes when I look at print preview I can't see the borders on things, but if I zoom in I can see the borders and when I print it off the borders are there. "Claire" wrote: > Hi, > > I'm using Excel 2003 and I have a spreadsheet which I have set up so that > 'gridlines', 'black and white' and 'draft' are unchecked. The cells where > information is to be entered have black borders. > > When I select print preview, most of the cells are fine but there are 5 rows > where the borders aren't showing at all. They're not even together, they're > throughout the spreadsheet! > > I've tried manually drawing each border, I've tried changing the colour but > it doesn't seem to work. > > Does anyone have any ideas? > > Thanks in advance > > Claire
From: Dave Peterson on 25 Mar 2010 08:26 And those borders show up when you're just looking at the worksheet, right? Just a guess... I'd try a different printer/printer driver. Claire wrote: > > Hi, > > I'm using Excel 2003 and I have a spreadsheet which I have set up so that > 'gridlines', 'black and white' and 'draft' are unchecked. The cells where > information is to be entered have black borders. > > When I select print preview, most of the cells are fine but there are 5 rows > where the borders aren't showing at all. They're not even together, they're > throughout the spreadsheet! > > I've tried manually drawing each border, I've tried changing the colour but > it doesn't seem to work. > > Does anyone have any ideas? > > Thanks in advance > > Claire -- Dave Peterson
From: Claire on 26 Mar 2010 05:42 Yup it does actually print fine! *sigh* its always a simple answer Thanks for your help! "Sam H" wrote: > Hi, > > Just a thought, have you actually printed it off, or are you just looking at > print preview. As sometimes when I look at print preview I can't see the > borders on things, but if I zoom in I can see the borders and when I print it > off the borders are there. > > > "Claire" wrote: > > > Hi, > > > > I'm using Excel 2003 and I have a spreadsheet which I have set up so that > > 'gridlines', 'black and white' and 'draft' are unchecked. The cells where > > information is to be entered have black borders. > > > > When I select print preview, most of the cells are fine but there are 5 rows > > where the borders aren't showing at all. They're not even together, they're > > throughout the spreadsheet! > > > > I've tried manually drawing each border, I've tried changing the colour but > > it doesn't seem to work. > > > > Does anyone have any ideas? > > > > Thanks in advance > > > > Claire
|
Pages: 1 Prev: Validation dropdown list is not coming visible Next: protection |