Zip code lookup
Operating System: Mac OS X 10.6 (Snow Leopard)
I want to enter a zip code in sheet 1 column D and return a county name from sheet 2 to sheet 1 column E. Help!
On 3/22/10 6:24 PM, email@example.com wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
> Intel I want to enter a zip code in sheet 1 column D and return a county
> name from sheet 2 to sheet 1 column E. Help!
Assuming that you have table of county names and zip codes in sheet 2,
then you simply need a hlookup formula in each cell of column E in...how to move screen right or left in excel
in lotus 123, we use ctrl+arrow left or arrow right to move the screen left
how to do it in excel for the same. thanks.
now in excel if i use ctrl+arrow right, it will bring me only to the end of
the worksheet column which is not I want...
You can grab the scroll bar at the bottom right and move to whatever column
"sunfai" <sunfai02(sunfai)@yahoo.com> wrote in message
> in lotus 123, we use ctrl+arrow left or arrow right to move the screen
> or right.
> how to do it in excel for the same. thanks...How do I change the size of Value Axis Title box for an Excel Cha.
The title box cannot be sized. I must reduce the font to very small to
prevent truncating the title.
I would have thought I could drag the box to the size I wanted but I do not
get the chance to do so.
Instead of a Title, you can use a Text Box:
Select the Chart
Type the text you want in the Title
Press the Enter key
A text box will appear in the centre of the chart
Drag it to the location you want it, and format/resize as desired.
If you prefer, you can link the text box to a worksheet cell, and
display its text:
Select the chart
Type an equal sign
Click on the cell you want to link
Pr...Opening multiples instance of Excel
since a few days i have the following problem.
I open an excel document, then want to open a 2nd one, it open it but in the
same excel. Before the same action resulted in have 2 excel running, now all
document are opened in the same excel windows....
How can this be changed to the default settings? In doc in a separate excel
hope someones knows...
thanks in advance,
Go to the Tools menu, choose Options, then the View menu. Look at
the setting for "Windows In Taskbar".
Microsoft MVP - Excel
Pearson Software Consulting, LLC
ww...the disadvantages of microsoft publisher
i' am doing my coursework and i can't find anything about the advantages and
disadvantages of microsoft publisher and power point i would appreciate it if
someone could help me
burn41 <firstname.lastname@example.org> was very recently heard to
> i' am doing my coursework and i can't find anything about the
> advantages and disadvantages of microsoft publisher and power point i
> would appreciate it if someone could help me
With regards to what circumstances?
I mean, if you want to do an animated presentation, Microsoft Publisher has
plenty of disadv...Office 2003 and XP
I have both Office 2003 Standard and Office XP Standard on my laptop. Can I
safely uninstall Office 2003 to free up more moemory ?
"Puzzled" <Puzzled@discussions.microsoft.com> wrote in message
>I have both Office 2003 Standard and Office XP Standard on my laptop. Can I
> safely uninstall Office 2003 to free up more moemory ?
I'd rather uninstall Office XP, but you should be able to uninstall either.
Note that since only one version of Outlook can be installed at any one time,
you have eithe...excel add-ins
why do my add-ins have to be reloaded each time i open excel
Open Excel, then Tools, Add-Ins; from the listing find the add-in in
question and fill the check-box, then OK out.. That should do it.
"balik" <email@example.com> wrote in message
> why do my add-ins have to be reloaded each time i open excel
If this computer belongs to your employer and you do not have
administrative rights, then you should ask your IS department whether
you have rights to modify the HKEY_CURRENT_USER portion ...install Publisher 2002 with Office 2003
I have MS Office 2002 SB OEM version with Word, Excel, Outlook and Publisher.
Now, on a new hard disk, I want to install Office 2003 SSL with Powerpoint
but without Publisher. What's the best way to keep the old Publisher which I
won't miss. Using the same home ? Installing 2003 over 2002 ? How works
registration of the both versions ? Will 2003 registration cover 2003 ?
Hi tdo (firstname.lastname@example.org),
in the newsgroups
|| I have MS Office 2002 SB OEM version with Word, Excel, Outlook and
|| Publisher. Now, on a new hard disk, I want to in...Disable Tagging in Office Communicator
I am an individual user on a network that uses Office Communicator. I would
like to be able to use Communicator, but disable the ability for other users
to tag me to alert them to my status changes. Is there a way to do this? I
have searched a while and not found any way for users to do this.
(If this is not the right forum to post, can you point me specifically to a
You be better off posting this to the Communicator newsgroup
On the web:
Pe...MS Office X and Virtual PC running on Panther (10.3)
I am anxious to upgrade to OS X 10.3 when it ships later this month.
Has anyone had any experience, good or bad, using Office X and/or
Virtual PC under the pre-release versions of 10.3?
Thanks for the help
Everyone who has run any software on pre-released versions of Panther had to
sign agreements with Apple and other vendors. The agreements prohibit
discussion about the products or release of the kind of information you are
Those who know for sure can not tell you until the 24th of the month.
All respon...Add-in "C:\winnt\system\mociext.dll could not be installed or loaded
Starting Outlook 2003 on a Win2K Pro machine error
"TheAdd-in C:\winnt\system\mociext.dll could not be
installed or loaded. This problem may be reloved by using
the Detect and Repair on the Help Menu"
This does not fix nor does a reinstall of Office 2003 Pro.
How can this be remedied.
...Microsoft Word 12-15-09
Why wont my keyboard type in Word/
Does the message "This modification is not allowed because the selection is
locked" appear somewhere?
If so, than you either haven't activated your copy of Office or your trial
version is over and you have to pay for it.
"dynamictravel" <email@example.com> wrote in message
> Why wont my keyboard type in Word/
...keyboard doesn't respond when opening an excel book
When I double click on an excel file to open it, I cannot use the keyboard.
Nothing works. But if I use the mouse to double click on a cell, I can then
type in it.
If I close the workbook and then File->Open the same workbook or any
workbook the keyboard responds correctly.
...Junk Mail and Detect and Repair wont work in Office 2003
I am trying to update the Outlook Junk Mail filters, KB914454 it wont
let me in Office 2003 it continually shows the shield icon saying I
have an update to complete when I do it fails, tried to repair, that
fails too, should I try install even tho my software or CD is Office
2003 and I have SP2 on the computer already or is there a registry fix,
do I really need Junk Mail, how can I stop this update from happening,
I use AVG and it works fine
...Dates in Excel #5
In a column I need month and year. When I put in the
month, it is accepted, but the year defaults to 04
regardless of what year is typed in What do I need to
How are you typing in your dates?
It's also relevant to ask what your Regional Settings are.
Norman Harker MVP (Excel)
"Luv2resa@aol.com" <firstname.lastname@example.org> wrote in
> In a column I need month and year. When I put in the
> month, it is accept...Excel VBA
I wrote a vba function that should return data to the excel spreadshee
after querying the Oracle database. I have installed and created
Microsoft ODBC connection for Oracle on my workstation.
If I manually open excel workbook and navigate to Data, Get Externa
Data, New Database Query, connect to the database, click on the SQ
pushbutton and paste the query, click OK and hit the Return Dat
pushbutton, the query return data to the spreadsheet without an
I recorded all the above steps in a Macro and wrote a similar vb
function for extracting data for another table. I then reopened...Check patch from the Microsoft
Content-Type: multipart/related; boundary="pfhtuhkmduf";
Content-Type: multipart/alternative; boundary="snneiwdpzixer"
this is the latest version of security update, the
"October 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to protect your computer
from these vulnerabilities, t...EXCEL AND STATISTICS
Are there any good websites that deal with doing descriptive statistics with
Excel? Like graphing normal distributions?
If you want a normal probability plot, Mike Middleton has a downloadable
paper on this at
If you want to draw the normal distribution's bell-shaped curve, see
If you want to draw a histogram of actual data, there is a histogram
tool in the Analysis ToolPak; see also
http://w...Suddenly Save and Save as greyed out in Excel 2003
I use a networked pc and laptop. My Save and Save As applications on the
Excel 2003 toolbar have suddently become greyed out. Other users of shared
spreadsheets do not have this problem. I do not have the problem with any
other Office products. I can use Ctrl "S" or "Close" to get around the
problem but this does not help with new workbooks where I need to select the
correct location in which to save the file. Any suggestions for a quick fix?
...microsoft Office Newsgroups?
Does anyone know whether Microsoft will continue to have
newsgroups for Office 2010?
My news server, news.individual.net doesn't seem to be
showing any microsoft.public.office2010 of any of the programs.
Are they available on a different server?
Microsoft will never initiate another new NNTP newsgroup. MS has pronounced NNTP
Go to http://communitybridge.codeplex.com/ and download and install V40 of the
Community Bridge. You will be able to use the Technet Office 2010 forums with
your news client.
On Mon, 09 Aug 2010 02:55:55 -0400, louise &l...Plotting tabular data in an Excel graph?
I have some data in tabular form in an Excel spreadsheet - columns are the
years (7 so far) and 12 rows represent the months.
Is there any way I can plot the data in a linear graph, with time as the
x-axis, direct from the table as it stands? If not, presumably I must go
through an intermediate step to put the data all in one column or row first?
PS I think I know the answer to this question - no! However, one of the
delights of using this forum is that so often it turns out that someone,
somewhere, has invented an ingenious solution for doing what one previously
thought wa...Creating an "exception" report from comparing 2 excel files
We run a report from our system every day that shows all employees and a
bunch of demographic data on the employe. The number of rows varies based on
the number of employees in the database.
Is there a way to compare Monday's file to Tuesday's file in excel and get a
list of just the rows that changed from the prior day's file?
We have used a suggestion from (Martin W)
"Say you have two sheets in one file Sheet1 and Sheet2.
Then place this formula in A1 of Sheet3 and drag across
and then down as far as needed.
...Install of Office 2007 on Win 7 does not install VBA
New install of Win7 Ultimate 64 bit from Dell. Office Pro 2007 installs, but
there is no VBA folder under C:\Program Files ... \Microsoft Shared\, thus no
My normal.dotm files loads. Trying to start Visual Basic from the Developer
ribbon gives me a "Could not open macro storage." then Visual Basic editor
loads and displays the usual list of modules in the Normal template.
All attempts using Office setup to install VBA fail (it's indicated by
default that it should be installed and run from the computer, partly because
Access needs it by defau...Match 2 different zip code lists
I have a large 42,000 list of US zip codes which each row (42,000 rows) has a
zip code column, a counties column and states column that I want to match to
a smaller 4,000 zip code list- with a zip code column & dollar amount column.
Or even, use all the Illinois zip codes matched to a smaller IL zip codes
list- so I can match same zip codes and corresponding county? Now, they are
set up on separate workbooks or worksheets. thanks.
> I have a large 42,000 list of US zip codes which each row (42,000 rows) has a
> zip code column, a counties column and states ...out of office reply outside of LAN
Is it possible to send out of office reply's to people
outside of a lan? Would they recieve it.
If it is possible where would i go to see the proper
configuration for that?
Yes it is - you need to configure your Exchange to allow
out of office replies. View KBA 262352 for info regarding
>Is it possible to send out of office reply's to people
>outside of a lan? Would they recieve it.
>If it is possible where would i go to see the proper
>configuration for that?