Skip to main content
Microsoft 365

Anneliese W. Posts

Subscribe
Anneliese W.
Published 
2 min read

Generate invoice numbers in Excel 

<p>If you need a way to create invoices in Excel, you can use one of the many invoice templates on Office.com. While these templates are a great starting point, they don't automatically generate unique invoice numbers—you need a macro for that. In this video, Excel MVP Bill Jelen shows you how to create a couple of macros to generate invoice numbers. The first macro automatically increments the number and then clears cells on the worksheet so you can start fresh on the next invoice. The second macro lets you save a copy of the invoice with a unique file name.</p>
Published 
2 min read

The Excel part of mail merge 

<p>Hey, the holidays are fast approaching, which means you've got to get your cards signed, sealed, and delivered! This post goes out to those of you who keep your address list in Excel and need to figure out how to use it to create mailing labels in Word.  Creating labels can be intimidating, mainly because there are a number of steps and you're typically working across different programs—in this case, Excel and Word. Read on to learn best practices for preparing your address list in Excel.</p>
Published 
2 min read

Two tips for faster worksheet navigation 

<p>If your workbook contains a ton of worksheets, it can be a hassle to navigate to just the right sheet. For one thing, you often can't see all the sheet names at the bottom of the workbook. Sure, you can move around by using the four navigation buttons to the left of the worksheet tabs, or by pressing Ctrl + Page Up or Ctrl + Page Down, but there are faster ways to jump from sheet to sheet. </p>