Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • When Excel tells you to go get some life Excel User tips
  • Fx to cut long column into two columns Formulas - combined functions
  • Links between two workbooks – dynamically using functions INDIRECT
  • Calculate hours between two cells ABS
  • IF with AND and IF with OR AND
  • Workdays – Across months DATE
  • Sorting with functions only CHOOSE
  • Formula Beautifier Excel User tips

CTRL+Y a mini macro

Posted on October 6, 2020 By ANmar

On your daily work, in Excel, you have had the need to redo actions, simple same action to multiple areas perhaps

Or apply similar format to more than 1 region, or repeat actions, the last action you did

In all these scenarios, use CTRL+Y

It is like a mini-macro to repeat last action taken on new set of selected cells.

Easy, simple but will save you lots of time, try it out

Excel User tips, Non-functions

Post navigation

Previous Post: Formula Beautifier
Next Post: Lesson learned: Do not trust Google Sheets function

Related Posts

  • Excel @ before function names in formulas Excel User tips
  • Pixel Excel Drawing Format Cells
  • Edit directly in cell Excel User tips
  • When Excel functions are not enough Excel User tips
  • Excel Limits Excel User tips
  • Convert cell into textbox Excel User tips

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
  • Custom fiscal year calendar (CFlex) Basic Math
  • Looplist – Repeating months using formulas Basic Math
  • Unix DateTime Number Basic Math
  • Extract current (Active) workbook name CELL
  • Calculate hours between two cells ABS
  • Extract Address into table Formulas - combined functions
  • VALUE() of LEFT() Formulas - combined functions
  • When Excel functions are not enough Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme