Nicolet Federated Library System
  • Libraries
  • Online Resources
    • Library Catalogs
      • InfoSoup Library Catalog
        • InfoSoup App
      • Brown County Library Catalog
    • Digital Libraries
      • Wisconsin's Digital Library
      • Wisconsin's Online Library: BadgerLink
        • Resource guide for public libraries
    • Wisconsin State Documents
      • Wisconsin Digital Archives
      • Wisconsin Legislative Reference Bureau Digital Collections
      • Wisconsin State Government Web Archives
    • Beanstack library reading challenges
  • Library Services
  • Trustees
  • About
  • Blog
  • Translation
  • Libraries
  • Online Resources
    • Library Catalogs
      • InfoSoup Library Catalog
        • InfoSoup App
      • Brown County Library Catalog
    • Digital Libraries
      • Wisconsin's Digital Library
      • Wisconsin's Online Library: BadgerLink
        • Resource guide for public libraries
    • Wisconsin State Documents
      • Wisconsin Digital Archives
      • Wisconsin Legislative Reference Bureau Digital Collections
      • Wisconsin State Government Web Archives
    • Beanstack library reading challenges
  • Library Services
  • Trustees
  • About
  • Blog
  • Translation
Search

Excel "Find" Options, by Cindy Weber at SCLS

11/24/2015

 
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...)
BBW Louisiana link
3/13/2021 12:37:34 pm

Great blog post, thanks for sharing.


Comments are closed.

    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
​Libraries
  • Employment opportunities
  • ​Share your library story
  • Public library fast facts
Vertical Divider
​​Online Resources
  • Library Catalogs
    • ​​InfoSoup library catalog
      • ​InfoSoup App
    • Brown County Library catalog
  • ​Digital Libraries
    • ​Wisconsin's Digital Library
    • Wisconsin's Online Library: BadgerLink
      • Resource guide for public libraries
Vertical Divider
  • ​Wisconsin State Documents
    • ​Wisconsin Digital Archives
    • Wisconsin Legislative Reference Bureau Digital Collections
    • Wisconsin State Government Web Archives
  • Beanstack library reading challenges
Vertical Divider
Library services (for staff)​
​Trustees
  • Board members
  • Board meetings
  • Trustee resources
  • Meetings archive
About
Blog
return to homepage
Nicolet Federated Library System
1595 Allouez Avenue, Suite 4, Green Bay, WI 54311
Email: nic@nflsoffice.org
​Phone: 920-448-4410
​Fax: 920-448-4420
Staff Hours: Weekdays, 8:30 a.m. - 4:30 p.m.
Visitor Hours: By Appointment Only
Accessibility Statement
Language Translation
© Nicolet Federated Library System
  • Libraries
  • Online Resources
    • Library Catalogs
      • InfoSoup Library Catalog
        • InfoSoup App
      • Brown County Library Catalog
    • Digital Libraries
      • Wisconsin's Digital Library
      • Wisconsin's Online Library: BadgerLink
        • Resource guide for public libraries
    • Wisconsin State Documents
      • Wisconsin Digital Archives
      • Wisconsin Legislative Reference Bureau Digital Collections
      • Wisconsin State Government Web Archives
    • Beanstack library reading challenges
  • Library Services
  • Trustees
  • About
  • Blog
  • Translation