Sunday, 2 March 2014

Short Cuts 3

Ctrl + 3 Toggles italics on the current selection


Ctrl + 4 Toggles underlining on the current selection


Ctrl + 5 Toggles the strikethrough of text on the current selection


Ctrl + 6 Toggles between hiding, displaying


Ctrl + 8 Toggles the display of Outline symbols on the active worksheet


Ctrl + 9 Hides the rows in the current selection (Format > Row > Hide)


Ctrl + Shift + 0 Unhides the columns in the current selection


Ctrl + Shift + 2 Enters the value from the cell directly above into the active cell


Ctrl + Shift + 8 Selects the current region (surrounded by blank rows and columns)


Ctrl + Shift + 9 Unhides the rows in the current selection


Ctrl + A Displays formula palette given a function name or selects the whole worksheet or current date


Ctrl + B Toggles bold on the current selection


Ctrl + C Copies the current selection to the clipboard


Ctrl + D Copies the first cell in the selection downwards


Ctrl + F Displays the Find dialog box


Ctrl + G Displays the GoTo dialog box


Ctrl + H Displays the Replace dialog box


Ctrl + I Toggles italics on the current selection


Ctrl + K Displays the Insert Hyperlink dialog box


Ctrl + L Displays the Create Table dialog box


Ctrl + N Creates a new workbook


Ctrl + O Displays the Open dialog box


Ctrl + P Displays the Print dialog box


Ctrl + R Copies the leftmost cell in the selection to the right


Ctrl + S Saves, Displays the Save As dialog box if a new workbook


Ctrl + U Toggles underlining on the current selection


Ctrl + V Pastes the entry from the clipboard


Ctrl + W Closes the active workbook or window


Ctrl + X Cuts the current selection to the clipboard


Ctrl + Y Repeats the last workbook action Ctrl + Z Undo the last workbook action

No comments:

Post a Comment