| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying cells
Never had this before but how do I do it? I have a range of cells say A1 to D10, I tried to copy the cell contents to another sheet and while the cells controlled by macros copied the info the ones controlled by formulas returned ####ref How do I just copy the cell contents? my line manager only needs the figures in the cells so doesn't need to see my attempts at making them look better;) -- BrianT ------------------------------------------------------------------------ BrianT's Profile: http://www.excelforum.com/member.php...o&userid=35954 View this thread: http://www.excelforum.com/showthread...hreadid=557551 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying cells
Copy as usual (<Ctrl<C), move to the new sheet, click where you want to
paste, right click, select Paste Special, select Values and OK out will do it for you "BrianT" wrote: Never had this before but how do I do it? I have a range of cells say A1 to D10, I tried to copy the cell contents to another sheet and while the cells controlled by macros copied the info the ones controlled by formulas returned ####ref How do I just copy the cell contents? my line manager only needs the figures in the cells so doesn't need to see my attempts at making them look better;) -- BrianT ------------------------------------------------------------------------ BrianT's Profile: http://www.excelforum.com/member.php...o&userid=35954 View this thread: http://www.excelforum.com/showthread...hreadid=557551 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying cells
Copy the cells, select the destination, right-click
Paste special Values. HTH George Gee "BrianT" wrote in message ... Never had this before but how do I do it? I have a range of cells say A1 to D10, I tried to copy the cell contents to another sheet and while the cells controlled by macros copied the info the ones controlled by formulas returned ####ref How do I just copy the cell contents? my line manager only needs the figures in the cells so doesn't need to see my attempts at making them look better;) -- BrianT ------------------------------------------------------------------------ BrianT's Profile: http://www.excelforum.com/member.php...o&userid=35954 View this thread: http://www.excelforum.com/showthread...hreadid=557551 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatic copying of cells ? | New Users to Excel | |||
| Copying Cells | Excel Worksheet Functions | |||
| copying the same cells from many sheets | Excel Worksheet Functions | |||
| Excel should allow cloaking of certain cells when copying cells b. | Excel Worksheet Functions | |||
| Automatic copying data excluding blank cells | Excel Worksheet Functions | |||
Linear Mode
