Search results 66

  2. Search results
  3. sheets
Sorted from new to old.
Card image
ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10
Card image
ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8
Card image
ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31
Card image
ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1
Card image
RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

2024Jan25
Card image
PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

2024Jan23
Card image
PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22
Card image
ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23
Card image
ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22
Card image
ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21
Card image
ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13
Card image
ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13
Card image
bootstrap 5 Spacelab Dark

A Bootstrap 5 css and scss, Spacelab, dark after modified. Not a toggle, just ...

2023Aug12
Card image
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10
Card image
Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

2023Aug1
Card image
SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23
12345