Repeating data from page to page

  • Thread starter excel-defficient
  • Start date
E

excel-defficient

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Skipping the first row in a repeated header 0
Repeating a row other than the 1st row as the header row in a table from next page 1
Space at end of multi page list to accommodate new entries 1
Section and Page numbering 0
Text duplication question 0
(Word 2016/365) Removing white space between pages at a smaller zoom 0
Page numbering with Merged Document and IF statements 1
Changing margins on 2nd page of letterhead template 4

Top