ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Repeating data from page to page (https://www.excelbanter.com/setting-up-configuration-excel/24616-repeating-data-page-page.html)

excel-defficient

Repeating data from page to page
 
How do I set up repeating data in specified blocks from page to page without
retyping it on each and every page?

JulieD

Hi

by page to page do you mean printed pages or between worksheets?

for printed pages:
check out file / page setup - sheet tab and rows to repeat at top

for worksheets:
say you want the values of sheet1 A1 repeated in sheet 2 A1 then click in
sheet2 A1 type an = then click on sheet1 A1 and press enter

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"excel-defficient" wrote in
message ...
How do I set up repeating data in specified blocks from page to page
without
retyping it on each and every page?





All times are GMT +1. The time now is 06:19 AM.

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