Microsoft Excel Formatting and Time Saving Tricks
March 28, 2005 by daynah
Filed under Tips and Tutorials
I was helping out my co-worker with an “Introduction to Excel” class today. My job was to walk around and make sure no one is lost. But while I was in the class, I did learn a few new things. Let me share with you some nifty tips I got from the class.
Autofill of Days
This trick just made me smile. I’m not much of an Excel user, so this really amused me. First, type in the word Monday in a cell like in this image:
Now on the lower corner of that cell, left click, and drag the cursor down.
This will then display the words Monday, Tuesday, Wednesday, etc. in the next cells.
Nifty huh?
Another trick, if you go in a cell and press Shift+:. This will put the date in the cell. And if you press the three keys Shift+Alt+:, it’ll display the time. ;) So you learn something new everyday. ;) Have fun playing with Excel!
Related Products:
Make: Electronics (Learning by Discovery)"This is teaching at its best!"
--Hans Camenzind, inventor of the 555 timer (the world's most successful integrated circuit), and author of... Read More >
Electronics For DummiesElectronics is fascinating – want to make something of it? This book shows you how!You can make all sorts of things, once you understand what ele... Read More >
Electronics and Circuit Analysis Study Guide: Signal Transforms, Fourier, Laplace & Z transform, Transfer function, Electronic components, Analog & Digital Circuits (Mobi Study Guides)Boost Your grades with this illustrated study guide! You will use it from an undergraduate school all the way to graduate school and beyond. 
Popularity: 8% [?]
@
