Hi Friends, after a little break of heavy work i come back to update my blog again. today will check how to insert formula's in blank rows & columns in between of large data.
This will help to complete your task quickly with single minute. lets go inside the How to's.
These are the simple steps to insert formulas in blank columns/rows. you can check the image for
explained view.
This will help to complete your task quickly with single minute. lets go inside the How to's.
These are the simple steps to insert formulas in blank columns/rows. you can check the image for
explained view.
- Create the formula for single cell. for example if u want to get the same value what you have in the above cell, just type = give up arrow and press enter.
- Select all rows/columns.
- Press F5 (Go To).
- Select Blanks.
- All the blank cells had been selected,now right click and go to paste special.
- Select Formula's.
- Now all the blank rows added with formula values.
Check the below image for more cleared explanation .
0 comments:
Post a Comment