Excel page formatting and column wrapping ?
An interesting conundrum for anybody who is up to the challenge.
Essentially what I'd like to do is have a small code book printed fro
an Excel spreadsheet. Each page would come out looking roughly like
this' (http://www.licious.net/misc/spreadsheetcapture2.gif) .
Currently all of the formatting is being done by hand where each pag
is hand-formatted with extra cells near the bottom (for futur
additions) and each half of the page being divided up into two sets o
columns. Basically the columns snake from top to bottom, left t
right. Then the next page is done in the same fashion, le...search a text cell CONTAINING matching text in a dynamic range (not exact match)
I use the following, currently, to mark a row for exclusion
I'm looking for a way to use an exclusion keyword list on a separate
sheet in a dynamic range
so users may add to or delete exclusion keywords
rather than have the 'hardcoded' exclusion keywords in the formula
And I'm ho...Values on Axis
I have a line chart with three different values. monthly, quarterly, and
12months. they range from 15.0 to 55.00. the quarterly and the 12 month are
calculating off of the monthly using basic formulas. however, in my chart it
is not charting the quarterly and the 12 month with the correct values. for
instance it is showing 17.5 for quarterly to graphed at like 37. why is is
doing this and how do I fix it. Likewise the annual number is three times the
monthly amount. HELP
Check the chart sub-type, sounds like you may be using Stacked Line.
> I hav...What is controltip text? Looking for a field to store some text
I need a field in the properties to store a descriptive name of a textbox's
If a required field, which has "R" in the Tag field in the properties, has
not been entered a message box appears:
MsgBox "Please enter a value for " & ctl.Name
Where ctl.Name is the name of the text box. l need to be able to say, for
example, "Department Number" instead of "txtDeptno". I could put
"Department Number" after the "R" in the tag and parse up tag but is there
another field? How about ControlTip Text or Validation Text?...How to arrange mailing labels alphabetically by last name?
Word 2007, arrange mailing labels alphabetically by last name?
Use the instructions in
http://www.word.mvps.org/FAQs/MailMerge/ConvertAdrsToDatafile.htm to convert
the labels to a data source, sort it, and then re-merge the labels.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"mazziossharon" <firstname.lastname@example.org> wrote in message
> Word 2007, arrange mailing labels alphabetically by last name?
Before you run ...Horizontal Scrolling
Whilst I was using Excel the other day, the Scrolling facility of my Wheel Mouse changed to Horizontal, and I was unable to scroll up or down, unless i moved the cursor over the scroll bar at the side of the page.
In addition, poreesing the wheel button, which normally brings up the pan facility, only allowed panning left to right.
Can anyone tell me how this is turned on/off?
Kev - were you able to get an answer to this. I am having the same problem
> Whilst I was using Excel the other day, the Scrolling facility of my Wheel Mouse changed to Horizonta...default font when converting handwriting to text
I'm using OneNote 2007. I set my default font for the page. When I convert
handwriting to text it doesn't use my default font. Is it possible to set the
font for text when converting from handwriting?
I sent a newsletter in Office 2003 Publisher, but who receives it can´t copy
and paste the text into word, is there a way?
No, there is no way unless the person you are sending the *.PUB file has the
> No, there is no way unless the person you are sending the *.PUB file has the
> same version.
...Importing text file
I'm attempting import a text file into excel. In the first
Step of the Text Import Wizard, I need to define the File
Origin as "Nafitha" (Arabic Font), but the only options
available are MS-DOS, Windows and Macintosh. Without this,
i can only read numbers but not the arabic text. Where can
i get/download/install that from ?? (i'm using Office 2000)
...How to keep the original format of copied text
When I copy text in MS Word 2003 it arrives at the new location with an extra
(empty) line at the end. When I try to delete this line it causes the just
moved text to revert to the defalult text of the current document.
FOR EXAMPLE: I copy a paragraph that is Arial 10pt into a document that is
Arial 12pt. The copy brings an extra line at the end. When I try to delete
that extra line it causes the just pasted text to change to Arial
12pt......my problem is that I want to keep the original format.
when you paste text in a word document from a different file, at the bottom
of th...Using text as argument
I have the following problem.
I have the following list in cell range A1 to A3
( Note :- The text strings may differ from the above. It is no
possible to include any Hyphen, colan, Semicolan & Underscore etc. I
is also not possible to give numbers. )
Now I want a formula in Range B1 to B3 which gives threee differen
values or performs three different calculations based on the value i
cell A1 to A3.
ie - If cell A1 equals Milling then value in B1 is 1 ( or a formula)
If cell A1 equals Drilling then value in B1 is 2 (or a formula) & I
cell ...Adding Superscript Text to a Distribution List Name
We have a user who would like to add superscript text to a distribution
list name. He is currently calling it (BC)2, but he would like the 2
to be superscript and would like to get rid of the parenthesis. I
didn't think this was possible since you really can't put html in the
title, but he swears he has seen this before. Anyone have any ideas?
It's not possible.=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, ...How to change button text color in a CToolBarCtrl
I have a CToolBarCtrl that contains text only buttons. I want to know
how to change the text color of these buttons? Or even further, to use
the theme color for menu items.
Did you try NM_CUSTOMDRAW as mentioned earlier? That should do it. Its
not straight forward but it will work.
Thank you very much. I think that is what I need.
Ajay Kalra wrote:
> Did you try NM_CUSTOMDRAW as mentioned earlier? That should do it. Its
> not straight forward but it will work.
> Ajay Kalra
> aja...Axis Title Gets Cropped
In Excel 2003 when I add an axis title to the Y-Axis the
last letter gets cropped. It doesn't matter how long the
title is it just cuts off the last character. So then I
have to use a text box instead. Is there any known fix
It seems to be a common bug. One suggestion is to add a few spaces then a
period to the title. In this way the result is acceptable when the file is
opened on a PC that does not have the problem.
Can you email me (private message not to newsgroup) the offending file. I
have never had the problem so I would like to experiment.
"...Adding Text To Text
I have a long list of projects names and I need to add the same tex
addition to the lot. Currently the project names are simply displaye
I need to change each entry to:
Can anyone suggest a means of doing this which doesn't involve goin
through each and typing the  and.xls?
SamuelT's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2750
View this thread: http://www.excelforum.com/showthread.php?threadid=48481
If yo...Calendar Invites Arrive as Plain Text
Exchange Server 2003 SP1 Clustered Active/Passive
Windows Server 2003 SP1 Clustered Avtive/Passive
Exchange Server 2003 SP1 Non-clustered/Standard
Windows Server 2003 SP1 Non-Clustered/Standard
Exchange 5.5 SP 4 Clustered Active/Passive
Windows NT 4.0 SP6a Clustered Active/Passive
Exchange 5.5 SP 4 Non-Clustered/Standard
Windows NT 4.0 SP6a Non-Clustered/Standard
We have identified that any calendar invite request, when sent outside of
the Exchange Server Environment arrives at it's destination as plain text
instead of the standard invite format in Outlook. ...How do I group text to graphic?
In my document I'm trying to embed a graphic into the text. How do I do this
to where when I delete text before the graphic it moves with text instead of
me having to redo embedding?
BeanieBrain <BeanieBrain@discussions.microsoft.com> was very recently
heard to utter:
> In my document I'm trying to embed a graphic into the text. How do I
> do this to where when I delete text before the graphic it moves with
> text instead of me having to redo embedding?
Which version of Publisher are you using?
Ed Bennett - MVP Microsoft Publisher
i'm using both 2000 and...how to mirror text from one text box to another
im trying to mirror one text box to another text box but flipped the other
way so they are not facing the same way horozontally (hopefully that makes
Microsoft MVP - Publisher
How to ask a question
"Amber Van Berkel" <Amber Van Berkel@discussions.microsoft.com> wrote in
> im trying to mirror one text box to another text box but flipped the other
> way so they are not facing the same way horozontally (hopefully that makes
...Converting Text Date to Date/Value
Im having trouble converting a Text date to a DateValue, I have tried Text
to Columns and also the =Datevalue(A1) formula with no avail.
My date is written in a cell as e.g Wednesday 14th October 2009
Obviously as its in this format i cannot perform date calculations on it. Is
there a way i can convert this? I have a whole long column worth which
needs doing so typing over every one is not really an option!
Am Wed, 14 Oct 2009 22:40:10 +0100 schrieb Alex Barrow:
> My date is written in a cell as e.g Wednesday 14th October 2009
> Obviously as...Combine text from a field in multiple records
I have a database that tracks projects. Included in the tracking is a list of
the product(s) effected by the project. In a summary of a project I would
like to include the products effected as a single continuous text string
rather than a list column.
Project: 123 (project control number)
Date: 1/16/08 (start date)
Description: Change Color (Desc)
Products Effected: ABC, MNO, RST, XYZ (from a second table that relates back
to the first by the project control number field)
>I have a database that tracks projects. Included in the tracking is a list of
>the produ...Force Integers on Scale Labels in the Radial Gauge
How can I force the scale labels to display as "1" ratehr than as
I wanted to try to use the Radial Gauge in 2008 Reporting Services to
display elapsed time in seconds.
I set the Scale Properties for the gauge to have a "Maximum" value of
300 (representing 5 minutes) and leave the "Minimum" at zero.
under the "Multiply Scale Labels By" field I entered "=1/60" because I
want the tick labels to appear as minutes.
Problem is the labels appear carrying the decimal values.
This is a fun looking gauge and I...Text Cut-off
The text of my document is getting cut-off, especially the letters g and p.
I am using CG Times, font size 12 with a row height of 14.5 in Excel on MS
Any tips on how to get it to stop??
Click on the row, the double click on the bottom edge of the row nuber (=
the left hand side)
This will ensure that the screen row is adjusted to fit the characters.
Of course, now I ask is this on screen or on printout ?
If it is on the printer - suspect that the priver driver may need to be =
On Fri, 01 Sep 2006 16:25:02 +0100, kath0178 =
<kath0178@disc...Text to Columns?
In my spreadsheet, from cells F1 to CA1, I have a list of
titles. At the beginning of each of these titles is the
words Out of Stock/. I would like to know if there is an
easier way to get rid of these words other than text to
columns. Right now, I insert a column next to one with
text and use Text to Columns and choose "/" as my
separator, and then I have to go back and delete all of
the unwanted cells. I didn't mind doing this once, but
now that I have to do it weekly, I need to find a faster
This is what it looks like now.
F1 ...cannot Paste text to a text box
It seems that the standard Paste function doesn't work under any
circumstances when trying to copy to a text box in a chart... Has anybody
noticed this? Is there a fix? XL2002/Win2K.
have you tried using the keyboard shortcut "ctrl + v
MajorGeneralDes's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=370
View this thread: http://www.excelforum.com/showthread.php?threadid=31514
These are fighting words, General! :-)
Of course; have you?
z.entrop...TEXT = text
I have some data in an Excel table which uses case sensitive codes. Does
anyone know of a way to perform case sensitive VLookups.
A1 contains "TEXT", A2 contains "One".
B1 contains "text", B2 contains "Two"
If I enter "text" in cell A4 and the following VLookup in B4:
I get the answer "One", but I would like to see "Two".
I have found a work around by converting a number of characters to their
ASCII codes, but this is very messy.
I know that the FIND function is case sensitive whe...