u/Normal-Touch-2396

Basic Shortcuts and Navigation

Ctrl + C > Copy

Ctrl + V > Paste

Ctrl + X > Cut

Ctrl + Z > Undo

Ctrl + Y > Redo

Ctrl + S > Save workbook

Ctrl + P > Print workbook

Ctrl + A > Select all

Ctrl + F > Find data

Ctrl + H > Replace data

Ctrl + N > New workbook

Ctrl + O > Open workbook

Ctrl + W > Close workbook

Ctrl + B > Bold text

Ctrl + I > Italic text

Ctrl + U > Underline text

Ctrl + K > Insert hyperlink

Ctrl + Up Arrow > Move quickly

Ctrl + Shift + Arrow > Select data range

Ctrl + Space > Select column

Shift + Space > Select row

Ctrl + Page Up > Previous sheet

Ctrl + Page Down > Next sheet

F2 > Edit cell

F4 > Repeat action

Formatting and Insertion

F5 > Go To

Alt + = > AutoSum

Ctrl + T > Create table

Ctrl + ; > Insert date

Ctrl + Shift + ; > Insert time

Ctrl + D > Fill down

Ctrl + R > Fill right

Ctrl + 1 > Format cells

Ctrl + Shift + L > Apply filter

Ctrl + E > Flash Fill

