Monday 'Minder 2022.10


Today’s Topic: Can I get that again?

Excel tip: Format as Table

Sometimes a patron misses picking up their popular hold in time or they didn't get a chance to finish it and they want to put it on hold right away again. There's a quick and easy way to do this.   Read More...

You know about right-clicking in WorkFlows, right? All the cool stuff you can do? If you've forgotten, here's a link to a previous 'Minder to refresh your memory. 

And you know you can see a what a patron has had on hold before (going back at least a month) by switching to "Type of hold: Inactive" on the Holds tab:


You might need to scroll down the screen to see the various Display Options--it just barely appears on my screen and I have a fairly large monitor. Once I've selected "Inactive" from the menu box, you'll see suddenly a lot more holds in my list!

Right-clicking now will provide a quick option to re-place a hold on any of my previous holds that are still in the system.  While it still pulls up the Place Hold Wizard screen, all the patron and item info are already filled in for you. All you need to do is check whether it needs to be copy-level or title-level. Easy-peasy! 

Excel tip: Format as a Table

Say you have an Excel file of statistics. You want to make it look nicer and be able to quickly sort and filter the info. The easiest way to do that is to simply click on any cell and then click on Format as a Table:

Format as a Table is found on the Home tab sort of smack dab in the middle. When you click on it, you will get way too many choices of what style you'd like. 

Once you've picked a style, you'll get:

If, like me, you usually have column headers, make sure the box is checked.  It is also worth looking at the range of cells Excel chose to include.  Sometimes I've noticed that it doesn't include all the rows I think it should.  Click OK, and voila!.....              

Clicking on the down-arrows at the top of the columns provides all sorts of options for sorting and filtering.  If you don't want the down-arrows and all the bells and whistles, but still want the color formatting, just right-click, select Table--> Convert to Range. Then it is no longer a table, but it still looks pretty!

That's it for this week...

Share & Enjoy!




Blog Type: