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 LifeHacker.com 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
Click in the Target: field and use the End button on your keyboard to get to the end of the field.
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 http://www.facebook.com https://calendar.google.com/ http://www.gmail.com
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
Give your folder a name
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.
Right-click on the name of the folder, then select Open in tab group
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
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.
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.
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.
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.
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.
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.
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.
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.
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 mailto:email@example.com?subject=”subject line” type of link and when clicked, will open a new email in Outlook.
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.
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:
Recent Files looks as below:
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.
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.
If you want to change all the sheets at once then right click one of the sheet tabs and choose 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.