Tag Archives: outline

Excel Keyboard Shortcuts – Control with Symbols

Another selection of keyboard shortcuts. Press Control and the following symbols:

 

` – Toggles between displaying cell values and formulas in the current worksheet.

~ – Cell format is General.

! – Cell format is Number with two decimal places, commas, and minus symbol for negative values.

@ – Cell format is Time hour and minute, and AM or PM.

# – Cell format is Date (dd-mmm-yy).

$ – Cell format is Currency (with 2 decimal places and negatives in brackets).

% – Cell format is Percentage (with no decimal places).

^ – Cell format is Exponential with two decimal places.

& – Adds outline border on selected cells.

* – Selects the range of cells around the active cell.

( – Unhides all hidden rows in the selection.

) – Unhides all hidden columns in the selection.

– – Delete the selected cells.

_ – Removes outline border on selected cells.

+ – Insert cells.

; – Enters the current date.

: – Enters the current time.

‘ – Copies a formula from the cell above.

” – Copies the value from the cell above.

Excel Keyboard Shortcuts – Easy as Control + 123…

Continuing our series of Microsoft Excel Keyboard Shortcuts, we’re looking at what the number keys do when you press them with Control…

1 – Format cells

2 – Bold

3 – Italic

4 – Underline

5 – Strikethrough

6 – Hide/Unhide Object

7 – Hides or displays the standard toolbar

8 – Hides or displays the outline symbols

9 – Hide selected row(s)

0 – Hide selected column(s)