I want my grid lines back
How is it that part of my spread sheet has grid lines showing and muc
of it does not? Please make it all show grid lines..
Message posted from http://www.ExcelForum.com
Make sure that the area that doesnt have grid lines are not merged
- Larry -
Message posted from http://www.ExcelForum.com/
Or you have set a white backround Fill color for some cells
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
"nrage21 >" <<firstname.lastname@example.org> wrote in message news:email@example.com...
>...Removing text between hyphens and removing the hyphens
I am a bit new with regards to excel but If have a column of data that has
values in this format (note the placement of the hyphens)
9999- RR - AAAAAAAAAA
The length of 9's are constant at 4
The length of A's can change between cells
I would like to remove the R's and hypens to have this:
Any suggestions? Thanks for your help
Select the range to fix
what: -bRRb- (b represents the space character
with: (leave blank)
> I am a bit new with regards to excel but If have a column...Trouble with creating tab stops
This should be very simple but haven't found the answer in all the posts.
Following the "Create or modify a tab stop" instructions I can't get the
first tab stop to respond to anything but flush left. Center, Decimal, Flush
Right all do not seem to work. I'm sure it is simple and something I should
be able to do. My many searches re-phrasing to advance the search only take
me back to "Create or modify.....".
"Midge" <Midge@discussions.microsoft.com> wrote in message
>...RMS mysteriously stops tendering- help!
We're trying to install RMS on some new machines and the tender function
mysteriously stops working not long after it installs. We use Mercury's TPI
software (which continues to work on older installations) and it will work
for the first couple of test transactions, but inevitably fails not long
after. It throws no errors; nothing in RMS, its log, SQL, or even the Event
Viewer. We just click... and nothing. There is no consistency between Windows
versions (XP SP2, SP3, Vista) except for the persistence of the error.
We're desperate! Anyone encountered this before?
did you...Stopping a Loop
This is a great formum. Hope I don't wear out my welcome.
I have a form which is filled based upon a search of a specific string in a
specific column i.e. 455-203-23. On that form there is a commnad button that
calls an addtional search of the database to see if there are other records
with the same string exist in the database. It works great, however, I can't
get it to stop once its gone through the entire database as it simply goes
back to the first record in the database an starts over. Any suggestions as
to how to break the code once I've reached the last ro...Line Graph #6
In Excel 2000, how do I connect points in a line graph if I am missing
intervening data. For example if the x axis is 1,2,3,4,5,6 and I have data
at only 1,3,5,6, how do I connect these points.
With the chart selected choose Tools, Options, Chart and set Plot empty
cells as to Interpolated.
If this helps, please click the Yes button
> In Excel 2000, how do I connect points in a line graph if I am missing
> intervening data. For example if the x axis is 1,2,3,4,5,6 and I have data
> at only 1,3,5,6, how do I ...Converting Text to Number in 2000
I have a spreadsheet that has a sum formula at the end of a column. Th
problem is that the last 7 or 8 values being summed seem to be text.
However, if you go to format cells they show up as numbers. In Offic
XP you can simply click on the Green arrow in the upper left han
corner and select convert to number. This fixes the problem and all i
well. In 2000 this function is not available. Is there a way t
convert these values without having to retype all the values in?
Message posted from http://www.ExcelForum.com
Select the cells.
Give them a number format.
Data/text to ...Adding Attachment in OWA stops Information Store
When users attempt to add an attachment to a new email through OWA,
the information store service shuts down. I get an error in the event
log that reads:
Unexpected error <<0xc1050000 - Network problems are preventing
connection to the Microsoft Exchange Server computer. An unexpected,
unknown error has occurred. Microsoft Exchange Server Information
Store ID no: 80040115-0514-000006bf>> occurred.
If I restart information store service everything seems fine until
some tries to add an attachment again.
I am running W2k3 Server SBS Standard Edition. I tried installing SP1
for E...Text On Picturebox
I have two pictureboxes.
The View picturebox is visible and is proportional to the invisible box.
The Target is an invisible picturebox usually too large to display or work
I need to position text on the View box using the mouse and /or arrows.
The size of the text is controlled by scroll bars.
Single line of text.
After the user positions the text on the View, it is then transfered
proportionally (location and size) to the Target then saved to a file.
I am trying to use API calls to get interesting looking text output but I
cannot get past the first part, showi...Combination Bar/Line chart---each with different number of data points
I'd like to create a combination column/line chart (no problem there).
Here's what I'm having trouble with: The columns will each represent
data over a calendar quarter (primary x-axis), the line will represent
data for individual months (secondary x-axis); the columns and line
will be plotted against separate y-axes. Visually, the finished chart
should have columns with no space in between, and the width of each
will contain three data points of the line chart. Is it possible for
each chart to have a different number of data points, but graphically
have the same horizontal size?
...No Subject Line
When users try to send emails using Outlook 2000 without a
subject line, it looks as if the message was sent, but it
does not reach the recipient. Has anyone experienced this
before or does anyone know where I should look.
C <firstname.lastname@example.org> wrote:
> When users try to send emails using Outlook 2000 without a
> subject line, it looks as if the message was sent, but it
> does not reach the recipient. Has anyone experienced this
> before or does anyone know where I should look.
Perhaps the recipient is blocking messages with no subject.
...Stop all macros
I have a button on a form, which should do different things depending on
1. The data contained within the current record;
2. Whether the current record is a 'new record';
3. Whether the current record is the first record in the form.
On click, an embedded macro is initiated. Each step in the embedded macro
has a condition and a corresponding 'RunMacro' action.
All the conditions are mutually exclusive, and each sub-macro has a final
step of 'StopAllMacros'. So the embedded macro should trigger one, and only
However, it appears that what is act...Converting Text to Number?
I have a linked table that I'm working with dates defined as text (in the
format 25NOV without the year) and I'm trying to extract the date (25) and
use it as a number but I can't figure out how to do it - is it possible?
Alex Dybenko (MVP)
"Anastasia333" <u45871@uwe> wrote in message news:89763b784b816@uwe...
>I have a linked table that I'm working with dates defined as text (in the
> format 25NOV without the year) and I'm trying to extrac...Grid Lines imported to Word
Does anyone know how to copy from excel to word without the gridlines
showing on the Word file? I am copying a table and even if I set the
background to white and deselect the gridline box they still copy over,
however, they don't print on Word. There will be other people veiwing
the Word file so it needs to look clean.
Thanks for all your help
ccraig61's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31856
View this thread: http://www.excelforum.com/showthrea...Stopping Synchronization
I need to clear out email that I have synchronized to
offline folders. But I cannot select the "only when
online" option in the Syncronization tab under the
properties. Anyone know how I can unselect the "when
offline or online" and select the "only when online" option???
I'm confused - why can't you just delete the items you wish and synchronize
to the server again to your mailbox?
Or are you saying you want to stop synchronizing certain folders entirely?
What version of Outlook, and which folders?
Bob Keenan wrote:
> I need to clear out email tha...I do not want to use Outlook...so I uninstalled it.
I do not want to use Outlook...so I uninstalled it.
BUT now I cant send mail from IE6 and my internet
options, programs, does not allwo me to set my new
default email progam to OE
Also in my control panel, there is the listing MAIL, with
OUTLOOK listed there.
How do I get OUTLOOK completely off my computer??
...Creating a line
I am new to being able to create lines from data. I am a pilot. I have a
section on my navigational logsheet (in excel 2002) that I want to draw the
runways based on the runway number(heading) I enter.
The section set aside for this is S3-V9. I want the orientation, when
looking at the sheet to be as follows:
Up = North (360 degrees), Down = South (180 degrees)
East = Right (090 degrees), Left = West (270 degrees)
FYI: Runway numbers drop the last digit of the 3-digit heading. So runway
09 = heading of 090 and runway 27 = heading of 270. Obviously, the
reciprocal (other end...The DoMenu command was stopped?
I have used the wizard to put a delete record button on my form..
When the button is clicked it says.... Do you want to delete this record etc
It gived to options yes and no. Yes just deletes it and all done, if you
click no then I get an error message of "the domenu" command was stopped.
Does anyone know how to get rid of this?
Message posted via AccessMonster.com
In the code generated by the wizard, put an apostrophe in front of the line
MsgBox Err.Description. However, this will stop other er...BUG: DPM 2010 RC
1.) Setup 10 Hyper-V Childs on a High-End Server
2.) Install DPM2010 RA on these childs
3.) Wait for xx:00 / xx:30 and watch PerfMon
4.) DPM Service / TrustedInstaller will break RTC services for 1-5 seconds
KEEP IN MIND:
- New Feature "Run a constistency check..." should be disabled for all PGs
for RePro, because this generates well-known additional CPU load. This is out
- No Issues if you use DPM 2007 instead.
1.) Is this a known Beta/RC issue which will be addressed with RTM?
2.) Can this &qu...superscript specifict text in an equation
Normally to make a portion of text in a cell supscript I would use Format >
Cell, however if the text is in an equation, the Cell option is grayed out
and not available. How do a apply superscrip to specific text within an
AFAIK this is not possible for a formula result
> Normally to make a portion of text in a cell supscript I would use Format >
> Cell, however if the text is in an equation, the Cell option is grayed out
> and not available. How do a apply superscrip to specific text within an
...Share my on line money
How do I share my money accounts on the same computer but differant sign on
...Writing text on top of a pretty picture.
Instead of the typical windows background color, the powers that be
want a pretty picture to be displayed. My dialog application also needs
the functionality of an edit box, but I don't want an edit box with its
clunky, white appearance covering up a portion of the pretty picture.
If there's a way to make an edit box transparent....I tried that using
edit box controls and it's still clunky white....
I use DIBSectionLite to draw the picture. Controls show up on top of
the image - good. I set the background to transparent and do TextOut
(in OnPaint.) This works when I put the code i...Stop
In row 1 I have my column names. What I want is to be able
to scroll through my spreadsheet without having this row
move so when I am at the bottom of my spreadsheet I can
still tell what column I am working with. I tried
adjusting the scoll on the right top side but when I pull
the page to the top I get double columns and names??
Click in A2, and then,
<Window> <Freeze Panes>
Here's an old post that might help explain:
Please keep all correspondence withi...Add a goal line to a column chart
I have several column charts which I need to add different goal lines. Any
suggestions? The goal has to be represented as a line and not as a column.
Thanks for your help!
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Brandy" <Brandy @discussions.microsoft.com> wrote in message
>I have several column charts which I need to add different goal lines. Any
> sugg...Stopping an APAY
XP and MS Money 2003. There are 3 APAY accidentally sending that I
need to stop. They aren't listed in any bills/deposit areas for me to
delete. How do I stop them. Help file is useless. It says right click
on bill to stop paying, but as I said there is no bill listed for me
to click on. Help
Remove ISNOT to reply via email