Center a column header over two columns
Is there a way to center a heading over two columns. Right now, the
best I can do is (1) enter the first half of the column header in the
left column (2). right-adjust it (3). enter the second half of the
column header in the right column (4). left-adjust it.
Looks kludgy. There must be a better way.
Simply select the two cells, goto menu Format>Cells, select the Alignment
tab, and check the Merge Cells box
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"hedrew3" <pe...Change column color in chart when column value is over/under goal
No use of VBA or macros expected. It is believed to be Excel chart feature.
Any ideas on how to change column colors (Red/Green) if value exceeds or
meets the preset goal.
Eg. if goal is 4% - anything at or above 4 should show green and under 4
should be red.
Assuming your data is in A2:A20
copy B2:C2 down, add some labels to B1:C1, then chart B1:C20.
This will give you two series, one for the aboves, one for the rest.
Select each data series, right click, choose format, and set the colour as
(there's ...Outlook 2007 and vista, not responding...
Why outlook 2007 and Vista Ultimate does not work for me ?
It happens always " send and receive 33% " and then
" Outlook not responding...".
Indeed, I've replaced the Outlook. pst on other disque.
But this is the reason of the problem heh ?
what type of email accounts do you have? How many accounts? (I'm guessing 3
because it gets to 33% done.)
are you using the junk mail postmark feature? Turn it off if you are.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips....scrolling functionality to edit box
My application consists of drawing a series of rectangles in the edit
box. I'm currently having some problems adding both vertical and
horizontal scrolling features to an edit box in a dialog. Though I have
checked "Horizontal Scroll", "Auto HScroll", "Vertical Scroll" and
"Auto VScroll" in the "Styles" tab of this edit box, no scrolling goes
on when I draw to my edit box.
When I do a paint, the drawing exceeds the width of the edit box and
even paints up to the borders of the dialog. What's strange is if I
type text into the e...Outlook 2003 Appears to Freeze
A client has Office 2003 on XP Pro with McAfee Security Center, all fully
updated. on a P4/3GHz/1G RAM/80G hard drive with plenty of space.
When starting Outlook (which opens to the Inbox) with the preview pane on,
it takes an interminable amount of time -- over a minute -- to fully start
so that we can do anything with it. The preview pane is the last element
of the display to be rendered. If the preview pane is disabled, Outlook
starts very quickly, within about 5 seconds. However, if we then try to
open a message for the first time in its own window, we still have to w...How do I change headings for columns from numbers to letters?
Go to the Tools menu, choose Options, then the General tab.
There, uncheck the "R1C1 reference style" setting.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"scott" <email@example.com> wrote in message
Tools>Options>General. Uncheck R1C1 reference style.
Tools > Options > General tab
Uncheck "R1C1 reference style" > OK
ht...Copy Data from one Column to another
In a list of names and addresses, my secretary listed entries as follows.
Column A has last name. Column B the first name. Column C the Street address
and so forth. I would preferred to have had both first and last names
together in Column A. Is there any formula that will add the first name from
Column B to the last name in Column A. Thanks for any help ... if there is
any solution to this questions. Over three hundred names to cut, copy
Having separate Fname and Lname columns can be pretty handy for sorting,
searching, and filtering...so...
Go ahead and make ...Locks freeze
outlook locks up during start-up.
changed from dial up to dsl.
also- IE (internet explorer) locks or no response at
...Stacked Column Graphs
What I would like to do is something I thought was very
simple, create a chart that compares total costs vs total
funds over a period of years.
I have a total of five columns of data. I want to select
three columns to be in a stacked column graph (showing
total Funds). I then want to create a second stacked
column graph to sit beside the first one made from the
remaining two columns of data (showing total Costs) for
the same time period. The years will go along the X axis
and the total dollars along the Y axis.
I can do this so easily on graph paper, but for the life
of me I cannot...Summing entire column
I have a 2 worksheet workbook that is being used as a Credit Card log. The
user enters all the transactions into a worksheet named, CreditCardLog. The
CreditCardLog worksheet takes 10 values, PONum, PODate, Vendor, Description,
Amount, CCCObjectCode, C, CO, CR, PCO. The totals are then displayed on the
first worksheet, Totals. This adds up C, CO, CR, PCO columns for totals.
These sums are done like this,
The issue that I am having is that if a user inserts a new line or pastes
some content into the CreditCardLog worksheet, then the sums o...Outlook 2007 Auto Archive error
After upgrading to windows 7 I got the follloowing error message and I just
got it after an auto-archive when it could not archive the caledar and notes.
"You do not have the permission required to access the file C:\Documents and
Settings\Paul\Local Settings\Application Data\Microsoft\Outlook\archive1.pst."
If a number in a column is > or = to a value, I want to highlight that field
Look into Conditional Formatting.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"PamRodriguez" <PamRodriguez@discussions.microsoft.com> wrote in message
> If a number in a column is > or = to a value, I want to highlight that
> in Red
cannot do this in a table or a query, but you can do it in a form, via
...Outlook 2007 to Entourage 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
We got a customer over here that is trying to transfer the information from their Outlook 2007 in a Windows-based computer to Entourage 2008. <br><br>I've searched around and found this article: <br>
<a href="http://www.entourage.mvps.org/cross_platform/win_mac.html">http://www.entourage.mvps.org/cross_platform/win_mac.html</a> <br><br>But the customer reports that none of the options mentioned work for them. <br><br>Is there any easier way or ...MATCH function; comparing letter grades in columns
I am currently comparing the contents on two cells in columns H & I
(for example, cells H10 and I10). The contents are letter grades
(i.e., A, A-, B+, B, etc., through E). I have my function tell me if
there is any difference between the two columns and report the result
(i.e., =93no change,=94 rating decrease,=94 or =93rating increase=94) in th=
adjoining column, J10. I use the MATCH function, and since it can=92t
distinguish between the letter grades, I have placed the letter grades
in cells M2 through M13. My function is as follows:
=3DIF(MATCH(H10,M$2:M$13,0)=3DMATCH(I10,M$2:M$1...Break One Column A (City, State) into 2 columns A City, B State
I have a spreadsheet that has City, State in one column and need to break
that up into 2 columns (one for city and one for state)
What is the easiest way to do that?
If the cities and states are always separated by a comma, you could:
Select the column
Data|Text to columns|delimited by comma
> I have a spreadsheet that has City, State in one column and need to break
> that up into 2 columns (one for city and one for state)
> What is the easiest way to do that?
> Thank you.
Dave Peters...Prevent access to Old Project Server
Using MSProject2003 (I know)
I recently updated to a new server, communication to users about new server
URL for access and login information has been delivered. Problem is that
some users don't read their email and are still accessing and updating their
projects on the old server. Is there any way to prevent users (not admin)
from accessing the old server without removing (MSProjectServerUser and
MSProjectUser) logins? Or, possibly add a warning message when access to old
server is initiated?
Remove all of the users from all of the security Groups in PWA...Freezing pane
When I attempt to freeze the top header pane in a sheet for scrolling
purposes, Excel freezes the first 13 panes instead. How do I fix this.
Thanks in advance for any help.
What cell did you select previous to doing window>freeze panes?
"JB" <JB@home> wrote in message
> When I attempt to freeze the top header pane in a sheet for scrolling
> purposes, Excel freezes the first 13 panes instead. How do I fix this.
> Thanks in advance for any help.
This i...Insert extra columns
Is there any way that one can insert extra columns in
Excel? I need about 500 columns whereas Excel only has
No, that is absolutely impossible. Quattro Pro from http://www.corel.com/ is
the only "bigger" spreadsheet I know of.
HTH. Best wishes Harald
Followup to newsgroup only please
"Alan" <firstname.lastname@example.org> skrev i melding
> Is there any way that one can insert extra columns in
> Excel? I need about 500 columns whereas Excel only has
You cannot exceed 255 columns th...Publisher Freezes when Opened
I have encountered a user who says that every time she
runs Publisher 2002 while other programs are running, her
machine instantly freezes, requiring a reboot. She also
says that while running Publisher by itself, the program
will run briefly and then her machine will also freeze.
Microsoft Knowledge base article #322119 lists damaged or
outdated printer drivers as a possibl cause of this
problem. The article mentions 2 specific printers known
to cause this problem, the HP OfficeJet T45 all-in-one
printer and the Canon BJC250 printer, but the user is
connected to an HP2000 printer an...getting rid of a hidden column behind the front column
I created columns and rows; however, the 4th column has a column that I had
created earlier but couldn't find so I created another one.....Now, I'm
positive that I have one on top of the other......how can I see the one in
the back so that I can get rid of it (delete it, etc.)?.....thank you so very
You'll be able to see if there is a hidden column, because the column
letters which you can see will not be consecutive, so you would see A B C E
F or something similar in the column headings.
Select the whole sheet by clicking the square at the top left, abo...Outlook Web Access and Read Receipt
I currently use Outlook through the web. Does anyone
know how to block read receipts (i.e. you read a message
that has read receipt marked, but you don't send the
receipt?) I know how to do this in Outlook Express and
Outlook, but it appears you can't do it through web
Take a look at Read Receipt Remover application:
"Kristin" <email@example.com> wrote:
> I currently use Outlook t...Sum Of Cells in a Column
How can I get the sum of data in a column if there are non number
I have got a column with numbers and #NA. When I take the sum or
average, #NA is diplayed. Instead I want to get the actual average of
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.
But wouldn't it be better to correct the #N/As?
-- ...copying a database in 2007
I have a user who says she made a copy of a 2003 database and pasted it into
another folder with a different name. She opened that new database in Access
2007 and entered several records. She closed and saved the database but when
she reopened the new database, the new records were not there. Another person
opened the old file after she closed it but said the names were not in the
old file. This person is a very savvy user and searched her entire
computer/network drives for both the 2007 and 2003 file extensions but was
not able to find the new file with added records. The databases did...Combinations from values in a column
I'm trying to figure out how to generate all combinations from a list
of N values in a column, let's say column A.
In particular, I want to have all combinations of 2 values, 3 values,
4, ... up to 7 values.
To give an example: Let's assume I have a list of only 3 values
(1,2,3) for which I want to have all combinations of two values. In
this case, the result would be 1,2; 1,3; and 2;3. The ordering of the
values does not matter, i.e. duplicates should be eliminated.
I hope I could explain it sufficiently. I would be grateful for any
Use the Co...Creating PDF from Publisher 2007
I have Publisher 2007, and need to create a PDF file to upload to my company
website. The file is approx. 40 pages and I want to have the bookmarks
usable in the PDF format. I have the PDf converter download, but no access
to Acrobat. Is it possible to have the bookmarks I created in Publisher
carried over to the PDF file with the simple plug-in converter provided from
You've posted your question in the wrong group. This group is dedicated to
Microsoft Access. You should repost in microsoft.public.publisher
> I h...