Hi,

I enter formula =sheet'!A1 in cell A1 on sheet2. It brings value from sheet1 A1. I want it to bring value as well as formatting both. Is it possible ?

Please help.

regards

A formula only returns a value, it does not include formatting. If you want to copy the formatting from Sheet1 to Sheet2 automatically, you'd need VBA code, for example in the Worksheet_Change event procedure of Sheet1. But that would disable the Undo function, so it might not be an attractive alternative.

Hi Hans Vogelaar,

Thank you,

Actually I have long list of articles. I change them frequently in sequence. I need to print them in A4 size. I have to get the long sheet to get break down in A4 size printable sheet retaining first two lines and last one line same (headings and name etc) in all sheets. The sequence should change as I do in changes in long sheet.

regards

santosh

Hi drsantoshsinghrathore,

I agree with Mr. Hans, a formula can't return the formatting. Your request need VBA code. Please see the article below:
https://msdn.microsoft.com/EN-US/library/office/ff838835.aspx

If you have any further question about the VBA code, I recommend you post the question to MSDN forum:

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

George Zhao
TechNet Community Support

Thank you

Have a look at the Page Setup - Options in Page Layout. What you've described should be doable from you Long list as it is - no copy paste or macros needed.

Hidden behind the small arrow down right, you'll get to a menu called "Page Setup"  on the last page there called "Ply" under "Print titles" you can select how many of the top rows you want to retain ("rows to repeat at top").

Assuming that the last row you want to retain is actually you footer area, where you display file name, date aso - you can specifiy this quite nearby in the "Header/Footer" section of the "Page Setup" menu.