Repeating Column Headers And Blank Worksheets With Fomulas

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

Guest

I have two questions about excel: In my spreadsheet I have titles for all my
columns that I have typed in the first cell of every column and I was wonder
how you make those titles repeat on every page of the spreadsheet. My second
question is how do you take an exsiting spreadsheet and then make a new
spreadsheet thats blank but have all the formulas as the original one.

Thanks
 
Hi
1. Question:
- for printing: file - Pagesetup - sheets' and define your repeating rows
-for display: Move the cursor below your heading row and goto 'Windows -
Freeze Panes'

2. Question:
After copying everything, select your data area, hit F5, choose 'Special',
choose 'Constants' and then hit the DEL key
 
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

How to make a column of formulas all ROUND 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to sort when I have multiple header rows (not included in sor. 1
Having Blank Cells, etc. ? 1
Print Titles - Columns to Repeat at Left 1
Header Columns 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Display index of column headers in column A 9

Back
Top