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.
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.
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”.
6.Click OK.
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.
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
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.
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.
- Back to the Computer Technology Unlimited web site