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 to copy and paste my resume
i am trying to copy nand paste my resume from microsoft word on to a job
website. its not letting me. how do i make this work???
Your best plan would be to ask the support of the site you are trying to
paste to, but my guess is that the site wants plain text so copy to Notepad
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< >&l...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...Publisher 2003/Word Art/EPS
I have created an (A3) Poster which includes a WordArt Object and some text.
I do output it as EPS, using the "Generic Color PS for Commercial
Printing"-driver from office.
EPS-generation seems to succeed. However, if I open the EPS within
Macromedia Fireworks, the "WordArt"-Text is not included (visible), all
other texts have been moved to the top of the page.
What am I doing wrong????
Dipl.-Ing.(TH) Winfried Kaiser
c/o Fortune Systems GmbH & Co.
I can import it into Corel okay. Depending on what Word...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
news:email@example.com...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...2003 excel
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...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...Multiple colors transparent in picture-HOW?
I am trying to make multiple areas of a picture partially transparent, but am
unable to in Publisher. What programs would allow me to make this change?
If it is a bitmap, i.e. jpg, bmp and others, you need to use a photo editing
program. If it is a vector (.wmf) you can ungroup the image, select the area you
want partially transparent, right-click, click format object.
This link will take you to Paint.NET, it is a pretty good free program.
Mary Sauer MSFT MVP
...cant see pictures in publisher 2003
Inserting pictures work ok , then i cant see them , clicking on the area of
picture the outline grabs are there but no visible picture. TOOLS > GRAPHIC
MANAGER shows the thumbprint , thats all , What am i going wrong
>Inserting pictures work ok , then i cant see them ,
clicking on the area of
>picture the outline grabs are there but no visible
picture. TOOLS > GRAPHIC
>MANAGER shows the thumbprint , thats all , What am i going
If you can click on the image and see outline grabs. Do so
and then choose Order from the Arrange ...Word Decides to Not Save Documents
We're having a problem where users will be working on files and Word
will just STOP saving changes. A user will work for an hour updating
a document and will click the save button. After clicking save, they
get no error, everything looks fine, and they close the document. But
the hour worth of changes are not saved and the Modified Date doesn't
change. If the SAME user double clicks and opens the file they see
their changes but if someone else opens the file they get the old
Sometimes if they just close all their open word documents the changes
will be flushed a...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...Merge to email w/Word and Outlook 2002 security issue
I am trying to merge email using Word and Outlook 2002.
This merge consists of about 3000 recipients. When I
commence the merge I get an Outlook Security warning that
tells me that some outside program is trying to send
email using my Outlook profile and I have to click Yes or
No. It procedes to ask me for ever single recipient...
I'm not going to sit there and say yes for 3000 people.
Do you know of a setting somewhere that I can change to
not ask me everytime?
What service pack(s) have you applied? Did you choose HTML as the message
format for the merge?
-- ...Spinning Beach Ball
I seem to notice a correlation between seeing the spinning beach ball more often after launching MS Word for OSX. I removed the PDFMaker.Lib and this improved the performance a great deal, but still noticing the SBB more often after launching Word.
Anyone know about this?
Many Word issues are related to corrupt Word Settings or Normal Template.
You could try removing the Word Settings file, then testing. The Normal
Template could be renamed, then test. Be sure Word is closed before removing
or changing any files. You could also consider running the Remove Office
utility and reinstalling Offi...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?
...Quotation mark key produces << instead of " in Word doc from PC
Operating System: Mac OS X 10.6 (Snow Leopard)
I am updating a document that was created in Word on a PC several years ago. When I viewed it all the ' had become =. I found out in the forum how to fix that. But more important, I do not seem to be able to type a quotation mark. When I hit Shift ", I get a symbol that looks like a doubled >. The symbol doesn't even exist on my keyboard. I suspect that I can go to Insert, Symbols, and get the proper ", but this is a syllabus for a class that I teach year after year, updating t...