MS Excel Shortcuts
MS Excel Keys
CTRL+SHIFT+(
Unhides any hidden rows within the selection.
CTRL+SHIFT+)
Unhides any hidden columns within the selection.
CTRL+SHIFT+&
Applies the outline border to the selected cells.
CTRL+SHIFT_
Removes the outline border from the selected cells.
CTRL+SHIFT+~
Applies the General number format.
CTRL+SHIFT+$
Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+SHIFT+%
Applies the Percentage format with no decimal places.
CTRL+SHIFT+^
Applies the Exponential number format with two decimal places.
CTRL+SHIFT+#
Applies the Date format with the day, month, and year.
CTRL+SHIFT+@
Applies the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+!
Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+SHIFT+*
Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
In a PivotTable, it selects the entire PivotTable report.
CTRL+SHIFT+:
Enters the current time.
CTRL+SHIFT+"
Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+SHIFT+Plus (+)
Displays the Insert dialog box to insert blank cells.
CTRL+Minus (-)
Displays the Delete dialog box to delete the selected cells.
CTRL+;
Enters the current date.
CTRL+`
Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+'
Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+1
Displays the Format Cells dialog box.
CTRL+2
Applies or removes bold formatting.
CTRL+3
Applies or removes italic formatting.
CTRL+4
Applies or removes underlining.
CTRL+5
Applies or removes strikethrough.
CTRL+6
Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+8
Displays or hides the outline symbols.
CTRL+9
Hides the selected rows.
CTRL+0
Hides the selected columns.
CTRL+A
Selects the entire worksheet.
If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet.
When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.
CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
CTRL+B
Applies or removes bold formatting.
CTRL+C
Copies the selected cells.
CTRL+C followed by another CTRL+C displays the Clipboard.
CTRL+D
Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
CTRL+F
Displays the Find and Replace dialog box, with the Find tab selected.
SHIFT+F5 also displays this tab, while SHIFT+F4 repeats the last Find action.
CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected.
CTRL+G
Displays the Go To dialog box.
F5 also displays this dialog box.
CTRL+H
Displays the Find and Replace dialog box, with the Replace tab selected.
CTRL+I
Applies or removes italic formatting.
CTRL+K
Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+N
Creates a new, blank workbook.
CTRL+O
Displays the Open dialog box to open or find a file.
CTRL+SHIFT+O selects all cells that contain comments.
CTRL+P
Displays the Print dialog box.
CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab selected.
CTRL+R
Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
CTRL+S
Saves the active file with its current file name, location, and file format.
CTRL+T
Displays the Create Table dialog box.
CTRL+U
Applies or removes underlining.
CTRL+SHIFT+U switches between expanding and collapsing of the formula bar.
CTRL+V
Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.
CTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
CTRL+W
Closes the selected workbook window.
CTRL+X
Cuts the selected cells.
CTRL+Y
Repeats the last command or action, if possible.
CTRL+Z
Uses the Undo command to reverse the last command or to delete the last entry that you typed.
CTRL+SHIFT+Z uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.
Monday, November 1, 2010
Monday, October 18, 2010
HOW to Speed up a Sluggish Computer?
This give an idea on how to optimize the system. No other magic work!!
Are you frustrated by your sluggish computer? With regular use, even the newest PC will slow down significantly. Here are some suggestions to free up PC resources and get that computer back in shape!
Instructions
Step 1 - Free up PC resources by deleting old programs: get some of that unused space back. In Windows XP go to start -> control panel -> add/remove programs. Highlight any program that you do not use and click REMOVE.
Step 2 - Free up PC resources by getting rid of adware and spyware: these two parasites threaten your privacy, expose you to unwanted advertisements and most importantly, slow down your computer. Free programs such as Spybot S&D and AdAware make it easy to remove adware and spyware. Simply install these programs, update them, run a scan and remove the intruders!
Step 3 - Free up PC resources by cleaning your start up files. These are files that run automatically as soon as you boot up your computer. Many of them are unneeded and are only taking up space! Besides removing spyware, Spybot S&D can also help you clean your start up files. With Spybot S&D running click the "tools" button on the left. Then click "system startup" on the left. Uncheck any entries that are highlighted in red, as they may be malicious files. Uncheck any entries of any color that are unwanted. Your computer will speed up as soon as you restart your computer!
Step 4 - Free up PC resources by cleaning your registry. Easy Cleaner is a program that can help you accomplish this. Make a backup of your registry before deleting registry entries.
Step 5 - Clean your junk and temporary files will also free up PC resources. You might be surprised at how many junk and temporary files your computer is storing! Programs such as CCleaner can help you delete these files quickly and easily.
Step 6 - Defrag your hard drive. Over time, files become misplaced and this can slow down your computer. Defragging puts files where they belong! In Windows XP, go to windows explorer and right click your hard drive. Scroll down and select properties. Click the tab named tools, and then click defragment now. Finally, select your hard drive and click defragment. Let your computer do the rest!
Step 7 - Reboot your computer, your PC resources are now freed up and you should notice a significant boost in speed.
Tips & Warnings
- All programs mentioned in this article can be downloaded for free at majorgeeks.com.
- Be careful when deleting files from your computer.
- Be sure to make a backup of your registry before editing it.
- These steps should be repeated from time to time to ensure that your computer continues running well.
Are you frustrated by your sluggish computer? With regular use, even the newest PC will slow down significantly. Here are some suggestions to free up PC resources and get that computer back in shape!
Instructions
Step 1 - Free up PC resources by deleting old programs: get some of that unused space back. In Windows XP go to start -> control panel -> add/remove programs. Highlight any program that you do not use and click REMOVE.
Step 2 - Free up PC resources by getting rid of adware and spyware: these two parasites threaten your privacy, expose you to unwanted advertisements and most importantly, slow down your computer. Free programs such as Spybot S&D and AdAware make it easy to remove adware and spyware. Simply install these programs, update them, run a scan and remove the intruders!
Step 3 - Free up PC resources by cleaning your start up files. These are files that run automatically as soon as you boot up your computer. Many of them are unneeded and are only taking up space! Besides removing spyware, Spybot S&D can also help you clean your start up files. With Spybot S&D running click the "tools" button on the left. Then click "system startup" on the left. Uncheck any entries that are highlighted in red, as they may be malicious files. Uncheck any entries of any color that are unwanted. Your computer will speed up as soon as you restart your computer!
Step 4 - Free up PC resources by cleaning your registry. Easy Cleaner is a program that can help you accomplish this. Make a backup of your registry before deleting registry entries.
Step 5 - Clean your junk and temporary files will also free up PC resources. You might be surprised at how many junk and temporary files your computer is storing! Programs such as CCleaner can help you delete these files quickly and easily.
Step 6 - Defrag your hard drive. Over time, files become misplaced and this can slow down your computer. Defragging puts files where they belong! In Windows XP, go to windows explorer and right click your hard drive. Scroll down and select properties. Click the tab named tools, and then click defragment now. Finally, select your hard drive and click defragment. Let your computer do the rest!
Step 7 - Reboot your computer, your PC resources are now freed up and you should notice a significant boost in speed.
Tips & Warnings
- All programs mentioned in this article can be downloaded for free at majorgeeks.com.
- Be careful when deleting files from your computer.
- Be sure to make a backup of your registry before editing it.
- These steps should be repeated from time to time to ensure that your computer continues running well.
Tuesday, November 24, 2009
Data recovery
Data recovery is the process of salvaging data from damaged, failed, corrupted, or inaccessible secondary storage media when it cannot be accessed normally. Often the data are being salvaged from storage media such as hard disk drives, storage tapes, CDs, DVDs, RAID, and other electronics. Recovery may be required due to physical damage to the storage device or logical damage to the file system that prevents it from being mounted by the host operating system.
The most common "data recovery" issue involves an operating system (OS) failure (typically on a single-disk, single-partition, single-OS system), where the goal is to simply copy all wanted files to another disk. This can be easily accomplished with a Live CD, most of which provide a means to 1) mount the system drive, 2) mount and backup disk or media drives, and 3) move the files from the system to the backup with a file manager or optical disc authoring software. Further, such cases can be mitigated by disk partitioning and consistently moving valuable data files to a different partition from the replaceable OS system files.
The second type involves a disk-level failure such as a compromised file system, disk partition, or a hard disk failure —in each of which the data cannot be easily read. Depending on the case, solutions involve repairing the file system, partition table or MBR, or hard disk recovery techniques ranging from software-based recovery of corrupted data to hardware replacement on a physically damaged disk. These last two typically indicate the permanent failure of the disk, thus "recovery" means sufficient repair for a one-time recovery of files.
A third type involves the process of retrieving files that have been "deleted" from a storage media, since the files are usually not erased in any way but are merely deleted from the directory listings
The most common "data recovery" issue involves an operating system (OS) failure (typically on a single-disk, single-partition, single-OS system), where the goal is to simply copy all wanted files to another disk. This can be easily accomplished with a Live CD, most of which provide a means to 1) mount the system drive, 2) mount and backup disk or media drives, and 3) move the files from the system to the backup with a file manager or optical disc authoring software. Further, such cases can be mitigated by disk partitioning and consistently moving valuable data files to a different partition from the replaceable OS system files.
The second type involves a disk-level failure such as a compromised file system, disk partition, or a hard disk failure —in each of which the data cannot be easily read. Depending on the case, solutions involve repairing the file system, partition table or MBR, or hard disk recovery techniques ranging from software-based recovery of corrupted data to hardware replacement on a physically damaged disk. These last two typically indicate the permanent failure of the disk, thus "recovery" means sufficient repair for a one-time recovery of files.
A third type involves the process of retrieving files that have been "deleted" from a storage media, since the files are usually not erased in any way but are merely deleted from the directory listings
Subscribe to:
Posts (Atom)
