Monday, January 7, 2019

Excel Data Entry Tips and Techniques

There are excel data entry tips and techniques.



Other



= Starts a Formula


Ctrl + ` Toggles between the value layer and the formula layer


Ctrl + Insert Copies the current selection to the clipboard


Ctrl + Shift + ( Unhides any hidden rows within the selection


Ctrl + Shift + ) Unhides any hidden columns within the selection


Ctrl + Shift + Select unequal cells


Alt Toggles the activation of the old Menu Bar


Alt + Shift + Left Arrow Displays the (Data > Group and Outline > UnGroup) dialog box


Alt + Shift + Right Arrow Displays the (Data > Group and Outline > Group) dialog box


Alt + Spacebar Activates the Control Box in the top left-hand corner


End Toggles between switching End Mode on or off


Scroll Lock Toggles between switching Scroll Lock on or off


Shift + Insert Pastes the entry from the clipboard