With “ paste special Paste Special Paste special in Excel allows you to paste partial aspects of the data copied. If a formula cell is copied and pasted, its formula is pasted and not the value of the cell. To develop expertise in Excel, it is imperative to go beyond the basic cut (Ctrl+X), copy (Ctrl+C), and paste (Ctrl+V) shortcuts. However, a regular usage does allow gradual learning. It is not possible to memorize every excel shortcut.
The explanation of each technique is followed by a relevant example. This article discusses the important excel shortcuts which have been consolidated keeping in mind the day-to-day needs of the user. Since such tasks may not have a shortcut, the solution is to create it by recording a macro. This improves the productivity at the workplace.Īt times, the same task is repeated in Excel on a daily basis. The purpose of using an excel shortcut is to save the worksheet creator from extra clicks. The shortcut “Ctrl+W” closes the currently active workbook. Since Excel is used by almost everybody in some form or the other, it is essential to be aware of the shortcuts.įor example, the excel shortcut “Ctrl+O” opens an already existing workbook. The shortcuts help speed up the work, which saves time for the secondary tasks of the job.
An Excel shortcut is a technique of performing a manual task in a quicker way.
0 kommentar(er)
