Computer and Web Articles

The easiest method of inserting today’s date in an Excel cell is to simply hold down the Ctrl key and … press the semicolon key. That’s it. It works, I promise! Try it out.

There’s a great shortcut for entering the current time as well - hold down the Ctrl and Shift keys, and then press the colon key. Ta-da!

Remember that hitting the Alt + Enter key combination while typing inside a cell forces a line break.

The next time you want to select ALL your Excel sheets at once, click on the tab of the first one, hold down the Shift key, then click on the tab of the last one.

You can always sort your data by columns by selecting Sort from the Data menu, then Options. Select that Sort left to right option button, then click OK - and in the Sort by option dialog box, just select the row number by which the columns should be sorted. Click OK one more time and you’re good to go.