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
Technology Tips and News
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
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
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.