Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Excel sessions – 2013 VS 2010 Excel User tips
  • Links between two workbooks – dynamically using functions INDIRECT
  • Sum of divide – Array formula Array formula
  • Formula Beautifier Excel User tips
  • When Excel functions are not enough Excel User tips
  • Tally chart in functions Formulas - combined functions
  • When Excel tells you to go get some life Excel User tips
  • Looplist – Repeating months using formulas Basic Math

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 sessions – 2013 VS 2010 Excel User tips
  • Show developer tab Excel User tips
  • Skills Grid Conditional Formatting
  • Expenses calendar, FaCal Basic Math
  • Shapes with dynamic output Excel User tips
  • Excel @ before function names in formulas Excel User tips

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

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 (82)
    • 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 (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • 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 (5)
      • 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
  • Tally chart in functions Formulas - combined functions
  • Rotate table using 1 formula ADDRESS
  • VALUE() of LEFT() Formulas - combined functions
  • Filter. Google Sheets function Google Sheets
  • Jan8 date format AND
  • Sum of divide – Array formula Array formula
  • GoLast to jump to last cell in a column CELL
  • Edit directly in cell Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme