Office 365 Mail Clutter Feature

I had a few people ask me about the Clutter feature in Office 365 mail recently.  Clutter automatically filters out email that you normally ignore and stores it in the Clutter folder instead of the Inbox.  According to the Microsoft documentation, Clutter studies the following to learn your email reading behavior: 

  • The sender Messydesk-300px

  • Whether you participated in the conversation

  • If you’re the only recipient

  • Its importance

You can fine-tune the Clutter feature by right-clicking low-priority mail in your Inbox and selecting Move to Clutter.  You might notice mail in your Clutter folder that you would prefer to appear in your Inbox.  You can right-click this mail and select Move to Inbox.  Within my email, Office 365 has learned that I rarely read Announce emails dealing with Job Announcements and Giveaways.  Those emails automatically get moved to my Clutter folder.  On Sunday evenings I receive an email summarizing what the Clutter feature has been doing for me the past week.

To disable Clutter:

  1. Log into your Office 365 Email
  2. Click the Settings icon (the little gear at the upper-right)
  3. Click Mail at the bottom beneath My app settings
  4. Click Clutter at the left
  5. Uncheck Separate items identified as Clutter
  6. Click Save

Working with Excel’s tabs


 Until recently, I had a pretty limited understanding of some of the options that are available with Excel’s tabs: add, remove and rename. Here are some new tab ‘tools’: color coding, quick pick list and making alltabs go away.

In the past, a typical set of tabs might look like what's below. The tabs had basic labeling. 



What if you could color code your tabs? You can.

  • In Excel, select Format from the Home tab.
  • Select Tab color from the Organize Sheets section.
  • Select a color from the Theme Colors matrix
  • Note: You’ll only be able to see the results of your work after you make another tab the ‘active’ tab.


What if you had a tab pop up list and you could just jump to a specific tab? You can.

  • Excel has a series of arrows in the lower left hand corner.
  • Right click any one of them and a tab pick list will pop up.
  • Select the tab of interest in the list and Excel will take you there.


But wait, there’s more!

What if you wanted more Excel real estate and wanted your tabs to ‘go away’ completely. You can.

Select File, Options, Advanced and then remove the check from Show sheet tabs in the Display options for this workbook section.


Website editing tips: Shift+Enter and Paste as Plain Text

These two website editing tips got such a positive reaction at the latest Drupal Basics website training session that I want to shout them from the rooftops:

Shift+Enter is the keyboard shortcut for "Make a line break without starting a new paragraph and adding a margin of space between lines," like so:


This tip does double-duty: it works in the editor SCLS provides for Drupal websites, and it works in Microsoft Word. This and more keyboard shortcuts are in the Glorious Guide to Keyboard Shortcuts (which was written for Drupal sites hosted by SCLS, but most of the shortcuts are standard across many apps).

Paste as Plain Text (Paste-as-plain-text) is the editing toolbar button to use when you copy a chunk of text and want to paste it into your SCLS-hosted Drupal website without dubious font/size/color formatting. The button opens a popup dialog, and you just hit Ctrl+V to paste your text in. Once pasted, the text will lose all its formatting and you'll be able to reformat it using the toolbar options. It's not just for brand new pages, either—you can also copy existing website content where you have been fighting with troublesome formatting, and paste it in as plain text to start fresh. Also good to know: Remove Format and Source buttons and Ctrl+Shift+V.

Exercise Your Mind with State Resources

BrainContinuing last summer's successful Super Librarian Powers (SLP) Project focusing on databases, Jean Anderson is going to exercise our minds while exploring our state's treasure trove of online resources.

Jean writes:

Most every month, I meet with a group of librarians from state agencies like the State Law Library, Legislative Reference Bureau, Historical Society, Department of Transportation,Department of Justice, Employee Trust Funds, and Resources for Libraries & Lifelong Learning - just to name a few. I learn something new at every meeting and have found a way to share that knowledge with you.

Starting next Monday, June 13, Jean will explore the publicly available resources for six or seven agencies on the Know More blog. Look for a new blog post every other Monday through early September, or subscribe to the blog to automatically receive the posts via email. Stay tuned!

Project Cards & More from Denver Public Library

BlueBearAt the PLA Conference this past April in Denver, I attended a program called Tech Assistance for Cutting Edge Communities. One of the speakers, Tracy Treece, is from the Denver Public Library and she spoke about Project Cards and the many technology classes offered by the library. I was especially intrigued when she said that the Project Cards and the handouts and lesson plans for the classes are all available online.

