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

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

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

News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.