Start speeding up the way you use Office Excel by setting it up to reflect your personal needs. Open Options from the Tools menu, File ribbon or Office button, then work your way through the options on offer. Set up how many worksheets you prefer new workbooks to contain from the General section, and choose a default format and location new files are saved to from the Save section. When entering data, make use of the Fill Handle to dramatically speed up data entry – just type in a figure, then click and drag the fill handle down or to the right to duplicate the number or formula in each [...]

Continue Reading...

Google’s Chrome browser is marketed as a streamlined browser that removes all unnecessary bloat in order to maximise its speed on the web. But its lack of bells and whistles shouldn’t be misinterpreted as a lack of functionality. There are still plenty of ways that you can tweak Chrome to suit your own surfing habits.. 1. Useful Chrome shortcuts As with other browsers, you can use keyboard shortcuts to save time. Use [Ctrl]+[B] to toggle the Bookmarks bar, [Shift]+[Esc] to open Chrome’s Task Manager and [Ctrl]+[J] to bring up the Downloads window. Move the cursor without moving [...]

Continue Reading...

Getting used to using your keyboard exclusively and leaving your mouse behind will make you much more efficient at performing any task on any Windows system. I use the following keyboard shortcuts every day: Windows key + R = Run menu This is usually followed by: cmd = Command Prompt iexplore + “web address” = Internet Explorer compmgmt.msc = Computer Management dhcpmgmt.msc = DHCP Management dnsmgmt.msc = DNS Management services.msc = Services eventvwr = Event Viewer dsa.msc = Active Directory Users and Computers dssite.msc = Active Directory Sites and Services Windows key [...]

Continue Reading...

Hard ResetOld: *#7370# or “Original Settings” dialogueNew: hold Green (send) and 3 and * whilst turning onLock code: 12345 Holding down # will toggle between the current profile and silent modeBlue Function Key + Ctrl activates Bluetooth.Blue Function Key + Chr activates IR.Ctrl + C copiesCtrl + X cutsCtrl + V pastesCtrl + Joystick Down functions as Page Down (goes to the next page down)Ctrl + Joystick Up functions as Page Up (goes to the next page up)Shift + Joystick Left or Right highlights one letter at a time.Shift + Ctrl + Joystick Left or Right highlights one word at a time.Ctrl + Joystick [...]

Continue Reading...

101 Hidden Tips & Secrets For Photoshop Press Tab will hide tool bar and palette, Shift+Tab will hide only palette. Hold Shift + click the top blue bar for toolbar and palette will move them to the nearest edge. Double click the top blue bar, on any palette window, to minimize it. Double click the gray background will bring up open file option, Hold Shift+double click will open up the browser. Sick of the default gray background around your image? Select paint bucket, hold shift and click on the gray background, it will change to whatever color you have in your foreground color box. 6. In [...]

Continue Reading...