Forum Discussion
Sue_G
Jun 04, 2019Brass Contributor
Microsoft Excel
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?
No RepliesBe the first to reply