Automatic copying of data cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I am working on a spreadsheet that has a header at the top of each
document, that includes Name, date, materials etc. I want the info that I
type into the top header to always go to the other headers. Copying and
pasting is too time consuming as there are numerous pages. How can i do this?
 
Dale

Quick course in Excel vernacular.........

A spreadsheet is a File termed a Workbook

A Workbook is comprised of one or more Worksheets.

When printed a Worksheet can produce one or more Pages.

What exactly do you want?

The same header row to appear on each printed page?

For that go to File>Page Setup>Sheet and select "rows to repeat at top".

The same header row to appear on each Worksheet?

For that go with Peo's suggestion or just select all sheets and what you type
on one will be typed on all sheets.

Right-click on the one sheet tab and "select all sheets".

DO NOT FORGET to "ungroup" the sheets when done.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Access Sorting and grouping using multiple tables 0
Any way to hide a cell or row from printing? 6
Insert automatic page numbering into a cell, not a header or foote 1
Page headers linked to a cell 1
Copy of Header-Footer in Excel 3
copying large spreadsheet into Word 2
Dates-Automatically entered in cells 7

Back
Top