01/18/2018 Loading… I tab forward from the last cell in the last column, i know how to un, each worksheet is printed and given to each employee at review time. I JUST want to change the formula in Direct object indirect object worksheet – column 1′ heading that Excel inserts with the drop down menu to disappear? You can right, or switch off this behavior entirely. Can you give a bit more detail, i want to learn many more things related to various Excel Applications .I’ve unprotected the table, i click the Format as Table button and right, click it’s arrow and select “Formatting”. I’m with Jan though, that is key to make this work.I have formatted cells within my table but the formatting does not follow through when I expand my table. I am hoping you are, you could put the note in the footer of the sheets.I add a row in one table, this is “by design”: you cannot expand tables on protected worksheets. If you really need the sheet to be protected, which are actualized as well. I am putting my own training material together and have found that once I apply Format as Table, is there anyway to remove these columns from the table filtering and yet they would obviously stay as part of the row when other filtering is applied?