Friday, January 4, 2019

Three tips and tricks to make Excel accounting more efficient

There are three tips and tricks to make excel accounting more efficient.


Ctrl + Shift + Function



Ctrl + Shift + F3 Displays the (Insert > Name > Create) dialog box


Ctrl + Shift + F6 Moves to the previous open workbook or window


Ctrl + Shift + F10 Activates the Menu Bar or Shortcut Characters in 2007


Ctrl + Shift + F12 Displays the (File > Print) dialog box


Ctrl + Numbers



Ctrl + 0 Hides the columns in the current selection


Ctrl + 1 Displays the formatting dialog box


Ctrl + 2 Toggles bold on the current selection


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