Forum Discussion

Sue_G's avatar
Sue_G
Brass Contributor
Jun 04, 2019

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