Excel General

For all general questions relating to Excel but not including VBA or formulas.

    2. Excel Best Practices - Efficient Spreadsheet Design 2

      • AAE
      • AAE
    3. Replies
      2
      Views
      48k
      2

    4. vcoolio

    2. 37 New & FREE Functions/formulas For Excel

      • pike
    3. Replies
      0
      Views
      38k

    2. How To For Microsoft Office Applications

      • pike
    3. Replies
      0
      Views
      35k

    2. Excel/VBA Golden Rules. These Should NOT Be Optional 11

      • pike
    3. Replies
      11
      Views
      53k
      11

    4. pplanch

    2. Replace text in fields 8

      • ´romanenko
    3. Replies
      8
      Views
      3.7k
      8

    4. ´romanenko

    2. Prevent data being deleted by using "DEL" key in a protected spreadsheet 2

      • _123
    3. Replies
      2
      Views
      7.3k
      2

    4. _123

    2. Lock Unlock Cells Based On Format 3

      • _channelx_
    3. Replies
      3
      Views
      5.3k
      3

    4. _channelx_

    2. Convert Jd Edwards Julian Dates 8

      • _channelx_
    3. Replies
      8
      Views
      30k
      8

    4. dcurtis1

    2. PLEASE HELP ME OUT Parent-Child hierarchy construction 14

      • _disha_
    3. Replies
      14
      Views
      6.8k
      14

    4. Wigi

    2. Insert Pictures with varying naming convention from a list of a specific length VBA 3

      • _donald
    3. Replies
      3
      Views
      2.2k
      3

    4. _donald

    2. Importing AS400 Reports and Appending Header Data 3

      • _donald
    3. Replies
      3
      Views
      1.8k
      3

    4. _donald

    2. Delete Excel Rows Using Auto Filtering .SpecialCells(xlCellTypeVisible).EntireRow.Del 7

      • _donald
    3. Replies
      7
      Views
      17k
      7

    4. dangle

    2. Private Sub Worksheet_Change(ByVal Target As Range) issues with Protected Sheet 19

      • _HG_
      • _HG_
    3. Replies
      19
      Views
      8k
      19

    4. royUK

    2. Locate Cell Using its Values and then Copying the Adjacent Cell to Other Workbook 4

      • _Janyce
    3. Replies
      4
      Views
      1.8k
      4

    4. _Janyce

    2. Mobile Number Filter ( Formula for begins with in data) 2

      • _lovemeet_
    3. Replies
      2
      Views
      5.6k
      2

    4. Rob Xaos

    2. Data Validation : Accumulating Data from a quastionare 17

      • _NFio_
    3. Replies
      17
      Views
      7.4k
      17

    4. _NFio_

    2. FormulaArray - interpolate variables 3

      • _NFio_
    3. Replies
      3
      Views
      4.1k
      3

    4. _NFio_

    2. Find unique values where criteria is met 5

      • _NFio_
    3. Replies
      5
      Views
      6.8k
      5

    4. Richie(UK)

    2. RegEx - test formula in range 2

      • _NFio_
    3. Replies
      2
      Views
      7.5k
      2

    4. _NFio_

    2. Assign cell with value chosen in a combobox 14

      • _NFio_
    3. Replies
      14
      Views
      43k
      14

    4. Wigi

Label

Display Options