| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting an excel sheet without the formatting.
Is there any way to insert an excel data to another new sheet without the
original format of the first sheet. If I have date, percentage in my first sheet, will my second sheet keep that format or will it paste that also as a normal text? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting an excel sheet without the formatting.
When you go to copy the data, right click, choose paste special. Select the
option that best suits your need (either "value only" or "formulas") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Radha" wrote: Is there any way to insert an excel data to another new sheet without the original format of the first sheet. If I have date, percentage in my first sheet, will my second sheet keep that format or will it paste that also as a normal text? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting an excel sheet without the formatting.
Thank you, Luke for your quick response, I appreciate it.
Radha "Luke M" wrote: When you go to copy the data, right click, choose paste special. Select the option that best suits your need (either "value only" or "formulas") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Radha" wrote: Is there any way to insert an excel data to another new sheet without the original format of the first sheet. If I have date, percentage in my first sheet, will my second sheet keep that format or will it paste that also as a normal text? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting extra lines for comments in an excel sheet | Setting up and Configuration of Excel | |||
| inserting scrollbar inside an Excel Sheet | Excel Discussion (Misc queries) | |||
| Inserting a file in a work sheet in excel | Excel Discussion (Misc queries) | |||
| Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
| Inserting the date that an excel sheet is saved into a cell | Excel Discussion (Misc queries) | |||
Linear Mode
