75 Essential Excel tips - CBS Interactive

Excel removes it when you save the sheet, but you can use this macro to have Excel quickly rebuild it: Sub ViewChangeSummary() With ActiveWorkbook. HighlightChangesOptions When:=xlAllChanges. ListChangesOnNewSheet = True. ... Insert two blank rows above the range, and copy and paste the column headings into the first blank row. ................
................