Current Date & Time in Excel

To show the current date & time whenever a spreadsheet is opened use NOW()

Enter “=NOW()” in to the cell where you want the date and time to show press enter and there it is.

If you just want the date then use “=TODAY()”

But remember these functions will show the current date and time, so tomorrow the date and time will have changed.

Word shortcut to capitalise headings

When you are writing your Word document you can easily capitalise headings using s build-in Word shortcut.

Write the heading as normal.

Select the line.

Press shift+F3 to toggle through capitalising options:

ALL CAPS / First Letter Of Each Word / no caps i.e. all lower case.

If you’re like me this will save a ton of time fiddling around with shift or caps lock.

Configure XP to reopen open folders on restart

Imagine this common scenario: You’ve just installed new software and now have to restart your PC. Normally you would log back in to your usual desktop and manually fid and re-open all the folders you were working in.
If you would like XP to automatically reopen all the previously open folders when you restarted your PC do the following:
1. Open Windows Explorer (Right click the Start menu and select Explore).
2. Click Tools.
3. Select Folder Options.
4. Click the View tab.
5. Under the list of Advanced Settings, scroll down and put a checkmark in the box that says “Restore previous folders at logon”.XP Folder Options
6.Click OK.

Using the Windows key

Ever wonder what the Windows key can be used for? Here are some useful
keyboard shortcuts that use the Windows key.

The Windows key is on the bottom left of the keyboard between “Ctrl” and “Alt”
and has the Windows symbol on it.
windows key
The position on laptops may vary.

In this list of shortcuts “WK” stands for “Windows Key”

WK – Displays the Start Menu

WK + D Toggles Minimise all windows and Restore all windows
e.g. Press WK + D and all the windows will be minismised
Press WK + D again and all the windows are restored

WK + E
Opens a new Explorer window

WK + F Displays the Find dialog box

WK + L Locks your Windows XP computer

WK + M Minimises all open windows. Different to WK + D
in that there is no restore when you press this combination again.
See below for the restore combination.

WK + R Display the Run command

WK + F1 Displays the Help menu for MS Windows

WK + Pause/Break Displays the System Properties dialog box

WK + Tab Cycles through buttons of open applications on the task bar

WK + Shift + M Restores all windows that were open before you
pressed WK + M

Tips to keep your PC working properly (1)

Leave the Windows folder alone

If your PCs hard disk was an office building then the Windows folder would be labeled “Authorised Personell Only” and have a security lock on the door.

Modifying, moving or copying files in the Windows folder can cause total failure of your PC.

It’s surprising how many times CTU is called to fix a PC where the cause of the problem turns out to be missing or moved files within the Windows folder.

So, please, stay out of the Windows folder.

The Most Important Windows Tip – Ever!

What is the one most important tip to keep your PC in good health?

Always allow your PC to shut down correctly using the Windows “start” button.

Never just switch off.

This is because Windows performs some essential operations as part of the shutdown process.

The Registry can become corrupt if you don’t shut down the PC properly causing your PC to behave unpredictably.

The contents of the cache will be lost (cache is the part of the computer memory used when reading from and writing to the hard disk). This could corrupt documents and files you have been using.

If you are on a network and do not perform a shutdown then any shared resources you have been using will still show as “in use” by the the network and may become unusable by other network users.