Nicolet Federated Library System
  • Home
  • Libraries
    • Employment Opportunities
  • Online Resources
    • Beanstack Library Reading Challenges
    • Digital Libraries
      • Wisconsin's Digital Library
      • Wisconsin's Online Library: BadgerLink
        • BadgerLink Resource Guide for Public Libraries
    • Library Catalogs
      • InfoSoup Library Catalog
      • Brown County Library Catalog
    • Wisconsin State Documents
      • Wisconsin Digital Archives
      • Wisconsin Legislative Reference Bureau Digital Collections
      • Wisconsin State Government Web Archives
  • Library Services
    • Inclusive Services
    • Youth Services
  • Trustees
  • About
    • NFLS Staff
  • Blog
  • Home
  • Libraries
    • Employment Opportunities
  • Online Resources
    • Beanstack Library Reading Challenges
    • Digital Libraries
      • Wisconsin's Digital Library
      • Wisconsin's Online Library: BadgerLink
        • BadgerLink Resource Guide for Public Libraries
    • Library Catalogs
      • InfoSoup Library Catalog
      • Brown County Library Catalog
    • Wisconsin State Documents
      • Wisconsin Digital Archives
      • Wisconsin Legislative Reference Bureau Digital Collections
      • Wisconsin State Government Web Archives
  • Library Services
    • Inclusive Services
    • Youth Services
  • Trustees
  • About
    • NFLS Staff
  • Blog
Search

Excel "Find" Options, by Cindy Weber at SCLS

11/24/2015

1 Comment

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

Great blog post, thanks for sharing.

Reply



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
Home
Libraries
Employment Opportunities

​Online Resources
Beanstack library reading challenges
Wisconsin's Public Library Consortium digital library

Wisconsin's online resources: BadgerLink
Brown County Library online catalog
InfoSoup libraries online catalog
Vertical Divider
Library Services
Continuing education​​
​Cricut maker
Digitization kits
Ellison dies
​Grants
​Helpful sites & abbreviations
​​Homework hotspot labs​​
​Inclusive Services resources
​​Interlibrary Loan & Delivery

Vertical Divider
Intertype library services
​​Librarians' advisory committee meetings
​​Marketing resources
NFLS newsletters
OWLSnet
​
​Programming & resources (blog)
​​Tech support
​​Travel & expenses

Workforce Development resources
Youth Services resources
Vertical Divider
​Trustees
Board members
Board meetings
Trustee resources
Meetings archive

About
About NFLS
​NFLS staff

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:00 a.m. - 4:30 p.m.
Visitor Hours: By Appointment Only
Accessibility Statement
​​Office 365 Email Login
© Nicolet Federated Library System
  • Home
  • Libraries
    • Employment Opportunities
  • Online Resources
    • Beanstack Library Reading Challenges
    • Digital Libraries
      • Wisconsin's Digital Library
      • Wisconsin's Online Library: BadgerLink
        • BadgerLink Resource Guide for Public Libraries
    • Library Catalogs
      • InfoSoup Library Catalog
      • Brown County Library Catalog
    • Wisconsin State Documents
      • Wisconsin Digital Archives
      • Wisconsin Legislative Reference Bureau Digital Collections
      • Wisconsin State Government Web Archives
  • Library Services
    • Inclusive Services
    • Youth Services
  • Trustees
  • About
    • NFLS Staff
  • Blog