ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Make a piece of text in 1st page appear in remaining excel pages (https://www.excelbanter.com/excel-discussion-misc-queries/238174-make-piece-text-1st-page-appear-remaining-excel-pages.html)

Arun

Make a piece of text in 1st page appear in remaining excel pages
 
How to make a piece of text and image in the first page of an excel workbook
to appear in all the remaining pages.

Luke M

Make a piece of text in 1st page appear in remaining excel pages
 
Depending on where the info is located, and how you want it to appear, you
could go under Edit-Page setup, and make it a header/footer, or in the same
dialogue, under the Sheet tab, you can choose to repeat a set of rows/columns.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Arun" wrote:

How to make a piece of text and image in the first page of an excel workbook
to appear in all the remaining pages.


Gord Dibben

Make a piece of text in 1st page appear in remaining excel pages
 
Define "page"

Do you mean each page of a printed worksheet?

Rows to repeat at top should do what you want.

Just make sure your image is inside the boundaries of the cell/row to print.

OR..................add the text and image to a header.


Gord Dibben MS Excel MVP

On Tue, 28 Jul 2009 03:55:02 -0700, Arun
wrote:

How to make a piece of text and image in the first page of an excel workbook
to appear in all the remaining pages.




All times are GMT +1. The time now is 10:02 AM.

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