Formatting does not follow when copying from one cell to another

I have a cell on sheet 1 that I have added text to with some bolding, 
coloring of text, etc. On Sheet 2 I have a cell that I have told to copy 
whatever is in the cell on sheet 1 described above.  Why doesn't the 
formatting copy over too??
0
Utf
4/7/2010 8:55:01 PM
excel.worksheet.functions 4936 articles. 2 followers. Follow

7 Replies
1484 Views

Similar Articles

[PageSpeed] 17

A formula returns a result, not any formatting.

Pete

On Apr 7, 9:55=A0pm, Banker <Ban...@discussions.microsoft.com> wrote:
> I have a cell on sheet 1 that I have added text to with some bolding,
> coloring of text, etc. On Sheet 2 I have a cell that I have told to copy
> whatever is in the cell on sheet 1 described above. =A0Why doesn't the
> formatting copy over too??

0
Pete_UK
4/7/2010 10:19:30 PM
"told to copy" means you have used a linking formula such as  =Sheet1!A1

Linking formulas do not bring over formatting............values only.


Gord Dibben  MS Excel MVP

On Wed, 7 Apr 2010 13:55:01 -0700, Banker <Banker@discussions.microsoft.com>
wrote:

>I have a cell on sheet 1 that I have added text to with some bolding, 
>coloring of text, etc. On Sheet 2 I have a cell that I have told to copy 
>whatever is in the cell on sheet 1 described above.  Why doesn't the 
>formatting copy over too??

0
Gord
4/7/2010 10:39:38 PM
That is exactly what I am doing.  Are there any other options?

"Gord Dibben" wrote:

> "told to copy" means you have used a linking formula such as  =Sheet1!A1
> 
> Linking formulas do not bring over formatting............values only.
> 
> 
> Gord Dibben  MS Excel MVP
> 
> On Wed, 7 Apr 2010 13:55:01 -0700, Banker <Banker@discussions.microsoft.com>
> wrote:
> 
> >I have a cell on sheet 1 that I have added text to with some bolding, 
> >coloring of text, etc. On Sheet 2 I have a cell that I have told to copy 
> >whatever is in the cell on sheet 1 described above.  Why doesn't the 
> >formatting copy over too??
> 
> .
> 
0
Utf
4/8/2010 1:34:01 PM
Do you know of any other options/?

"Pete_UK" wrote:

> A formula returns a result, not any formatting.
> 
> Pete
> 
> On Apr 7, 9:55 pm, Banker <Ban...@discussions.microsoft.com> wrote:
> > I have a cell on sheet 1 that I have added text to with some bolding,
> > coloring of text, etc. On Sheet 2 I have a cell that I have told to copy
> > whatever is in the cell on sheet 1 described above.  Why doesn't the
> > formatting copy over too??
> 
> .
> 
0
Utf
4/8/2010 1:35:02 PM
Copy and Paste.
--
David Biddulph


"Banker" <Banker@discussions.microsoft.com> wrote in message 
news:95869E63-FA26-479E-8AA7-242F29955C0C@microsoft.com...
> Do you know of any other options/?
>
> "Pete_UK" wrote:
>
>> A formula returns a result, not any formatting.
>>
>> Pete
>>
>> On Apr 7, 9:55 pm, Banker <Ban...@discussions.microsoft.com> wrote:
>> > I have a cell on sheet 1 that I have added text to with some bolding,
>> > coloring of text, etc. On Sheet 2 I have a cell that I have told to 
>> > copy
>> > whatever is in the cell on sheet 1 described above.  Why doesn't the
>> > formatting copy over too??
>>
>> .
>> 

0
David
4/8/2010 10:10:56 PM
Thanks for the response.  I know the Manual function of Copy/Paste will work 
but I am trying to automate the spreadsheet so there is less manual work with 
repeating information.  I appreciate your time.

"David Biddulph" wrote:

> Copy and Paste.
> --
> David Biddulph
> 
> 
> "Banker" <Banker@discussions.microsoft.com> wrote in message 
> news:95869E63-FA26-479E-8AA7-242F29955C0C@microsoft.com...
> > Do you know of any other options/?
> >
> > "Pete_UK" wrote:
> >
> >> A formula returns a result, not any formatting.
> >>
> >> Pete
> >>
> >> On Apr 7, 9:55 pm, Banker <Ban...@discussions.microsoft.com> wrote:
> >> > I have a cell on sheet 1 that I have added text to with some bolding,
> >> > coloring of text, etc. On Sheet 2 I have a cell that I have told to 
> >> > copy
> >> > whatever is in the cell on sheet 1 described above.  Why doesn't the
> >> > formatting copy over too??
> >>
> >> .
> >> 
> 
> .
> 
0
Utf
4/9/2010 6:47:01 PM
I think you will have to go with VBA for your automation if you need the
formatting copied over along with the data.


