Excel in Hindi- Excel Dashboard Trick how to Create Tabs
Topic:-
1. How to Create multiple tabs ina single sheet in Hindi
2. How to create a dashboard trick in Hindi
3. How to use conditional formatting in Hindi
4. How to write Macros in Hindi
5. How to Insert Shapes In Hindi
6. How to select shapes In Hindi
7. How to Working with object In Hindi
8. How to use Shape Format In Hindi
9. How to use Bring Forward, Send Backward In Hindi
10. How to use Selection Pane In Hindi
11. How to Hide and unhide object In Hindi
12. How to Hide and Unhide Columns In Hindi
13. How to Use Aligns In Hindi
14. How to Work with Groups
To know more:- https://forms.office.com/FormsPro/Pag...
How to create tabs in Excel with dashboard VBA programming
Excel Dashboard Trick how to Create Tabs
Excel workbook link:- https://skrlearningpoint-my.sharepoin...
Code:-
"
Sub Empinfo()
With Sheet1
.Shapes("infoon").Visible = msoCTrue
.Shapes("infooff").Visible = msoFalse
.Shapes("hron").Visible = msoFalse
.Shapes("hroff").Visible = msoCTrue
.Shapes("salon").Visible = msoFalse
.Shapes("saloff").Visible = msoCTrue
.Range("D:H").EntireColumn.Hidden = False
Range("I:X").EntireColumn.Hidden = True
End With
End Sub
Sub hours()
With Sheet1
.Shapes("infoon").Visible = msoFalse
.Shapes("infooff").Visible = msoCTrue
.Shapes("hron").Visible = msoCTrue
.Shapes("hroff").Visible = msoFalse
.Shapes("salon").Visible = msoFalse
.Shapes("saloff").Visible = msoCTrue
.Range("K:P").EntireColumn.Hidden = False
Range("D:H,Q:X").EntireColumn.Hidden = True
End With
End Sub
Sub Salary()
With Sheet1
.Shapes("infoon").Visible = msoFalse
.Shapes("infooff").Visible = msoCTrue
.Shapes("hron").Visible = msoFalse
.Shapes("hroff").Visible = msoCTrue
.Shapes("salon").Visible = msoCTrue
.Shapes("saloff").Visible = msoFalse
.Range("S:X").EntireColumn.Hidden = False
Range("D:R").EntireColumn.Hidden = True
End With
End Sub"
#ExcelinHindi, #Skrlearningpoint, #Excel2016, #Excel365, #Sarabexcel, #Office365
FB page: - / excelskrlearningpoint
For more videos- / skrlearningpoint
excel conditional formatting in excel conditional formatting in excel in hindi conditional formatting in excel new rule conditional formatting in excel color coding conditional formatting in google sheets conditional formatting in tableau conditional formatting in libreoffice calc conditional formatting in excel dates conditional formatting in excel in tamil conditional formatting with multiple conditions conditional formatting compare two columns conditional formatting highlight column Excel conditional formatting excel conditional formatting color excel conditional formatting in hindi excel conditional formatting based on another cell excel conditional formatting formula excel conditional formatting tutorial excel conditional formatting new rule formula excel conditional formatting color dates excel conditional formatting formula multiple conditions excel conditional formatting color in hindi
excel tab function excel tab in hindi excel tab data excel tab formula excel tab data excel tab within worksheet excel tab order of cells excel tab name based on cell value excel tab settings excel tab change shortcut excel tab color excel tab hide excel tab order excel tab shortcut create tab in excel create tab in excel cell create tab in excel vba create tab in excel how to create new tab in excel 2007 how to create search tab in excel how to create developer tab in excel how to create tab in excel sheet how to create developer tab in excel 2007 how to create new tab in excel dashboard tab excel