Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • LastSunday, LastSaturday Date and Time
  • Paste Special Percentage Excel User tips
  • Jan8 date format AND
  • Filter. Google Sheets function Google Sheets
  • Blank (isempty) VS “” (null string) Excel User tips
  • Walking Columns ActiveX controls
  • Sheet() and Sheets() Lookup and References
  • Get monthly total from table with dates DATE

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

  • Scorring, saving multiple outputs in 1 number Basic Math
  • Custom fiscal year calendar (CFlex) Basic Math
  • When Excel functions are not enough Excel User tips
  • Blank (isempty) VS “” (null string) Excel User tips
  • Recover the unrecoverable Excel User tips
  • Pixel Excel Drawing Format Cells

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
  • Fx to cut long column into two columns Formulas - combined functions
  • Multiple lines in cell using functions CHAR
  • Always get 1st name (or last) Formulas - combined functions
  • The Excel “&” bug Excel User tips
  • OFFSET+MATCH Formulas - combined functions
  • Show developer tab Excel User tips
  • VALUE() of LEFT() Formulas - combined functions
  • Multiple-Validations (connected to each other) Data Validation

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme