Computer Era
A site about Computer tips, Latest Technology computer News. tech tips on computers, Internet, Windows, networking, review, more
Tuesday, September 12, 2023
Tuesday, January 10, 2017
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.
4. Then click RUN Button on Standard toolbar
5. And there you will get all hideen sheets unhidden.
Share this Post if Your Like.
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
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.
4. Then click RUN Button on Standard toolbar
5. And there you will get all hideen sheets unhidden.
Share this Post if Your Like.
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
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.
4. Then click RUN Button on Standard toolbar
5. And there you will get all hideen sheets unhidden.
Share this Post if Your Like.
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
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.
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.
Subscribe to:
Posts (Atom)