Use the Keyboard to Substitute for Excel's Temperamental and Super-Sensitive Fill Handle

BY STANLEY ZAROWIN

Q: I bet I’m not the only one who hates using the mouse to grab that little slippery fill handle in Excel. The idea is great—click on the tiny handle and drag it to fill cells in a variety of ways. But I can’t always maneuver the mouse with that kind of accuracy. I know you’re a big advocate of using the keyboard instead of the mouse. So please, is there a keyboard alternative to control a fill handle?

 

 

A: Ah yes, that tiny square in the lower-right corner of a cell can sometimes be quite elusive—often slipping out of the mouse’s grasp. I’m happy to tell you there is a great keyboard substitute, it’s called the Series, and it works in all editions of Excel. To access Series, select the cells you want to fill. Then, while holding down the Alt key, press, in turn, E, I, and S, and the Series screen (see screenshot below) appears.

 

 

Use the Tab key (or you may now find it more efficient to use the mouse) to move among the various options in the dialog box. When you’ve selected them, press Enter.

 

SPONSORED REPORT

How the election may affect taxation of business income

This report summarizes recent proposals to reform the U.S. business income tax system and considers the path to enactment of any such legislation.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

Did you follow 2016’s biggest accounting news?

CPAs will remember 2016 as a year of new standards and new faces. How well did you follow the biggest accounting events? The 7 questions in this quiz will help you find out