cannot change part of a merged cell

Annoying problem...
I merged cells and come time to paste from the clipboard into a merged cell, 
I get the error it can't be done. I can hit F2 and paste. It's an annoying 
step and users who are not quick on the draw with Excel would be stuck.

Is there a way to stop the error and succeed with a paste?

thanks! 


0
shank (44)
4/7/2008 12:46:27 AM
excel 39879 articles. 2 followers. Follow

6 Replies
1512 Views

Similar Articles

[PageSpeed] 43

don't use office clipboard use Ctrl + C & Ctrl +V



On Apr 7, 5:46=A0am, "shank" <sh...@tampabay.rr.com> wrote:
> Annoying problem...
> I merged cells and come time to paste from the clipboard into a merged cel=
l,
> I get the error it can't be done. I can hit F2 and paste. It's an annoying=

> step and users who are not quick on the draw with Excel would be stuck.
>
> Is there a way to stop the error and succeed with a paste?
>
> thanks!

0
muddanmadhu (119)
4/7/2008 2:16:19 AM
Don't use merged cells.

The problem you found is only one of a great many you will come across when
using merged cells.


Gord Dibben  MS Excel MVP

On Sun, 6 Apr 2008 20:46:27 -0400, "shank" <shank@tampabay.rr.com> wrote:

>Annoying problem...
>I merged cells and come time to paste from the clipboard into a merged cell, 
>I get the error it can't be done. I can hit F2 and paste. It's an annoying 
>step and users who are not quick on the draw with Excel would be stuck.
>
>Is there a way to stop the error and succeed with a paste?
>
>thanks! 
>

0
Gord
4/7/2008 8:14:07 PM
....gotta use merged cells. That's the only way to layout a comprehensive, 
tight form and make it look good.

thanks



"Gord Dibben" <gorddibbATshawDOTca> wrote in message 
news:k20lv3p8ddqdc7lju9npknqscgadr054jk@4ax.com...
> Don't use merged cells.
>
> The problem you found is only one of a great many you will come across 
> when
> using merged cells.
>
>
> Gord Dibben  MS Excel MVP
>
> On Sun, 6 Apr 2008 20:46:27 -0400, "shank" <shank@tampabay.rr.com> wrote:
>
>>Annoying problem...
>>I merged cells and come time to paste from the clipboard into a merged 
>>cell,
>>I get the error it can't be done. I can hit F2 and paste. It's an annoying
>>step and users who are not quick on the draw with Excel would be stuck.
>>
>>Is there a way to stop the error and succeed with a paste?
>>
>>thanks!
>>
> 


0
shank (44)
4/7/2008 8:54:00 PM
OK


Gord

On Mon, 7 Apr 2008 16:54:00 -0400, "shank" <shank@tampabay.rr.com> wrote:

>...gotta use merged cells. That's the only way to layout a comprehensive, 
>tight form and make it look good.
>
>thanks
>
>
>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message 
>news:k20lv3p8ddqdc7lju9npknqscgadr054jk@4ax.com...
>> Don't use merged cells.
>>
>> The problem you found is only one of a great many you will come across 
>> when
>> using merged cells.
>>
>>
>> Gord Dibben  MS Excel MVP
>>
>> On Sun, 6 Apr 2008 20:46:27 -0400, "shank" <shank@tampabay.rr.com> wrote:
>>
>>>Annoying problem...
>>>I merged cells and come time to paste from the clipboard into a merged 
>>>cell,
>>>I get the error it can't be done. I can hit F2 and paste. It's an annoying
>>>step and users who are not quick on the draw with Excel would be stuck.
>>>
>>>Is there a way to stop the error and succeed with a paste?
>>>
>>>thanks!
>>>
>> 
>

0
Gord
4/7/2008 10:23:39 PM
Will Format > Cells > Alignment > Horizonal > Center across selection work 
for you?

HTH
Regards,
Howard


"shank" <shank@tampabay.rr.com> wrote in message 
news:%23zzIXjEmIHA.464@TK2MSFTNGP02.phx.gbl...
> Annoying problem...
> I merged cells and come time to paste from the clipboard into a merged 
> cell, I get the error it can't be done. I can hit F2 and paste. It's an 
> annoying step and users who are not quick on the draw with Excel would be 
> stuck.
>
> Is there a way to stop the error and succeed with a paste?
>
> thanks!
> 