Gord Dibben  MS Excel MVP

On Fri, 9 Apr 2010 11:47:01 -0700, Banker <Banker@discussions.microsoft.com>
wrote:

>Thanks for the response.  I know the Manual function of Copy/Paste will work 
>but I am trying to automate the spreadsheet so there is less manual work with 
>repeating information.  I appreciate your time.
>
>"David Biddulph" wrote:
>
>> Copy and Paste.
>> --
>> David Biddulph
>> 
>> 
>> "Banker" <Banker@discussions.microsoft.com> wrote in message 
>> news:95869E63-FA26-479E-8AA7-242F29955C0C@microsoft.com...
>> > Do you know of any other options/?
>> >
>> > "Pete_UK" wrote:
>> >
>> >> A formula returns a result, not any formatting.
>> >>
>> >> Pete
>> >>
>> >> On Apr 7, 9:55 pm, Banker <Ban...@discussions.microsoft.com> wrote:
>> >> > I have a cell on sheet 1 that I have added text to with some bolding,
>> >> > coloring of text, etc. On Sheet 2 I have a cell that I have told to 
>> >> > copy
>> >> > whatever is in the cell on sheet 1 described above.  Why doesn't the
>> >> > formatting copy over too??
>> >>
>> >> .
>> >> 
>> 
>> .
>> 

0
Gord
4/10/2010 12:11:49 AM
Reply:

Similar Artilces:

copy #3
How can i copy difference cells from one worksheet to the next worksheet the date is in cell a1. i have about ten worksheet that the infomation coming from it must place in order in the next worksheet by date in order of date If your data is in rows, then copy each row to the destination sheet without regard to the date. Once the copying is complete, sort by column A to put the rows in order. -- Gary''s Student "lloyd_scotland2005@yahoo.com" wrote: > How can i copy difference cells from one worksheet to the next > worksheet the date is in cell a1. i have about t...

Suppressing auto format in Excel
I have a .CSV file that is automatically generated by a program. Apparently, when the file is opened with Excel, the numeric fields that are enclosed in double quotes in the file and look like "123,456.1234" are being formatted by Excel and displayed with only 2 decimals. The cause of the problem seems to be the comma in the number, which I don't really want to remove. Is there any way to suppress automatic cell formatting in Excel, so the contents could be displayed just the way it appears in the source file? In the Text import wizard - step 3 of 3 - select the offending colu...

Pivot Table Cell Formatting
A pivot table "seems" to want to define all the cells within the table as numbers. Several columns of data within my source data are character (i.e. Y/N). The pivot table displays all Y and N's as a 1 when the cell is defined as a count. If you change to a sum or any other "available" types, they display as 0's. I can't seem to get around this. I want the Y or N value displayed. Any ideas or suggestions. Thanks, Jim G. Hi Jim the data section of a pivot table can (AFAIK) only consist of (aggregated) values. That is counts, sums, averages, etc. You're not ...

Make $15,000 in one month guaranteed
Hello, No need to purchase just click or copy and paste the link YOUR JAW WILL HIT THE FLOOR WHEN YOU HEAR WHAT I'VE GOT TO SAY I'm about to present you with the most amazing income opportunity you have ever seen. So far i have made $24,000 + this month alone. CASH MAGNET Please click link to see for yourself. No need to pay aution cost. The link is free. http://www.the-cash-magnet.com/index.php?uid=3D1816 I tested this product as part of research into so called money making schemes and was blown away. I just want to tell everyone i can and anyone who like me wants to earn more m...

Copy to Clipboard using Dexterity
Hi, I want to override the Line_Pre event to copy the Item No to the clipboard. Is it possible to copy a text field' value to clipboard in Dexterity? Thanks. MH. Why would you want to do this? If you are attempting to 'save' the item number value somewhere before you override with your script won't it make sense to store it to a global variable or a local variable? Working with the clipboard is simply not practical. Best regards, -- MG.- Mariano Gomez, MIS, MCP, PMP Maximum Global Business, LLC http://www.maximumglobalbusiness.com The Dynamics GP B...

Copies of messages
I have a client with SBS2003 including Exhange Server 2003. The client wants to be able to see all the email being sent to and sent from his employees. Is there a way to have a copy of all incoming emails go to another (the administrator?) mailbox? Is there a way to copy outgoing messages to another mailbox, too? If not, is there another way to accomplish the same thing so that the small business owner can monitor his employees' emails? Thanks, Mark http://www.exchange-forums.com/phpBB2/viewtopic.php?t=96 Will http://www.exchange-forums.com "MarkR" <MarkR@discus...

