Automatcally Hiding Rows in Excel 2000 #2
Is there a way of automatically hiding rows in Excel 2000 based on a rule
(ie if there is no data in a row, we want to hide that row without doing it
manually)? We have a couple of ideas which involve VB code which reacts to
data within that row but if anyone has done this before or knows of a way to
do it, that would be great.
Thanks in advance!
Was a reply you got to your first post.
Tom Starr wrote:
> Is there a way of automatically hiding rows in Excel 2000 based on a rule
> (ie if there is no...printing labels
I can print word and excel documents, but when I go to print a full page of
labels I can't. My printer shows a meesage to add paper when I all ready have
have you tried to remove
the paper from the printer
before printing labels?
then simply feed the
printer with the label
paper when it asks.
DatabaseBen, Retired Professional
- Systems Analyst
- Database Developer
- Veteran of the Armed Forces
- Microsoft Partner
~~~~~~~~~~"share the nirvana" - dbZen
...Hiding tasks with due dates in the distant future
I'd like to display only my tasks for the next month or so. How can I filter
out those that are in the distant future or recurring tasks that won't be
due until next year or the year after?
Goto the Tasks folder.
Goto the Customize current view. Click on the Filter Button.
Goto the Advanced Tab. Under define more criteria, clickon the Feilds and
then select All Task Feilds and then select Due Date.
Then under the condition Select Between and then in the Value enter the
range of dates ( say 3/8/2004 and 3/10/2004 ).
Hope this helps !!!
"Ambe...Outlook 2007, proofing options greyed out in Editing Options dialog
I've just uninstalled the Office 2007 trial and installed a retail copy of
Outlook 2007. For reasons I won't go into I've reverted to Office 2000,
with the exception of Outlook, which didn't work with Vista.
While the Outlook editor still autocorrects spelling mistakes, I noticed it
isn't underlining unknown words in red any more. When I go into the Editor
Options and select Proofing, all the options in the Microsoft Office Section
are available to me, but the Outlook specific ones are all greyed out.
Moreover, in neither of these sections is there a "Hide spe...Print Tasks Outlook 2007 Q.
I would love to print out a listing of all my tasks. Unfortunatly, I cannot
think of how to do this. I can select my desired list of tasks but when I
print it out, they only print one page to a task. How can I print a listing
of tasks that will be more like the display?
Greenville, South Carolina USA
How and where in Outlook are you "selecting my desired list of Tasks?"
Have you made a filtered view of the Tasks Folder?
Outlook 2003 user? Read "7 settings all Outlook 2003 us...Signature page not printed for Credit card transaction
I have set up new POS system and the POS system does not print
signature page for credit card use.
I check 'require signarue' for the receipt from tender type window and
print Z-out to apply it but it still does not printing out the
Please be advised.
thank you for your help!
This is a multi-part message in MIME format.
Make sure the receipt is set to print it. Manager | Database | Register =
Lis...Printing business cards #6
I am trying to design and print cards for my business. I
have the card designed, but I am confused by crop/bleed
marks. The blue lines that intersect inside of Publisher
do not seem to be the same lines that print when I print
the card. How do I know how much room to leave around
the edges (or "margins"). I do not know how much space
is usable. Any help is appreciated.
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from steve <firstname.lastname@example.org>...
> I am trying to design and print cards for my business. I
> have the ...I can't print Excel document on legal size paper even with correc.
I have checked my settings, but I cannot print my worksheet on 8 1/2X14 legal
size paper. Can anyone give me suggestions on why this would be happening? I
can print documents that are letter size with no problem.
I am using Microsoft Office 2003 with Windows XP.
Choose Page Setup from the File drop down menu. Click on
the Page tab and change the "Letter" to "Legal"
>I have checked my settings, but I cannot print my
worksheet on 8 1/2X14 legal
>size paper. Can anyone give me suggestions on why this
would be happening? I
>...text font color won't print in Excel, why?
I am using Excel 2002. I changed the text font color of the cell. It
displays correctly on my screen, but it prints as black text even though I
selected a pale yellow. Word 2002 prints correctly. The pale yellow prints
as a light shade of gray. Does anyone know why? Thanks
Perhaps in Page Setup>Sheet you have "Black and White" checked?
Gord Dibben Excel MVP
On Sun, 23 Jan 2005 22:51:01 -0800, eagle7 <email@example.com>
>I am using Excel 2002. I changed the text font color of the cell. It
>displays correctly on my screen, b...Document extra check was printed and mark it void
I'm trying to figure out how to tell GP8 that an extra check was printed but
we need it to be void. We printed checks today and accidently printed 1 more
than we should have. Since we used that check number, GP will move on to the
next one. We want to be able to go into GP and document that we did print
that check but it should be void. Does that make sense to anyone?
Did that exra check print on a check or on blank paper. Do you want to
re-use that check number? I'm not 100% with GP 8, but in 10 you just go to
"Void Historical Transactions" and void the check. ...how to save settings for printing several envelopes
I want to print addresses on several envelopes which are the same size but
the addresses are different (for Christmas cards). Is there a way to do this
without going to options each time and reset the size and font that I want?
Create an envelope template. You can start from scratch with a new document,
selecting the desired paper size (or specifying a custom size) or use Add to
Document to add your envelope to the current document. Then see
http://sbarnhill.mvps.org/WordFAQs/DetachEnvelope.htm for instructions on
separating the envelope from the document. Once you have just the ...Receipt print strange characters on Vista
We run Vista business with RMS. The receipt printer is an Epson TM88 clone
and on both printers it randomly prints strange characters all over the
It sometimes come up with an error 'unknown error - retry or cancel' but not
We have never had any problems on XP so I don't know if this is Vista
related or not. The supplier of the printer suggested we download the latest
OPOS drivers which we have done without success.
Has anyone else seen or had this problem?
...Cannot view print preview of HTML messages after IE7 uninstall
I can no longer view a print preview of HTML messages in OUtlook 2003 after
uninstalling Internet Explorer 7 Beta 2. Anyone know how to fix this?
Have you tried reinstalling IE7 Beta 2?
"QaT" <QaT@discussions.microsoft.com> wrote in message
>I can no longer view a print preview of HTML messages in OUtlook 2003 after
> uninstalling Internet Explorer 7 Beta 2. Anyone know how to fix this?
Yes, and still does not work. Very annoying. Might Windows Repair fix this
"Patrick Schmid&...How do i print an excel file in the form of a booklet?
I have a list of phone numbers and addresse that I need to print in the form
of a small booklet that I can carry in my purse. How do I print it? What
program and how to set it up? Also I want ohotos on the left and data on the
right side pages.
I'm not sure excel is the best application for this kind of thing.
I'm sure you could do it (after a few hours/days/months of frustration!), but
maybe you could find a better application by searching google.
Or even put the data into MSWord and use that for all the nice formatting.
> I have a list of p...blank page prints after group (sometimes)
I have report of students with the class_id defined as a group. "Force New
Page" is defined "Before Section".
Whether I have a page and a group header defined (they can be the same anyway)
or just a page header defined, I am getting the same problem:
27 students can fit onto a page. However, if there is a class of 25 students,
the next page is blank except for the header. (I have not seen a class of
27 students so I have not tested that yet).
I can't seem to find a way out of it. Where I am I going wrong?
Message posted via AccessMonster.com
After I removed the pagebreak, my worksheet prints out very small. Also,
without actually signifying the number of pages to print, it trys to print
1000s of pages ... that just started.
First select and set a print range/area.
Next under Page settings disable "Fit to" and use "adjust to" 100%
Gord Dibben MS Excel MVP
On Tue, 8 Sep 2009 13:12:54 -0700, allstarmanage
>After I removed the pagebreak, my worksheet prints out very small. Also,
>without actually signifying the number of pages to print, it try...Excel charts in print preview distorted.
I'm assisting a customer with an excel presentation she
created on another computer. She is curently using Excel
XP and she changed some of the data the charts are pulling
from and now the charts are all distorted in print
preview. The charts are all scrunched up in the upper
portion of the page. I view this presentation on my
computer and all looks fine in page layout and print
preview. I tried setting her default printer to mine, no
help. I tried adjusting her video resolutions (they were
originally the same as mine) to higher and lower
resolutions and get the same results. Any...Print Item Number Ole object on Sales Order Processing reports
Would like the ability to print an Item Number Ole object on my SOP reports.
For example, go to Transactions, Sales, Sales Transaction Entry. In the
Sales Transaction Entry window, enter an Order for an Item. Click the Item
Number Note button. Once you are in the Note window, click the paperclip
button to add an Ole Object. In the OLE Container window, click Edit, and
then click Insert New Object. In the next widow click Create from File. This
is where you will attach an existing object (such as an image or text file).
Close the window and save your changes. Click Attach to atta...XP Professional printing to HP 722C
When I had my printer HP 722C installed on a Windows 98
computer, I had the option for duplex printing and
printing to banner paper.
Now, I have it installed XP Professional machine and
these options are not available.
Has anyone else seen this and know how to fix this?
Before David A comes in to blast HP, you might want to go up to the HP site
to see if their is a newer driver available for your printer. However, in
many cases some printer functions have been lost with XP, and you may have
to do your duplex printing manually. Good luck DavidF
"Bimshure" <firstname.lastname@example.org&...in publisher my work is printing mirrored?(backwards) why??
Take a look at your printer settings. There probably is a T-Shirt or Mirror
"brett" <email@example.com> wrote in message
Thanks!!!! now sorted :-)
"Mary Sauer" wrote:
> Take a look at your printer settings. There probably is a T-Shirt or Mirror
> Mary Sauer
> "brett" <firstname.lastname@example.org> wrote in message
> news:C11...urgent , display to print
on a landscape print i would like to print text example "excel statistics" on
left but vertical. when i print i would like it running from the top to
bottom on the left, instead of starting where the data in the sheet starts. I
mean when i print this way it leaves a gap at the top and bottom but i would
like it without the gap covering like a heading on the left side of paper.
Do i need to use something like a clip art or anything else to achieve this
? Any help will be great. thanks
I think I'd use another application (MSWord) and print that separately. Then
send the ...Chart labels do not print in 2003
My spread has several sheets and two of these have eight graphs on each
- all sized to fit on one A4 page per sheet.
Since i have upgraded to Excel 2003 from 2000, some chart titles no
longer print. I have upgraded my printer drivers and also tried this on
other Excel 2003 machines, and they have the same problem.
However, if i go back to an Excel 2000 machine it prints fine.
The report is distributed to users of both versions.
Any ideas how to fix this?
I don't really have a guess.
Have you tried it on different printers (if you have them available)?
If you create a small test work...How to print 2000+ characters seen in formula bar? #2
Formula bar shows +1024 characters, screen only shows 1024. Printer only
prints 1024. How can I print all?
Add some alt-enters to force new lines within the cell.
Use a smaller font.
Widen the column width
lengthen the row height.
> Formula bar shows +1024 characters, screen only shows 1024. Printer only
> prints 1024. How can I print all?
Thanks, but none of your suggestions work. I'm using Excel 2003 by the way.
"Dave Peterson" wrote:
> Add some alt-enters to force new lines within the cell.
&g...Open/Convert Dialog Box Disappears after selecting open once
This has been bugging me, and I haven't found any documentation on
this anywhere. When faced with the Open or Convert Dialog when
opening an Access 97 file in Access 2002 (Office XP) and you choose
"OPEN", you do not get the dialog back a second time. Where does this
setting get set in the file?
Is it written to one of the system tables or somewhere else like your
pagesys file? The reason I ask, one of my clients sent a file with an
Access 97 database inside a ZIP file. They do not have a later
version of access. And usually we receive the dialog. But this time
we didn'...Print to Adobe PDF not showing up in Publisher toolbar
Does anyone know why I do not have the option to print to Adobe PDF? The
user just wants to be able to convert the MS Publisher file to PDF.
It cannot be selected when I choose which printer to print to.
It is also not up in the toolbar for MS Publisher & probably some of the
other MS Office apps as well.
The user was using Adobe reader v7 but then one day the option to print to
I have since installed v9 then rolled back to v8 & neither of them allow the
user to select it in the printer selection as an option.
Thanks for any input,