Where is the Keep Text Formatting feature located in Word 07
I believe this Keep Text Formatting feature might be what I need, but I have
been unable to locate exactly where it is located in Word 2007. I'm trying to
rid a Word document sent to me of tables, text boxes, graphics and all other
document formatting, while retaining the document's text content. It is
unimportant to me whether the text formatting is retained or not. Thanks.
Are you referring to a Keep Text Formatting feature in an earlier
version of Word?
I wonder whether what you're looking for is "Paste Unformatted," since
you seem to be saying you _don...Adding new rows
I have a spreadsheet with 100 rows in, I need to add a row after each
current row, is there a quick way to do this or have i got to insert
each new row individually?
Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24783
View this thread: http://www.excelforum.com/showthread.php?threadid=390760
I assume you want to add an empty new row in between the existing rows.
One way would be with an extra column
Save as "trial" first.......just in case thi...Publisher has turned yellow. How do I make it white again??
When I open Publisher, it seems to have aquired its own colour scheme - the
blank page is yellow. How do I make it white again? I have searched all the
menus but cannot find anything that helps. It's driving me mad!! It only
happened in the last few weeks, and I've no idea what I did to change it. I'm
usung Publisher 2000.
A small child turns to Ed, and exclaims: "Look! Look! A post from
> When I open Publisher, it seems to have aquired its own colour
> scheme - the blank page is yellow. How do I ma...First row in Selection range (first index of a cell)
I have a problem with selecting first cel in selection Range or return
an index of the first cell in Selection Cell.
I have something like this:
"and here I want to Select the first range in selection Range1"
I there any special function of finding first cell in selection range
or returning an index of the first cell??
Thanks for answet
> I have a problem with selecting first cel in selection...OWA returns HTTP/1.1 503 Service Unavailable
Outlook Web Access used to work fine, but now users are receiving the
HTTP/1.1 503 Service Unavailable
Users can access the OWA page, but after typing in credentials and clicking
"Log On" the above error is returned. If the incorrect credentials are
entered the "You could not be logged on to Outlook Web Access" message is
received. This tells me I'm authenticating fine but whatever the next step
is it is failing.
There are no error messages in event viewer. Any recommendations of what to
look at next?
The OWA Exchange 2003 Server sits on a ...CRM HTTP Error 401.1 IIS
I installed CRM on the Windows Server 2003 on three box for 100 users. All
users registred in the CRM Server and working on the clients.
A: 1 for Active Directory Domain controler (ADSRV)
B: 1 for SQL 2000 + CRM Server ver 1.2 (CRMSRV)
C: 1 for Exchange Server 2003 (EXSRV)
i have one problem that when i type http://crmwebsite on the CRMSRV then i get
"HTTP Error 401.1, Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)".
When i try it on the ADSRV then it works well. It is also working well on
the client c...Tree view of wiki pages: is it possible???
I'm building a wiki site and I'd like to have on the left side menu
(the quick launch menu) somehting like a tree view that let me easy
navigate the wiki pages...
maybe a wiki library is not what I need, because none will add or
remove contents... basically I'm using a site as an "instruction
and the tree view should make easy to navigate the differents web
On Mar 19, 5:59=A0pm, Vit <fina...@gmail.com> wrote:
> Hi all,
> I'm building a wiki site and I'd like to have...Same image/every page
I'm wondering if it is possible to have a png image appear
automatically on every page. It needs to sit behind the text, and to
further complicate things, needs to shift with the gutter depending on
whether it is on a left or right page. This is of course a breeze with
a page layout app but the client insists the project be completed in
Alternatively, is there something like a Paste in Place command in
> I'm wondering if it is possible to have a png image appear
> automatically on every page. It needs to sit behind the text, and ...partially turning off auto calculate?
Any way to NOT auto caluculate 1 particular formula, while leaving the
rest of excel to auto calculate? In particular, I have an SQL query I
would prefer to run manually, while not interferring with the rest of
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Calculation is an all or nothing setting. You can't prevent calculation of
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ...CRM 1.2
I am going to move the CRM SQL databases to a new server. We will also
be moving Great Plains off the CRM server and on to the new SQL server.
We are bouncing around the idea of naming the new SQL server to the
name that the current CRM server uses and renaming the current CRM
server. The thinking here is that we won't have to touch the Great
What kinds of issues can I expect in this scenario? I believe that CRM
"might" make us of the SID in which case I would need to use SysPrep to
create the new one?
I wouldn't think that this is that unusal of a proje...Page Breaks Problem ( Emergency , Gurus.. PleaseHelp)
Can any body help me immediately.
Please understand the snario.
I am setting the page breaks on my excel sheet. that i had generated b
executing code from Visual Basic. When i first time generate the exce
sheet the code used to set the page breaks executes right. but when
second time execute the code. the code to set the page breaks, Fails.
Below is given the code that i am using to set the page breaks.
Plese help ..
wrkSheet.HPageBreaks.Add Before:=Cells(Row, 1)
wrkSheet.VPageBreaks.Add Before:=Cells(1, CmbMaxColumns+1)
Follwing is the error that s show when i execute the code s...Want to make complex header on 2nd and 3rd page
I need to make a quotation which consists of a first page, thats fully
on its own and then two pages which has a same header.
The header, though, consists of quite a lot of text and also a company
logo and that was byond the header functionality.
How to get the 2nd and 3rd pages with a complex upper part?
...Prinding each row of Excel sheet on a seperate page dispallying one record on each pa
From a spread sheet ,I need to print out a row on each page seperately
that is printout each record on the row on one page seperately.
Can any one please advise how it can be done ?
Row 1 Data 11 Data 12 Data 13
Row 2 Data 21 Data 22 Data 23
Row 3 Data 31 Data 32 Data 33
I would want to print out Data 11 and Data 22 on one page
then Data 21 and Data 22 on the second page and data 31 and Data 33
on the third page
Pleae advise if and hwo this is possible.
Message posted from http://www.ExcelForum.com/
Sorry ...Delete 3 end row
I want to delete three end row of any sheet. any sheet has different row
Thank's for any help.
This will clear the last 3 rows of the active sheet. Note I the on error
line is to cope when there are less than 3 rows on the sheet
Dim LastRow As Long
On Error Resume Next
LastRow = ActiveSheet.Cells.Find(What:="*", _
ActiveSheet.Rows(LastRow - 2 & ":" & LastRow).ClearContents
Whe...Invalid page fault #4
When I start up Outlook a message displays this program
has performed an Illegal Operation. Further explanation
describes " Outlook caused an invalid page fault in
Just started doing this. When I try to reinstall Outlook,
I get a message Unable to run setup.
Are you sure that the name of the file is correct ? Is it clthood.dll ???
Please verify ..
Hope this helps !!!
"Mark" <firstname.lastname@example.org> wrote in message
> ...keeping footer from resizing when using the fit to page function
How do I keep the footer from shrinking in excel when i
use the "fit to page" option for my worksheets. I'd like
it to stay the same size no matter what the font of the
...Sub Report Repeating
With On My Main Report I have a Sup Report,
The Main Reports Shows The Project Number. Project Title and Enquiry:
Enquiry Could Be Anything From "Supply Only Ductwork"
The Sub-Report Shows All The Drawings That Are Needed For That
Enquiry, The Sub-Report Is Set to a Contineuos Type,
The Problem Arise's If Ive Seletced The Say 2 or more Companys For
What Is Happening The Sub Report Is Duplicating The Drawing List For
How Many Companys Ive Set The Enquiry To.
Is The Away I Can Just Print the One Set of Drawings for that Enquiry
Records, and Not Repeat the Whole S...lookup row number
can you tell me how to lookup the row number of a name in a list.
EG say I have a list of names as below:
I would normally just add a column with the row numbers and then lookup the
row number in the second column but is it possible to do without adding the
extra column by using the row formula someohow?
Try the below..
Jacob (MVP - Excel)
> can you tell me how to lookup the row number of a name in a list.
> EG say I hav...how can I show repeating values in a chart?
I would like to show modes in the form of a pie chart but am not sure how.
For example the number 73 comes up 3 times in a column on my spreadsheet, how
can I show that compared to the number 50 which come up 2 times in the sheet?
Thanks for the help
You will need to compute those values using formula or a pivot table and
then chart the results.
> I would like to show modes in the form of a pie chart but am not sure how.
> For example the number 73 comes up 3 times in a column on my spreadsheet, how
> can I show that compared to the number 50 whi...print preview does not match page i am working on
In this white space (not the subject line), let us about the problem in more
If print preview is showing only part of the worksheet, then you need to
reset the print area in the File | Print Area dialogs
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"gillygalloo" <email@example.com> wrote in message
...Thai collation in SQL for MS CRM 1.2
A number of our Partners have been requesting for double-byte characters such
as Chinese, Japanese and Thai languages to be recognized by MS CRM 1.2. Most
of their clients have this included in their business requirement.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane....2 different domains/1 exchange server
Hi. I'm currently running E2k03 SP1 as my mail server in our network.
Recently another company move in our building (same owner) and both company
are sharing network infrastructure. Each company has a different AD domains
and this domains are not related in any ways (trust relationship). Is there
any way that I can provide mail services to the new neighbors without
trusting the domains or using pop3?
Pellerano & Herrera
...Display Screen 1/2 Grid; 1/2 VBE (or at least Code Window)
Is there a way (button, command, etc) to be able to view (quickly, and side
a my worksheet (only 1 workbook is open say) and my code window?
If you just want to look at macros do a cltr+' (key to left of 1).
"Jim May" <firstname.lastname@example.org> wrote in message
> Is there a way (button, command, etc) to be able to view (quickly, and
> by side)
> a my worksheet (only 1 workbook is open say) and my code window?
With Excel workbook open to the sheet of your choice and VBE o...Outlook Web Access
I cannot open e-mails forwarded to me from several AOL
users. OWA shows "The page cannot be displayed" message. I
can open all other e-mails. Looking at the details of the
message I find these content types: multipart/mixed,
text/plain, message/rfc822, multipart/alternative,
text/html, application/msword. text/html is the only one
represented in the registry and is in Level2MIMETypes
registry entry. Any help on what may be blocking these e-
mails is greatly appreciated.
...how to retrieve data from password protected web pages?
how can I retrieve data from password protected web pages in excel?