Spreadsheet Nation

▶

▶ 647 ❤ 0 💬 0

My top band names for bands made up only of accountants. #Inverted

▶

▶ 3.9K ❤ 0 💬 0

Checkboxes in Excel just got SO much easier ✅Insert > Checkbox, done. Perfect for to-do lists and trackers. #checkboxes #todolist #excel #exceltips #creatorsearchinsights

▶

▶ 1.8K ❤ 0 💬 0

You can take a picture of a table and turn it into an Excel spreadsheet 📸➡️📊No more retyping! Data > From Picture. #datafrompicture #exceltricks #excel #exceltips #creatorsearchinsights

▶

▶ 27.8K ❤ 0 💬 0

Excel keeps deleting the 0 at the start of your number? 😤Here's how to make it stop. Save this for the next time your ZIP codes get messed up! You can also change the number format. #leadingzeros #excel #exceltips #spreadsheet #creatorsearchinsights

▶

▶ 1.1K ❤ 0 💬 0

Stop filtering and adding things up by hand 🙌SUMIFS totals only the rows that match your conditions, like total sales for one vendor, one rep, or one month. Formula: =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2]...) Example: =SUMIFS(C:C, A:A, "Krusty Krab", B:B, "Jan") Follow Spreadsheet Nation for quick Excel tips every weekday. #excel #exceltips #shorts #sumifs #creatorsearchinsights

▶

▶ 2.2K ❤ 0 💬 0

Excel shortcut feels like cheating 🤯Type one example, hit Ctrl + E, and Excel fills in the rest of the column. Save this one for your next messy spreadsheet! #flashfill #datacleaning #excel #creatorsearchinsights #excelshortcuts

▶

▶ 1.9K ❤ 0 💬 0

Stop scrolling through your list looking for duplicates 🙅Excel can delete them in 3 clicks: Data > Remove Duplicates. Save this for later! #removeduplicates #datacleaning #excel #exceltips #creatorsearchinsights

▶

▶ 2.3K ❤ 0 💬 0

Stop scrolling to the bottom of your spreadsheet 😅Ctrl + ↓ takes you there instantly. Add Shift to select the whole column. Use the other arrow keys to move to the other edges of your data. Follow for more time-savers! #excelshortcuts #excel #exceltips #spreadsheet #creatorsearchinsights

▶

▶ 1.4K ❤ 0 💬 0

Drop down list in both Excel and Google Sheets

▶

▶ 1.6K ❤ 0 💬 0

Lose track of which column is which when you scroll? Freeze Panes keeps your header row (and your first columns, if you want) on screen no matter how far down you go. How: View > Freeze Panes > Freeze Top Row. To freeze rows AND columns, click the cell below and to the right of what you want locked, then choose Freeze Panes. #excel #exceltips #shorts #freezepanes #creatorsearchinsights

▶

▶ 2.7K ❤ 0 💬 0

2 ways to remove duplicates in Excel

▶

▶ 3K ❤ 0 💬 0

Here’s how to do an XLOOKUP in Excel or Google Sheets. Compared to VLOOKUP, XLOOKUP is better in almost every way. Here’s what makes XLOOKUP superior: • It can look left OR right (VLOOKUP can’t 😬) • No more counting column numbers — just select your return range • It handles exact matches by default • Built-in support for missing values • Cleaner formulas that are easier to read and maintain • You can return multiple columns If you work with tables, reports, pricing lists, employee data, or any kind of lookup, XLOOKUP is faster, safer, and more flexible than VLOOKUP. Whether you’re an Excel beginner or an experienced user, learning XLOOKUP will instantly level up your spreadsheet skills and save you time.