Many times you want to repeat some actions. You can do repetitive task faster by pressing Ctrl + Y for repeat. Some actions, such as using a function in a cell, cannot be repeated.
For example you have filled a cell with a color. And you want all the cells that need value to of the same color. Then do the following.
1. In first cell fill the color that you want the cell to be filled by.
2. Click on the cells that you want to fill with same color and press Ctrl + Y.
Happy excelling.
Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and + post if you find it useful. follow us to get more.
Leave a Reply