Have the Fill Handle Fill Your List of Part Numbers

September 24, 2021 - by Bill Jelen

Have the Fill Handle Fill Your List of Part Numbers

Problem: Sure, the fill handle is good for filling months, days, and sequential numbers. But what about other lists I have to type lists of product lines, company regions, sales rep names, and so on.

Strategy: No matter what job you do, you probably have some annoying list of items that you have to type over and over. If your list contains from two to 96 items, you can add your list of items to the Custom Lists dialog. You can then fill items from the defined custom lists by using the fill handle.

continue reading »

More Reading

Enter a Series of Months, Days, or More by Using the Fill Handle

Enter a Series of Months, Days, or More by Using the Fill Handle »

September 23, 2021 - by Bill Jelen

I need to create a new worksheet. My first task is to enter the 12 month names across row 1. Is there a faster way than typing them all?

Mix Formatting In A Single Cell

Mix Formatting In A Single Cell »

September 22, 2021 - by Bill Jelen

I’d like to use strikethrough on the text in part of a cell. Is this possible?

Why Can’t Excel Find a Number?

Why Can’t Excel Find a Number? »

September 21, 2021 - by Bill Jelen

The Excel Find and Replace dialog drives me crazy. I always have to go to the Options button to specify that it should look in Values. In the figure below, the mouse pointer is showing the value that Excel says is not there is actually there. Why can’t Excel find a number?

read more articles »

Featured Products

Excel Data Cleansing Straight To The Point

July 2019

This Straight to the Point guide provides an introduction to data cleansing, which also goes by names such as data munging and data wrangling. Whatever the name, it basically means doing what needs to be done to make data useful and trustworthy.

MrExcel 2020 - Seeing Excel Clearly

January 2020

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.

Introduction to Financial Modelling

October 2019

With over 50 examples and an extended case study that creates a simple financial model from scratch to highlight the key concepts, this is a "hands on" book, focused on working with Excel more efficiently and effectively.

Continuing Financial Modelling

November 2020

You wait for one decent Financial Modelling book to come out and then two come along at once. This edition is aimed at those who wish to advance their knowledge and expertise in financial modelling by addressing common problems that occur day to day in the world of business / decision analyses, forecasting, and valuations.

see more products »