Excel 2010 Keyboard Shortcuts
| Ctrl combination shortcut keys Key | Description | Key | Description |
| CTRL+PgUp | Switches between worksheet tabs, from left-to-right. | CTRL+SHIFT+Plus (+) | Displays Insert dialog box to insert blank cells. |
| CTRL+PgDn | Switches between worksheet tabs, from right-to-left. | CTRL+Minus (-) | Displays Delete dialog box to delete selected cells. |
| CTRL+SHIFT+( | Unhides hidden rows within the selection. | CTRL+; | Enters current date. |
| CTRL+SHIFT+& | Applies outline border to selected cells. | CTRL+' | Copies a formula from the cell above the active cell into the cell or the Formula Bar. |
| CTRL+SHIFT_ | Removes outline border from selected cells. | CTRL+1 | Displays Format Cells dialog box. |
| CTRL+SHIFT+~ | Applies General number format. | CTRL+2 | Applies or removes bold formatting. |
| CTRL+SHIFT+$ | Applies Currency format with two decimal places (negative numbers in parentheses). | CTRL+3 | Applies or removes italic formatting. |
| CTRL+SHIFT+% | Applies Percentage format with no decimal places. | CTRL+4 | Applies or removes underlining. |
| CTRL+SHIFT+^ | Applies Scientific number format with two decimal places. | CTRL+5 | Applies or removes strikethrough. |
| CTRL+SHIFT+# | Applies Date format with day, month, and year. | CTRL+6 | Alternates between hiding and displaying objects. |
| CTRL+SHIFT+@ | Applies Time format with the hour and minute, and AM or PM. | CTRL+8 | Displays or hides the outline symbols. |
| CTRL+SHIFT+! | Applies Number format with two decimal places, thousands separator, and minus sign (-) for negative values. | CTRL+9 | Hides selected rows. |
| CTRL+SHIFT+* | Selects current region around active cells. In PivotTables, it selects entire PivotTable reports. | CTRL+0 | Hides the selected columns. |
| CTRL+SHIFT+: | Enters the current time. | CTRL+A | Selects entire worksheet. |
| CTRL+` | Alternates between displaying cell values and displaying formulas. | CTRL+SHIFT+A | Inserts argument names and parentheses when insertion point is to the right of function names in formulas. |
| CTRL+SHIFT+" | Copies value from cell above an active cell into the cell or the Formula Bar. | CTRL+B | Applies or removes bold formatting. |
The West Bengal Board of Secondary Education has completed the WB 10th Class exam from February 2023. Nearly 10+ lakhs students completed the examination in 2,839 various exam centres. Due to the Covid-19 WB Board 10th Syllabus 2023 pandemic issue across the globe,
BalasHapusYour posts are really helpful. Thank you for sharing your knowledge. You can also check out Schedule in WAT time for the FIFA World Cup 2022 which is hosted by Qatar. The world cup will start from 21st November.
BalasHapus