Category Archives: Quick Tips

Little things that are useful to know

Synchronizing across devices

I have a Blackberry Q5 smartphone (running OS10), an ipad, a PC running Windows 7 and a lap top running Windows 8.  I was synchronizing my phone with Outlook on my PC to sync calendar and contacts, and then syncing my ipad with Outlook by connecting to itunes on the PC.

I created a new email address <<myname>>@outlook.com, and set that up on all my devices, set to synchronize contacts and calendar, and now everything is in sync, all the time!  Lovely!

 

Windows 8 – Search

On Windows 8 if you want to search for something, e.g. “check for updates” if you are on the Start screen, simply type “check for updates” and the search function will open and then show your results.

If you click on a possible search result, and then want to go back, move the mouse (or whatever you are using) up to the top left corner – the search results will be displayed – click (or tap) to view them again.

Multi Level List in Word

In Word, if you have a multi level list – in other words a list that has 1.1, 1.2, 1.3 etc and also 1.2.1, 1.2.2 for the items, this can be a useful tip.

To change the level of an element of the list – for example maybe item 1.2 should really be item 1.1.1 – what you do is:

Click on the item you want to change; right click with the mouse, choose Numbering, then Change List Level, then choose the appropriate level.

In Excel to Delete or Add (Insert) a row

To Delete a row in Excel:

In your open spreadsheet, find the row you want to delete, and highlight it :- to do this, move the cursor to the left hand edge of the spreadsheet, and click on the number of the row.  So in the picture below, to delete the row containing ‘Web Design’ click on the number 22 on the far left.insert delete

 

(To increase the size of this picture, click on it)

Now, EITHER
right click with the mouse in the same place, and choose Delete
OR
go to the top ribbon and click on Delete

To add or Insert a row in Excel:

In your open spreadsheet, find the place where you want to add the row, and highlight the row below where you want the new one :- to do this, move the cursor to the left hand edge of the spreadsheet, and click on the number of the row.  So in the picture above, to add a new row above the row containing ‘Web Design’ click on the number 22 on the far left.

Now, EITHER
right click with the mouse in the same place, and choose Insert
OR
go to the top ribbon and click on Insert

SEARCH function

If you have Windows 7, there is a search function which is sometimes handy.  If you are looking in a folder to find a file, and you know what sort of file it is – a picture, document, video etc, but you can’t remember what you called it, if you type ‘kind:’ into the search box on the top right like this:

search boxthen follow that with =picture, or =video, then Windows will search that folder for that type of file. (If this image is too small to see properly, click on it and it will enlarge.)

Sadly, I think it only works for folders, not for libraries.

Tidy up – empty the recycling bin, and defrag the disk

When you delete something, it goes in to the recycling bin; it doesn’t actually get deleted until you empty the recycling bin.  If you delete something by mistake, you can recover it from the recycling bin before you empty it.

To recover something from the bin, right click on the Recycle Bin icon with the mouse, then choose Open, select the item you want to keep, and choose Restore.

To empty the bin, right click on the Recycle Bin icon with the mouse, then choose Empty Recycle Bin, it will ask if you’re sure, say yes.

Every so often it is a good idea to defrag the disk, especially after you’ve deleted a lot of stuff.  (When you are using your PC, the free memory space gets fragmented over time, and this can slow things down a bit.  When you do a defragment all the free memory space is tidied up.)

To defrag the disk, go to the control panel (from the Start menu) and choose System and Security, then Administrative Tools, then Defragment Your Hard Drive.
A new window opens, showing the status of the hard disk – if it is very fragmented, then choose the Defragment Disk button.
Now sit back and let it get on with it!