Microsoft Excel Formatting and Time Saving Tricks

March 28, 2005 by  
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 Through DiscoveryMake: Electronics: Learning Through Discovery

"This is teaching at its best!"

--Hans Camenzind, inventor of the 555 timer (the world's most successful integrated circuit), and author o... Read More >

Otium Wireless Sports Bluetooth Headphones In-Ear Earbuds IPX7 Waterproof Earphones Stereo with Mic Bass Noise Cancelling Bluetooth V4.1 for iPhone Android SmartphonesOtium Wireless Sports Bluetooth Headphones In-Ear Earbuds IPX7 Waterproof Earphones Stereo with Mic Bass Noise Cancelling Bluetooth V4.1 for iPhone Android Smartphones

- BLUETOOTH HEADPHONE IN TERMS OF SOUND OF QUALITY & MUCH MORE

The Superb Sound is due to Bluetooth V4.1+EDR Most Updated Technology. Specia... Read More >

Acer Aspire E 15 E5-575-33BM 15.6-Inch Full HD Notebook (Intel Core i3-7100U Processor 7th Generation , 4GB DDR4,  1TB 5400RPM Hard Drive,  Intel HD Graphics 620, Windows 10 Home), Obsidian BlackAcer Aspire E 15 E5-575-33BM 15.6-Inch Full HD Notebook (Intel Core i3-7100U Processor 7th Generation , 4GB DDR4, 1TB 5400RPM Hard Drive, Intel HD Graphics 620, Windows 10 Home), Obsidian BlackAcer Aspire E5-575-33BM comes with these high level specs: 7th Generation Intel Core i3-7100U Processor (2.4GHz, 3MB L3 cache), Windows 10 Home, 15.6"... Read More >
Related Posts Plugin for WordPress, Blogger...
  • http://www.adamthedog.com Adam

    You can customize those lists. You can do months, regular numbers, certain patterns, formulae, dates, pretty much anything. It’s pretty nifty–I use Excel quite a bit when doing repetitive web programming tasks (like SQL insert commands, etc).

  • http://www.adamthedog.com Adam

    You can customize those lists. You can do months, regular numbers, certain patterns, formulae, dates, pretty much anything. It’s pretty nifty–I use Excel quite a bit when doing repetitive web programming tasks (like SQL insert commands, etc).

  • http://atthe404.com Root

    This is all very spiffy – really nice work. I am happy to say that the MS inhouse Excel gurus use one of my templates for their blog. If you get stuck I am sure they would be happy to assist. Best wishes. Root. :)

  • http://atthe404.com Root

    This is all very spiffy – really nice work. I am happy to say that the MS inhouse Excel gurus use one of my templates for their blog. If you get stuck I am sure they would be happy to assist. Best wishes. Root. :)