ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   copy the format (https://www.excelbanter.com/excel-discussion-misc-queries/257839-copy-format.html)

Format copying

copy the format
 
On excell sheet, i made some calculation and copy this format to another cell
that format can work for rest of the page. But rather than coppying the
format it is just copying the cell and rest of the page appeal to have some
result which is incorrect.

How do I apply the same format for multiple line ?

FSt1

copy the format
 
hi
pastespecial formats

Regards
FSt1

"Format copying" wrote:

On excell sheet, i made some calculation and copy this format to another cell
that format can work for rest of the page. But rather than coppying the
format it is just copying the cell and rest of the page appeal to have some
result which is incorrect.

How do I apply the same format for multiple line ?



All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com