Show whole Table of Contents for Excel Help
It would be nice if users could easily find the whole table of contents for
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.
Does anyone know of a good site for explaining basic Exchange admin
issues. Kinda new to Exchange and would like to nail down some basics. One
issue at hand right now is to some how retrieve mail that a user has
deleted. If I remember correctly there is a timeout period from when the
user deletes a message and when the server actually deletes it. Any help
would be much appreciated!
If Deleted Item Retention is enabled on the Exchange
Information Store and the user is NOT storing their email
in a PST then you'll be able to use the "Recover Deleted
Items"...removing gridlines in Excel spreadsheet
how do I remove gridlines in one particular column so that they do not appear
in my print out--this column will include a heading that will be placed
vertically in that column.
You might like to check out Format | Cells | Alignment (tab) and then
Orientation 90 degrees for that cell.
The gridlines are either on or off - you can turn them off the printout
by File | Page Setup | Sheet (tab) and uncheck Gridlines about half-way
down the panel. You can also turn them off the display by Tools |
Options | View (tab) and uncheck Gridlines near the bottom of the
You now have much more flex...How do I create a drop down list in Excel 2003
How do I create a drop down list in Excel 2003. I've tried to use the help
menu and I cannot figure it out.
"Lenny" <Lenny@discussions.microsoft.com> wrote in message
> How do I create a drop down list in Excel 2003. I've tried to use the help
> menu and I cannot figure it out.
...Need to delete pending MS updates
A friend asked me to help him with his computer.
So I went and started applying the updates to his XP machine.
Well it turns out that he has a VERY small drive and even less memory :-(
I have downloaded some MS updates but there is not enough room to run them
let alone let them just remain on the drive
Where are the pending updates located so I can go and delete them?
Start > Run > type in, press Enter or click OK after each command
net stop wuauserv
net stop bits
Show hidden files, folders, and system files:
http://www.bleepingcomputer.com/tutorials/tutorial62.ht...Excel query is returning only part of the data from a column
Even while previewing while still in the query, data is previewing as 5
numerals with a decimal point, e.g., 5555.0, when numbers are in format of 4
numerals, or 4 numerals and a letterin the original spreadsheet. Those with
letters are not showing at all.
Have tried formatting the original column as text, or general, but this has
amanda <firstname.lastname@example.org> wrote ...
> Even while previewing while still in the query, data is previewing as 5
> numerals with a decimal point, e.g., 5555.0, when numbers are in format of 4
> numerals, or 4 numeral...Deleting CRM User!
I am looking to find ouit how one can delete a CRM USer
and have the license go back into the pool of unused
licenses. I can only find a way to disable the account.
The users that I wanted to delete are in the disable user
account view right now but I need to delete them and I
need the licenses.
I do not believe that you can delete using the supplied interfaces. You
simply remove the license as stated below. If you were to remove or delete
a user, there could be many orphaned entities.
"Joseph Michaud" <email@example.com> wrote in message
news:#Qfbbc7UDHA.964@TK2MS...how to format and print labels from an excel file
I have an excel list of people with 12 cells of information. I want to
format and print "name tags" (labels?) using only the information in four
cells. How can I do this?
You can print labels in Excel but formatting can be a problem.
Best to use Word for the mailmerge operation and select the 4 labels to print
during the setup in Word.
For help on Word mail merge using Excel as the data source.
And a t...Question: How to delete the email history which created by workflo
The whole process is:
When a case has been created for 1 hour but not be closed, then the workflow
will send an CRM email to the case's owner for notify.
After sent an email, there will be a email history in the history, But we
don't want to save the email which created by workflow.
How can we do that?
...Game in Excel
Way back in office 97, there used to be a way to find a flight simulator in
excel by going into a certain cell and typing in a commmand. Does anybody
know if there is one for excel 2000?
"Jasper Recto" wrote in
> Way back in office 97, there used to be a way to find a flight simulator
> excel by going into a certain cell and typing in a commmand. Does anybody
> know if there is one for excel 2000?
"easter egg" microsoft excel
at google, this is the first hit...
"Jordon" <...SOS! how do I write a customized function to do multiple-value lookup in Excel 2007?
I have two regions in exact same places of sheet 1 and sheet 2,
I want to find all cells in the region in sheet 1, with cell
content equal to 0,
and then add the numbers at the corresponding locations in the region
in sheet 2 up.
For example, let's say in the region in sheet 1,
there are multiple locations where the cell content = 0:
I would like to obtain sum(sheet2!A1, sheet2!B3, sheet2!C4, sheet2!
How do I do that?
I want to write a user customized function for that: The regions in
sheet1 and sheet2 are fixed to be D7 to Z20.
So the ...controliing a web page from MFC
I am looking to load a web page into our MFC application and want some way
of accessing the controls on the page
For example, if the loaded web page page has a text box with a specific ID
is there any way to 'get and set' the text on that control from MFC
I've looked at the Web browser activeX, this loads the page but I cannot
find a way of getting at the controls
Any help will be much appreciated
"phil" <firstname.lastname@example.org> wrote in message
>I am looking to load a web page into our MFC applica...Delete a Closed Invoice
is ther anyway i can delete a "Closed" invoice? one of the user accidentlly
close the invoice by selecting "paid in full". Now , the invoice are mark as
read only and we can delete it.
It is possible to go into the DB and delete it manually from the InvoiceBase
and InvoiceDetailBase tables, but I wouldn't recommend it.
You can also manually change the StatusCode and StateCode fields in the
InvoiceBase table. Look at other values used in the InvoiceBase table as
examples of valid states. Once it's not closed, you can edit/delete it
again through th...Outlook Express 2007 hyperlinks do not work (page does not open)
Receive a notification that the administrator requires action. What action
is needed to allow hyperlinks in e-mails to work?
"Russ Wimberly" <Russ Wimberly@discussions.microsoft.com> wrote in message
> Receive a notification that the administrator requires action.
No you didn't. That's not what the error says. Never paraphrase an error.
Always post the exact text of the message.
> What action is needed to allow hyperlinks in e-mails to work?
The crystal ball says this:
http://www.s...Emailing XML direct from Excel
Please help! I have a problem with Excel 2003 and Excel 2002 where if I open
an XML Spreadsheet file in Excel and then select File - Send To - Mail
Recipient as Attachment, Excel converts the XML to XLS before attaching it.
Is there someway I can make Excel leave the document alone so that XML gets
sent on? I need to open XML, allow changes to cells, save changes and send
as XML to be further parsed etc.
This works fine if the XML is opened in Internet Explorer (Excel 2003 only)
but not in Excel itself.
Could someone please test and tell me if this is happening for them too or
whet...Printing Excel sheet
I cannot print any borders on my sheets. I used to be able to. I
checked old sheets that printed OK before and cannot print now. What
has happened? Running Mac OS X 2.3. Do not know the version of Excel as
I am not at that machine now. By borders I mean all underlines in a
report. The rest of the report is fine.
> I cannot print any borders on my sheets. I used to be able to. I
> checked old sheets that printed OK before and cannot print now. What
> has happened? Running Mac OS X 2.3. Do not know the version of Excel
> as I am not at that machine now. ...My delete file is autmatically being deleted every 7 days. Why?
This just started and I dont know why. Thanks
Neither do we.
We have no idea what you are asking.
Try again. Do not hesitate to use accurate details.
"Denny" <Denny@discussions.microsoft.com> wrote in message
> This just started and I dont know why. Thanks
Your deleted folder is being emptied every 7 days? Are you using autoarchive
to do it?
Are you using exchange server? If so the admin could have configured it on
Diane Poremsky [MVP - Outlook]
Outlook ...Delet page in publisher wont delete
I cannot delete the pages I want in my publication. When i press edit, delete
page it will not delete the pages. I have no problem deleting any of the
other pages though.
Turn off the two page spread and try again.
Mary Sauer MSFT MVP
"pippy6" <email@example.com> wrote in message
>I cannot delete the pages I want in my publication. When i press edit, delete
> page it will not delete the pages. I have no problem...Making items inactive as opposed to deleting them
I have read that it's bad to delete items, and I think I found that true
because I went back recently to look at a prior sale and it wouldn't pull up
any info on it cause I had deleted the item in question.
So, I went in and made a few items inactive to try it, and now I can't find
them. Sorry for being an idiot, but how do I access the inactive items in
Couple things you can do is run an item quantity report and filter for
inactive = yes....you can also run an inventorry wizard task "set items
active" it will show you the items that are flagged...Pubs Keep large file size after pages are deleted
I am using Pub 2003. I have a quick reference guide that has 123 pages with
graphics the size of the document is 72,503 MB. I deleted everything except
17 pages but the document size is STILL 71,881 MB.
In previous discussion groups I found the two links listed below. I looked
under Objects > Design Gallery Object but I have only 3 tabs, Objects by
Category, Objects by Design, and My Objects. I looked at any "options"
buttons but could not find a tab called "Extra Content".
"PUB2000: Publication Retains Large File Size When Pages Are Deleted
http://support...Money 2001 Deletion #2
I CAN'T DELETE/REMOVE MONEY!!!! I lost the disk and was
having problems with the program so bought 2004. 2004
say's it sees the old version and I must have the 2001
disk in order for it to finish install. I stopped install
and tried to remove through Windows, only to have it tell
me that I need the disk. I called Customer Service, and
they were completely incompetant and unable to help me do
anything but realize microsoft has terrible support
options. I just want to get this worthless program off my
I'm just going to keep calling microsoft every...Delete transactions w/out deleting POs
Is there a way to delete training transactions without deleting Purchase
Orders. I found out the hard way that using Delete Transactions in SO
Administrtor also deletes POs.
Thanks in advance - Bob
...Cannot acccess SEND THIS PAGE AS MESSAGE menu option
Want to send a publisher page as an email message and cannot access the
option under the file menu. I see the toolbar option but it won't allow me to
select it either. What is prohibiting this feature from being active?
Which email program are you using?
MVP Microsoft [Publisher]
"Lisa" <Lisa@discussions.microsoft.com> wrote in message
> Want to send a publisher page as an email message and cannot access the
> option under the file menu. I see the toolbar option but it won't all...FRx
Please help. I am trying to export an FRX report to a formatted excel
file. I am using FRX 6.7 service pack 10. The formats on the FRD file
looks alright (i.e. row headers are navy blue) but when I export it to
formatted excel, the colors are lost (although the font remains the
same). Column header formats are ok. Any ideas?
Check your Excel Security Settings. I think the issue is with excel settings.
> Dear All,
> Please help. I am trying to export an FRX report to a formatted excel
&...how to delete a row in excel with a specific word using visual basic
I have an excel file that always come with a line at the end with
"downloaded:" in the cell. How can I write a macro to search for that
cell and delete the row that cell is in?
Thanks for all your help!
Any time you are in doubt on how to interact with excel, try recording a new macro and then physically do the steps you are trying to code. Stop the recording and then go look at the recorded macro
Hi "mchen" firstname.lastname@example.org,
Delete rows with "N" in Column 31 (col AE)
from my http://www.mvps.org/dmcritchie/excel/delem...