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...How do I set up inches per Minute/Second in Excel
I need to know how to take a known inch per Minute and divide by a known
measurement and displayed as minutes and seconds. The answer of the equation
(minutes and seconds) is where I'm having trouble.
Actually, you need to divide your measured length by the known rate (inches
per minute). This gives you the number of minutes, but to display using m:ss
format you need to divide by 1440, the number of minutes per day (since
Excel counts time as the fraction of a day).
So put your measurement in A2, your rate in B2, and this formula into C2:
Then format C2 using a custom...Excel Functions #2
hi guys, just wondered if anyone knew which function i would use to do this,
because im fairly novice with excel:
Basically if the cell value is above 110 i want the cell to turn green
if the cell value is between 110 and 105 i want it to turn yellow
if the cell value is below 105 i want it to turn red
any help would be seriously appreciated. thanks
> hi guys, just wondered if anyone knew which function i would use to
> do this, because im fairly novice with excel:
> Basically if the cell value is above 110 i want the cell to turn gr...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...Some good work
I just able to create lookup field. And with this I can enble to show the
lookup field of the same entity in the same form. So I think I got a way to
get around the one-to-one and many-to-many relationship. Is not it good?
Anyone need any help, let me know.
Thanks and Regards
...Button/Macro Not Working, Help!
I have a macro that pulls up Report Manager and prints out pre-define
views. The macro works fine only after I use Report Manager the firs
time. If I exit my workbook and Excel, then return to it, th
button/macro does not function. Nothing happens until I manully us
Report Manager again. Is there a bug with this or am I missin
Message posted from http://www.ExcelForum.com
Post your code.
Gord Dibben Excel MVP
On Thu, 20 May 2004 08:38:55 -0500, baston
>I have a macro that pulls up Report Manager and prints out pre...Can I make a database in Word with Excel Data
I know this may be a "DUH" question, but...
I am making a list of area dentists that I have copied and pasted of
of the Dex website into Excel. I am wondering if I can take this inf
and make a database in Word for printing address labels. Does anyon
know if this can be done, and HOW?:confused
Myn777's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2958
View this thread: http://www.excelforum.com/showthread.php?threadid=49283
For help on Word mail merge using Excel as the...Opening tab-delimited files in Excel... how to stop the autoformat of dates?
I'm doing bioinformatics work in which I often download tab-delimited
files describing genomes and open them in Excel. Unfortunately, Excel
decides that genes with names like APR1 and SEP7 are actually dates,
and reformats them as such. This is a huge headache, as I often don't
notice these problems until much later.
Is there anyway to completely disable this date autoformatting? I've
searched high and low and have yet to find a solution.
P.S. I'm using Excel 2002
sa...Saving Excel workbook in SQL server using c#
Could anyone please help me out as to how we can save the excel workbook in
the database and
read it back.
I was able to convert the text files and image files into binary format and
save them to the
DB and finally able to retrive them back in the same format. But was unable
to do same for
the excel object.
Your help will be greatly appreciated.
...Excel's localization of scientific notation
Does Excel use "E+" and "E-" for scientific notation for all locales?
Or are there some locales for which it uses different characters?
I'm pretty sure that the E is universal. If it were not, it would have been
in the list of international symbols. Look here for more info about
Microsoft MVP - Excel
"Greg Lovern" <firstname.lastname@example.org> wrote in message
I would like to change the cell color if there is a "r" found in it. All the
cells are in the same colum and there are also numbers in the cells with the
"r". Can anyone help ?
Assume data in col A
Select the col, then apply conditional formatting
using Formula Is:
Format to taste > OK out
Replace SEARCH with FIND if you need it to be case sensitive
Downloads:16,400 Files:356 Subscribers:53
> I would like to change the cell color if ...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...Access ODBC problem: Excel cannot get float columns
I need some help
I'm trying to get Access external data from an Excel workbook, using
the MS Query feature.
Everything is ok except when I try to fetch some tables that ODBC
refuses to get data from. The error message tells that the MS Access
ODBC driver doesn't allow some columns to be transmited because of its
number of characters.
The most strange thing is that I can see the data from MS Query
correctly, but I caannot get it back from Excel.
After some tries, I thing it occurs only with real typed columns.
Can anybody help me?
I use Windows XP Home + Office 2000 spanish versio...HELP: Excel userform version control issue
I have an excel userform that is posted on my companys intranet. The issue I
am having is, users are saving this form to their hard drive and then using
it(Instead of launching it everytime from intranet), SO basically when I
have a new version of form on intranet they still use the old version as they
have a habbit of saving it on their hard drive.
Is there a way to resove this? something like they would see a popup message
saying that "This is an older version that you are using, Please launch the
form from Intranet for newer version".
Thanks in advan...Rule not working
Background: I have a user with two email addresses. His
primary address is "email@example.com" and he has a second
address called "firstname.lastname@example.org". We are running SBS2003
with Exchange and the user is using Office 11.
Goal: He wants all mail that is sent to the
email@example.com address to be forwarded to another user in
the same domain.
Problem: Sounds easy enough, right? When the Exchange
server receives a piece of mail to firstname.lastname@example.org, it
renames the recipient to email@example.com thus causing our
rule not run. Obviously we can't forward all mail to the
o...Email to Quote not working...
Here are the steps we have taken to make email - to - queue work, yet is has
1) created a new user in AD which will be the public email for our users,
2) Ensured an email box was created for this new acct.
3) Created a 3rd Acct which will be the forwarded to acct: CRMMBX@CRM.local
4) Configured properties to include the mailbox rights for SELF were a) Read
b) Full Mailbox Access c) Associated Ext. Acct.
5) Added the two new users to the CRM.
6) Ran the Rule Deployment Wizard and typed in "CRMMBX@CRM.local" in the
box. ...Error in code exportin tables to excel
I'm tryin to export a table to excel with the code:
Private Sub Command4_Click()
On Error GoTo Err_Command0_Click
Dim stDocName As String
stDocName = "F01_UT"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, F01_UT,
However, Access displays the message:
Compile error :
What I'm doing wrong? If I want to export more tablas do I have to write
more lines (DoCmd.TransferSpreadsheet acExport, acSpr...AutomaticScale doesn't work properly
a question a fellow employee has asked me earlyer:
I have two identic formatted tables, with each 2 columns
1. Column contains each Month of the last 3 years
2. Column contains Data, normal numbers without link or whatever
first table ranges from 98.8 to 109.3
second table from 100 to 136
Now i'm going to do two chart from those two tables:
first table changes into a chart where the minimum is automatically set
to 92, second table however has a minimum of 0!??
even when i change some of the numbers it stays like that!
What points does excel take into consideration for calculating ...Multiple IF statement not working
I have numbers in cells b2, d2,e2, and f2. I am trying to write
statment that will increment number in cell b2 by one for each cell
(d2, e2, f2) that is greater than or equal to one. The following
formula will not work if more than one cell (d2, e2, f2) has a zero in
Does anyone know why?
Wag more, bark less
> I have numbers in cells b2, d...Scheduled Active Directory Synchronization doesn't work
We have some troubles with scheduled AD synchronization with MOPS 2007.
This error was appeared without visible reason. We have the following error
in Application log:
Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Active Directory Synchronization
Event ID: 7715
Standard Information: PSI Entry Point:
Project User: DOMAIN\runsql1service
Correlation Id: d5ddd59b-b0d7-40a5-bb1c-7839c26608ea
PWA Site URL: https://sh1.xxx.com/PWA
SSP Name: SharedServices1
PSError...POP3 and SSL not working 8(
My pop3 ssl connection to exchange 5.5 mailboxes isnt working. The
exchange server is NT4.
I created an OpenSSL certificate and followed the MS guide to
installing SSL certificates:
In Exchange administrator the pop3 protocoal is enabled for the site
and the server, with 'Basic (Clear Text) using SSL' and 'Windows NT
Challenge/Repsonse using SSL' ticked.
The IIS key manager shows a key under POP3, the properties of this key
shows it is not out of date, and is 'complete and usable'
Do I have to do an...emailing spreadsheet within excel
I have a user that has sent her spreadsheet as an
attachment using the Send To Function. We use Outlook.
Now, it seems as if the Send To option has lost its
settings and is now trying to set up an Internet account
instead of using the Microsoft Exchange Settings. Anyone
know how to reset the Send To settings in Excel?
...How do I import data from a SECURED website into Excel?
I can import data from a regular web page directly into Excel spreadsheet,
but when I tried importing them from a secured site I encountered problems.
Does anyone have any suggestions?