Hi All,
Don't know if this can be done; I have a range of cells formatted as below;
What i want to do is lock the 10 rows and 10 columns as a 'table template' and be able to paste into the workbook (Keep the 'template at the bottom of the list) but column A sorts alphabetically so when i enter a new employee it ends up in the list correctly.
Can the 10x10 range be converted into table?
I have Excel 2007
Thanks
Don't know if this can be done; I have a range of cells formatted as below;
What i want to do is lock the 10 rows and 10 columns as a 'table template' and be able to paste into the workbook (Keep the 'template at the bottom of the list) but column A sorts alphabetically so when i enter a new employee it ends up in the list correctly.
Can the 10x10 range be converted into table?
I have Excel 2007
Thanks
