Lines Not Showing Up in Print PreviewHi everyone,
Whenver I preview a spreadsheet with numerous lines on one page (ove
15 rows of lines) some of the lines don't appear. If I zoom in, the
appear once in a while, but it's not very constant. I was wondering i
anyone heard of this as maybe an excel bug. If not, maybe it's m
monitor? If anyone has any insight, I would greatly appreciate it.
did some searches but didn't find anything so far.
Thank you in advance.
Ric
--
Message posted from http://www.ExcelForum.com
I think it is a monitor resolution "problem" - the screen
paint isn't quite the...
Show zero values in specific areaI know it is possible to show zero values in a sheet by ticking "zero
values" in options, but I have a situation where zero values should only be
shown in certain areas of the sheet.
I've tried setting formatting to text and this displays zero values entered,
but it plays havoc with the data validation (Decimal greater than or equal
to 0).
Is there any way I can retain operation of the data validation, but still
display zero values in a specific range?
--
Ian
--
The only way I can think of is to use the option "show zero values"; then in
th...
shortcut keys for commentsIs there a shortcut key to add a comment. How about to
edit a comment
Sherry, I don't think there is a short cut key for it, but you could use a
macro and assign it to a button or key. Have a look here for details
http://www.contextures.com/xlcomments03.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
"Sherry" <anonymous@discussions.microsoft.com> wrote ...
Deleted Distribution Lists (OL2003) still show...how do I completely delete??I had created a DL in OUTLOOK 2003. It had a list of people from my
address book. I decided I wanted to completely change the name of the
DL. I removed each individual person and then DELETED (using CTRL+D)
the DL from my CONTACTS folder.
My company uses and EXCHANGE GAL for addresses, but this DL was in my
personal AB. Everytime I go back into e-mail in the TO: box, and I
type the first 1, 2 or 3 letters of a name (which was similar to the
DL I had created), it keeps showing the DL in the TO box, even though
it is empty and has been deleted.
How do I get the DL to be COMPLETELY GONE? M...
autoformat comments to move & size with cellsIs there a way to set the default to autoformat comments to move & size with cells? In a big file, it can take a long time to edit comment by comment.
Not that I know of.
But Debra Dalgleish has a macro approach that puts them back in there place!
http://www.contextures.com/xlcomments03.html#Reset
KMiles wrote:
>
> Is there a way to set the default to autoformat comments to move & size with cells? In a big file, it can take a long time to edit comment by comment.
--
Dave Peterson
ec35720@msn.com
...
Why is Bible Bob not showing up in Outlook Express?Is there someway that BB is on filter, and yet I do not know about it?
Bob does show on my other Usenet clients, and to my recollection there are
no ways to filter the hate filled posters with Outlook. Although I am knew
to Outlook, and Gastrich seemed to have figured out a way to filter people
with this software.
Outlook Express experts please reply. Is there some filter I am not aware
of?
I am using Windows XP and using version 6 of Outlook Express.
Thanks,
John
--
Luke 9:26-If anyone is ashamed of me and my words, the Son of Man will be
ashamed of him when he comes in his glory...
Article on showing Windows style error on MS Access FormI am building an application with several forms. In the BeforeUpdate event
for the form, I will run some data validation routines.
If there is an error, I would like to display an error control next to each
field containing an error (the exclamation point). The user can then hover
over the error control and get an explanation of the error. This is similar
to how a normal windows application works.
Some time ago, I can recall seeing an article that described the exact
technique that I want to use, but I can't find it now. Could someone please
point me to the article?
Many thanks!
...
Can Save As PDF enable comments?When I use the Save As... | PDF option, is there a way that I can
enable comments and/or markup so that the person I sent it to can add
annotations?
If the recipient has the full version of Acrobat, he/she can annotate the
PDF using that. Otherwise consider PDF as a graphic.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> &...
Showing names assigned to phone numbersI have entered in the cells A1:B10 numbers in column A, and names in
the column B.
In the range A20:A25 there are six phone numbers and I want Excel to
show -if the number does exist- the names in the cells B20:B25 or -if
not- an empty string
I was trying the array formula:
{=IF(A20=$A$1:$A$10;$B$1:$B$10;"")}
written in the cell B20 to -if worked- be then copied and pasted on
the following B21:B25 cells.
But doesn't work. Is the first time I tried an array formula.
Could somebody tell me how to do it?
Thanks
Jaime
Oviedo-Spain
...
Comments in Excel #2When you create a comment the font and size defaults
to "Tahoma", "8". Is there a way of changing the default
font and size for comments so that when you create
comments after changing the default they will all be the
font and size that you set as the default.
eg. "Arial", "10".
You can change the default font size:
Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK
or use a macro to insert a comment with specific f...
Show Query Design ToolbarI am starting my database with the database window and built-in
toolbars hidden. Certain people have the right to created new queries,
so I have created a button (which is visible only for these people)
that will display the database window so they can access queries.
The problem is the Query Design Toolbar is not displayed when they go
into Design view. I have tried to show the toolbar using the following
statement, without success:
---DoCmd.ShowToolbar "Query Design", acToolbarYes
I have tried putting this statement before and after the statement
that opens the database window, a...
crystal configuration manager shows no server...hi,
since all the crystal services are running (i can see them from services
screen), i could not see any crystal servers in the crystal configuration
manager list. all servers are enabled and i can see any errors about them.
what can the reason be?
regards,
orkun
...
SP3 update not showing | Ok to delete wrong email client?[MS WinXP Home 2002 - SP3; OE 6; IE 8; MS Office Pro; Avast Antivir Free;
Dell Dimension XPS T448MHz Pentium III; 640 MB RAM; high speed cable;
Windows Media Player; Adobe Reader 8; Adobe Flash Player 10 Activex..]
Hello again! New 2 little problems?:
(1) I had installed successfully Windows XP SP3. When it offered an
update, the first one, and I ran it by placing the Office XP
Professional...CD which it asked for, BUT, it doesn't show it under the
Windows Updates in add/remove. Did I do something wrong? Windows isn't
showing anymore on my Taskbar the offer to...
When I drag a note to my desktop it shows as the Windows flag. H.
Sunshyn <Sunshyn@discussions.microsoft.com> wrote:
Ask your question in the body, not the subject.
How do you want it to show?
--
Brian Tillman
...
Memory leak listing shows #File Error#(line num) when leak is in an OCX.At the top of my cpp file, I have the following:
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
I get the following memory dump on program exit:
Detected memory leaks!
Dumping objects ->
First-chance exception at 0x77e75b46 in ITWin.exe: 0xC0000005: Access
violation reading location 0x05030290.
#File Error#(4400) : {392148} normal block at 0x05C2EA68, 88 bytes long.
Data: < > D4 E3 FC 04 02 00 00 00 00 00 00 00 FF FF FF FF
I know where the memory leak is occuring. It is in a cpp file we wrote
where it is calling new ...
how to show another column when hovering on a point in a chart?Is it possible to show info from another column when you hover on a point in
a chart?
I have 3 columns, A, B, and C for a scatter plot
I have B and C as x and y coordinates of a point,
and I'd like to have Excel show A when I hover on the point in the little
popup box.
thanks,
Wei
Showing custom data when hovering over a chart point requires VBA
support -- and even then is reasonably complicated and less than
elegant. For one possible solution see
Hover Chart Label
http://www.tushar-mehta.com/excel/software/chart_hover_label/index.html
Regards,
Tushar Mehta
www.tushar-mehta.co...
How to show traffic light or status signsHi All
I want to display traffic light kind of display for a bunch of metrics
in a SSRS report. If the metric is above a certain value I want to
show a green traffic light next to it, if it is close to certain value
show a yellow traffic light and if it is below a certain value show a
red traffic light against the metrics.
Can you please kind advice how I can do it I am also checking if it is
possible to show a Down arrow if the value is below a certain
threshold and greater than arrow if it is above a certain value.
Please kindly share ideas how I can do this in SSRS 2008 repor...
MATCH doesn't show desired resultGood morning, all!
I have a cell in my Excel 2007 workbook which is dependent on the value of
cell A1. The result I want in cell A1 is either 1, 2, or zero. The formula
in cell A1 is:
=MATCH(TRUE,A2:A3)
When the values in cells A2 and A3 are FALSE, cell A1 shows a value of 2
when I expect a value of zero. Why is this?
Thanks,
Tucson Jeff
=IF(ISNA(MATCH(TRUE,A2:A3,0)),0,MATCH(TRUE,A2:A3,0))
Look in HELP for the meaning of the 3rd argument
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Jeff Wright" <jeffwright@cox.net> wrote in message news:qiOaj.17761$Rf5.10...
Online download shows deposits as withdrawalsOnline services for accounts seems to be
downloading transactions as withdrawls that should be
downloaded as deposits.
I tried to correct this by simply changing the category of
the transation. It changes the category but the deposit
still shows as a debit.
Any help appreciated.
Thanks.
This is a known issue.
--
-------------------------------------------
Joe Guidera
jguidera@msn.com.remove
"Bruce Wolper" <bwolper@optonline.net> wrote in message
news:327b01c4adfe$faaa4de0$a601280a@phx.gbl...
> Online services for accounts seems to be
> downloading transact...
Deleted apay shows up in budgetSo I deleted an apay and created a new one (its a payment
for a loan account that I also track in monney 2004).
While it is deleting out of my bills and deposits, it is
not deleting out of my "transfer out of budget accounts"
in my budget. so i now have duplicates. When I right-
click and edit, the screen just sort of blinks, but no
other screen comes up until I do it to the "active"
transfer/apay.
Any thoughts on how to get rid of the dupes, because they
are affecting my budget. Thanks...
J
I have the same problem. When you find an answer., let me know. My ...
Chart to show response to a question. One of answer 15 choices.I know this will be simple but I can't figure it out. On a number of given
dates I ask how happy people are and get a number of responses between 1 and
15. I then need to plot the number of occurences of those individual respones
i.e. two people were 2, three people were 7 etc. I guess it might be a simple
X/Y but I just cannot fathom it out.
Any help would be greatly appreciated.
Regards, Nick.
Hi,
You need to create a summary table of possible responses and tally.
Assuming responses are in A1:A15
in B1:B5 are the value 1 to 5, which are the available responses.
...
Excel 07 cell reference formula only showing literal text not valueHi, I've used Excel before but not 2007 version. I have a simple cell
reference formula in a cell B2 that I'm trying to reference the value
in A2. In B2 I have =A2. And all that is displaying in B2 is the
literal text of the formula, it is not returning the value in A2.
I've never experience this behavior in Excel. With a simple cell
reference formula it should return the value it's trying to reference
not the literal text. Is there something new in 2007 I need to do?
TIA
G
...
Calendar folder under public folder doesn't show up after migrated exchange from 5.5 to 2003Hello,
I got a problem on the public folder migration.
I set up a new exchange 2003 server on the network and join it to
exchange 5.5 site. and make a replication between two server.
everything seem be ok.
I have moved some mailbox to new exchange server, and also replica
public folder to the new server.
I can see all of public folder in the new exchange 2003 server from
exchange 2003 system manager. but when I attached outlook client to
the new exchange server, user can see all of public folder which
contain mail items, but can not see public calendar folder which
contain appointment items...
Show Daily Price Change Statistice in PortfolioSince there are many people who use MS Money Plus Deluxe might find that the
Options to show the Price Change and Percentage change from previous days
activities has been ELIMANATED in the latest version of Plus Deluxe.
I would be interested in having this option and feature returned as an update.
Since the holdings in many company profit sharing plans, IRA's and 401k
don't have TICKERS, the need to compute the needed information already exists
in the price histoty data downloaded from the Non Microsoft Web Site.
----------------
This post is a suggestion for Microsoft, and Mic...
Mail enabled public folderWe have several mail enabled public folders, or public folders that have
distribution list membership. When an email message arrives in the public
folder, it appears with a "note" icon instead of an envelope icon when we
view the contents of the public folder in Outlook. I have Googled this but
cannot find anything and am hoping to avoid using up a support case with MS
on it. Anybody else have this problem?
David-C-NetAdmin
In news:IFGwf.1230$SD1.244@tornado.texas.rr.com,
David-C-NetAdmin <reply-to-group-please@reply-to-group-please.thanks> typed:
> We have sever...