• HOME
  • About Us
    • Who We Are
    • Staff
    • Location
    • Events Calendar
    • Board Members
    • NFLS Documents
    • System Blogs
  • Our Services
    • Continuing Education
    • Delivery
    • Ellison Dies
    • Game Systems
    • Interlibrary Loan
    • Marketing Resources
    • NEWIL
    • Tech Support
    • Travel & Expenses
    • Youth & Inclusive Services
  • Catalogs & Resources
    • Brown County Catalog
    • Digital Collections
    • Helpful Sites
    • InfoSoup
    • OWLSnet
    • OWLS Web
  • Member Libraries
    • NFLS Libraries
    • Member Library Directors
    • OWLSnet Directory
  • Meetings
    • AAC
    • Advisory
    • NFLS Board
    • NEWIL Board
Nicolet Federated Library System

Excel "Find" Options, by Cindy Weber at SCLS

11/24/2015

0 Comments

 
Recently I was looking through a spreadsheet to find the numbers that were in red text.  Now, while that was rather visible, the spreadsheet was huge and there was a large number of rows between each red entry.  While an earlier TechBits article showed how to sort by text color, that wasn't an option in this case since there were subtotals that would have been messed up by resorting the page.
​
Because I knew you could sort​ by color, I figured I could probably search by color too and I was right.  There are a lot of extra Find options actually, you just don't see a number of them because they hide behind the Options button. ​
Picture
If you open the Find window in Excel and click on the Options button on the right hand side just above the Close button, you'll see a number of the Find options.  The ones I've used most often have been: (rest of article...)
0 Comments



Leave a Reply.

    Author

    John's collection of tech tips, trends, and training for NFLS librarians

    Click to set custom HTML

    Archives

    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015

    RSS Feed

    Current blog posts
    Back to Tech Support
    E-Book Resources
    The Tech Tank
    ​Who to Call
Nicolet Federated Library System       1595 Allouez Ave.  Suite 4       Green Bay, WI 54311       P: 920-448-4410      F: 448-4420       Office 365 Email Log In
✕