Monday, July 4, 2016

Excel Tips : How to unhide Multiple Sheets in Excel

Steps to Unhide all the sheets in Excel at once.
1. Press Alt+F11 or Developer >> Visual Basic
2. Go to Insert >> Module
3. In the VBA Code Editor Window, copy and paste the following Code.


Sub Unhide_Multiple_Sheets()
Dim ws As Worksheet
 
    For Each ws In ActiveWorkbook.Worksheets
     
        ws.Visible = xlSheetVisible
 
    Next ws

End Sub




4. Then click RUN Button on Standard toolbar
5. And there you will get all hideen sheets unhidden.

Share this Post if Your Like.

Excel Tips : How to unhide Multiple Sheets in Excel

Steps to Unhide all the sheets in Excel at once.
1. Press Alt+F11 or Developer >> Visual Basic
2. Go to Insert >> Module
3. In the VBA Code Editor Window, copy and paste the following Code.

Sub Unhide_Multiple_Sheets()
Dim ws As Worksheet
 
    For Each ws In ActiveWorkbook.Worksheets
     
        ws.Visible = xlSheetVisible
 
    Next ws

End Sub



4. Then click RUN Button on Standard toolbar
5. And there you will get all hideen sheets unhidden.

Share this Post if Your Like.

Excel Tips : How to unhide Multiple Sheets in Excel

Steps to Unhide all the sheets in Excel at once.
1. Press Alt+F11 or Developer >> Visual Basic
2. Go to Insert >> Module
3. In the VBA Code Editor Window, copy and paste the following Code.

Sub Unhide_Multiple_Sheets()
Dim ws As Worksheet
    
    For Each ws In ActiveWorkbook.Worksheets
        
        ws.Visible = xlSheetVisible
    
    Next ws

End Sub




4. Then click RUN Button on Standard toolbar
5. And there you will get all hideen sheets unhidden.

Share this Post if Your Like.

Friday, March 25, 2016

Excel Tips : Split the Column of Data based on what you type..



You need to seperate first and last names (or part names and numbers, or any other data) into separate columns. A new Excel 2013 feature called Flash Fill can help.

1. Enter the first name or other value in the columns next to your data and press Enter.
2. Start typing the next name. Flash fill will show the suggested names. 
3. If it looks good just press Enter to accept the list.

To continue typing without using suggested name, Press Escape..

Tuesday, March 22, 2016

Know your Internet browser shortcuts

here are dozens of different shortcut keys that can be used with Internet browsers. Below are a few of our top suggested Internet browser shortcuts.


  • Press Alt + D or Ctrl + L to move the cursor into the address bar
  • Hold down the Ctrl key and press the + or -to increase and decrease the size of text. Ctrl + 0 will reset the text.
  • Press the backspace key or press Alt key + left arrow to go back a page.
  • Press F5 or Ctrl + R to refresh or reload a web page.
  • Press F11 to make the Internet browser screen full screen. Press F11 again to return to the normal view.
  • Press Ctrl + B to open your Internet bookmarks.
  • Press Ctrl + F to open the find box to search for text within the web page you are reading.