Follow @Twitter: / ishanllb
Follow @Instagram: / ishanllb
Join Our Telegram Channel : t.me/ishanmonitor
My Mic : amzn.to/2CYC2k2
My Camera : amzn.to/394SD1Y
My CPU : amzn.to/2U58Boj
My Monitor : amzn.to/2wnX4rf
Website : www.ishanllb.co
How to use sort and filter in excel in Hindi - Find and replace in excel | Part 29
is video me aap janege ki excel me sort aur filter ko kaise use karte hai aur find and replace function ka kya use hota hai. is video me sirf inke bare me hi baat ki gyi hai aur aapko inki hi practice karni hai.
The Find and Replace dialog. To start, we'll take a quick look at the Find and Replace dialog itself. Open the dialog by pressing Ctrl + F. You can also click the Find & Select button on the far right side of the Home tab and choose Find or Replace. This will bring up the basic Find & Replace dialog
Select the range of cells where you want to replace text or numbers. To replace character(s) across the entire worksheet, click any cell on the active sheet. Press the Ctrl + H shortcut to open the Replace tab of the Excel Find and Replace dialog
If your data range contains any blank columns or rows then it is best to select the entire range of cells. Once the data cell(s) are selected, press Ctrl+Shift+L to apply the filters. The drop down filter menus should appear in the header row of your data, as shown in the image below.
Watch Other Parts Here :
Computer Education Part-1 : • Computer Education Par...
Computer Education Part-2 : • Computer Education Par...
Computer Education Part-3 : • Computer Education Par...
Computer Education Part-4 : • Computer Education Par...
Computer Education Part-5 : • Computer Education Par...
Computer Education Part-6 : • Computer Education Par...
Computer Education Part-7 : • Computer Education Par...
Computer Education Part-8 : • Computer Education Par...
Computer Education Part-9 : • Computer Education Par...
Computer Education Part-10 : • Computer Education Par...
Computer Education Part-11 : • Computer Education Par...
Computer Education Part-12 : • Computer Education Par...
Computer Education Part-13 : • Computer Education Par...
Computer Education Part-14 : • Computer Education Par...
Computer Education Part-15 : • Computer Education Par...
Computer Education Part-16 : • Computer Education Par...
Computer Education Part-17 : • Video
Computer Education Part-18 : • Computer Education Par...
Computer Education Part-19 : • Computer Education Par...
Computer Education Part-20 : • Computer Education Par...
Computer Education Part-21 : • Computer Education Par...
Computer Education Part-22 : • Computer Education Par...
Computer Education Part-23 : • Computer Education Par...
Computer Education Part-24 : • Computer Education Par...
Computer Education Part-25 : • Computer Education Par...
Computer Education Part-26 : • Computer Education Par...
Computer Education Part-27 : • Computer Education Par...
Computer Education Part-28 : • Formula of Sum Average...
Tags: excel in hindi,microsoft excel,ms excel in hindi,How to use sort and filter in excel in Hindi,Find and replace in excel,computer education part 29,computer classes in hindi,excel tutorials in hindi,excel me filter kaise lagate hain,excel me sort filter,excel me find replace,excel me find kese kare,ms excel 2007 classes in hindi,ishan computer academy,ishan llb computer,ms excel ishan llb,ica kiratpur,ica computer course,ishan,excel hindi
5 июл 2019
