paste special | values should work with merged cells
When you use past special | values, and try to paste a large bunch of data
with merged cells into another sheet, it will not let you paste just the
values. This requires un-merging the cells. The problem that I have with
this, is that the error message makes NO sense. It says "This operation
requires the merged cells to be identically sized". Well, guess what? They
are!!! I just copied them in from another worksheet. I even used paste
special | column widths to ensure that the were indeed the same size. I
don't understand what the big deal is anyway? If Excel can ...How do I set up a financial planner using Microsoft excel?
How do I set up a financial planner using Microsoft excel?
What have you done so far?
Is there a specific problem that you need help with?
> How do I set up a financial planner using Microsoft excel?
Excel FAQ, Tips & Book List
...setting up O.E. to send and recieve MSN mail
I have a MSN mail account, and want to set up my O.E. to
sent and recieve my mail. I went to "accounts" and did
everything that I was supposed to, and when I tried to
send mail, I got the following two messages:
The service is currently unavailable. Try again later.
', Protocol: HTTPMail, Server Response: 'Service
Unavailable', Port: 0, Secure(SSL): No, Error Number:
Unable to poll for new messages on your HTTP server.
Serve...WMP 12 Video Settings (Brightness/Contrast etc.) Won't Work
I have new Sony CW laptop running Windows 7 (64-bit) with an Nvidia GeForce
GT 230m graphics card.
The problem I have is that I can't adjust the video settings
(colour/contrast/brightness etc.) in Windows Media Player 12 as I am used to
being able to do in previous versions. I use this function all the time and
it is not enough for me to simply change the global settings as I know it
should be possible within Windows Media Player.
I updated the Nvidia driver and downloaded the K-Lite codec pack (too
complicated - didn't know which codecs to adjust) with no resu...make a cell automatically populate with "1" when specified cell va
I am trying to figure out how I can use Excel formula or function to do the
When the name column is valued, it will automatically populate "1" in the
Assuming Column A is the name column and Column B is the tally column, enter
the following in the first cell of the tally column:
Drag this formula down as far as you want. HTH Otto
"WendyM" <WendyM@discussions.microsoft.com> wrote in message
>I am trying to figure out how I can ...Need help with Alphanumeric Auto number combination
Access 2000. I need a to assign an Audit number that is alphanumeric and
partially auto number and partially assigned by the user. Example: Audit
Number: 01086AB07 The first two digits of 01 is the first audit, which
will advance one number automatically for each audit (Textbox). The second,
third and fourth digits are the julian date which will be set to
default(Textbox). The fifth and sixth digits are assigned indicating a
company name(Combobox) for selection by user. The last two digits are the
year which will be set to default(Textbox). I need this alpanumeric sequence
to en...Settings area disappeared from Client
Hi, I have been working in Settings area, adding new fields to forms etc and
all was well. I then decided to install the Outlook Client which seems to
have gone well except for when I go back to Internet Explorer and go to
http://crmserver my whole Settings area isn't there anymore , just Workplace,
Sales, Marketing and Service. (I went to server to check my role was still
Systems Administrator and it is) Any ideas on how to get Settings to show up
again would be appreciated.
Sorry,step 13 Restart computer, fixed it.
> Hi, I have been working in Set...Delete previous cell content
Not sure if this is function or programming?
In column F, Row 4, Header is "Do You Require Training?" in row 5 is a
validation list = Yes, No.
In column G, Row 4, Header is " Training Completed?" in row 5 is a
validation list = Yes, No.
If the user has selected Yes in Column F, Row 4 because they did need
training...then they do it...so when they select Yes in Column G, can the Yes
in Column F be automatically deleted.......I have set up a Validation Message
telling the=m to delete previous cell, problem is they don't read it and it...hidden value in each cell or in each row in Excel
I need to store a two information in one cell with one value as hidden
,kindly reply if any one know the way
without creating hidden rows or columns or worksheet
The need is to store two information in one cell,with one value in
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Using comments is one option.
>I need to store a two information in one cell with one
value as hidden
>,kindly reply if any one kn...HTML Emails
This is for my job, so I cannot change software packages.
It's Outlook or it's nothing.
I need to create a newsletter that will be distributed
quarterly. To spice it up, we decided to create a nice
looking HTML formatted email with images, etc. (just like
the everyday spam we get).
The only way I was able to figure out how to get the HTML
into an Outlook email is by...
1) Create the HTML in another program (namely, I use
2) Preview the HTML in a browser (I use Internet Explorer)
3) 'Select All' on the page, 'Copy' it and 'Paste' it into
t...Backing up Contacts
How can I back up my Vista Windows Mail Contacts? I just want to put them
in a folder which I can transfer to a disk when I back up my data.
The Windows Mail contacts are just plain text files in a folder....
Just include this folder in your backups.
Additionally, you might want to export the contacts into a CSV file for
In WM, open Contacts, Export - CSV, etc.
Windows 7 Ultimate
"Drew" <firstname.lastname@example.org> wrote i...Sum according to cell info
I want to sum three column of numbers according to a category number that
lies in three columns,
The category numbers are in columns B5 - B61 and then starting at N5 - N61
and then again starting at Z5 - Z24.
The category numbers are 1 - 6. But may add categories later.
I would like the sums to go into cells AH32 - AH37.
Thank You in Advance
I am sorry I forgot to mention where the data is I am looking for.
F5 - F61
R5 - R61
AD5 - AD24
Thank You in Advance
"Ed Davis" <email@example.com> wrote in message
news:uumtXNdGKHA.3708@TK2MSFTNGP...exceeded the numbers of times to install Office v. X
I have a G4 that I have had nothing but problems on. Apple's latest
solution was to replace the computer completely. This one is working
fine, so far. I run OS X 10.2.6. Because of my computer problems, I
have had to install Office v. X a number of times. Apparently, one
too many times, according to my pop up message. Is there a work
around for this? I tried calling microsoft, but waited for over an
hour today for tech support with no one picking up, so i'm putting my
question out to the newsgroup. What is up with Microsoft?
On 9/17/03 12:16 PM, in article
a64b5a2e.0309171116....AD not backing up
I've got DPM 2007. When I try to backup Active Directory to it the agent
just displays unavailable to me. What must I do to resolve this issue. Any
assistance would be great
i would like to ask you some questions first, have you restarted the server
after installing the agent, also have you checked the connectivity between
these 2 servers, have you checked for the firewall ports?
also if possible try to send me the error id and source on both DPM and AD
> I've got DPM 2007. When I try ...How to get a long column of numbers to wrap and print on 1 page?
I have a long column of numbers that we add to daily. This column needs to
be sorted in ascending order and then printed. I don't know of a way to sort
multiple columns together so that is why it is one long column. Is there a
way to get it to print as multiple columns across a page so as to not have
numerous pages with only 1 column on each?
take a look here:
In article <3880FBB4-BF95-4A82-B98A-519C79BF1A34@microsoft.com>,
Sue <Sue@discussions.microsoft.com> wrote:
> I have a long column of numbers th...Using COUNTIF but blank cell if zero
Operating System: Mac OS X 10.6 (Snow Leopard)
I'd like to count how many times "x" appears in a column but leave the cell blank if the count comes to zero. <br><br>I've had a go with =IF(COUNTIF(J3:J37,"x")>0,(COUNTIF(J3:J37,"x"),"")) but am getting an error message. <br><br>What am I doing wrong? <br><br>Thanks in anticipation
On 3/3/10 5:27 PM, Ross_Langmead@officeformac.com wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Sn...In-Cell editing unvailable in address card view
Outlook 2007, SP2 on Windows XP SP3
IMAP/POP email, not exchange
In modify address card view, the option "Allow in-cell editing" is not
available. It's available in phone list view.
Any way to enable it?
How could you? Only table views have cells. That's why it's disabled in
other views. There's no use for it.
"cheerful" <firstname.lastname@example.org> wrote in message
> Outlook 2007, SP2 on Windows XP SP3
> IMAP/POP email, not excha...Excel cell number formatting should have a significant digits opt.
One should be able to format a cell in Excel so that the number of
significant digits stays constant, no matter how the digits or decimal places
change. You get something like this with the "Scientific" number format, but
it's not as intuitive to look at.
maybe the following helps you:
"Sleep Scientist" <SleepScientist@discussions.microsoft.com> schrieb im
> One should be able to format a...how do I display the name of a worksheet automatically in a cell?
I use a rolling 12 months spreadsheet that has a sheet for each month of
activity, and is a home sheet of rother workbooks to connect to and pick up
relevant data. As I delete old sheets and add clone new ones I have to
manually change the title cell name of the sheet to the proper month. I would
like to be able to just change the name of the tab, (example: "Sep_05"), and
have that name propagate to the title cell on that page.
In article <EF733ED6-CCE3-4C98-9057-C1877562975A@microsoft.com>,
Archie N. &...Numbers? automatic
I would like to know is there a way to get excel to automatically put
the decimal at the second position without having to type the point in?
Example I want to type 149 and would like it to read 1.49 Also is
there a way to get it to automatically put the first digit in? As
everything I type into these cells always starts with 1. Can it be
typed in as 49 or.49 and show up as 1.49?
Message posted from http://www.ExcelForum.com/
Use Tools|Options; open the Edit tab and locate Fixed Decimals
Be warned: this is a sticky setting and will apply to all workbooks you
The n...I cant set up my microsoft outlook..just get error
I have set up the following
E-mail address: RosieMayCarter@amaratravel.co.uk
Incoming mail (POP3, IMAP, or HTTP) server: mail.amaratravel.co.uk
Outgoing mail (SMTP) server: mail.amaratravel.co.uk
Account Name: RosieMayCarter%amaratravel.co.uk
Domain Name: amaratravel.co.uk
But it does not work...and I can not put this under the tools as Account
settings does not exist:
- Under Tools >> Account Settings >> Account (Double clicking on each email
account) >> More Settings >> Outgoing Server Tab, check “My outgoing server
(SMTP) requires authentication”
- Und...How can I use a cell reference in Sumproduct array formula?
I have a table with dates down the and employee numbers across the top.
I have SUMPRODUCT formulas in all the cells to gather data from named
arrays from a database in the spreadsheet. I'd like to avoid munually
changing (either individually or with REPLACE) date and employee number
references in each formula in each cell. my formula looks like:
also, I used a previous suggestion from this forum on another similar
spreadsheet (successfully...for fiscal 3/05)with copying the whole
spreadsheet and changing the d...Splitting Text in a Cell
Using Excel XP, I have a cell that has full names of people (First & Last
Can I split these two text somehow recognizing the space in between them?
Brig, have a look at data, text to columns, post back if you need any help
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
"Brig" <email@example.com> wrote in message
news:ed9422dXEH...Problem with Excel getting correct # of records back from Access
I have a qry in MSAccess that brings me 1316 rows, but when I go to excel and
run the qry it only gives me 692 rows. It look like it isn't making it to the
2nd statement or the "Or" statement in the query. Looking at the data in
Excel. I can't remember how to get this to pass all the records over to Excel.
Here's my "Having" part in the Qry:
HAVING ((([Tracking].[Type of Case])="Expedited" Or ([Tracking].[Type of
Case])="Fast Track" Or ([Tracking].[Type of Case])="Standard Pre-Service")
AND (([Tracking].[Appeal or Gr...Can't move from one cell and/or enter any data, or exit wksht...
My worksheet cursor is stuck in one cell and I cant get it to move what has
happened and how does one undo the problem and understand how it can be
Right now I cant get out of excel or perform any functions in the
Has your PC possibly locked up? If so hit Control - Alt - Delete, go to the
task manager, and shut down the program. Then, go back into Excel to see if
you have normal functions now.
"Stuck in One cell" wrote:
> My worksheet cursor is stuck in one cell and I cant get it to move what has
> happened and how does one undo the pr...