Question about Microsoft Excel for PC

1 Answer

Cells copies post as bitmap

Sometimes when I paste a copied cell it pastes the whole sheet rather than just the contents of the cell. If I choose paste special it comes up with the bitmap. I don't know what I am doing wrong

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

I think you are referring to 2003 onwards when this problem appears - in which case at the bottom right hand corner of any pasted item is a list of options and buttons which will refer to the table. cells or image being pasted.


Click on the table option to retain your formatting.

Posted on May 22, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

How do you copy and paste one excel spreadsheet to another making sure the headers are lined up correctly.


right-click the sheet you want to copy, select "copy to", then either select the position within the current document, select annother document (needs to be open in the same excel instance) or select "new document". check the box "copy" to copy, leave unchecked to move.

Jan 01, 2016 | Microsoft Excel Computers & Internet

2 Answers

In one cell I am trying to add the text .jpg to the data from another cell but I keep getting error when entering for example =J259&".jpg" , also the content of cell J259 is a formula which is...


This is a long shot ... I dont know what spread sheet you are having trouble with. It might be that your sheet thinks you are entering text when you put in the reference "J~" Be dure you are entering a formuila and not test that looks like a formula (to you)

Sep 14, 2009 | Computers & Internet

1 Answer

In Excel find/replace multiple cells when using wilcards?


I don't recognize cell names beginning with an exclamation(!). It usually separates sheetname from cell name, like sheet1!C2. (Probably don't want the "!".) Usually you use names like C2 or $C2 or C$2 or $C$2 for movable cells or partially or fully absolute addresses. The last form doesn't change on moves or copies.
With find and replace you could use just the partial string 2 for find and 4 for replace.
Better yet, copy the cells you want as source and you can just paste the new location and Excel will adjust the non-absolute parts of addresses. (Drag and Drop may apply but Copy and Paste always works.)
There are restrictions on non-contiguous selections. -Ken

Jul 15, 2009 | Computers & Internet

1 Answer

I had data on sheet one and for same the text format on another i want to copy data in the sheet having text format for particular cell reference which is there on first sheet


Try using "Paste Special". Select the data you want to copy. Position your cursor on the new sheet. Select Edit / Paste Special. Try the "Values and number formats". If that doesn't copy all the formatting you want, on the second time select "Formats". I often do this as a two step process: do a normal cut and paste, then go back and do a "Paste special" selecting "Formats" to get the formatting correct.

Jun 26, 2009 | Microsoft Excel for PC

1 Answer

MS Excel-Values in the formula in place of cell reference


Copy the cell(s) and then right click on the cell(s). Choose Paste Special and then choose Value. That will convert it.

Jun 22, 2009 | Microsoft Excel for PC

1 Answer

How to copy 395.6 and paste only 396 and copy 395.4 and paste 395


two options - 1st format the cells where you will paste (e.g. highlight one column - "the paste to column") by right clicking and choosing format cells, then number and set number of decimal places to 0 - then when pasting instead of usual paste (right-click>>paste or Cmd-V) choose Paste Special (right-click>>Paste Special) then choose Values so you don't override the format with the paste

option two - similar but just wait until you've pasted and format the pasted cells as Number>>0 decimal places.

Cheers,

Mar 26, 2009 | Microsoft EXCEL 2004 for Mac

2 Answers

Copy formulas


It should work if you just copy and paste it. Or select the range of your working area and right click in destination cell and choose paste special. When new window pop up, just choose Formula.

It should work usually, but by any chance you've encountered the problem regarding this. Just let me know...i'll try to help you...


P.S.: If this information was helpful, please rate this solution.

Mar 23, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Exel 2003


You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (!) to the cell reference. In the following example, the AVERAGE worksheet function calculates the average value for the range C1:C10 on the worksheet named Marketing in the same workbook.

default.aspx?assetid=za010939481033 Refers to the worksheet named Marketing default.aspx?assetid=za010939491033 Refers to the range of cells between C1 and C10, inclusively
  1. Click the cell in which you want to enter the formula.
  2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) default.aspx?assetid=za060515351033, type = (equal sign).
  3. Click the tab for the worksheet to be referenced.
  4. Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

1 Answer

Can we replace column & rows label with each -other if yes ,How?


First, select all the data you wish to transpose, and hit <CTRL>+<C> to copy it. Next, open a new sheet, and select the cell you want to be the top-left cell of your data (usually A1). Now, go to the Edit menu, select "Paste Special" and select "Transpose" from options presented.

If you choose, you can copy this sheet back to the original location.

Dec 29, 2007 | Computers & Internet

1 Answer

Formula


You can copy any selected cell(s), and then in the sheet you want a link in, select 'Paste Special' from the Edit menu, and then choose 'Paste Link.' I have assumed that you're working in Excel, since you mentioned sheets. The pasted link will update any time you open the second sheet with the links in it.

Oct 13, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

102 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18330 Answers

Prashant M
Prashant M

Level 3 Expert

2259 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...