Opening multiple tabs in Chrome – no extension needed

I love it when we can collaborate with others in the division. I shared my browser workaround with a few folks and someone sent me the link to the article that walks through the following steps.

Many of us have Google Chrome pinned to our task bar. Right-click on that pinned Google Chrome icon, right-click on Google Chrome, and choose Properties

Google Chrome: Properties

Click in the Target: field and use the End button on your keyboard to get to the end of the field.

Google Chrome: Target

In the address area for “Target:” you will need to add the following command to the end of the target path (–pinned-tab-count=x) making certain to leave a single space in between the final quote mark and the “pinned tab count command”. Enter the number of permanent pinned tabs that you would like to have in place of the “x”… in my example below, it shows the number of tabs as 3.

“C:\Program Files (x86)\Google\Chrome\Application\chrome.exe” –pinned-tab-count=3

The second part of this process is to add the URL for each of the websites you want to have open in your (in this case, 3) tabs. Be sure to have a single space between each URL and the pinned tab count command as shown below.

“C:\Program Files (x86)\Google\Chrome\Application\chrome.exe” –pinned-tab-count=3


Opening multiple tabs in Internet Explorer in 3 clicks

If you work at a company where the IT staff has locked down the capability to modify your Startup feature in Internet Explorer, here’s a workaround to your ability to open your favorite sites in a couple of click.

Setting it up

First, if you don’t have the menu bar showing on your IE, right-click at the top of the browser window and choose menu bar.

Open the websites that you normally launched on Startup, then from the Favorites menu, choose Add current tabs to favorites

Internet Explorer Favorites: Add Current Tabs

Give your folder a name

Internet Explorer Favorites: Name Folder

Opening multiple tabs in Internet Explorer in 3 clicks

Next time you load Internet Explorer, click on the Star icon located between the Home and Gear icons at the top right of the browser.

Internet Explorer Favorites Icon

Right-click on the name of the folder, then select Open in tab group

Internet Explorer Favorites: Open in Tab Group

Opening multiple tabs in Chrome in one click

If you work at a company where the IT staff has locked down the capability to modify your Startup feature in Chrome, here’s a workaround to your ability to open your favorite sites in one click.

One of my favorite time saving devices that I have used is setting the home page on my browsers to open certain pages. In talking with some folks in the division, they use this feature also. When the decision was made to override our home page settings, I looked to other solutions for maintaining my ability to open multiple tabs without the need for the home page settings.

In Chrome, you can install this extension, and then add your favorite links to the tabs.

When you first load it, it will show you the options screen where you can add your descriptions and the URLs

Chrome Multi Tab Extension: Add Page

Add your favorite sites (you may need to browse your history if you don’t have those links saved anywhere), so that you end up with a list similar this one.

Chrome Multi Tab Extension: Sites Added

Clicking on the app icon will launch the tabs you have saved.

To make changes to your tabs, right-click on the app icon and choose Options.

Chrome Multi Tab Extension: Options

You can drag and drop the order of your tabs as well which is helpful.

The only thing you cannot do is edit an existing tab, so you would need to select it, delete it, and add a new one.

Overall, this is a nice, single-click workaround to the limitations of locking down the home page options.

Quick Access Toolbar

In older versions of the Microsoft Office suite of products all the commands lived within menus, not in the ribbon as they do now. There was a section of the user interface where you could “dock” various often-used functions, such as font manipulation, open/close/print, etc.

When they went to the ribbon look, Microsoft thankfully didn’t forget us folks who had gotten used to these quick-click functions, and left the Quick Access Toolbar in-tact, which above the tabs.

Each application has slightly different default options, and also offers slightly different commands specific to the application.

Quick Access Toolbar - Word Quick Access Toolbar - Excel
Quick Access Toolbar - Outlook Quick Access Toolbar - OneNote

If you haven’t played with the Quick Access Toolbar, you could miss out on placing some of your most commonly used featured in an accessible spot.

In Outlook, I added the Edit Message feature to the Quick Access Toolbar because I couldn’t find it in the ribbon. I also created new buttons to play my macros that create email templates and clean up my inbox, etc.

I tend to use this toolbar more when I am doing repetitive work. In my current position I have such variety that I haven’t had a need for adding features to the Quick Access Toolbar.

Microsoft Office: Hyperlink Window – continued

In the last post I showed you the basic settings in the Hyperlink Window and we looked at Existing File or Web Page. But if you look at the window below, there are other options, including Place in This Document, Create New Document, and Email Address. I thought we would look at those today.

Place in This Document

Place in This Document gives you some options of headings and bookmarks in Word and Outlook; Cell references and Sheet names in Excel; and Slide options in PowerPoint.

Microsoft Office: Hyperlink Window - place inside document

Create New Document

You can also create a brand new document from the Create New Document feature in this Hyperlink window, which I have never used.

Microsoft Office: Hyperlink Window - create new document

It looks like you can choose where your document will live, and whether you want to open the new document right away, or whether you want to just save it to edit later. Now that I see this feature, I might use it more often, especially since you can create files directly on SharePoint using this method, if you know the location where the file should live.

Microsoft Office: Hyperlink Window - create new document in SharePoint

Email Address

Adding an Email Address will generate this window, which allows you to enter in the Email address and the subject line for the email. This can help quite a bit when you want all the emails about a specific subject to be the same. It will generate a”subject line” type of link and when clicked, will open a new email in Outlook.

Microsoft Office: Hyperlink Window - Email

Microsoft Office: Hyperlink Window

Ctrl + K opens up the Hyperlink window in a number of Microsoft Office suite applications. Another way to get to the Hyperlink window, is to right-click your text, showing the menu. A third way is to use the INSERT ribbon and click on LINK.

Inserting a link activates the “Insert Hyperlink” window box, which looks a little different based on which program you’re in.

I don’t know if I have ever really examined this Insert Hyperlink window, because I usually know where I need to go, which is usually somewhere on the machine in which case I would use the folder window below to browse, or a web address which I would normally have copied from the internet and pasted in the Address bar.

Microsoft Office: Hyperlink Window

But, take a look at this window and all the options it offers: Existing File or Webpage, under which you have Current Folder, Browsed Pages, or Recent Files.

Current folder shows the above view.

Browsed pages looks as below:

Microsoft Office: Hyperlink - Browsed Pages

Recent Files looks as below:

Microsoft Office: Hyperlink - Recent Files

Beyond Existing File or Web Page there are three tabs in the Hyperlink window: Place in This Document, Create New Document, and Email Address, which we will look at more closely in the next post.

Make the same change across multiple worksheets

In working on the Resident Adviser Duty Schedule spreadsheets for Housing and Residence Life, we changed the procedure a little bit. Instead of having 20 individual spreadsheet files with 10 sheets in them for each of the months, we made 10 monthly spreadsheets with 20+ building sheets in them. It allows us to make changes to one master file for the month, and it is referenced by all the building sheets. Using Office 365 we can have 20+ users making schedule updates at the same time without locking the sheet.

You can imagine that formatting and copying and pasting formulae across 20 sheets could be a nightmare, but Excel has that covered for us, and has a way for us to make changes across multiple sheets.

Making changes in multiple sheets

You can select multiple sheets at one time by holding down the Ctrl key as you select the sheets you need to modify. Making a change on the current sheet will then replicate across them all.

Excel: Select Multiple Sheets

If you want to change all the sheets at once then right click one of the sheet tabs and choose Select All Sheets.

Excel: Select All Sheets

Using some of these features in Excel can save us an immense amount of time. Let me know in the comments which features you use most often.