Awesome list of Excel/Word/Powerpoint shortcuts!
I recently discovered a great keyboard shortcut list for the office
applications. It seems to have practically every shortcut imaginable and it
fits on one page too! I printed it out and put on the wall next to my
monitor -- just great!. Thought you would appreciate it...
Here's the link to the PDF file. Hit print and you're ready to go.
For Excel, I like Chip Pearson's Excel Keyboard Shortcuts page at:
There is also a d...XML parsing error: Invalid unicode character value for this platform
I've seen a couple other posts on this but no real answers. I'm
trying to do a bulk insert and everything is fine until I run the
objCom.ExecuteNonQuery() statement at which point I get the XML
parsing error. Of course, it would be easy to simply wrap unicode
characters with CDATA <![CDATA[
]]> but is this doable when
passing values to fields to create a row since a whole row is treated
as a single element? I.e.:
<FileProperty File_ID_FK=\"80\" Property_Name_VC=\"Categories\"
Property_Value=\"\" Property_DataType_VC=\"ol...Category color changes when changing values.
When I copy a chart I get two identical ones. When I change the values of one
of the charts and sort the values, Excel changes the colors of the categories
to a preset order, so that the color of the biggest customer in chart 1 is
not the same as this same customer (let's say now on the third place) in
Is there a way to prevent this?
...How do I delete a text box from an Excel spreadsheet?
Rightclick on it and select cut
If the textbox is from the control toolbox toolbar, you may have to click on the
designmode icon first.
Uncle Binky wrote:
...Using insert to paste a row--how done in Excel 2007
In my old version of Excel, I could copy a row or chunk of rows, move to a
new spot and use the "insert row" icon to insert the rows and paste it
automatically. Now in Office 2007 it just inserts a row instead of what I
have copied. I want it the old way! How do I do it?
R-click, Insert Copied Cells.
> In my old version of Excel, I could copy a row or chunk of rows, move to a
> new spot and use the "insert row" icon to insert the rows and paste it
> automatically. Now in Office 2007 it just inserts a r...How make range of Hyperlinks?
I see how to make a single cell into a Hyperlink but what if we want to have
all email and web addresses in a spreadsheet turn into hyperlinks? Is there
an easy way to turn this on and off?
for making hyperlinks in your selected range have a look at the
Dim cell As Range
For Each cell In Intersect(Selection, _
.Hyperlinks.Add Anchor:=cell, _
End Wit...How do I alpha my mailing list in Microsoft excel and delete names
To alphabetize -- use sort
Sorting, Some notes on sorting in Excel
To delete rows
pick a range of rows by selecting one or more contiguous
row number(s) then Edit, Delete rows
You might also be interested in Filtering to expose only names in Ohio
You can use Filtering to permanently delete rows or just hide them.
you can read more about filtering at
If you want to print labels for your mailing list, you do the printing in MS Word
with Excel acting as your data bas...hide Admin from address list
Exchange server 2003 (SBS2003) how do I hide / remove the administrators
mail box address from all lists to stop people sending emails to it when
they select all domain users?
> Exchange server 2003 (SBS2003) how do I hide / remove the
> administrators mail box address from all lists to stop people sending
> emails to it when they select all domain users?
Well, you can control who can send email to that mailbox in the delivery
restrictions section (ADUC properties of the admin acct, exchange general
tab). Would that not suffice?...Product list in CRM v.1.2
i have another question concerning the product list, can i attach an excle
sheet that contains my products instead of loging each product one by one as
i have over 25,000 products to log?
I'm afraid not. This is a major pain point for a lot of people and I do not
kno of any 3rd party add-ons that have addressed it either.
MVP - Microsoft CRM
"marwa" <firstname.lastname@example.org> wrote in message
i have another question concerning the product list, can ...How can I Enable a Check Box based on another fields value?
I have a form with a disabled check box. I need to enable it when a certain
value ("approved") is selected from a combo box.
When I am in Form Design View and I have the Check Box selected the
Conditional Formatting menu item on the Format menu is greyed out.
I am using Access 2003.
Can you tell me what I need to do to make this work?
As you've discovered, Conditional Formatting isn't availabe to checkboxes.
Private Sub Form_Current()
If Me.YourComboBox = "Approved" Then
YourCheckBox.Enabled = True
YourChe...Newbie: can't get a calculated value on the form?
I have a table with numbers and a form that shows the numbers. I have
a query that takes one of the numbers and mulitplies it. I put a text
box on the form from the query result field, but I get a "#Name" error
instead of the result. When I run the query, I get the correct
"Ed from AZ" <email@example.com> wrote in message
>I have a table with numbers and a form that shows the numbers. I have
> a query that takes one of the numbers and mulitplies it. I p...How can I add numbers but ignore the minus signs?
How can I add numbers but ignore the minus signs? In the following, the
answer I'm after is 17
Gord Dibben MS Excel MVP
On Thu, 07 Jun 2007 04:19:52 GMT, Invalid <firstname.lastname@example.orgINVALID> wrote:
>How can I add numbers but ignore the minus signs? In the following, the
>answer I'm after is 17
Gord Dibben <gorddibbATshawDOTca> wrote in
Thank you Gord.
> Gord Dibben M...check number > 10000
I have a checking account where my check numbers recently went over the 10000
mark and my credit union told me that the OFX format only goes up to 9999 so
they start over at check number 1. I find it hard to believe that this could
really be true. Anyone else run into this and have a better solution? Would
another bank not have this issue? I use Money 2004 and it allows me to enter
check numbers over 10000, but when I download my transactions from my Credit
union it knows enough to match the check up correctly (IE: Credit union check
number 10 match my entry of 10010) but when I accept ...incorrect audio track length returned from MCIWndGetLength for mp3
i am using the MCIWnd* (ie Video for Windows) apis to play mp3 and wave
the MCIWndGetLength() macro is meant to return the length of the audio
file, in milliseconds (to make sure this happens i call MCIWndUseTime()
this works fine for WAV files, but the values returned for MP3 files
don't reflect their duration in millisecs - what does it return for mp3
files? can i translate that easily into millisecs?
"bhu Boue vidya" <email@example.com> wrote in message
> the M...Graph Data Values
I am trying to create a pick and mix graph that shows forecast spen
against actual spend by a selected business area.
I somehow want to create a graph on the fly based on the selections fo
If I choose company one and want to see the contracted data I want th
graph to pick up the forcasted contracted Labour, Passthru and Othe
and show the combined contracted actuals; See attached;
and if i then choose company 2 then graph will pick up the releven
Attachment filename: help.zip
Download attachment: http://www.excelforum.com/attachmen...Converting Values to Unicode Characters
The function CHAR converts a value in the range 1-255 to to an ANSI
character. Is there a way to convert values in the range 1-65,342 to
Gary L. Smith firstname.lastname@example.org
You can use VLOOKUP but you'll have to create your own lookup table of
the unicode characters and I think you'll have to paste it onto the
same spreadsheet.... Maybe you can find a lookup table on the
internet somewhere that you can easily paste into your spreadsheet.
tsides <email@example.com> wrote:
> You can use VLOOKUP but y...generate list of non-entries within dates
I use Excel (2007) to record activity and support for about 100
current online learners and I have to provide an activity summary
sheet every two weeks. The list of learners is in one sheet and are
marked "current", agreed break" or "completed" in an adjacent column.
The total list is about 1000 and grows by about 10 each week. The
activity log is another sheet of the same workbook. Assuming that all
activity is logged in this way I need to generate a list (sheet) of
those current learners who have not submitted any recent work and are
therefore "inacti...Combo box choice outcome
I have a combo box with the following choices:
What I want is if anything BUT "New issue" is selected, two fields in the same form as the combo box are populated by other data in the table the above list is pulled from. I can get this to happen by itself.
Me.Text27.Value = Me.imac.Column(2)
Me.model.Value = Me.imac.Column(3)
If "New Issue" is selected, I want another form 'New_case' to open and enter the required data there. I can get this to work alone ...Passing Values from One Form to Another Including a Combo Box
Hi, hope someone can help with passing two values from one form to
another by way of a command button. I have spent a week on various
code taken from this site, but still no luck. Please ... someone help!!
The form I am passing values from is called PATIENT HISTORY-Form. On
this form, I need to pass a date from a field called DateSFESigned and
I also need to pass information collected from a Combo box, Combo91.
The command button is called Command119.
The form that the values are being passed to is called Personal Habits-
Thank you in advance for any help on this matter.
Maurita ...Global Address List #16
This is a brand new Windows 2003 SBS Exchange 2003 install.
I have created a separate OU and added a few users to that
OU. From Outlook 2003, the GAL only shows the
administrator and 1 of the default SBS groups. However,
when 'All Users' is selected from the drop-down menu, the
other users appear.
I have checked the preview for both the GAL and All
Address lists filter in System Manager and all of the
appropriate users appear. Shouldn't they all appear on the
GAL by default?
"Jorge Azcuy" <firstname.lastname@example.org> wrote:
>This is a brand ne...Keeping a range constant when inserting rows
I'm trying to keep a range of cells constant within a
function when I insert a row (e.g. average(a1:a6) becomes
average(a1:a7) but I want it to keep the a1:a6 range).
Even if I use absolute cell references ($a$1:$a$6), it
I would greatly appreciate any ideas.
In your formula, use:
Absolute cell references (dollar signs) do one thing only: They keep any
copies you make of the cell references from changing relatively as they're
copied. They still change when the cells to which they refer are m...Copy Distribution List from One Computer to Another
Hi Folks - I have seen various methods for accomplishing this, but none seem
to help me. Our company uses Outlook 2003 in a NON Exchange Server
environment. I have seen a method for copying distribution lists within a
Exchange server environment, but it does not work in our environment. Any
Michael <email@example.com> wrote:
> Hi Folks - I have seen various methods for accomplishing this, but
> none seem to help me. Our company uses Outlook 2003 in a NON Exchange
> Server environment. I have seen a method for copying distribution
> lists with...find sum in list of of numbers
I have a list of numbers in a column and I need to find which numbers
when summed together equal a figure. I have a list of invoice amounts
that I need to match up with payments (the payments are always made for
several invoices so I need to come up with sums of several invoices to
get to this payment amount).
An example would be I have this in the following section (A1:A10):
I need to find which combination of these figures would sum $1,173.76.
Thanks in Advance,
Dza the troubled ...How to recall the Phone number ... what about other variables?
just a simple question, I'm customizing my status.htm page. Without having
any guide, I'm guessing almost every variable.
One of the easy of them: Customer's PhoneNumber.... I tried with
QSRules.Transaction.Customer.PhoneNumber but didn't bring my anything
What is the right syntax?
Does anybody have any list of variables you can call using QSRules ?
Gustavo, try this out:
...References omit formatting and return cell address
In two cases of references between worksheets, the formatting from the
original cell does not appear in the cell that it is referenced to.
Worksheet 1, A1 contains a currency formatted number - $2,000
Worksheet 2, A1 references the Workhseet 1, A1 cell using the = sign, yet it
returns 2000 (unless I manually reformat the Workksheet 2 cell to Currency
Worksheet 3, A1 contains an apartment # - e.g. 4
Worksheet 4, A1 references this cell but returns the cell address -
Worksheet2,!A1' - rather than the number 4. I tried different formats for the