Hi frends,
I searched the forums but didn't find any thread, may be there is some thread which would helped me for finding formatting tips for prints
can anyone recommend me any thread for formatting for print.
is it possible that if i have 3 col and 3 row
a1 country capital
a2 usa washington
a3 uae abu dhabi
& all font size is 10 arial is it possible these 3 col & row is on the full page in landscape without changing the font size.
can anyone help me out for formatting tips for print.
Thanks
My problem is this: I'm using Excel '03 to hand edit (!) a fairly large db. I have the data charted as a scatterplot, the x-axis is a numerical data id in the range 0-500,000 and the y-axis is the measurement value. Basically I go along the chart and look for outliers and bad data, then mouse over the point so the chart tip appears with the values and then I can easily edit them out of the worksheet. My problem is that on some sheets (I'm working with about a dozen) when I mouse over the point instead of the integer value (e.g. 286,458) I get a truncated scientific value (e.g. 3E+05) which doesn't really help me dig the value up in the worksheet. This seems possibly unrealted to the x-axis value, as some sheets in a similar range will display. Is there a way to force excel to display full integer values here?
I apologize if my terminology for the numbering is wrong, I hope I managed to make it clear none the less. Thanks for any help.
I am using Excel 2003. The spreadsheet has formatted columns - some formatted as dates, some formatted as currency, etc.
I want the spreadsheet to highlight in colour any value that is different from the value in the ROW directly below it (i.e. in the same column as it)
I was hoping to do the conditional formatting in one cell and then copy it to the rest of the spreadsheet. That works OK - but the problem is that the non-conditional formatting is copied at the same time. That causes Currency columns to display as dates etc. Is there a way around this?
Thanks
Hi,
Warm Regards to all the superbrains !!
I'm just unable to retain the cell formats of conditional formatting after removing it.
Please help me in this regard.
Your help is greatly appreciated.
Thanks & Regards,
Sunny Kumar
What is the easy way to create forms in different sheets.......
In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......
Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards
J-O
Hy guys,
I still work with excel 2007, so, can someone tell me please if the 2010 version shows the formula tips, when we are tipping a formula in the "name manager box", and in the "conditional formating box".(when you use a formula to do conditional formating), like they are shown when we tipe a formula in a spreadsheet cell??
I think that would be a great help
Hello. I recorded the code below to convert pages of workbook to pdf. It works well on my computer but on a co-worker's computer the pdf produced has header and footer pictures shifted slightly down and to the right, showing small areas of white area on his pdf and I do not see this on my pdf produced.
-Any idea what might cause this situation?
-If I have pictures in the header and footer and the pictures are inserted from my desktop,
does this cause Excel issues with those headers/footers on another computer? Is a better
way to load and link the pictures somewhere in the Excel document?
-Is Excel not the best tool to convert to pdf? Would it be better to use Publisher
or even Powerpoint linked to Excel sheets? How about one of the many Excel to
PDF softwares out there?
Thank you.
Sub convpdf()
Sheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5")).Select
Sheets("sheet1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Documents and Settings\myname\Desktop\pdf_file.pdf", Quality:= _
xlQualityHigh, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub
I'm currently working on a new Excel Tips and Tutorials Blog for
beginners, intermediate and advanced users alike. I need some ideas
for common problems or tips that people request on newsgroups and
searches on the internet etc.
If you could please suggest some ideas to me that I can write tutorials
for and therefore add content to my blog with I would be grateful.
Please email any ideas or previous problems you have had to
mattyboy150279@gmail.com and I will add them to my site with detailed
solutions.
My site is http://teachr.blogspot.com
Many thanks in advance.
Mat
Hi,
I just wanted to create a Receipt voucher for some Documents. So that i wish to create a Userform. But I need to print those form in the same style. Could you anyone please help me to do this?
