How to link the excel cells with next colums so that when we miss any colums to fill then we don't hv write to fill next colums
![]() |
How to link the excel cells with next colums so that when we miss any colums to fill then we don't hv write to fill next colums
You need to explain this further. You can reference any cell in a spreadsheet by using the cell's address (col and row, i.e. a1). But I don't understand what you mean by missing columns.
You're referring to a feature in Data Validation. With this, you can set B2 to not accept any input until A2 has been filled in.
For example:
1. Select B2:F2
2. Open the Data Validation window and apply these settings:
Settings: Allow: Custom
Formula: =A2<>""
[ ] Ignore Blank << uncheck this
That should do it.
All times are GMT -7. The time now is 12:12 AM. |