0
lhkittle (223)
4/10/2008 11:06:05 AM
nope - that's how it's formatted.


"L. Howard Kittle" <lhkittle@comcast.net> wrote in message 
news:7Lqdne1ug74BaWDanZ2dnUVZ_qGknZ2d@comcast.com...
> Will Format > Cells > Alignment > Horizonal > Center across selection work 
> for you?
>
> HTH
> Regards,
> Howard
>
>
> "shank" <shank@tampabay.rr.com> wrote in message 
> news:%23zzIXjEmIHA.464@TK2MSFTNGP02.phx.gbl...
>> Annoying problem...
>> I merged cells and come time to paste from the clipboard into a merged 
>> cell, I get the error it can't be done. I can hit F2 and paste. It's an 
>> annoying step and users who are not quick on the draw with Excel would be 
>> stuck.
>>
>> Is there a way to stop the error and succeed with a paste?
>>
>> thanks!
>>
>
> 


0
shank (44)
4/10/2008 1:08:46 PM
Reply:

Similar Artilces:

How to Filter cells and save the file with certain criteria?
Hello. I have a Excel file that contains a large list of Tracking Numbers. The tracking numbers are from two sets of order types- Internet orders and Mail Orders. Orders that are from the Internet are matched up with a order number such as "5678". Orders from the mail-order side are designated by initials "MO". So in Excel it'll look something like this: trackingnumber orderid 123365656666 5467 152155896345 5468 123365634567 MO 152134567789 5469 152151234563 MO Is there a way to eliminate the Mail-Order rows and save the Excel file to ...

Email Merges via Quick Campaign
Hi: How can I send messages using a different email address when using the Quick Campaign Feature? I have experimented several times, but can't find a solution with using another AD account when sending bulk emails. Please help. Thanks. ...

pasting into merged cells #2
Every time I try to copy and paste data into a merged cell I get error messages about the cells not being the same size. Even if I try to just paste values only. Is there any workaround or fix for this??? Dennis Try pasting into the formula bar. It's a pain, but it works. HTH Carole >-----Original Message----- >Every time I try to copy and paste data into a merged cell I get error >messages about the cells not being the same size. Even if I try to just >paste values only. Is there any workaround or fix for this??? > >Dennis > > >. > See my res...

Changes to the global template
Recently I had to start a new username because of some corrupted files. I was able to save my documents. However, everytime that I quit microsoft office a dialogue box appears and says: "Word cannot save changes to the global template because it was opened with read only access. Do you want to save the changes in a template with a different name?" Initially I tried to save it, because I was afraid that the changes to my document would not be saved. Now I click save, and the next dialogue box appears: "Microsoft Visual Basic" "Run-Time errror "5995" Word c...

3.0 Mail Merge
Is anyone experiencing this issue post upgrade to 3.0.....? When attempting to Print Quote for Customer in Outlook, we select the quote template, then Microsoft Word opens. From here the mail merge functions would begin. However, the mail merge toolbar is grayed out and we cannot merge to new document. We can't do anything. Is the process for Print Quote for Customer different in CRM 3.0? Or is this an issue? If so, can anyone provide assistance on this. Thank you! Cayla Will the templates we had set up to use in CRM 1.2 (for mail merging) still function in 3.0? Or are there ...

V4 Mail Merge on Custom entities
Hello We have noticed that new entities added at v4 appear in the mail merge list but that custom entities carried over when upgrading a v3 system do not. Does anyone have any information on how this is controlled and whether there is an option to set an entity as included once it has been created ? All info gratefully received Thanks...Phil That should help: http://blog.sonomapartners.com/2008/01/enabling-mail-m.html Cheers -- George Doubinski CRM Certified Professional - Developer Blog: http://crm.georged.id.au/ "Phil Kedward" <Phil Kedward@discussions.microsoft.com...

cell protection to allow GROUP/UNGROUP function
2 asthetic questions for all you advanced Excel Users.... Q1. is it possible to protect a worksheet, but still be able to us the +GROUP & -UN GROUP buttons ? to expand / contract the viewe ranges? Q2. anyone know how to change the colour of the AUTO FILTER button - i changes from black to dark blue when activated - i would like to hav this with more contrast and so it jumps out at you ( and the othe plebs in the office who keep forgetting) Regards David ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages dire...

