Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
How do I set up repeating data in specified blocks from page to page without
retyping it on each and every page? |
#2
![]() |
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
How do I automatically transfer data to a 2nd worksheet page? | Excel Worksheet Functions |