Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Cells with additional spaces AND
  • Always get 1st name (or last) Formulas - combined functions
  • Excel ad from early 90s Non-functions
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • CHOOSE – tree of decisions CHOOSE
  • VLookup Lookup and References
  • Filter. Google Sheets function Google Sheets
  • Progress bar in pure functions CHAR

Insert Blank rows into table using functions

Posted on February 5, 2012 By ANmar No Comments on Insert Blank rows into table using functions

Here you will see how to work with functions to insert a blank row every certain number of rows in a table using a blank sheet to copy all values of that table into the new sheet
Then using Copy > Paste Special to make them constants
The new thing is that this is all done using only functions (Except the Copy and Paste for sure)

Formula used:

=IF(ROW()/$F$1=INT(ROW()/$F$1),"",INDIRECT("Sheet1!"&CHAR(COLUMN()+64)&INT(ROW()/$F$1)-(INT(ROW()/$F$1))*2+ROW()))

CHAR, COLUMN, Formulas - combined functions, IF, INDIRECT, INT, Lookup and References, ROW, Standard functions

Post navigation

Previous Post: Change Calculator – calculate change in multiple bills/coins
Next Post: Sort list dynamically (functions)

Related Posts

  • Custom fiscal year calendar (CFlex) Basic Math
  • Extract current (Active) workbook name CELL
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • CONVERT function CONVERT
  • MATCH fumction, just a simple search Lookup and References
  • Jan8 date format AND

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (83)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (6)
      • Average (1)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Shapes with dynamic output Excel User tips
  • DayName Date and Time
  • Pixel Excel Drawing Format Cells
  • Extract Address into table Formulas - combined functions
  • Jan8 date format AND
  • Spreadsheet Compare application Excel User tips
  • Sheet() and Sheets() Lookup and References
  • Workdays – Across months DATE

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme