I am currently using Excel 365. I have a spreadsheet that doesn't require the same information for each line item. I have conditionally formatted certain cells based on another cell's data. For example, if Column A has the word "Regrade" in it, then columns B-J are grayed out and no data gets entered. The user then has to tab to column K to start entering data again. Is there way that I can format columns B-J that if they are grayed out the tab key will take you directly to the next available cell, which in this case is column K?
