ReBizRU

Linking two pull-downs (drop-downs) without macros (for linking only one set) Excel (Excel)

This article explains how to link two dropdown lists in Excel. Are you struggling with how to display only employees relevant to the selected department after choosing it? Actually, you can easily link them using the INDEX and MATCH functions. An Excel expert will teach you how.

2025.06.09

Excel Functions

How to Use Wavy Lines to Crop or Skip Part of an Image in Excel

Master the wavy line technique to compress images in Excel! Step-by-step tutorial showing how to create professional image breaks and save space in your spreadsheets and presentations.

2025.08.07

Excel Functions

Automatically create invoices from sales invoices3 Excel (Excel)

Continuing from the previous article, "Creating Invoices Automatically from Sales Statements 2: Excel," we will now move on to creating invoices. If you haven't read it yet, please also read "Creating Invoices Automatically from Sales Statements 1: Excel". Putting details on an invoice (using a macro)...

2024.05.16

Excel Macro (VBA)Let's make an invoice from a sales invoice.

Insert rows without breaking formulas (using spil) Excel (Excel)

With Microsoft365 and Excel 2021 or later versions, you can insert, delete, and rearrange rows without breaking the formula by using a feature called Spill. In this article, we will show you a specific example...

2024.09.13

Excel Functions