Little Known Excel Shortcut #4
By BankersBall on May 1, 2006 in Cube Life, Excel, Excel Shortcuts, Tools
Got a burning urge to fill an entire worksheet with some value? This’ll do the trick.
 |
SHORTCUT:
Highlight area (i.e. A1:C5). Type a value. Hit Ctrl + Enter.
PURPOSE:
Quickly, efficiently auto fill area with given value without having copy/paste.
FURTHER EXPLANATION: For instance, let’s say you wanted to fill an entire worksheet with zeros. This would allow you to do so.
Post a Comment