Reoccurring mathamatical answers

  • Thread starter Thread starter Stan W.
  • Start date Start date
S

Stan W.

Hi
In XL2003 I am building a table that will have several answers per row. I
wish for these to be repeated down the columns and to go on for ever.

My question is - Do I write the formula in a Macro or as a formuna for the
appropiate columns?

I may wish to transfer the table to other computers or even sell it via the
internet.

How do I set the table up to scroll leaving the table head line in place?

Thanks,
Stan W.
 
Not sure what you mean exactly by "answers", but if you wish these to
be repeated, just copy the row and paste down.

For leaving the table head in place - assuming that's in row A - set
your cursor in cell B1, go to Window and select Freeze Panes.
 
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

On going formula 2
How to export table from outlook into ms access table? 0
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
advanced filter office 2007 1
VBA set thick borders around non empty cells in range 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
modified pivot table using a macro 2
Excel How to Auto-Alphabetize a Specific Range in Excel? 1

Back
Top