Nicolet Federated Library System
  • Libraries
    • Advocacy
    • Curbside Pickup
    • Employment Opportunities
    • Fast Facts
  • Catalogs & Resources
    • Beanstack Library Reading Programs
    • Brown County Library Catalog
    • InfoSoup Library Catalog
    • OWLSnet
    • Wisconsin's Digital Library
    • Wisconsin's Online Library: BadgerLink
  • Library Services
  • Trustees
  • NEWIL
  • About Us
    • NFLS Staff
    • NFLS Staff Calendar
  • Blog
  • Libraries
    • Advocacy
    • Curbside Pickup
    • Employment Opportunities
    • Fast Facts
  • Catalogs & Resources
    • Beanstack Library Reading Programs
    • Brown County Library Catalog
    • InfoSoup Library Catalog
    • OWLSnet
    • Wisconsin's Digital Library
    • Wisconsin's Online Library: BadgerLink
  • Library Services
  • Trustees
  • NEWIL
  • About Us
    • NFLS Staff
    • NFLS Staff Calendar
  • Blog
Search

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

    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    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

    Back to Tech Support
    The Tech Tank
NFLS homepage
Nicolet Federated Library System
1595 Allouez Avenue, Suite 4
Green Bay, WI 54311

Phone: 920-448-4410
​Fax: 920-448-4420
Staff Hours: Weekdays, 8:00 a.m. - 4:30 p.m.
Visitors Hours: By Appointment Only
Accessibility Statement
​Office 365 Email Login
  • Libraries
    • Advocacy
    • Curbside Pickup
    • Employment Opportunities
    • Fast Facts
  • Catalogs & Resources
    • Beanstack Library Reading Programs
    • Brown County Library Catalog
    • InfoSoup Library Catalog
    • OWLSnet
    • Wisconsin's Digital Library
    • Wisconsin's Online Library: BadgerLink
  • Library Services
  • Trustees
  • NEWIL
  • About Us
    • NFLS Staff
    • NFLS Staff Calendar
  • Blog