| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Random dotted line
I've got random dotted lines in all of my worksheets in a document!? They all start at a column border and end at another column border....i dont get it- what r they?  -- hustla7 ------------------------------------------------------------------------ hustla7's Profile: http://www.excelforum.com/member.php...o&userid=37760 View this thread: http://www.excelforum.com/showthread...hreadid=574160 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random dotted line
are they from col A to col IJ or just a few columns... -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=574160 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random dotted line
In one sheet, they stretch from the end of column f to the end of n- they are vertical columns btw. Therefore- there's one which drops all the way down from F, one from N and then one from W- they're therefore not consistent. Also, there are rhorizontal ones too....one from the bottom of 52, one from the bottom of 106 and so on...i cant seem to understand what they are!! ill send u a screenshot if u need.. thnku -- hustla7 ------------------------------------------------------------------------ hustla7's Profile: http://www.excelforum.com/member.php...o&userid=37760 View this thread: http://www.excelforum.com/showthread...hreadid=574160 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random dotted line
Hi,
it sholud be the print area marker, go to File | Page Setup and set the print to one page width for one page height hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "hustla7" escreveu: I've got random dotted lines in all of my worksheets in a document!? They all start at a column border and end at another column border....i dont get it- what r they? -- hustla7 ------------------------------------------------------------------------ hustla7's Profile: http://www.excelforum.com/member.php...o&userid=37760 View this thread: http://www.excelforum.com/showthread...hreadid=574160 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random dotted line
such lines appear when you look Print Preview of any sheet. and one box of such lines usually cover area from A1:J50 (more or less) close the file and reopen it these will disappear (if they are really because of Print Preview) hustla7 Wrote: I've got random dotted lines in all of my worksheets in a document!? They all start at a column border and end at another column border....i dont get it- what r they? -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=574160 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random dotted line
hustla7 Wrote: In one sheet, they stretch from the end of column f to the end of n- they are vertical columns btw. Therefore- there's one which drops all the way down from F, one from N and then one from W- they're therefore not consistent. Also, there are rhorizontal ones too....one from the bottom of 52, one from the bottom of 106 and so on...i cant seem to understand what they are!! ill send u a screenshot if u need.. thnku Hi hustla, It sounds like your are in Print Preview Go to View Normal Do that do the trick? oldchippy :) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=574160 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random dotted line
the screenshot is attached of one of the sheets- quality of pic is bad because of filesize upload limits :( +-------------------------------------------------------------------+ |Filename: excelproblemscreenshot.GIF | |Download: http://www.excelforum.com/attachment.php?postid=5255 | +-------------------------------------------------------------------+ -- hustla7 ------------------------------------------------------------------------ hustla7's Profile: http://www.excelforum.com/member.php...o&userid=37760 View this thread: http://www.excelforum.com/showthread...hreadid=574160 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random dotted line
these line may not consistant because you may have different width for different columns and rows. hustla7 Wrote: In one sheet, they stretch from the end of column f to the end of n- they are vertical columns btw. Therefore- there's one which drops all the way down from F, one from N and then one from W- they're therefore not consistent. Also, there are rhorizontal ones too....one from the bottom of 52, one from the bottom of 106 and so on...i cant seem to understand what they are!! ill send u a screenshot if u need.. thnku -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=574160 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random dotted line
Marcelo was right- thanx a lot for all of your help- it is much appreciated!! thankuuuu Nitish -- hustla7 ------------------------------------------------------------------------ hustla7's Profile: http://www.excelforum.com/member.php...o&userid=37760 View this thread: http://www.excelforum.com/showthread...hreadid=574160 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random dotted line
thanks for the feedeback
-- regards from Brazil Thanks in advance for your feedback. Marcelo "hustla7" escreveu: Marcelo was right- thanx a lot for all of your help- it is much appreciated!! thankuuuu Nitish -- hustla7 ------------------------------------------------------------------------ hustla7's Profile: http://www.excelforum.com/member.php...o&userid=37760 View this thread: http://www.excelforum.com/showthread...hreadid=574160 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Excel Charts - Time line for random points on X axis | Excel Worksheet Functions | |||
| ? change default line style from solid to dotted | Excel Discussion (Misc queries) | |||
| Random Sampling | Excel Discussion (Misc queries) | |||
| VBA "Rnd" Function: Truly Random? | Excel Discussion (Misc queries) | |||
Linear Mode
