Excel 2010 automatically adding new formatted lines to form

March 5, 2013 at 09:23:30
Specs: Windows 7 64b, P4- 2.8 ghz 22 gb
I created a form in Excel 2010... the Excel sheet does not use headers or footers.
I have company information in some merged cells along the top
Then I have some category headings just below that
Then, at the bottom, I have some more company information, like signature etc.

The rows and columns are formatted to various heights and widths.
EG: a row might say, employee name, current date, location, etc
If I have currently 10 employees and one more joins, is there a way to just automatically insert another row with the same formatting??

I want to "freeze" the top few rows to always show the company information and the column headings, but the bottom company information does not need to be frozen or seen until scrolling all the way down.

I am just using employees as an example.
The form is used by our welding department per project and sometimes it would have only 10 lines and sometimes they will need 2500 lines (rows)

See More: Excel 2010 automatically adding new formatted lines to form

Report •

April 16, 2013 at 06:57:10
You want to select one row below the one you want to stay at the top and "freeze panes". As for adding extra rows you probably would want to use a table, select the entire data range and convert to table, that allows it to keep formatting as you add new rows. It's "automatic" as you say

Report •
Related Solutions

Ask Question