When browsing the Internet pressing the Space bar will move the page down one page at a time in your browser. If you press Shift+Space bar the page will go up a page at a time.
Quick Drop-down List in Excel
Do you want to repeat data that’s already been used in the column? To enter Yellow in a new cell in the column Excel will bring it up anyway when simply typing Y – this is because there is only one data entry starting with the letter Y. Conversely if you need to enter Blueish, […]
Pin Files and Folders
To pin files to the Recent List in 2010 click on the File tab, Recent. Click on a stickpin, next to a Recent Document that you want to anchor to the top of the list. On the right hand side in Recent Places you can now also pin entire folders permanently to the top of […]
Clipboard
The Clipboard is handy to use when you want to Copy and Paste something but you don’t necessarily want to do the pasting immediately after you’ve done the copy. The Clipboard will also hold items you’ve copied from various programs, not just Word. To use open the Clipboard by clicking on the Clipboard button. Position your insertion […]
Quickest way to review a Sum or Average
A quick way to find the sum and average of cells in Excel 2010 is to select adjacent or non-adjacent cells and look in the status bar. Excel displays the average of the numbers, a count of the cells, and the sum.
Check Disk in Windows 7
Check Disk will scan thorough your entire hard drive and find errors. It’s probably worth doing every month or two. Start > Computer. Right click on the drive you want to check and choose Properties. Select the Tools tab and click the Check now button Check both options in the dialog box if you want […]
Crop to a Shape
First we need a picture in our Word document (Insert tab – Picture). The Picture Tools format ribbon should now be active. If not, click on the image. In the Size group click on the Crop down triangle. Select Crop to Shape and choose any of the available shapes.
Cropping Pictures Word 2010
First we need a picture in our Word document (Insert tab – Picture). The Picture Tools format ribbon should now be active. If not, click on the image. Click on Crop. Click and drag inward any of the four corners to crop from any one side. You can still see the area to be cropped […]
Keyboard strokes for AutoSum
The AutoSum tool is already fast, but even quicker just try selecting a cell at the bottom of a column of figures and press Alt+=, which inserts the =Sum() function (just like AutoSum does).
Customise Excel’s Default Workbook 2010
If you really only use one sheet and not the default three that Excel creates with any new workbook you can customise this to suit your way of working. Change Excel’s default settings by going to the File menu > Options > General. Look in the section ‘When creating new workbooks’ and change ‘Include this […]
