How Long Do Medical Debt Collections Stay On My Credit Report? Medical debt may stay on your credit report for as long as seven years, even after they are paid in full. It is the most common collection item on credit reports, with paid-off listings currently staining the credit of more than three million Americans.
Heed these steps: 1  Click the Insert tab. 2  From the Header & Footer group, choose the Header button. 3  Choose the format you want from the list.  Change any [Type here] text in the 1  header. When youâre done working on the header, click the Close Header and Footer button.
Best Answer: Here is one way to 'lock' the header and footer control, by disabling it in the WorkBook_Open event. You indicate that the workbook is 'macro enabled', so if you are well versed in VBA please forgive the following step by step 'how to'. Copy the following code to the clipboard: Private Sub Workbook_Open()