|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)