When we use excel most often shortcut keys speed up our working. Most ofter used shortcut keys in excel as follows –
Contents
To Auto Filter on /off = ctrl+shift+L
This key will activate filter at the top of selection. Same key will be useful to deactivate filter.
To Select only visible cells = Alt+;
This shortcut key is most useful when we want to copy data, where most cells within the range are hidden. To select and copy only visible data, this shortcut key is most useful.
To copy data to below = ctrl+d
This shortcut key copy data from above cell to below cell. using this shortcut key we can copy data from top cell to required number of rows vertically.
To copy data to right = ctrl+r
To copy data to right side of cell, just place selection right side of data cell and press ctrl+r. Data from left cell will be copied selected cell.
in case of multiple cell selection horizontally, start selection from cell which data we want to copy and press ctrl+r. Data from first cell will be copied to all cells right side to that cell.
