How to add Mr. Mrs. in front of name in excel automatic / add border / upper lower proper function
Friends in this video you will be able to learn excel very effective function to increase your work productivity.
1 How to add Serial Number in sequence automatically
2 How to add Mr. in front of name
3 How to add Mrs. in front of name
4 How to add Master in front of name
5 How to add Border automatically for recording data in spreadsheet
6 How to make first letter of name Upper case, Lower case or Proper
#excel #database #explore #excel #customlist #learning #Explore #custom #list #learn #define #name #formula #insert #cell #rows #columns #shift #move #education #knowledge #timesaving #time #management #students #school #college #toppers #exam #professional #Information #Info #conditional #formatting
Coding : Go to developer, go to insert, there go to module, paste the coding there, close the developer file, go to view, go to macros, go to view macros, select upper, lower, proper as per video instruction and go to options to do the rest.
Sub upper()
For Each cell In Selection
If Not cell.HasFormula Then
cell.Value = UCase(cell.Value)
End If
Next cell
End Sub
Sub proper()
For Each cell In Selection
If Not cell.HasFormula Then
cell.Value = Application.WorksheetFunction.proper(cell.Value)
End If
Next cell
End Sub
Sub lower()
For Each cell In Selection
If Not cell.HasFormula Then
cell.Value = LCase(cell.Value)
End If
Next cell
End Sub
Explore Twitter Account : / explore43629915
Explore Facebook Account : / explore-100142805429230
Disclaimer -
video is for educational purpose only.Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use.