Topic Wiki

For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by shoobi on November 12, 2015, 11:24:07 PM »

Author Topic: Excel Help and Problems  (Read 121845 times)

Offline jose34

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2016
  • Posts: 1593
  • Total likes: 59
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Help and Problems
« Reply #1410 on: July 06, 2020, 03:12:13 AM »
Very Impressed with https://exceljet.net/.
Explains formulas in text and has some videos.
Very clean interface and easy to learn from.   

Offline yoruel

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: May 2013
  • Posts: 676
  • Total likes: 1
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: New York
Re: Excel Help and Problems
« Reply #1411 on: August 04, 2020, 10:49:52 AM »
Is there a way to use ctrl f, on multiple open sheets?
If I don't know which sheet the information is in

Online cgr

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2017
  • Posts: 1988
  • Total likes: 321
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Excel Help and Problems
« Reply #1412 on: August 04, 2020, 10:59:21 AM »
Is there a way to use ctrl f, on multiple open sheets?
If I don't know which sheet the information is in
I'm assuming you mean workbooks (to search multiple worksheets within the same workbook just click on Options and select Workbook instead of Sheet).
There's no built in excel functionality to search across multiple workbooks so assuming you don't want to go the VBA route, you can search the folder instead of the file. This will isolate the file containing your desired text and while it won't give you the cell location you can then search within that particular Workbook for the cells containing the data desired.