Excel General

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

    1. Excel Best Practices - Efficient Spreadsheet Design

      • AAE
      • AAE
    2. Replies
      0
      Views
      44k
    1. 37 New & FREE Functions/formulas For Excel

      • pike
    2. Replies
      0
      Views
      36k
    1. How To For Microsoft Office Applications

      • pike
    2. Replies
      0
      Views
      33k
    1. Excel/VBA Golden Rules. These Should NOT Be Optional

      • pike
    2. Replies
      0
      Views
      50k
    1. We want to hear your feedback!

      • S O
      • S O
    2. Replies
      0
      Views
      3k
    1. Replace text in fields 8

      • ´romanenko
    2. Replies
      8
      Views
      3k
      8
    3. ´romanenko

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

      • _123
    2. Replies
      2
      Views
      6k
      2
    3. _123

    1. Lock Unlock Cells Based On Format 3

      • _channelx_
    2. Replies
      3
      Views
      5k
      3
    3. _channelx_

    1. Convert Jd Edwards Julian Dates 8

      • _channelx_
    2. Replies
      8
      Views
      25k
      8
    3. dcurtis1

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

      • _disha_
    2. Replies
      14
      Views
      5.9k
      14
    3. Wigi

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

      • _donald
    2. Replies
      3
      Views
      2k
      3
    3. _donald

    1. Importing AS400 Reports and Appending Header Data 3

      • _donald
    2. Replies
      3
      Views
      1.5k
      3
    3. _donald

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

      • _donald
    2. Replies
      7
      Views
      14k
      7
    3. dangle

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

      • _HG_
      • _HG_
    2. Replies
      19
      Views
      6.4k
      19
    3. royUK

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

      • _Janyce
    2. Replies
      4
      Views
      1.4k
      4
    3. _Janyce

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

      • _lovemeet_
    2. Replies
      2
      Views
      4.7k
      2
    3. Rob Xaos

    1. Data Validation : Accumulating Data from a quastionare 17

      • _NFio_
    2. Replies
      17
      Views
      6.6k
      17
    3. _NFio_

    1. FormulaArray - interpolate variables 3

      • _NFio_
    2. Replies
      3
      Views
      3.8k
      3
    3. _NFio_

    1. Find unique values where criteria is met 5

      • _NFio_
    2. Replies
      5
      Views
      6.4k
      5
    3. Richie(UK)

    1. RegEx - test formula in range 2

      • _NFio_
    2. Replies
      2
      Views
      6.9k
      2
    3. _NFio_

Display Options