Put Results in another cell
OK guys/gals - I know this MUST be simple, but I'm very new to excel. I'm trying to look at one column (A), if the work "Dist" or "Sale" is in the Cell, I would like to fill the next column (B) with "--", otherwise, leave the values alone in column B. =IF(OR(A1="Dist",A1="Sale"),B1="'--", otherwise leave value alone in B1 Thanks for everything! To clarify, I would like my formula to reside in column (B), but there is other info already in that column. If the condition in column (A) is met, then (B) must change, ot...

Excel using =RC[-1] format and I don't want it
On this machine only, Excel will use the format =RC[-1] when I am entering a formula on the command line by hand and click on a cell to reference it in the formula. I don't know how this got on but I would like it to go off. On my other machines, it does the old familiar A1:B2 style of cell reference. I can't even search for how to fix it since I can't determine what this is called so I can turn it off. The only reference I have seen is a button that is only effective for macro creating and I am not creating a macro, just a formula, interactively, in the cell. How ...

Transfer Non Inventory receipt to another project in PA
Hello- We have non-inventory items on a PO that have already been received and invoiced against Project A. Is there any way to transfer them to Project B? We just realized that they were originally issued against the wrong project. Please advise. Thanks! Marisol, You can create a Return by selecting the Type as Return in Inv Transfer Entry in Project | Transactions | Inventory Transfer. Then, Send the same to appropriate Project using Project | Transactions | Inventory Transfer, now selecting Standard as Type. -- Thanks Janakiram M.P. MCP-GP http://janakirammp.blogspot.com &...

Macro to select & autofill adjacent cells
I would like to create/use a macro that selects a cell to the right of highlighted cell and the two directly below. I then want to autofil down this selection. I've tried to record a macro for this, but i always performs the task at the same range - but I want it to wor wherever I choose to highlight a cell from. Does anyone know how thi can be accomplished? Sincerely, Ti -- Message posted from http://www.ExcelForum.com Hi! Yes: lots of people will know how;) Why not post your macro: someone will show you how it can be tuned t do more than just fill the three cells you recorded it f...

Sending kbd & mouse input to another computer
Hello, I am trying to send keyboard and mouse input to another computer in order to be able to control that computer remotely. Sort of like a Virtual Desktop or VNC but I'm not concerned with the graphics part. I put together little client and server apps. The server app sits on the remote computer. At the local computer, the client app sits and listens for Keyboard and mouse messages (WM_KEYDOWN/WM_KEYUP, WM_MOUSEMOVE, etc..). It then transmits those messages to the server (remote computer) via TCP. The remote server then translates those messages into SendInput calls. It...

Conditional Format: Dates
Date is displayed in cell like this: Thursday, January 01, 2004 Currently, cells have no cell color format. How can I set formatting so cells containing 'Sunday' are a different color? Is there a formula I can use or some function that will do this for me? If the dates are text use =ISNUMBER(SEARCH("Sunday",A1)) in the formula is box, if they are real dates use =WEEKDAY(A1,2)=7 format>conditional formatting and formula is -- Regards, Peo Sjoblom "JEM" <abc@def.com> wrote in message news:emRrHL1IEHA.2688@tk2msftngp13.phx.gbl... &g...

Convert Campaign Response to another record
When I convert a Campaign response to an Opportunity it is already 'created'. This means that the create callout has already fired, before the user can enter information it requires (so it fails). Another strange thing is that although the call out fires, the 'create' workflow does not seem to run, meaning that I get the worst of both worlds! Has anyone figured out a way to use the 'convert to record' functionality without the resulting record already being 'created'? ...

Variant Array Copy, Array row contains Object
Hi All, For the first time I had a need to put an object inside a two dimension variant array. The proc below was for some initial testing. I had to code an object test at the line marked with 1. I was surprised that the 'copy' at line 2. worked. Can you tell me why? Thanks. Neal Z. Sub Test() Dim vArray, vArrayB Dim Row As Long, Col As Long ReDim vArray(1 To 2, 1 To 2) Set vArray(1, 1) = ActiveWorkbook vArray(1, 2) = "abc" vArray(2, 1) = 24 Set vArray(2, 2) = ActiveSheet ReDim vArr...

How To Find "x" In A Column And Show "y" In Cell "z"
Example: A1 = aircraft type B1 = flight time C1 = jet category Is there a way to maintain a list somewhere in the book of aircraf types that are of the jet variety so that when "A2" is checked agains the list it knows whether or not it is in fact a "jet" and will ente the time (which is in "B2") under the jet category ("C2"). Otherwis it simply will ignore adding flight time to the "C" column? Did I just confuse everyone? Thanks in advance. thanks r -- rcan ----------------------------------------------------------------------- rcane&...

Data showing up in Cells as ####
I'm trying to enter an amount in a Column labeled "Limit"...I've tried changing the cell's format but no matter what I do, the data shows up as ####. How can I change this to reflect the actual numbers? -- MCD Increase the column width >-----Original Message----- >I'm trying to enter an amount in a Column labeled "Limit"...I've tried changing the cell's format but no matter what I do, the data shows up as ####. How can I change this to reflect the actual numbers? >-- >MCD >. > Or reduce the Font size?? anonymous@discussi...

Can you create and send e-newsletters longer than one page?
While Publisher lets me create an e-newsletter longer than one page, it won't let me e-mail it in the body of the e-mail. I'm not looking to write a book, but three stories is a bit too limiting. Any ways to trick the technology into letting me have my way with it? http://ed.mvps.org/Static.aspx?=Publisher/multipageemail -- JoAnn Paules MVP Microsoft [Publisher] "kRo" <kRo@discussions.microsoft.com> wrote in message news:E8596441-7317-4CEF-B972-F689BEF16399@microsoft.com... > While Publisher lets me create an e-newsletter longer than one page, it > w...

Preventing auto-formatting when Replacing
Say I have a cell that contains LED2/14 The cell is formatted as Text. If I use Ctrl-H to replace LED with nothing, Excel insists on reformatting the remaining 2/14 as a date (i.e. 14-Feb). Is there any way to prevent this infuriating behavior? Thanks, Frank How about: Edit|Replace LED with ' (apostrophe) Frank Marousek wrote: > > Say I have a cell that contains > > LED2/14 > > The cell is formatted as Text. > > If I use Ctrl-H to replace LED with nothing, Excel insists on reformatting > the remaining 2/14 as a date (i.e. 14-Feb). Is there any way to...

please post a 2006 calendar iin excel format. thank you.
---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=21daf53e-db8a-443e-a122-d0e35c3e84aa&dg=microsoft.public.excel.misc Try File > New and look at the templates available. In particular http://offic...

Counting Rows/Columns for Copying Formulas
I have two spreadsheets in a workbook as follows: Source Worksheet contains by customer each product it purchases and the sales for each product (see sample below). Not all customers buy each product. There are also new customers added/deleted each month and new products added/deleted each month. Column A Column B Column C January February..... Customer A Product Code 1 Customer A Product Code 1 100 Customer A Product Code 2 200 Customer A Product Code 3 300 Customer B Product Code 1 500 Customer B ...

duplicate cells
I have a spreadsheet of Names and addresses. the list is very large (about 8000) there are quite a few duplicate entries that I would like to eliminate. is there a formula or a uncomplicated method that will do this for me? bear in mind that I am a novice with excel spreadsheets.d appreciate any help. Thanks Richard, have a look at Chip's site for a way to do it. http://www.cpearson.com/excel/deleting.htm#DeleteDuplicateRows You may also what to have a look here on getting started with macros http://www.mvps.org/dmcritchie/excel/getstarted.htm if you need more help post back with...

Formatting Cells Question
Hi I am having troubles with formatting cells in EXCEL 2003. I have a column of many hundreds of rows lthat contain data like this: 01Jan12 on fist glance this looks like a date but it really is not. EXCEL on the other automatically assumes it is a date and formats as such. 2001-Jan-12 I have tried formatting as text, General and even experimented with custom formats to no avail. In the same column I have 03Mar1543 Which is dispolayed exactly as is. How can I get EXCEL to simply display data like 01Jan12 exactly as is? You must format the cell as Text BEFORE typing any information...

Chart formatting #3
Is there a way to shade certain areas of a line graph? I have a simple line graph extending horizontally from point 1 to 10 on the x-axis. I would like to shade the entire background area of the graph from points 2-4 and points 6-8. Is there a way to make the graph apear that the background is grayed out between these points. Thanks Chris Chris - This has been sitting here a long time... Make a combo chart. Start by locking the Y axis scale parameters (uncheck the auto boxes). Add a series to your chart which has zero values where you want no shading and <Y axis max> where ...

insert an order number when another sheet opens
I have a form and every time I open it I need it to create a new number. Is this possible. also if I put it a number that does not correspond to an other number can it give me a warning. Thank you so much for your help Carmen cbucco@buccocouture.com ...

Moving a symbol within a cell
On imported data I often have the minus sign for a number appear on the right side of the numbers instead of the left side, I need to move it to the left so the cell data is a number and not text. Also not all numbers in the sheet are negative numbers. Is there a way to move this symbol within a pertinent cell without affecting the rest of the data and not doing it manually cell by cell. Hi! Have a look at http://www.asap-utilities.com/ which has an excellent freely-downloadable Add-In. One of the utilities in it does what you are looking for. Alternatively, put =--("-"&...