Monday, January 27, 2014

Tip #121 Finding Files

100 (or more) Computer Tips in 100 (or more) Days

Tip #121 - Finding Files

Some of my best tips come from working with my husband. He's my typical client, someone who uses the computer every day but never got the basics down. He was struggling to find a document from four years ago that he was sure he had saved...but where...that was the question.

In both the Apple and PC environment there is a fabulous search feature right in the folder window. If you think you saved a document in the documents folder then navigate to that folder first before you perform your search. My husband was not sure where he might have put the folder so we went to the Libraries folder which allowed us to search just about everywhere someone would save a document. In the Apple environment navigate to the Finder.

In the Search box type in the word(s) you think were in the file, not necessarily in the file name but words that might have been used in the file. Yes, you see that the search is not just for file names but the CONTENTS of the file are returned too. You should try to come up with a unique term to search for or you will get too many results. Once we put in the unique word we found the document lickety split.



My second book, Excel's Amazing Pivot Tables, should be out in a few months. Click the Subscribe button on the right so I can let you know when it's available for purchase.

Happy Computing!



Diane

Don't forget to click the Subscribe to 100 Computer Tips in 100 Days via email link on the right side of the screen so you get email alerts when Diane adds a new post.

Want more tech news or interesting links? You'll get plenty of both if you keep up with Diane McKeever, the writer of 100 Computer Tips in 100 Days, by subscribing to her Facebook posts or visiting her web page, www.dianemckeever.com . 



Monday, January 20, 2014

Tip #120 - Opening and Attaching Files

100 (or more) Computer Tips in 100 (or more) Days

Tip #120 - Opening & Attaching Files

If you use your computer as much as I do you probably spend a good part of your day creating and saving documents that need to be attached up uploaded. If you are in any Microsoft Office program you can do this easily by clicking on the Email button you added to the Quick Access Toolbar (click to view that tip) or by going to the File menu and choosing Save & Send (see the 4 steps in the figure below).


Did you also know that when you open the attach dialog box and navigate to the folder that contains the file, you can begin to type in the name of the document you want to attach in the File Name box. This is really helpful when you have a folder with lots of files in it. Give it a try the next time you need to open or attach a file.


My second book, Excel's Amazing Pivot Tables, should be out in a few months. Click the Subscribe button on the right so I can let you know when it's available for purchase.

Happy Computing!



Diane

Don't forget to click the Subscribe to 100 Computer Tips in 100 Days via email link on the right side of the screen so you get email alerts when Diane adds a new post.

Want more tech news or interesting links? You'll get plenty of both if you keep up with Diane McKeever, the writer of 100 Computer Tips in 100 Days, by subscribing to her Facebook posts or visiting her web page, www.dianemckeever.com . 


Named Cells and Ranger in Excel

Great Computer Tips Named Cells and Ranges in Excel Naming cells Cells already have names such as A1, B27, etc. but you can also give them n...