Anneliese W. | Author at Microsoft 365 Blog

Generate invoice numbers in Excel

Anneliese W. — Thu, 12 Jan 2012 04:50:00 +0000

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.

The post Generate invoice numbers in Excel appeared first on Microsoft 365 Blog.

The Excel part of mail merge

Anneliese W. — Tue, 15 Nov 2011 05:30:00 +0000

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.

The post The Excel part of mail merge appeared first on Microsoft 365 Blog.

Two tips for faster worksheet navigation

Anneliese W. — Tue, 18 Oct 2011 05:00:00 +0000

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.

The post Two tips for faster worksheet navigation appeared first on Microsoft 365 Blog.