Check out the Project Cards from Denver Public Library's IdeaLAB. There are six categories: Art & Design; Electronics; Game Design; Music; Video; and Web Design. There are anywhere from 2-9 projects in each category and each project is given a star rating for difficulty. Each card covers the basics, includes great screenshots, step-by-step instructions, and ideas for more.

Next up are the Technology Classes. And, there are a lot of options here and some are even in Spanish. No, you don't have to drive or fly to Denver to take the classes. The handouts and lesson plans are available for you to use for your own learning or in a class at your library. Look at this class for Craigslist 101 and you'll see what I mean. The lesson plans are detailed and include pretty much everything you need to replicate the class in your library.

Everything that Denver has put out there is published under Creative Commons Attribution license. You can use these resources anyway you'd like as long as you credit Denver Public Library. Thanks DPL!



Find a Grave, or why I love technology.

I attended the Support Staff and Circulation Services conference in La Crosse, Wisconsin last week.  I really enjoyed all of the sessions I attended but one piqued my interest so much I spent way to much time later that night exploring.

Barry McKnight works in the La Crosse Public Library Archive Department and he presented a session on "Local History Programming and Partnerships".  One of their programs, "Dark La Crosse", sounded like something I would want to do as a tourist.  As I was researching the LPL Archives and Local History Department's webpage, I kept finding new and interesting links to investigate and, as I said, spent waay too much time exploring.

But my favorite was "Find a Grave".  How cool is that?  Instead of driving and walking and writing to various municipal clerk offices you can plug in a name, or a cemetery or add photos or .....  The last time I was at our family's cemetery I couldn't locate my maternal grandmother's gravesite.  And my Mom and my Aunts couldn't remember either.  But with the use of this tool I found the section, lot and space number. 

I love technology.

Info Sheets for BadgerLink Resources

BadgerLink recently announced they've added "Info Sheets," short and easy-to-digest training materials for educators, librarians, and the general public.  The Info Sheets give a quick overview of the navigation of each resource and also provide information about full-text availability, how to access a permalink, if there is an automatic citation feature, and copyright information for the resource.

Access NewspaperARCHIVE info sheet (p.1)

The Info Sheets and many other types of training materials can be found on the BadgerLink Training page.

More information about the Info Sheets can be found in this  "Announcing Info Sheets and Training Survey" post on the WI Libraries blog.

Sort by Subtotal

If you try to sort an Excel spreadsheet that has subtotals, Excel gives you a "This removes the subtotals and sorts again..." message.  This is fine if you want to sort the underlying rows differently, but what if you want to sort by the subtotals themselves?

To do that, you need to collapse the display so only the subtotals are showing and then do a sort.  This will sort by the subtotal, but not the underlying rows. To collapse the spreadsheet so only the subtotals show, go to the subtotal levels that display on the left hand side of the spreadsheet and click the number at the top that corresponds to the subtotal level that you want to use to sort.  The number may change depending on how complex your spreadsheet is, but in general level 1 shows only the grand total and the last level on the right shows all details.  You may need to experiment to figure out which level is the one you need to use.  In this case, it's a simple subtotal so the level is 2. 


This collapses the spreadsheet so only the subtotals are showing.  When the subtotals are collapsed, you'll see a + sign in the box to the left of the subtotal instead of the - sign. 



Once everything is sorted by the subtotal, you can sort as normal.  If you want to see the details for all of the subtotals again, click on the level button on the right hand side.  In this case, it would be level 3.

Google Keep

Do you like lists? Do you like checking off lists? Do you like sharing your lists? Do you like having lists accessible on your mobile device? Do you have a Google account?

You should be using Google Keep!


I tend to usually use Google Keep for creating collaborative grocery lists with my wife, but it can be used for any myriad of lists and notes. The lists can be synced between PCs, phones, and tablets; and can be shared with other people. Check it out!

PC and laptop order form update

The SCLS PC order form has been updated to include a current Dell PC and laptop.

We are offering the Optiplex 3040 for staff and patron PCs with a starting price of $499.00. The biggest difference between the new 3040 model and the previous models is that it has 8 USB ports, 4 in the front and four in the back. The previous model had 6 USB ports in the back.The new laptop is the Dell Latitude E3570. This is a 15 inch laptop that includes the number pad on the keyboard.

The biggest difference between the old models and the new models is we are starting to offer solid state drives for and extra charge. These drives are much faster than the standard hard drives we are all used too.

Dell is in the process of moving away from the docking stations they’ve supported for the last 10 years to a new USB docking station. The price is comparable to previous docking stations at $103.00.