75 tips and tricks for your favourite spreadsheet.
5 Replies
Sushil
(ACA)
(123 Points)
Replied 06 October 2009
too old boss ............ the new office 2007 is completely a new pakage.............jsut chk it out
CA Ruben Balooni
(Professionalism ™)
(1324 Points)
Replied 06 October 2009
thanks for sharing!
post some tricks for MS Excel 2007 too if u have!
Sushil
(ACA)
(123 Points)
Replied 06 October 2009
here are some shortcut keys which can be used to work faster on Excel 2007
CTRL combination shortcut keys
| Key | Descripttion |
|---|---|
| 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+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. |
Recent Topics
- Best Game Platforms
- Need help regarding a non-functioning Private Limi
- RCM on payent of rental charges of commercial prem
- Manufacturing under shops and establishment act?
- If registered person renting immovable property in
- 10 Year Old Pvt Ltd Technology Services Company
- Capital Gain Tax on Gifted Shares
- GST applicability on online course
- What is the Rule 86A. Conditions of use of amount
- Surcharge imposed by CPC for AOP
Related Threads
Trending Online Classes
-
25 Hours GST Scrutiny of Return and Notice Handling(With Recording)
Industry Expert14 February 2025 -
Survey, Search and Seizure under Income Tax Act 1961
CA Hari Agarwal
CAclubindia
