PDA

View Full Version : How to link excel sheet?


himanshu_monga
Mar 29, 2011, 11:53 PM
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

ScottGem
Mar 30, 2011, 03:49 AM
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.

JBeaucaire
Mar 31, 2011, 11:44 AM
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.