Ctrl + ` > Show formulas

Ctrl + Home > Go to beginning

Ctrl + End > Go to last cell

Ctrl + Shift + + > Insert row or column

Ctrl + - > Delete row or column

Alt + Enter > New line in cell

Ctrl + 9 > Hide rows

Ctrl + Shift + 9 > Unhide rows

Ctrl + 0 > Hide columns

Ctrl + Shift + 0 > Unhide columns

Ctrl + Shift + $ > Currency format

Ctrl + Shift + % > Percentage format

Ctrl + Shift + # > Date format

Ctrl + Shift + @ > Time format

F11 > New worksheet

Advanced Functions and Layout

Ctrl + Shift + ! > Number format

Ctrl + Shift + ^ > Scientific format

Ctrl + Shift + ~ > General format

Ctrl + Shift + & > Add border

Ctrl + Shift + _ > Remove border

Ctrl + Shift + U > Expand formula bar

Shift + F11 > New worksheet

Ctrl + Tab > Switch workbook

Ctrl + Backspace > Show active cell

Ctrl + Shift + O > Select cells with comments

Ctrl + Alt + V > Paste special

Alt + H + O + I > AutoFit column width

Alt + H + O + A > AutoFit row height

Alt + W + F + R > Freeze top row

Alt + W + F + C > Freeze first column

Alt + W + V + G > Gridlines on or off

Ctrl + Shift + F > Font dialog

Ctrl + Shift + P > Font size

Ctrl + Shift + ~ > General style

Alt + Down Arrow > Open dropdown

Ctrl + Shift + * > Select current region

Ctrl + Shift + : > Insert current time

Ctrl + Alt + F9 > Recalculate formulas

Shift + F9 > Calculate sheet

Ctrl + Alt + K > Insert hyperlink

Ctrl + Shift + F3 > Create names

Ctrl + Shift + F6 > Previous workbook

Ctrl + F3 > Name manager

Ctrl + Shift + N > Normal style

Ctrl + Shift + " > Copy value above

Ctrl + ' > Copy formula above

Alt + F1 > Create chart

F11 > Create chart sheet

Ctrl + Shift + Enter > Array formula

Ctrl + Alt + Arrow > Move between windows

Ctrl + Shift + Tab > Previous tab

Ctrl + Mouse Scroll > Zoom in or out

Alt + A + T > Borders menu

Alt + H + FC > Fill color

Alt + H + FS > Font size menu

Alt + H + M + C > Merge & Center

Alt + H + W > Wrap text

Ctrl + Shift + F12 > Print command

Ctrl + Alt + Shift + F9 > Full calculation

Ctrl + Shift + Page Up > Select previous sheet

Ctrl + Shift + Page Down > Select next sheet

Ctrl + Alt + Shift + V > Paste values

Ctrl + Shift + Drag > Copy sheet

Alt + F4 > Exit Excel

Alt + Q > Search or Tell Me

Hello How do you change the names where the number of members appear, etc., those on the right of the sub. I couldn't find the section. Thanks.

Hey everyone,

Just wanted to share a formula setup that completely changes how you track sequences, especially if you’re tired of messy old-school helper columns.

We all know UNIQUE is great for telling you what is distinct in a dataset, but it doesn’t tell you when something showed up for the first time chronologically. If you have a long list of transactions, logs, or customer check-ins and you want to flag the exact moment a value debuts - row by row, in order - you need a running unique index.

A lot of examples online tell you to use a basic SCAN and COUNTIF combo with a custom range. Except there is a huge catch: Excel doesn't actually accept that raw variable as a valid range index inside COUNTIF, and if your range has blank rows at the bottom, the counter gets totally confused and starts indexing the empty spaces.

Here is the clean, bulletproof version that handles expanding ranges and ignores blank rows perfectly:

=LET(
    rng, A2:A100,
    SCAN(0, SEQUENCE(ROWS(rng)), LAMBDA(acc, idx,
        LET(
            current_val, INDEX(rng, idx),
            sub_range, TAKE(rng, idx),
            IF(current_val="", "", IF(COUNTIF(sub_range, current_val)=1, acc+1, acc))
        )
    ))
)

Instead of feeding the raw text data directly into SCAN, this setup feeds it a row index using SEQUENCE and ROWS. Inside the LAMBDA, TAKE creates a dynamic, expanding slice of your data that grows row by row, looking from the very top down to where the formula is currently working. COUNTIF checks that specific slice. If it’s the first time the value pops up, the counter ticks up. If it’s a duplicate, it holds flat.

The real lifesaver here is the blank check at the end. If your data stops at row 50 but your range goes to 100, it leaves the remaining rows completely blank instead of filling them with ghost numbers.

This comes in handy for a ton of real-world scenarios. In a CRM system, you can use it to pinpoint the exact transaction row where a customer ID converted for the first time. If you do log analysis, it lets you flag the exact timestamp a specific error code made its first appearance. It is also great for inventory management when you need to mark the precise row a new SKU debuted in a seasonal order list.

The best part is that it lives in a single cell, it is fully dynamic, and the index updates automatically as you add rows. Just a heads-up: since it uses COUNTIF on an expanding range inside SCAN, it can get heavy if you throw 50k rows at it, but for standard datasets it works like a charm.

SCAN has been around since 2022 but it feels like barely anyone touches it. Definitely worth adding to your toolkit if you want to level up your spreadsheet game.

Note; content tested and verified on Excel 365.

https://preview.redd.it/g4beyq7ay92h1.jpg?width=1024&format=pjpg&auto=webp&s=c9d571bbb77fced3f0ce28eb76d9d6252130d25e

https://preview.redd.it/740bo5vay92h1.jpg?width=1024&format=pjpg&auto=webp&s=9fb12e9e6961c458a02764ecd833ea46713cf3e9

https://preview.redd.it/oc34otkby92h1.jpg?width=1024&format=pjpg&auto=webp&s=62ee595570ecad7c77badac6a47cb9af1c8235b3

https://preview.redd.it/d7wlq5xqg32h1.jpg?width=2048&format=pjpg&auto=webp&s=90f6b184a89b419af99859d69ae38b39aee88535

https://preview.redd.it/7qtzed9uc32h1.jpg?width=2048&format=pjpg&auto=webp&s=9eb1a7114af2197cd2e3254043cca6bca31ddb4e

Hello everyone;

I've been making pivot tables for like 10 years for the dumbest quick sums ever.

last week i was messing around with a sales dump and accidentally typed GROUPBY instead of something else. had no idea this was even a thing.

so i have Region in A and Sales in C. i just did:

=GROUPBY(A2:A5000, C2:C5000, SUM)

and it just... spilled the whole summary. no insert pivot, no drag fields, no refresh. it just lives there.

i used to do this for a 30 second check. now it's one line

if you want it by region AND rep you can just hstack them:

=GROUPBY(HSTACK(A2:A5000,B2:B5000), C2:C5000, SUM)

pivotby does the same but with columns too. honestly i still use normal pivots for proper reports but for quick dirty checks this is so much better.

Anyone else just finding this now or am i late as usual?

Note; you need office 365.

https://preview.redd.it/h9rspol4sv1h1.jpg?width=2048&format=pjpg&auto=webp&s=e1effd9b3cd21a94ddc85ac4f4908b6f2a4d2524