Highlight Cells with different values
Hi, I have a column that I want to locate the differences. I can use the F5---Special---Column Differences. But I wanted to know if I can do it with Conditional Formatting. Like if Value in A1 is different than the values in Column A:A, then it is highlighted... Any help appreciated Fuad Sounds like an Excel question..try one of the Excel newsgroups, this one is for Publisher. "Fuad" <Fuad@discussions.microsoft.com> wrote in message news:0536FB95-362E-412F-BD1C-99BF9B10E8CD@microsoft.com... | Hi, | | I have a column that I want to locate the differences. I can use th...

Language change in outlook express
Hi, I cannot change th language to english in outlook express by defult it has French. please help me how to change in options. i check all my regional settings shows english(us) execpt in word and express. -- Nisha P nishkrish <nishkrish@discussions.microsoft.com> wrote: > I cannot change th language to english in outlook express by defult > it has French. Ask in an Outlook Express newsgroup. microsoft.public.outlookexpress.general -- Brian Tillman [MVP-Outlook] nishkrish Ask in the Outlook Express newsgroups Outlook Express with IE7 http://www.microsoft.com/co...

How to total cells in a range with data input
Greetings to all members I am running Excel 97. An office colleague presented me with an issue that might be of interest to any Excel whiz and seasoned programmers. I would certainly appreciate any pointers in solving it. So here goes. The set of values includes 33 cells ranging from B4:D14. The data type is numeric. Data is only input in a few cells. QUESTION What would be the function to enter in, say, cell A15 to indicate the total number of cells in range B4:D14 that have received data input? Or does it involve some behind the scene VBA programming? EXAMPLE B6 = 9 C9 = 4 D11 ...

How do I protect one single cell?
I have a spreadsheet where people are going to type in numbers, and the final cell is a total, which of course I don't want people to accidentally type over, as it will lose the formula behind it. So...... I put some "data validation" behind that cell, to say only allow entries of text length = 50 - a kind of "mock" condition. Nobody'e ever gonna type in 50 chars. are they?! And sure enough, typing in (eg) 854221 brings up the error box to stop them, just like (eg) HHJSYT brings up the error box to stop them. I even unchecked the ignore blank" box, so that ent...

change direction of cursor after enter
In excel 2003, how do I change cause the cursor to go the next cell to the right, rather than to go to the cell below? Thank you! Tools > Options > Edit > Move selection after Enter > select Right. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk "duke" <jbrown2lt@msn.com> wrote in message news:9793815c-97dc-4894-9adc-f3c43d71c91d@i29g2000prf.googlegroups.com... > In excel 2003, how do I change cause the cursor to go the next cell to > the right,...

How-To: Last change date on row
When I set up a database I always include a last change date that auto updates every time any field in the record changes. Does anyone have a suggestion for how to achieve a similar function in a spreadsheet. i.e. put the current date/time in a field in the row whenever anything in the row changes? -- GGG ------------------------------------------------------------------------ GGG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29220 View this thread: http://www.excelforum.com/showthread.php?threadid=489447 GGG, For example, to put the last change date in...

Stop running sum(Over All) when customer change
Dear All I hv report based on tblTransaction which contains many customers with their transactions by date wise. I grouped report on CustomerID sub Group by Fromat(trnDate,”MMM-YY”) to get monthly transactions for each customer. I made calculated field to obtained closing balance with running sum over Group. I want to make the Running sum – over all but when customers is changing it must stop and start again, by default it will give running sum of all the customer, exactly this I don’t want. Any idea to stopped or make running sum based on customer when month is changing it ...

The recalcitrant active cell.
I am way over in column EO, reconnoitring data, when I need assistance of a "what if", I activate the auto filter, and the active cell jumps back to A1. any workarounds for this annoying habit? Thanks in advance. Works for me, if I filter on something in one column and the active cell is there as well it won't change to A1 2 guesses, your active cell was A1 from the start even though you filtered on EO you have a recorded macro that was setup to go back to A1 -- Regards, Peo Sjoblom "Rodney" <rodney@touch88gum.com.au> wrote in message news:u3PI%...

How to change labels on a chart from numbers to words?
Can Someone Please help me? I can't figure out how to change the labels on my chart in excel from numbers to words! I'm not sure which labels you want to change to words, but maybe Jon Peltier's charting tutorial will help you: http://www.peltiertech.com/Excel/ChartsHowTo/index.html Arin wrote: > Can Someone Please help me? I can't figure out how to change the labels on my > chart in excel from numbers to words! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html I suspect it's this page: http://peltiertech.com/...

Batch Number Changed
I recently upgraded GP from Ver. 8 to 10. few days back i notices that around 800 SOP orders transfered to One batch. This Batch was not existing before. system created the batch. How this could happen? i checked in the activity tracking table, no clues from there. ...

Change Password Next Login, Enforce Password Policy and Expiration
I'm curious why are the Change Password Next Login, Enforce Password Policy and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a user. my client want to know how to enable it. hope for your prompt action. -- Jeremy Ayaay Technical Specialist STRC Only works for SQL 2005. If you client wants to use a beta database server... "Jher" wrote: > I'm curious why are the Change Password Next Login, Enforce Password Policy > and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a > user. my client want to know how to enab...

How To Add Rows and Cells in The Table Using IHTMLTable
Hello Everyone, I am currently working on the DHTML Dialog Based Application. I have been stucked due to a problem, which is that my HTML Page contains a HTML Table element and a button, i want my application to add rows and cells on the click event of that button. I have captured the event of the button but i am unable to add rows and cells in the table. Can anyone tell me how to acheive that by using the IHTMLTable interface. Thanks in advance. From, Ghazanfar Ali. "Ghazanfar Ali" <ghazanfarali17@hotmail.com> wrote in message news:uMq8CiCjFHA.1416@TK2MSFTNGP09.phx.gb...

change from SIZE ON DISK: 4:00kb
I am using publisher 2000. How can I can size on disk: 4:00KB into bigger number such as 16:00KB in "properties" menu. thank: nguyen You can't. The file size is what it is because of the content. Why do you want to change the file size? This won't help you to open it. If you are getting an error message, that's a different story. Are you running Norton Antivirus on your system? -- JoAnn Paules MVP Microsoft [Publisher] "nguyen" <anonymous@discussions.microsoft.com> wrote in message news:2b6401c4be29$c5da6f60$a301280a@phx.gbl... >I am using ...

A Macro that will cut and paste to specific cell
I import tables from web into excel. These tables vary in size. Therefore one day the first table may go from A:7 to P:20 then the second table starts at A:22 and ends at P:40 and so on. Then the next day the first table may be A:7 to P:12 and the second A:14 to P:33. I need each table to have the same starting point each day. I have been cutting and pasting each individule table to achieve this. Is there a macro that can do this or a macro at the very least if highlight the table will then cut and paste for me to a specific cell. Thank you for any help you can give Hi, can you send me...

How to get combo box selected index changed event in another page from the existing page in winforms
Hi, I am working on windows forms project. I have two winforms (window1 and window2). I have a combobox called cmbEmail in window1 and Textbox called txtName in window2. I want to retrieve some information into the txtName in window2 when I selected something from cmbEmail in window1. If I write code to retrieve something into the txtName (which is in window2) in cmbEmail SelectedIndexchanged event in window1, I will get an error of txtName doesn't exist in this page. Can anybody help me to solve this problem.. Thanks and Regards Naresh "Naresh" &...

format cell to change color when copied
I do alot of cut and pasting. Is there a code that will change the color of a cell if I right click to copy it, so I can track what I have worked on? Thanks, Tawnee -- tawnee jamison ------------------------------------------------------------------------ tawnee jamison's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16137 View this thread: http://www.excelforum.com/showthread.php?threadid=346063 Tawnee Can be done, but you'll soon end up not knowing which was which. Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, _ Cancel As Boolean) ...

Merge data by macro
Hi all, I got data in column A and B as show below. Row A B ......col 1 ID DATA ...headings 2 XY01 Record 3 Time 4 Left 5 XY02 Time 6 Right 7 XY03 System 8 Record 9 Time 10 Left I need macro which should merge column B data and put result in column C as shown below Row A C ......col 1 ID DATA ...headings 2 XY01 Record Time Left 3 4 5 XY02 Time Right 6 7 XY03 System Record Ti...

how to merge data from multiple columns to one column #2
I have first, middle, and last names in A, B, and C. I want to merge everything into A. Ho do I do that? In column D use the formula =A1&" "&B1&" "&C1 The " " would put in your spaces in between the names. Then go to column D & do Edit Copy, move to column A & do Edit Paste. Then you should be able to delete columns B, C & D. Hope that helps! >-----Original Message----- >I have first, middle, and last names in A, B, and C. I want to merge >everything into A. Ho do I do that? >. > =CONCATENATE (text1,text2,....