Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   How to link excel sheet? (https://www.askmehelpdesk.com/showthread.php?t=566545)

  • Mar 29, 2011, 11:53 PM
    himanshu_monga
    How to link excel sheet?
    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
  • Mar 30, 2011, 03:49 AM
    ScottGem

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

    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.