Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Print Preview Spacing
Hi sorry for the questions btu I have had them for a while and just discovred
these boards. On a company template i have drop down boxes with dollar values in them. When looking at the sheet itself everything looks lined up correctly but once i go to print preview or print there is now about an inch space between the last word and the dollar value, there are no cells in between, no extra spaces, i have been working on this for weeks and i have not been able to figure it out. This is happening on multiple locations on my worksheet so i ruled out a simple typo or something like that. Pleas help/ |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Print Preview Spacing
Hi,
This is probably a print driver issue. Test the file on a machine that uses a different type of printer. A second and less likely option would be to make sure the cell format is Currency not Accounting. Select some of the offending cells and choose Format, Cells, Number tab, and choose Currency. A third option would be to 1. remove the currency formatting or 2. to replace it with the Custom format "$"#,##0.00 or some decimal variation of this. -- If this helps, please click the Yes button Cheers, Shane Devenshire "C Vi" wrote: Hi sorry for the questions btu I have had them for a while and just discovred these boards. On a company template i have drop down boxes with dollar values in them. When looking at the sheet itself everything looks lined up correctly but once i go to print preview or print there is now about an inch space between the last word and the dollar value, there are no cells in between, no extra spaces, i have been working on this for weeks and i have not been able to figure it out. This is happening on multiple locations on my worksheet so i ruled out a simple typo or something like that. Pleas help/ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Print Preview Spacing
I tryed different printers and computers and it makes no difference. The gap
comes before the brop down box if that any help. Also, i am using Excell 2007 "Shane Devenshire" wrote: Hi, This is probably a print driver issue. Test the file on a machine that uses a different type of printer. A second and less likely option would be to make sure the cell format is Currency not Accounting. Select some of the offending cells and choose Format, Cells, Number tab, and choose Currency. A third option would be to 1. remove the currency formatting or 2. to replace it with the Custom format "$"#,##0.00 or some decimal variation of this. -- If this helps, please click the Yes button Cheers, Shane Devenshire "C Vi" wrote: Hi sorry for the questions btu I have had them for a while and just discovred these boards. On a company template i have drop down boxes with dollar values in them. When looking at the sheet itself everything looks lined up correctly but once i go to print preview or print there is now about an inch space between the last word and the dollar value, there are no cells in between, no extra spaces, i have been working on this for weeks and i have not been able to figure it out. This is happening on multiple locations on my worksheet so i ruled out a simple typo or something like that. Pleas help/ |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Print Preview Spacing
If desired, send your wb to my address and I'll have a look.
-- Don Guillett Microsoft MVP Excel SalesAid Software "C Vi" wrote in message ... Hi sorry for the questions btu I have had them for a while and just discovred these boards. On a company template i have drop down boxes with dollar values in them. When looking at the sheet itself everything looks lined up correctly but once i go to print preview or print there is now about an inch space between the last word and the dollar value, there are no cells in between, no extra spaces, i have been working on this for weeks and i have not been able to figure it out. This is happening on multiple locations on my worksheet so i ruled out a simple typo or something like that. Pleas help/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does my print preview (and print) not reflect the chosen margi | Excel Worksheet Functions | |||
First page of Excel sheerepeats in print layout or print preview | Excel Discussion (Misc queries) | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
print preview v page break preview | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) |