Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Excel sessions – 2013 VS 2010 Excel User tips
  • Hyperlink usage and HyperlinkOf UDF CELL
  • Return 12 values in one number AND
  • Calculate above and below me Average
  • VALUE() of LEFT() Formulas - combined functions
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Middle name + 1st name Basic Math
  • When Excel functions are not enough 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

  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Shapes with dynamic output Excel User tips
  • Shades of gray Graphics
  • Edit directly in cell Excel User tips
  • When Excel functions are not enough Excel User tips
  • Excel Limits 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
  • Middle name + 1st name Basic Math
  • OFFSET+MATCH Formulas - combined functions
  • 0% interest promotion Basic Math
  • Cuts string of list of items Formulas - combined functions
  • Highlight dates dynamically AND
  • Sort list dynamically (functions) COLUMN
  • LastSunday, LastSaturday Date and Time
  • Min Max vehicle Formulas - combined functions

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme