Is there any way to have the text overprint more than one line?
For example, Excel typed in cell c5 with an 18pt type will
cut off the top half of all letters unless the row
height is increased.
Is it possible to have the text expand into C4
as opposed to increasing the height of the row?
It can extend into d5 if nothing else is there
"Paul Dulong" <firstname.lastname@example.org> wrote in message
news:imVLd.2555$Sx6.2...how to I block text not to break across columns or pages ?
I want to keep certain text together and not have it split apart over columns
or on a new page: like several lines comprising an address in an address
book -- I want to keep it all together.
Either apply a style with the Keep With Next paragraph format option to all
but the last of the paragraphs you wish to keep together
Use Shift+Enter to make a line break within the same paragraph
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MV...How to write text to command prompt console windows?
I am using VC++ 6.0 to build a windows based application, however, my
application allows user to input command arguments in the dos prompt
windows. I want to have a warning message for user if they have input the
wrong arguments. How can I write text to the dos prompt windows if user
input the wrong arguments?
Thanks in advance.
> I am using VC++ 6.0 to build a windows based application, however, my
> application allows user to input command arguments in the dos prompt
> windows. I want to have a warning message for user if they have input the
> wrong ar...Paste into "Advanced Find" "search for the words:" field????
Am I doing something wrong, or did microsoft really disable the ability
to paste into the "search for the words:" field? You can paste into the
email address fields, but that is it. I'm trying to search emails for a
specific numeric string, and I don't want to have to type a 30
character number from an email when I could easily copy and paste it.
Am I doing something wrong or are they really that stupid??? Thanks!
Does CTRL V work for you
"Mick" <MickBurkellc@gmail.com> wrote in message
>...How can I put text in a circle using Publisher ?
Have looked everywhere for an answer to this ? : How can I put text in a
circle while using Publisher ?
If I want to surround a shape or piece of clipart with words, I often need
to have text in a circular or oval shape ........ surely this can be done
Thanks for any expertise.
> Have looked everywhere for an answer to this ? : How
> can I put text in a circle while using Publisher ?
> If I want to surround a shape or piece of clipart with
> words, I often need to have text in a circular or oval
> shape ........ surely this can be ...conditional text merge
I want to merge text under the following criteria,
First issue (data in Col A in sequence)
Col A(text) Col B(text)
a gg hh s
d ss ee
Second issue (data in Col A not in sequence)
a gg hh s
d ss ee
Is it possible to merge it?
Message posted from http://www.ExcelForum.com
yes it is possible but will require some VBA. below one
1. Create a unique list for column A on a separate sheet:
- selec...Grey text prints as black..
I'm printing a page that has some text de-emphasized by using a grey font
colour. Unfortunately when I print it comes out as black like the rest of
I looked for a setting in the Options and in the Print dialogs, but was
unable to see anything that said "allow grayscale" anywhere.
I have the same problem and have not yet found a solution. could it be a
configuration problem with the printer? Have you recently re-installed Excell?
"RGK" a écrit :
> I'm printing a page that has some text de-empha...Deleting Text
I know that with "&" I can add two text cells together.
How do I get rid of text?
In the example "Roddick, Andy (USA) " in A2, I want to get rid of "(USA)
". I can separate with "=right(A1,7)", the last seven characters, but how to
"subtract" them from within A2"
In an un-used cell, enter:
=LEFT(A2,LEN(A2)-7) then copy this cell and
paste/special/value back onto A2
Gary''s Student - gsnu200827
> I know that with "&" I can add two text cells together.
> How...How can I cross reference a SmartArt Graphic to a page/text?
Operating System: Mac OS X 10.6 (Snow Leopard)
I am trying to allow users to click on the SmartArt Graphic on my first page and automatically go to the respective page within the document. I click next to the wording on the graphic and go to Insert, but it will not allow me to insert the cross reference. You can do it the other way around - from the text to the graphic, but not from the graphic to the text. Anyone know a way around this or another way to do it?
Objects cannot be used as active hyperlinks in a Word document. You can do
what you describ...how to find a second comma in a text
I have a text as --> Madison, Dane, Wisconsin
How can I find the position of the second comma?
Assuming there is *always* a 2nd comma...
Microsoft Excel MVP
"Boon" <email@example.com> wrote in message
> I have a text as --> Madison, Dane, Wisconsin
> How can I find the position of the second comma?
thanks. this works well fo...[ANN] New XML Text Editor in Visual Studio
Announcing: New XML Text Editor in Visual Studio 2005 Beta 1
Visual Studio 2005 Beta 1 contains a completely new XML Text Editor, built
on top of the core text editor provided by Visual Studio. It is entirely
written in C# and leverages all the cool stuff provided by the System.Xml
..NET assembly. The XML editor provides support for editing XML and DTD
content, including special support for XSD and XSL and includes the
following handy features:
a.. Full syntax coloring for all XML and DTD syntax.
b.. Well formedness checking while you type, with red squiggles and error
c.. Intel...how to find numbers that give another number
I need to make a macro which look up a column of an excel paper and
find the numbers that once summed give the number in cell b5 for
example!!they could be 2 or 3 ..or 4..and so on!!
You would need the solver
"Rossella" <firstname.lastname@example.org> wrote in message
> hi all.
> I need to make a macro which look up a column of an excel paper and
> find the numbers that once summed give the number in ce...How to copy rows from Excel without losing the row height format
In Excel 2003. I have a section of a spreadsheet that contains a 25 rows
that each have different row height. I want to copy these to a section
below, but lose the row height formatting. How do I copy without losing the
row height format?
Are you copying the entire row? Also, don't forget the format painter and
the right-click paste special options.
"artex boy" <artex email@example.com> wrote in message
> In Excel 2003. I have a section of a sp...Need to format text in header, but value is generated using VBA
This is a multi-part message in MIME format.
I wanted to reference a cell value in my spreadsheet header and found =
out how to do that using this function:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim WS As Worksheet
For Each WS In Worksheets
ActiveSheet.PageSetup.RightHeader =3D _
Format(Worksheets("Time Period Info").Range("B3").Value)
However, this leaves my text for ...Find and replace text thats not wdAlignParagraphCenter alignment
Im trying to make a macro that set alignment on all text to
wdAlignParagraphJustify, except text that is wdAlignParagraphCenter.
Right now i have this:
.ParagraphFormat.Alignment = wdAlignParagraphRight
.ParagraphFormat.Alignment = wdAlignParagraphJustify
.ParagraphFormat.Alignment = wdAlignParagraphLeft
...Changing position of OK and Cancel buttons on CPropertySheet
I found out how to eliminate the Apply button on the property sheet. I want
to make the OK button be in the lower right corner and the Cancel button
just to the left of it. By default the Cancel button is in the lower right
corner and the OK button is just to the left of it.
How do I make it the way I want it?
On Tue, 27 Jul 2004 11:07:08 -0400, "Ken->" <firstname.lastname@example.org> wrote:
>I found out how to eliminate the Apply button on the property sheet. I want
>to make the OK button be in the lower right corner ...Need text in upper left corner of a cell
Is it possible to have some text written in upper corner
of a cell?
I use Excel as a fill-in userform.
I can justify the size of other columns, but it would be
nice to write something into the cell, so the user
understand what to fill inn.
Any workarounds or other suggestions?
Any help is appreciated.
maybe you can use the comment functionality (goto 'Insert - Comment')
to add some hints for the user
> Is it possible to have some text written in upper corner
> of a cell?
> I use Excel a...Exporting As Text with X Number of Spaces Between Data
Is there a way to export data in a MS Excel spreadsheet
as text and define the amount of spaces between the data
being exported? The number of spaces need to vary.
This concept is the opposite of importing text as "Fixed
Width" and creating column break lines. Instead, I'd
like to export columns into a text file and specify the
amount of spaces between the text that is being exported
from each column. The amount spaces in the text file
needs to be different between each set of column data.
Say you have 5 columns, and you want 2 spaces between A &..."Disappearing" lines of text in Word docs
I've noticed a really unusual intermittent bug in my version of MS Word.
Suppose there are two consecutive lines of text in my document, Line A and
Line B. I want to insert a new line between Lines A & B, so I position the
cursor in between them and hit return (not highlighting Line B beforehand,
because I'm not trying to get rid of it).
When I do so, Line B seems to disappear, with the cursor (and empty line in
front of it) taking the place of Line B.
However, when I hit "page up" or "page down", Line B reappears.
Anyone know why this might ...Find all the files in a folder
I had been using the FileSearch function to locate all the files of a
particular type in a folder. Office2007 appears to have replaced that
function with a FileSystemObject class, but i can't get that to work. Here
is what I had been using. Any help would be appreciated.
Set fs = Application.FileSearch
.LookIn = Range("C7").Value
.SearchSubFolders = True
.FileName = "*.csv"
If .Execute() > 0 Then
Row = 1
For i = 1 To .FoundFiles.Count
This works in 2007 although it is not clear from your co...Macro to find a row and delete it and the 9 rows above it. #2
Thanks alot that did the trick.
This forum and you guys are life saver
Rusty_nl's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=671
View this thread: http://www.excelforum.com/showthread.php?threadid=31376
...Finding X- & Y-intercepts of lines crossing curves
I created some charts with multiple data series by specifying certain points on the curves. THe series are displayed as lines. Now I want to draw (or specify the Y coordinates of) a horizontal line on the chart, & have Excel tell me the X intercepts where the horizontal line crosses each curve.
Ditto for drawing a vertical line & reading Y intercepts
Maybe you adapt my example of intersections.
> I created some charts with multiple data series by specifying certain points on...Why is "image and text" option grayed out for some buttons in the customization?
It so happens that the most frequently used buttons on the tool bar
are the up-arrow and down-arrow (the ones that move to the
As I tried to assign short-cut key to them, however, i found that the
"image and text" option is grayed out - for that matter, all other
display options are grayed out - when you go into customization mode.
Why is "image and text" option unavailable for some buttons?
...SFO offline without data ?
How can i go offline without synchronising any data (for security
Unfortunately, in the current release you can't. However, I must ask...without
data, why go offline?
MVP - Microsoft CRM
On 16 Feb 2005 09:25:06 -0800, "Bob" <email@example.com> wrote:
How can i go offline without synchronising any data (for security
...How to restart exchange 2000 without rebooting the server
after making changes, the Exchange server needs to be restarted according to
some suggestions I've seen in this newsgroup.
How can I do it without rebooting the server?
What kind of changes? Is it an OS level change? then you have to restart
the server. Otherwise try restarting the SA service.
"RobGMiller" <RobGMiller@discussions.microsoft.com> wrote in message
> after making changes, the Exchange server needs to be restarted acc...