Fill color isn't displayed during normal viewing of a worksheet. When the worksheet is printed or print-previewed, the colors are visible.
Re-installed Excel, problem persists.
Go to your control panel and double click on Accessibility Options.
Click on the Display tabsheet and uncheck "Use High Contrast" then press OK to close that window. You should now be able to see color in your view mode.
I am looking for a conditional formatting which works the other-way round. I want a specific number to be populated in a cellwhen it is given a specific color. Say, for example, if a cell is colored 'Red', then I want a number 1 to be polulated in that cell. Is there any way I could do that?
6 more replies
In Office XP, I need to make a template or form or something (unsure of correct MS term) to enter client data, name address b-day etc. Then, whenever they come in, want to take that saved data and have it entered to a preprinted, normally hand filled , company form. The company form is 2 page carbonless copy so a dot matrix printer will have to be resurrected to print the data to the form. New dates are all that would be new info. All data is presented horizontally except a few items that are on right edge at 90 degrees to normal portrait orientation. Word? Excel? I have a copy of Office XP for Dummies but can't find what I need. I don't have a MS Office book. Software came as disk only. I probably would have an easier time if I new the correct terminology.
Thanks in advance for your help.
Steve, it seems to me that the easiest way to accomplish this would be using Acess (assuming that you have the Pro version of Office XP -- the Standard version lacks this program.)
With Access, you can create a database containing all of the fields of raw information that you need to enter, an onscreen form for data entry that closely resembles the preprinted form needing to be filled in, and a printed report format that duplicates the layout of the preprinted form (or could possibly be used to actually print the data in the corresponding locations of the actual preprinted form.) Access also allows you to share the information you create with Word or Excel if needed. All of the data tables, reports, and data entry forms are objects that are contained in the Access file itself.
Lacking Access, Excel could be used to hold the data (spreadsheet programs are often used as database programs), but you would not have the same flexibility as a dedicated database program like Access provides. There is a great deal of info in the Office XP program help files -- the hard part is just in sifting through to find the information that really applies to you. Picking up an Access 2002 (or Excel 2002) for Dummies would give you more detailed information than the general Office XP book would -- I bought Access 97 for Dummies years ago and still refer to it often.
I've spent the last four hours trying to solve this/use info that's similar to my problem to no avail. I feel I'm so close I can smell the answer is near!
I have a form I use for work that I manually have to fill in 50 times a day with mostly the same information. This is definitely a job for a computer!
Ideally, I would like to open the spreadsheet and have a button that says 'Print' and it will print what I need - 50 forms with the right information.
So far I have done the following:
Created a custom page size (16cm x 14.7cm)
Scanned an original to use as a background so I can line up the information
Adjusted the Excel boxes to print the info in the right place.
Now I need to print the following number ranges as identifiers:
1 - 22, 29-42 and 51-54
I feel I'm close with using this macro:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
[copy] = [copy] + 1
I use both Excel 2003 and 2007, depending on where I am!
I have NO experience of macros until today, so any advice is very welcome.
When I arrange the worksheet columns to be only as wide as they need to be, the print preview (and the actual print out) has extra space after (to the right of) the last entry in the cell. So a cell that looks like : |xxx|, when printed, looks like : |xxx |. Can that be remedied ? The work-around I have found, is to make the original columns too narrow, so that the rightmost contents are hidden from view - that is really a quite undesirable method, though it achieves a 'correct' printout.Bastymessage edited by Sebastian42
How are you setting the columns to be "only as wide as they need to be"? Are you manually setting them or are you doubling clicking the column separator so that Excel sizes them automatically?I have experienced times when setting them automatically looks good on the screen when viewing the spreadsheet, but prints differently than what is shown. It may have something to do with the print drivers (which I can't control at work which is where I usually see the problem) but I'm not sure.Are you sure that there isn't actually a trailing space in the cells?Have you tried changing fonts just to see what happens?I'm just tossing stuff out for you to consider since I can't actually test anything or see your spreadsheet from where I'm sitting.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.12 more replies
Unsure if this is correct place for this, but here I go.
I wish to create a timetable using Excel (Not Works).
It will consist of several columns and several rows.
I want to highlight selected rows to be printed in a colour other
than black. How do I achieve this please?
In Win95, using Works, it was possible.
In WinXP, using Works, it is not.
Of course being Signor El Thicko, I hope you can educate me.
In the upper right hand corner of excel's toolbar you should see a "Bucket" and an "A".
They should have colors underneath them and a drop down arrow next to them.
Highlight a row or column. Change the background color of the row or column with the "Bucket" and the text color with the "A".
You can do this ahead of time so that any text entered in the future automatically changes to the color you want. (use the drop down arrow to select different colors)
Is that what you mean?
I have an Access database used on daily basis to enter and print the maintenance work order in a report format. I have assigned a command button to print the required record. On clicking the button in the Form, a parameter query will run asking the user to put the record number to proceed. Once the correct record number is entered in the parameter text box, the report is previewed and the user click on the print button to print the same.
My question is as follows:
Is there any method to find out the record i am going to print now was already printed before? A kind of record keeping for the printed records.
Also, a message box should warn the user saying incase if the record was already printed, “The record was previously printed, do you want to continue printing again?”
Please tell me a way to perform the above in my Form.
could't you just add a field in the record for printed?
Then if printeed true, show warning, else show printable form.
I am needing to transmit information from Quick Books to Excell.
It needs to be in a specific format with one set of numbers to be right justified and zero fill . When I highlight the column and go to edit/fill/left and start with 0 and end with 0, I get nothing.
So I thought that it was just hidden but it was not.
If there is anyone that could give me some help I will be your best friend!!!! Thanks in advance I am sure that I will hear something soon.
I'm not exactly sure what you're doing. Do you have a range of 0's in the column to the right that you want to fill left?
I would think it would be easier to enter a couple of 0's in 2 or 3 cells, then highlight the group and drag the "fill handle" - which is the little square on the bottom right corner of the highlighted cells. Just drag that to the area you want to fill. I believe that Excel can tell that you are filling zero's because the step between the cells is zero, and not incremented by any number.
Are you using QB Pro, where it will export a report to Excel? And then manipulating the data on the report?
Does that help at all, or am I totally misunderstanding?
Can I fill a cell on Excel with something other than just solid color? Maybe crosshatching or some other pattern? I'm using Excel 2000.
Originally posted by T-Bone:
Can I fill a cell on Excel with something other than just solid color? Maybe crosshatching or some other pattern? I'm using Excel 2000.
Thanx! Click to expand...
Have you tried Format/Cells/Pattern, click on the Pattern button at the bottom of the window?
I'm hoping someone can point me in the right direction with this. I am not a novice, but am in no way an expert on Excel.
I have a group of Budget Analysts. Currently they create spreadsheet templates and place them in a shared folder for different agencies to access. Each agency goes in and plugs their numbers into the spreadsheet for each fiscal year. Budget then compiles and calculates the budget.
It should work well in theory, and it's really not that terrible. But when you're dealing with multiple users and levels of understanding, things are bound to get screwed up some. Right now these people get a copy of their spreadsheet, they fill it out then copy and paste into the shared spreadsheet.
So, I'm just wondering if there might be an easier, more uniform way to get this information where it belongs and have a more user friendly interface. I looked a little at the forms tool but I'm not sure just how that works in Excel.
I was thinking of some simple form to fill in that would know which cells to enter the data in....
If you all could give me some ideas or just some information I'd really appreciate it.
Strange. I answered this question already, but it's not here. Did you ask it somewhere else?
Anyway, give them the worksheets and YOU link to them instead of making them copy and paste into yours...
I have an excel sheet that tracks my Umpiring schedule and pay rate. I have created drop down lists for populating cells for Umpire position and for division of play. I have the list of the pay rates for each division and each umpire position (Plate, Base and rookie House League, PeeWee etc) What I want to do is automatically populate the Pay Rate column based on the information in the Umpire Position and Division columns. Should this be done using a macro, conditional statement or what? i am not very well versed in Excel so I would appreciate any help offered.
I would use the VLOOKUP function to populate those results. To do this, you would need to create a list of the the position names, with their coresponding rates and a list of the divisions with their rates. I assume these are added together to get the total pay for a position and division. The lists will each need to be sorted Ascending. They can be anywhere in your spreadsheet and hidden or on another worksheet in the workbook.. which can also be hidden.
For Example if the following was typed into A1:B11:
(assume the position and divison names and the following numbers above are in separate columns.. they do not paste well here in the forum.)
Assuming A14 is where you populate the position and B14 is where the division is populated. Then using VLOOKUP, you can write a formula to look up the values. In C14, I would type the following:
In the above example, if you populated "base" in A14 and "1" in B14, the result in C14 would be 3.3.
If you have your lists named as an array, you could interchange the range (i.e. $A$2:$B$5 )with the array name in your formula.
I have a file in excel that does not fill the excel frame. I click on the full screen and reduce it and get full again, but it does not go to the screen full size. I have other excel files that expand and contract with the excel frame, but not this one. Any suggestions?
You don't say what you have tried so far. There are two things that come to mind that I would try:
1. After you have got it expanded to full screen, try doing a "save as" under a new name. (I usually just put an "r" for revised after the old name. Then see if the "r" file will come up full screen. If it does, then you can delete the original file and rename the new one to remove the "r".
2. Try this: bring up a blank sheet, then open the other, get it expanded to full screen, then do a copy and paste from that to the blank sheet.
I want to list every day of the year in Excel 2007 spreadsheet. I do this by using the Fill Handle.
But when I do that, the computer locks up and I get an hourglass which never goes away. I have to use Task Manager to get out of it.
The same thing happens if I do it from the icon on the tool bar.
I have used excel to create a simple eBay listing template but when I cut and paste the data the 'fill effects' do not show? Is there any way to do it? Basically I want the fill effect to show a gradient of colour but this data is not pulled when I cut and paste. If it cannot be done are there any free web based or downloadable programs out there that will do the same thing?
I create a spreadsheet for a report that comes out twice a week, while the reports do differ slightly, I create a new page for each date, i.e. July 7th, July 10th, July 16th etc. However, each time I create a new page the words I use on every page essentially, do not come up when I begin typing.
I am wondering if there is a place to add frequently used words so that they will come up faster. For example, I use Bradford, Summit, and Washington quite frequently. I would like to just be able to type b-r-a-d and autofill come up with the rest, it would save a lot of time.
I have thought about just making a template and then copying that for each date, but there is just enough differences that that will not save me any time.
I am open to trying anything to speed up the process.
What version of Excel are you using? Newer versions do this automatically.8 more replies
HI, I am really trying to link an IF statetment if a cell is shadded. Once cell (E44) is shadded, i need Cell (T33) to be linked to cell (B3). If the cell has not been shaded then cell (T33) is to be left blank or with a - in it. I just need to know how to link a cell using a fill color (dont care if its all of them) if its even posable. I tryed using cell color but hasnt worked yet.
Thanks in advance.
7 more replies
Is there any way to link the formatting, or even just the fill color, of two cells? All I'm trying to do is make a cell in a one worksheet mimic the fill color of a cell in another worksheet and change color when the original does. Also, if it requires a script, is there someone who has previously posted one?
Note: Excel 2007
6 more replies
I got a pretty difficult question.
I need a formula/macro, which does the following:
In Cells E1:E20 names of products are filled in.
In Cells in column B also names are filled in.
When a name in Column B matches with one of the names in E1:E20 behind the cell in column B (column C) the price of that product has to be set. The price stands after the productsname in cell G1:G20.
So how can I make a macro, that puts in the column C the correct price which stands in cell G1 till G20, regarding matching names in front of it.
Thanks in advance!
13 more replies
I've seen a couple of great posts about how to solve no color fill for excel 2003 by un-checking the Use High Contrast on the Control Panel Display. I just can't seem to find the right location to un-check it for my Windows 7 - Excel 2007. I'm having the same issues; no color fill will show in my excel document but it does show in my print preview. I have a color printer set as my default so I know that's not the issue. I've also had issues with my ability to view colors using Internet Explorer and another user also had that problem solved by un-checking the Use High Contrast (I just use Google Chrome instead). I'm certainly not a power user - but I have been all through my control panel selections and can't seem to find the correct location. Any easy help for this one?
Hi, I hope this is a fairly simple question. I think I have done it before but I cannot for the life of me remember how, nor can I find anything that explains it.
Anyway, what I'm trying to do is use the auto-fill handle to drop down a very simple formula but I want one of the cell ref numbers in the formula to remain the same while the other changes.
EG. I want the first formula to be A1*B1 and the second one to be A1*B2 and so on A1*Bn using the auto fill command.
Hopefully all the wizards on here understand what I am trying to explain and can show me how this is done.
Create an absolute cell reference by using $ signs like this: $A$1+B1
Now the B column cell reference will increment while A column will remain constant.
Using Excel 2003 (11.6560.6568) SP2.
*Really* simple spreadsheet here--just entering some data by typing plain text in the formula bar or in the cell.
I added a fill color to 2 rows (line 32 and 34) as a note to myself, but now *every* time I enter info into the formula bar in other cells on other rows (say 33 and 35), Excel insists on adding fill color to them.
The funny thing is that when I click on the cells in rows 33, 35, 36 before *and after* entering data into either the formula bar or the cell directly, the "fill color" toolbar icon indicates "no fill". However, there is fill after I've entered something.
Format->Style indicates "no fill" with & without data in the cells. I've tried selecting multiple rows and saying "no fill" outright using the toolbar and the Format-> style options, but that has done nothing! Still every time I enter info, I get yellow fill color.
Any help is greatly appreciated!
10 more replies
Can there be a macro in excel to find column headers of the excel file in word docs and fill them in excel respectively for all the docx files in a folder. word data/file is not in table format and all docx files are similar
I tried recording the macro but it doesn't work
16 more replies
I have applied various fill colors to specific cell & cell ranges, but I can't see the fill colors unless I go to Print, Preview. On Print, Preview all the fill colors are correct & it prints correctly. I just can't see the colors while I'm working on the document. It makes me nuts!!!
Yet any color changes I make to the font or line color in any cell shows immediately, whether in a 'filled cell' or not. Using Microsoft Office Pro, Excel 2003, XP Pro
7 more replies
I have a worksheet containing various data including an expiry date, this is created by adding 364 to the start date and then then using an auto fill to fill in all other rows (over 50,000).
I would like to make a macro to do this alongside a number of actions but when making the macro I am specifying only a certain range to fill (A1:A50000). The problem I have is this list is consistently growing and so this range would then not include any new records added. Is there a way that I can make it so it auto fills from A1 to the last present row?
Thanks for your help
8 more replies
I am new to this forum and not sure if this had already been answered. But here it goes anyway.
I would like to create a vacation form that users can use to fill their vacation requests. This form will have approve or reject buttons. If approved, the data would be auto populated onto an excel spreadhseet. If rejected, the rejection email will be sent back to the user.
Can someone show me how to do this.
Many Thanks for all your help in advance.
In Sheet one I have some raw data which in sheet two I have picked out the useful pieces and have then input into out work forms. The problem is that I need to fill the form across (column) but in the sheet that it is referenced from I need it to take the data from the row
....a.. b. c
1 a1 b1 c1
2 a2 b2 c2
3 a3 b3 c3
I need to find a way to automatically get it to do this referencing sheet 1 in column A and then filling to the right but actually having it go down the rows in sheet 1
...a.. b ..c
1 a1 a2 a3
2 b1 b2 b3
3 c1 c2 c3
the idea is that when the software exports to sheet 1 we will be able to print sheet two in the form we need it without having to make any changes. I know my explanation is a little crude but if someone could help me I would appreciate it. thanks.
You could use:
in Sheet2!A1, then replicate that down an across (pro forma style).
Would that help?
I've searched as many responses as possible to find an answer, but still need a bit of help. I am a novice with VBA.
I've created a workbook (Excel 2010, Windows 7) that is used for documenting a work-place incident. There are 7 separate tabs, all password protected, and the cells that require entry are conditionally formatted (to create a visual "reminder" that the user needs to make an entry) with data validation so that the user can select the required entry, by cell.
However, there are some entries that are a must but the user can choose not to make a selection in any one of the cells and print/save the file (I have a print/save macro for each tab). I found code that would highlight the empty cells, which is great, but it doesn't require the user to make an entry in empty cells before the print/save macro runs.
Below is the code for highlighting empty cells:
Sub Highlight_Cell() Dim Rng As Range For Each Rng In Range("A2:H20") If Rng.Value = "" Then Rng.Interior.ColorIndex = 6 ‘yellow Else Rng.Interior.ColorIndex = 0 'blank End If Next Rng MsgBox "Please fill in all mandatory fields highlighted in yellow." End Sub
Any suggestions or advice is truly appreciated.
7 more replies
I'm currently writing a macro, part of which necessitates a different fill colour being assigned to each cell in a range - from B28 to the last cell in column B where there is corresponding data in column C. This could potentially be up to 50 cells in any single worksheet (one month's Arrivals), so 50 different colours, but will more likely be somewhere between 15 and 30.
I found some code that randomly applies the fill colours, and modified it, as follows:
Dim r As Byte, g As Byte, b As Byte
Dim iRow As Integer, iCol As Integer
Dim iRows As Integer, iCols As Integer
Dim rng As Range, rngFill As Range
Dim strMsg As String
Dim iIcon As Integer, strTitle As String
Dim EOP as Integer
EOP = Cells(Rows.Count, "C").End(xlUp).Row
On Error GoTo ErrorHandler
iRows = EOP- 1
iCols = 0
Set rng = Range("B28")
For iCol = 0 To iCols
For iRow = 0 To iRows
r = WorksheetFunction.RandBetween(70, 255)
g = WorksheetFunction.RandBetween(70, 255)
b = WorksheetFunction.RandBetween(70, 255)
Set rngFill = rng.Offset(iRow, iCol)
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = RGB(r, g, b)
Next iColClick to expand...
This works pretty well, but there's always the chance of 2 very similar colours appearing consecutively, which I could do with avoiding...
As mentioned these colours are for Arrivals. I also need to apply colours for Estimated Arrivals in column A. These should be lighter shades of their c... Read more
16 more replies
I'm trying to stretch my resources and minimize some data entry, using the tools at hand. However, I've hit a bit of a wall on inspiration - looking for some ideas.
I have an Excel Spreadsheet (about 8 worksheets) that I use to log some daily activities - however, because I have a lousy memory, I like to email myself from the road with the notes for my Log. Then, when I return to the office, I either re-type (or copy/paste) my email notes into the appropriate sections of my log file.
What I'd LIKE to do is create a form and rule in Outlook that would auto-fill my Excel worksheets based on the text of my email. I'm not worried about Triggers (the rules setup on that end is simple enough for me), I'm more looking for the best way to have Outlook interact with Excel in this way.
I send emails from the road on my Android phone.
Any ideas? Thanks!
8 more replies
I am probably beg-intermediate excel user but just got switched to excel 2013.
I have a kids sports league of 10 teams with a rotating schedule which I need to create scoresheets weekly.
The scoresheets have to be populated with both team rosters (and coaches, etc.)
I put in a separate input tab/page to enter the basic schedule of the week (team #, times, location, etc.) which carries into the spreadsheet for the title information for each game.
What I can't figure out is how to data fill the scoresheets with the correct team rosters based on the schedule.
Right now, I fill out the input information and then copy / paste the 10 games (ie 20 rosters) of players into the scoresheet from a master. It is a bit cumbersome, and occasionally error prone. Especially since I often get to it in the wee hours before the league starts playing.
Any ideas? TIA
Hi, welcome to the forum,
If you 'trhow it' at Google ...
and many more, If you're still stuck then I suggest a sample file with what and how you want it would help give us the picture.
And, we all started with sample files anf trial-and-error
Happy hunting and we're here to help
I have been searching on the internet for hours trying to find a solution for this.
I have seen many similar posts but doing the suggested has not been able to fix my own problem yet.
I want to be able to use drag-and-drop to have Excel automatically fill the lower cells in increments.
For example I enter:
When I drag the fill handle I want to get:
What I get:
Basic PC specs:
I have Windows 7 and Microsoft Office 2007.
This spreadsheet was able to do this previously.
I can still drag-and-drop in increments on other sheets in the same workbook.
Other computers are also unable to make this spreadsheet's drag-and-drop function to automatically increment values.
What I have tried so far:
1. Select two cells and drag the fill handle.
2. Hold ctrl and drag the fill handle.
3. Went to "Excel Options", selected "Advanced" and made sure "Enable fill handle and cell drag-and-drop" was enabled.
4. Went to "Formula" tab, selected "Calculation Options" and made sure it was set to "Automatic"
The above have fixed the problem for other users but this has not yet fixed my own issue.
I have tried everything I can find on the internet so far.
Any additional methods would be greatly appreciated.
type 1 then 2 in column a
highlight 1 and 2
goto corner on cell (lower right were there is a square)
cursor change to a plus sign then left click drag down and release
If that isn't working check:
XL2007 go to File/Options/Advanced/check Show paste options checkbox
Using the "IF" functions on a spread sheet. It works ok, but is there a way for it display a different color when the IF results are out of bounds? I'd like it to come out red or green.
Not sure if this is available (but should be), in 2003, it's under Format > Conditional Formatting
i do not know how to make pages fit my monitor. there is 2.5 inch gap at either end
this is not equip. failure as it worked ok before i had to go back to a restore point. i am a complete novice,trying to keep up with grand kids,please excuse.6 more replies
I installed a new monitor - Westinghouse, and font colors as well as background colors will not display in excel or as backgrounds on internet explorer.
I would say check the resolution that you're using. Other than that, westinghouse is totally plug-n-pray so maybe call their 800 number because it's not a driver issue. Also check to see if there's any office updates you need.
I am working in Excel 97 using windows xp and hp printer 970cse. I highlight the cell to change its color to yellow, it changes on the worksheet, but not in the preview. I have updated the drivers from HP and have checked under file to see that my 970 series is the printer for the default. I want to print the background color. Any suggestions?
Might want to check the PROPERTIES of your printer to make sure black and white isn't selected.
Consider I want to make a new theme for my workbook. First (for the colors) I go through Page Layout > Themes group > Colors > New custom colors.
In this dialog box There are 4 text/backgrounds, 6 Accents and two hyperlinks.
My problem is how exactly they work?
On the right-hand there are two samples with texts and charts when I click those text/backgrounds or Accents these two change, but I can't figure out completely how those buttons affect real final theme.
Or, simpler, what are the meanings of those text/backgrounds or Accents buttons?
Hi Is the Information below what you are referring to?... Looks very basic to me ..
How to Apply a Design Theme to an Excel 2010 Worksheet - For Dummies
I have an Excel 2007 spreadsheet with simple "general" formatting, in which I log single numerical values (i.e. "1"). I have a general background color set (i.e. "grey") and there are no other formatting or linked cells. When I type in alpha-numeric entries (i.e. "1 hr.") the cells will appear correctly, however, when I type simple numeric values (i.e. "1" without the "hr.") the cell background color will change completely (i.e. bright red) and is not able to be changed or overriden until the numerical value is deleted or else modified to alpha-numeric terms.
I have tried re-formatting the cells themselves (i.e. instead of "general", formatting to "number" or "currency") and the problem still exists.
I haven't been able to find a solution to this, and, since I'm not intimately familiar with Excel, it has been a bit trying.
Hopefully you can be of assistance!
Thank you, in advance. I appreciate it!
Welcome to the forum.
It sounds like you have conditional formatting turned on. Try going to the formatting tab and looking into it there.
I have installed Windows ME and the display is in 16 colors. I have an ATI Technologies Rage Orion Video card. I suspect that I need an update driver or a ME update. Under System Summary>Problem Devices> I have the following lines:
IRQ Holder for PCI Steering PCI\IRQHOLDER\60 error code 22
IRQ Holder for PCI Steering PCI\IRQHOLDER\62 error code 22
Under Components>Display> I have the following:
Name: STD PCI Graphics Adapter (VGA)
Adapter Type: Not available
Adapter Description: (STD display type)
Driver: c;\windows\system\VMM32.vxd (,1,019.88KB (1,044,352 bytes) not available)
I found updated drivers for Rage 128 that should work with the Rage Orion and within ME. I can not install them because I get an error during installation that states I need DirectX 8 installed. I downloaded DirectX 9 (dxwebsetup) via my other computer to a floppy and tried to open it on the computer in question. It starts to install but quits because of an error that states "try later or check network". Is that the only way I can install DirectX which is needed to install new drivers? Is there another way to fix the 16 colors to 32 colors?????
does your motherboard have an on-board video? if it does, enable your video via bios and uninstall (add/remove hardware) your video card. if you can access the internet then try downloading DirectX. install your video card afterwards. or if you dont ahve on-board video and can access the internet, download directx directly and see what happens try installing your driver again. good luck with windows me.
This is something that has been bugging me for a while now, and I've been unable to solve this problem. Perhaps someone out there can provide some guidance.
Sometimes, I'm unable to print things (such as online coupons) because I'm told that my printer is set to "Keep Printed Documents." I've tried disabling this setting via the Advanced tab under the printer's properties. However, when I do this, click Apply then OK, and close the tab, the setting automatically reverts back to "Keep Printed Documents". Does anyone know why this is happening? It's sort of frustrating to not be able to set the printer settings the way you choose.
I appreciate any tips/suggestions you might have. Thanks!
9 more replies
Hello Team, When I am trying to select eqal (=) to button on which it is printed, it is not getting typed whereas when I am selecting some other button eqal (=) is getting printed. Please help me in solving this issue. Regards,NizamMore replies
I have searched to find an answer to this problem of faded pictures when printed from windows photo gallery. I have seen a few others having the same problem, but no solutions. I am hoping that someone now can help.
I can print pictures from other software on my computer, from the internet, etc, with great photo quality. When I print from Windows photo gallery they are very light and faded looking. I have made sure the adjustments are for my printer.
It seems that most of the people experiencing this problem had canon printers. Does anyone have a solution to this?
I have found the solution to this problem, you need to untick the checkbox for "borderless printing", this is how to do it:
When you click print, go to Options > Printer Properties
Click on the "Page Setup" tab, then Untick the box that says "Borderless Printing"
I love Myriam the little bunny
Whenever I print out an email from someone, the resulting document prints my first and last name (Outook Express) in the top left corner. I would like to orevent this but have searched in the Options and cannot find how it got there or how to permanently remove it. Can someone please tell me. Thank you.
It is using your user name for the header.
You can change this in the account settings.
Not sure if you can turn this off.
The problem I am having is that when I go to print tax return forms from the IRS site or New York Tax Dept site, the form prints "short", that is, the last four or five lines of each page do not print.
You cannot save the data in these forms, they will only save as a blank form. Your only option is to print it.
However, although Adobe tells how to cure this problem ( by clicking File-Print and going down the menu which comes up to "printer scaling", then chosing "print to fit page", this only works if there is a
FILE menu on the left hand side of the page.
In these tax sites, the forms do not have a tool bar above allowing you to chose a FILE menu.
You can right click the mouse and chose PRINT, however it will print a cut off page.
SOOOOOOO ..how do I either:
1. Get a standard Tool Bar to appear on top of the form, on these web site pages, or
2. use some other device or method to print these documents to fit the page.
If any of you are about to suggest right clicking on the printer icon PRINTERS, in the control panel, forget it....my printer does not bring up anything about "Print Scaling".
Hopefully, some geek out there will read this and solve my problem. Thank you. 44 Guy
Every computerized tax form that I have seen...is available at the website of the sponsoring governmental agency...and reflects a printed version option which has resulted in everything being printed properly.
I'm not sure where Adobe figures into tax preparation.
If you are using a 3d-party app to do taxes...then the problem resides with the support for that application, IMO.
I scan a document( on a hp 1315 all in 1) that is 8.5 X 11.00 but when I print it it is 8 X 10.25
how do you get it the original size? I tried resizing it in photo shop but cant get it. I have vuescan but still wont print out 8.5 X 11.00 ???????????????/
16 more replies
I'm new here!
First I would like to say I'm a TBI survivor and I'm a male and 42 years old .
I was purchased an emachine computer with a Lexmark lasar printer,
Whenever I go to print something, be it a web site article or a personal document that was created using Microsoft Works Word Processor. Whatever is being printed my name appears at the VERY top and the city and state printed at the bottom.
I know little about computers so I'm trying to get an answer why this is being printed.
The only thing that I can come up with is MY NAME, CITY and STATE was somehow entered on this computer's Hard drive and is prints it because it's been entered by someone at the store before iyt was brought home and set up for me.
If there is someway that I can delete this info. being printed, PLESE tell me what to do EXACTLY!
That's very strange, it sounds like a 'Header and Footer' has been set up with that info and is in your normal.dot template. (If Works uses such a template, I know Word does).
Try doing a Find (or Search depending on your version of Windows) for normal.dot and rename any found to normal.old. Then test the printing again. If there is a problem you change the names back again.
Im using access 2010 and there is a print of a report like a certificate whenever needed. My office is requesting me to provide a report of all certificate printed including the date and to whom .
my only way to do this is to force users to enter a field print (yes/no) and from there the query "yes" and the report be printed.
Is there any way to do this without forcing the user to enter the yes/no. field.
6 more replies
Well not sure if this is the right area for this but not really sure what the problem is.
When I boot my PC during the bootup dos stage I hear my PC making noises, it still boots up Windows 7 ok but as soon as I open something I get continious R type accross my screen, If I hit the caps lock it changes from R to r.
Thought it was my keyboard having the R locked down so tried to fix it, no luck. Changed keyboards with my spare one no luck. Disconnect all keyboards no luck.
So where is this R coming from, its impossible to us my PC at the moment as soon as you click somewhere (word, exel, Google etc) an R/r appears.
Any ideas where to start?
8 more replies
Don't print much multi page output, so am NOT sure when this problem began.
Originally, the pages on my HP DJ855C were printed as expected: page-1 first, then page-2, etc; this resulted with page-1 being on the bottom of the stack. Depending on the application being used, there was often a Print-Order option available for Back-to-Front printing so that the last page would be printed first and then page-1 would be printed last and be on the top in the stacker.
NOW, things seem to have reversed:
If I do NOT ask for the Back-to-Front, then I seem to get it anyway (i.e., page-1 last and on the top). but if I want the original order (i.e., page-1 first and on the bottom) then I must use the Back-to-Front option.
It seems as though the default has become Back-to-Front and then selecting the option for Back-to-Front re-reverses the order and the result is Front-to-Back.
Possibly this reversal happened when I went to Win/XP; possibly it happened with the installation of some piece of software.
Q. Has anyone else had this exxperience?
Please tell me where I might change some parameter to make the option of Front-to-Back actually print the page-1 first like it did originally?
Any advice apprecaited.
Go into your printers and faxes options off of your start menu.
Select your printer, right click the mouse and click on printing preferences.
On the features tab at the bottom there is a option for start printing from last page. If there is a check mark in the box next to it, click there with the mouse and uncheck it and then click on apply and ok and you should be all set after that?
I am unable to print pictures completely. I print them from Picasa on HP photosmart C4250. When I try to print, although the preview is correct, the printed result is not. Part of a picture will come out, or the image starts at the end of the paper and is therefore incomplete. Until now, everything worked properly.
I have 3 print queues that are retaining the printed jobs in the queue and every now and again the damn thing prints all the job again. I have checked that the keep printed jobs button is NOT checked/selected, but the queue acts ilke it is selected to keep printed jobs. I have 125 printer queues and only 3 act like this and they are set up identical to the others. I have reconfigured this twice on all 3 and they still act like they are set to keep printed jobs in the queue.
Anyone seen this and know of a solution, on the Microsoft site I am seeing posts but not a single reply about how to either run a job to clear them out a couple times a day or fix this so they act as configured. To NOT keep printed jobs in the queue.
Any help as always is much appreciated.
The race to solution is on, let's see who can figure this one out first.
7 more replies
when i tried to print photo from (user administrator)windows7 photo viewer there appear print picture windows without photo preview(seems busy) and after some seconds five repeated error messages "your picture cannot be printed because of this error occured" appear. It is working in user account Guest. printer and its driver is okay(updated). whats wrong with my windows 7 photo viewer? please help me
From Windows Answers:
I believe it is a problem with the "photowiz.dll" file in system32. It is version 6.x.xxxx.xxxx. I found an older version of this file, had to change the attributes and permissions of the file to allow it to be changed. I renamed it with an "dlx" extension and then copied a version 5.1 photowiz.dll to system32 and the print wizard works again! The site I got the file from is: http://www.dlldump.com/download-dll-files_new.php/dllfiles/P/photowiz.dll/5.1.2600.2180/download.html
Try Googling your problem first. Hope that helps
Other than dogging the print preview, and struggling with the size in any pertinent image editing software, has anyone found a reliable way to limit or control the size of a printed web document?
I scanned an odd shaped document, 3x8" to email to myself at another site, and the printed form was big enough for two pages. What a waste.
I print receipts regularly and they, 99% of the time have a "trailer" on a last page that has stuff like web site address or URL, a Secure Website emblem, or other, clearly unnecessary printing. My introduction to Windows word processing (WordPerfect) had, and I still use, a "makeitfit" command. Invoking such a command AUTOMATICALLY when printing from the web seems like a simple, brainless way to conserve paper...it'll give me a fractional font (e.g. 11.9 vs. a 12) and would prevent the idiotic tendency of a printed page to only have the leftward 80%, l which leaves off the important stuff like the prices...(you gotta print landscape to avoid this)
And I thought a computer was to make life easier, boy was I ever misled)
The problem is that web pages are usually coded to make them look good on screen, and that tends to make them "unfriendly" when printing.
Web pages designed for printing do exist, and it works well in those (few) cases.
Cutting and pasting into a word processor is sometimes the only workable solution.
I bought a parallel to usb printer cable to make my HP Laserjet 4L to work on my Vista dell laptop and it worked. Then I upgraded to Win 7 64 bit. Now it won't work. It sees it, installs fine, just won't print. no errors. Can it be a "cable driver" (never heard of such a thing until I started researching this problem) if it worked with Vista? It's a no-name cable, so won't likely have a driver that I can find.
Is there anything I can do but replace the cable?
7 more replies
I am looking for a solution (maybe a registry setting) to not allow XP to print, say, more than 30 pages in any one print job. Any ideas?
Any ideas? Found some software online that is far beyond what I need.
Hey, I have a person here that has the problem that drawings that she has in her documents don´t print out. I´ve tried turning off background printing still same, I´ve tried printing it on my printer and that works.
Anyone have any idea on any settings or something I can change to make it work?
Drawing objects (Tools - Options - Print) ticked?
computer freezes, especially when going to facebook.com. I am getting pop-up ads. everything I print on my Brother MFC-440cn printer comes up with a watermark from "Spectrum Glass" When trying to download from your instructions for DDS I get a blank page and no download. I have included info that I thought may be useful.
Run the following:
Please download Farbar Recovery Scan Tool and save it to your desktop.
Note: You need to run the version compatible with your system (32 bit or 64 bit). If you are not sure which version applies to your system download both of them and try to run them. Only one of them will run on your system, that will be the right version.
Double-click to run it. When the tool opens click Yes to disclaimer.
Press Scan button.
It will make a log (FRST.txt) in the same directory the tool is run. Please copy and paste it to your reply.
The first time the tool is run, it makes also another log (Addition.txt). Please attach it to your reply.
Gentlemen/Ladies,I?m not sure where to post this question so I?m plumping for this forum, knowing that it will be redirected if it is in the wrong place.Occasionally, when I open a website, its pages are too wide for my monitor and I have to scroll across to the right to see what is hidden from view. When I go to print the pages, I end up with just threequarters of the width of the script.I am using an HP LaserJet 1010 printer.I do not have this problem with all websites. Today, the offender is - http://www.explorenorth.com/whalers/featur...lecaptains1.htmWill the pages of this website be partly displayed on the monitors of all of the people who open it , or are my own ?settings? to blame. Please, how can I overcome the problem ?Yours sincerely, oldsoldier
Hi oldsoldier.I get the same thing when viewing that page. My screen resolution is set to 1024X768. I found that if I went to View>Text Size and set it to Smallest the page almost fit. Have you used Print Preview in the File menu to see what the page will print like? You can also use Page Setup in the File menu to adjust the margins etc. before printing.3 more replies
Other than using View>Text Size, is there anything I can do that may cause the print to be darker? I know that my eyes are beginning to grow weaker but perhaps someone knows a trick for me to use or an answer. The light print seems to occur on most web pages and very bad on my ISP webmail account. My signature will tell you I am using WinXP Pro and SP2. If all pages were as clear and dark as the print I am seeing while typing this thread, I would not be asking for help. As always, TIA
7 more replies
I doubt that I can post this question here but I assume it'll be removed if not.
I have an HP printer, 2540, wireless printer. Works fine.
I started to print a pdf file. Because it was a large file I choose the 'booklet' option, which prints 4 pages on one side, then, when everything of the even numbers (I think, not sure) has printed, you will get a message on the pc telling you how to replace the already printed pages in the printer so it can print on the backsides.
When I saw the first batch I decided I didn't like it. So when the message with instructions on how to replace the already printed paper, I went in the printer's menu, highlighted the name of the document and did 'cancel'. In this printer menu it now said it was 'deleting' the document. But it didn't. I waited about half an hour. I turned the printer off and back on. I closed the document. But still the printer menu said 'deleting'.
I opened the document up again, changed the settings for the printer (as in one sided, normal size) and accidentally hit 'print'. I then noticed that - in the printer menu - the 'new' document showed up above the one that still said it was deleting. But it still didn't print. I went in the print menu again and highlighted the new document and did 'cancel' and it did cancel it.
But the old document is still sitting there, 'deleting'. I can not get past that. Any suggestions wo... Read more
There's a way to force these to delete, if you don't mind a little typing. You need to open a command prompt by running cmd.exe. If you're unsure of how to do that, tell me which operating system you're using and I can walk you through that. This should open up a black window, and you need to type in the following commands sequentially, hitting the Enter key after each command.
net stop spooler
del %systemroot%\system32\spool\printers\* /q /f /s
net start spooler
The first command stops the printing service, allowing you to carry out the second command, which deletes any jobs in the queue. The last command re-starts the printing service, and you can try running a test print. Once that's all done, you can just close the black window.
I have a problem with my Word documents. When I try to print them, the right edge is cut off. I thought it was my computer or my printer, so I took it to another computer, and the same thing happened.
The problem is in the files themselves. How do I change the files so they function as they used to? This has been the case with more than 20 files, which were made at different times.
My computer used to warn that the form I was using was too wide, and ask did I want to go ahead. I would select yes, it would print, and would look just fine. Now it does not ask that question.
Incidentally, another problem is that my files no longer end with .doc, but now say .rtf. All of my Word files changed in several ways at once.
11 more replies
This question may look stupid.But please help me
Is there any way to save the documents or material from internet which to be printer
As i have no printer at home,I have to take that to my friend's house,where we can print.That pc has no internet
So i want to save douments offline and then print later using a pendrive
Windows document viewer is one kind of programme,that useful
Is there any other ways?
Please help me
Thanks in advance
6 more replies
I suspect this might be a fairly common problem. Whenever I print there also seems to be a block of about 5 fine lines printed over the text for about ever new line of text. Now I recently bought a new (high capacity) cartridge which costs a fortune, so I'm not too keen to buy another if it is the printer (about 6 years old) which is the problem.
Has anyone else had the same sort of problem?
Try cleaning the print heads, this is the normal solution to this problem.
I have an Access database used on daily basis to print maintenance work order. Each work order is assigned with an auto field No. I have a commend button assigned to print each record in a report format. On clicking command button, i enter the record number to be printed and it previews the report and check for accuracy of data entered. Once checked, i click on the print icon to print the same.
My question is, is there any method to find out the record i am going to print now is already printed before? A kind of record keeping of the printed records. Also, the same method shall help me to find out how many times each record is printed?
Hope someone can help me
8 more replies
I have printed photos from e-mails before, but never had a problem with moire patterns. This time I have a fine vertical line pattern that is not clearly seen unless you have glasses on that magnify them. Unfortunately, I wear glasses that bring them out. What can I do to prevent or get rid of the moire? Any ideas? Thanks, lilart
It likely just a matter of the resolution of the email derived image vs the resolution of the printer. Does it happen with every image or just the lower resolution ones from the emails?
I have an Access report that includes a sub-report in whihc I would like to print the records on one row, rather than one column. So far, I have been unable to find a solution.
Job Number: 123456
7 more replies
Can't find app that lets me get photos printed & delivered to me for Lumia 640XLMore replies
I am so hoping someone knows the answer to this very perplexing problem... I thought it was my printer so I bought a new one and I have the same problem. I print a picture of my granddaughter, who has these wonderful chubby cheeks.........until it is printed and the chubby cheeks are gone. She has slimmed right down...... lol I have been struggling with this problem for quite a while now, have asked everyone who comes within two feet of me and no ones knows how to fix this or what is even causing it. I know someone here will know. I have never had a problem that this site has not been able to fix for me. : ) Thanks, in advance.
Oh yes, and new printer is an Epson 835 al-in-one and my old one is an HP photosmart 2575
16 more replies
I have had my problem for some time and had a work around which is no longer applicable hence I get a white screen where message should be so I don't know what is being said.
My problem started about 6 or 8 months ago on Outlook Express. At that time I was using dial up and changed over to Earthlink.net with their e mail program Total Access. My problem immediately disappeared. One month ago I switched over to High Speed and the person doing the custom install saw I used Outlook Express so he reenergized (non computer word) the program. The custom installer saw my INBOX with about 30+ messages that go back a long way. EACH ONE LINE description was complete, meaning To: xxx,
From: YYY, Subject: ZZZ, and anything else that showns on the ONE LINE.
When I double click on one of the inbox messages I FIND MY PROBLEM! Everything that showed before is shown again, but now greyed out since it has to do with basics. HOWEVER, the text area (where the message should be) is 100% pure white. I have double clicked all 30+ messages and get the same thing,...a pure white screen.
I thought it might have something to do with installing SP-2 on my XP Home Edition BUT SP-2 was installed about 6 months ago and my e mail problem started about 8 months ago.
That is my problem! Can anyone offer suggestions?
Welcome to Tech Support Guy Forums!
So if I understand correctly, you can send and receive emails ok.
The problem lies in that the messages you receive are blank inside?
If you run your mouse over the inside of the message, does anything show up in the highlighted/selected area?
Perhaps your fonts have a white color?
Are you able to create a new message and see the fonts inside?
Let us know.
I'm trying to print images/pictures using windows photo viewer and I get this error "Your pictures can't be printed because this error occurred".... It doesn't tell me which error.. simply just says that in the dialog box. THe dialog box comes out like 4 times with the same message and I have to click OK.
I've already tried googling it and the only fix I can find is replacing photowiz and I already did but it has fixed. I've also installed Photo Gallery and it stil lgives me the same error when I try to print and picture. I've also reinstalled all my printer drivers...
Windows 8.1 Updates installed . HP Computer
What is the mfg & model of the printer? How is it connected to the computer?8 more replies
Hi, when I print anything from the web (Amazon receipt for example) the 'Print preview' and actual hard copt print appear as source code (similar to lots of DOS type commands etc) and very small print size. Only happens in Internet Explorer 7.0 -tried using Firfox and that appears okay- any suggestions -anyone? (thanks in anticipation)
open IE, click tools > internet options > advanced tab
click the reset button
This will put everything back to default options and all is good!
Problem: Green Cast on Images being printed
Editor - Elements Version 7 & Windows default viewer
Colour Management:- every variation tried
My Neighbour has a Epsom R285 http://www.epson.co.uk/Store/Printers-and-All-in-Ones/Epson-Stylus-Photo-R285 printer, his had it a few years.
I have recently changed his PC to a Windows 7 desktop and installed all the drivers. The Printer worked fine, but yesterday he was getting a green colour cast on all images
I checked the head alignment, nozzle set-up and cleaned the heads
Checked with windows default viewer, and printing from that application - same problem
Checked all the Colour Management, ICC, settings etc - tried without Management, sRGB, adobe 1998 etc, checked colour management on printer and elements
The image looks fine on the screen , I have emailed a sample image and on my setup it prints fine
The next step was to try the printer on my laptop
any other ideas - this is usually a colour management issue and i have fixed quite quickly in the past on other systems - so I suspect I'm missing something obvious now
Wild guess .. Windows 7 software update for the printer ??
I have an HP Deskjet 920c that has worked fine until a few days ago. I tell it to print and the goes through the motions but nothing comes out. This means the printer icon is appears and says that it is printing but it does not. I have checked the power cords and the made sure that it is connected to the computer correctly. Any ideas?
13 more replies
I'm running Windows 8.1 64 bit. I have a PNG file that exceeds the size of the page, 8.5 x 11, when printed. When I view the picture online it appears that it should fit the paper okay. I resized the file by %, pixels, and measurements (inches). I also changed the paper size to 8 x 10. Can somebody tell me what I am doing wrong.
Open a Word document of the desired size and import it there. You can also draw a box on the Word document and put it into there - it will fit. If you don't have Word, try Paint.3 more replies
Thank u for ur support on my previous issue. I have an another issue, whenever I give print from an adobe reader file it shows the error message "Document could not be printed" . I have HP LaserJet printer model F2180. Kindly help on this issue.
If your problem is that Adobe Reader is unable to print, but other applications can print, I suggest that you uninstall Adobe Reader and then download and install it again.
When i try to print something the documents appear in my print queue then are deleted before they even begin to print, my printer was working fine until yesterday and now this
G'day steviejay, sounds like you have an intelligent printer that is censoring your output!
That is a worry, I haven't seen that problem previously.
You might try having a look in your control panel, system, devices or device manager, with a bit of luck when you scroll down through all your devices you will find a USB printer, (assuming yours is usb) if you open that item you should see something like "this devise is working properly" which is a good start for troubleshooting.
There should be no yellow exclamation marks on this item.
Are you quite sure your print queue in the print manager is being actually deleted?
What kind of printer is it?
The assumption is that it is a PC using a windows variant.
Anything I print off the web or email says "Network + Job Functions" at the top of the page and the date at the bottom. Sure, I've been to websites pertaining to the job functions but I never saved anything with that name. How can it be printing at the top of any page?
If I print a document that I made and saved from Wordpad, not anything from the net, it prints fine with no header. I looked at the printer settings dialog box and it shows nothing with this title.
If you are using IE, at the top of the page click on file and page setup and see what you have under header and footer. You probably need to change those.
One of our users (out of about 300) is having a problem printing messages from Groupwise. His messages are missing characters. Random characers, randomly spaced. The message views correctly, and even looks correct through through printkey (screen capture program). I uninstalled GW and reinstalled it. No help. I turned off integrations. No help. I turned them back on. No help. I uninstalled and reinstalled the printer. No help. I pointed it to another printer. No help. I'm about out of options here! Any ideas?
6 more replies
When I print an email from outlook 2000 sometimes my attachements will appear on the print-out and sometimes they don't. I've found that if I have my emails set up in HTML format, then the attacment won't appear, but if the emails are set up in Plain Text format, then the attachment will appear (as an icon) at the top of the message. Is there any way to get the attachements to appear on the HTML formatted messages?
Hi All, Please Help !!!!!
I set the printer to Fast Mode. After few month used, now every day morning I print.
The first few pages printed are not clear (especially black color), then the following pages are printed fine. Why ??????
I'm guessing that the ink jet ports are drying up over night and it takes a couple of pages being printed before the ink is flowing correctly. I think using fast (draft) mode send less ink to the heads or less ink is available because you are printing faster.
I recently acquired a Canon EOS Rebel T1i (500D) 15.1 mp. Previously, I had a Canon PowerShot A80 (4.0 mp).
Here's my question. Whenever I try to print a photo from my Canon i860 printer, the picture is a lot brighter than the image on screen (overexposed). I need to darken the picture significantly before printing it, in order to get a ressemblant result on paper. When I was printing a photo from my PowerShot A80, the result was almost identical to the image on screen.
Does this have anything to do with my new camera's higher resolution? Would I need to lower the resolution in order to match the printer's capacity?
This is becoming annoying and I really would like to find a solution.
16 more replies