Friday, July 20th, 2012

5 Cool Excel 2010 tips and tricks

Here are five cool tips, tricks and keystrokes to help your day go faster in Excel:

Display cell formulas and not results

If you want to see the cell in your worksheet display formulas rather than the results of those formulas then  you can do it one of two ways.

Use the keyboard shortcut Ctrl + ~ to toggle formula display on and off

You can also use Formulas > Show Formulas

Start a new line

When you need to add a line break to a cell to start a new line of text press Alt + Enter in the cell. If you just want to wrap a long piece of text in a cell right click the cell and choose Format > Alignment tab > Wrap Text.

Copy the contents of the cell above

To copy the contents of the cell above into the current cell press Control + ‘.

Moving around super fast and super smart

To move from one sheet in a workbook to the next (or in reverse), press Control + PgDn and Control + PgUp.  To move to the next open workbook press Control + Tab or Control + Shift + Tab.

Super quick mouse free SUM formula

Skip taking the mouse to your Ribbon to add a SUM function and do it with a simple keystroke instead. Type Alt + = and Excel adds the SUM function automatically to the current cell. Doesn’t get much easier than that!

Helen Bradley

Friday, April 20th, 2012

Must know Windows 8 keystrokes

Windows 8 makes a lot of use of keystrokes –  more use than other versions of Windows ever has. Here is a list of handy keystrokes, you won’t use all of them but some are totally awesome for getting around. My fave? This week it is Windows + E! yeah instant access to My Computer – you gotta love it!

Windows key              display the Start menu

Windows + tab           display the task switching panel

Windows + C              reveal Charms

Windows + D              switch to the desktop

Windows + M             switch to the Desktop

Windows + H              Share charm

Windows + I               Settings charm

Windows + K               Devices charm

Windows + L              Lock the screen

Windows + P             shows second monitor options

Windows + Z              display an app’s application bar

Windows + T              Cycle through small images of open apps – press Enter to switch

Windows + Q             Open Metro search charm

Alt + Tab                    Cycle through open apps

Windows + , (comma) Show desktop (temporarily)

Right click an application window                 reveal the application bar

Windows + PrtSc        Capture a picture and save it to the Pictures folder

Windows + Space       change input language and keyboard

Windows + R                          Display the Run dialog

Windows + T                          Cycle through programs on the taskbar

Windows + F                          Find other computers on your network

Windows + E                          Open Windows Explorer and show My Computer

Windows + left arrow             Dock a desktop app to the left of the screen

Windows + right arrow           Dock a desktop app to the right of the screen

Windows + Shift + Up arrow maximize desktop app’s height (width is unchanged)

Windows + Shift + Down arrow        restore/minimize desktop app’s height (width is unchanged)

Windows + 1 (or 2, 3…)         Launch or switch to the application at this position on the taskbar

Windows + Shift + 1 (or 2, 3…)        Launch a new instance of the application at this position on the taskbar

Windows + + (plus)                Magnifier – zoom in

Windows + – (minus)              Magnifier – zoom out

Helen Bradley

Thursday, January 12th, 2012

Ten best Photoshop shortcuts

Photoshop has a huge range of shortcut keys for speeding up your day. Here are my ten best shortcut keys that I suggest you add to your Photoshop toolkit:

Find the sizing handles

When you paste a layer or selection into a Photoshop image – if it is larger than the current image it can be difficult to find the sizing handles.

To find them, press Ctrl + T, then Ctrl + 0 (zero) or on the Mac – Command + T, Command + 0. This selects Transform and sizes the image inside the window so you can see the sizing handles.

Flatten layers but keep them too

Sometimes you need, for example, to flatten the layers in an image to sharpen the result but you don’t want to get rid of the layers either. Here’s how to have your cake and eat it too (or more accurately, flatten your layers and keep them too).

Add a new empty layer to the top of the layer stack, click in it and press Ctrl + Alt + Shift + E (Command + Option + Shift +E on the Mac). This adds a flattened version of the image to the new layer but leaves the layers intact too.

Fill a layer

To fill an empty layer with the current foreground or background color use Alt + Delete or Option + Backspace on the Mac to fill the layer with the Foreground color or Ctrl + Delete or Command + Backspace on the Mac or to fill with the Background color.

Select a color from the image

When you’re working with a Photoshop brush and you want to sample a color from the image, instead of clicking the Eyedropper tool and then the Brush tool again, you can do it with a keystroke.

Hold the Alt the key (Option on the Mac) to switch temporarily to the Eyedropper tool and click to select a new foreground color. Let go the Alt/Option key to return to the brush.

Move a selection

Moving a selection is notoriously cumbersome without this keystroke: to move a selection while you are still drawing it, press and hold the Spacebar. Continue to hold the it while you move the selection and let it go when the selection is in the correct place.

Adjusting brush size

When you’re using a brush as an eraser, to paint with or in any tool that uses brushes, you can size the brush up or down using the [ and ] keys on the keyboard. In Photoshop CS5, you can hold the Alt key and the right mouse button (on the Mac use the Control + Option keys) and drag up to increase or decrease brush hardness and drag left and right to size the brush.

Scrubby sliders

Not technically a keystroke but a “must know” tool are scrubby sliders. In Photoshop CS3, and later, most options in most dialogs that can be adjusted using a slider can also be adjusted using a scrubby slider. Scrubby sliders appear as a hand with a pointing finger icon when you hold your mouse over the slider name. Drag on the name to adjust the slider value.

Zoom and Move with dialogs open

When a dialog such as the Layer Style dialog is open you can access the Zoom and Move tools by using Ctrl (Command on the Mac) to zoom in and Alt (Option on the Mac) to zoom out of the document. Use the spacebar to access the Hand tool to move the document around.

Hidden tools

Tools that share a tool palette position and a shortcut keystroke letter can be easily selected using the keystroke letter. So, for example, to access the Mixer Brush which shares a tool position with the Brush tool and if the Mixer Brush is hidden, press B to get the Brush tool. The press Shift + B until the Mixer Brush appears. In a similar way press M to get the Rectangular Marquee tool and Shift + M to get the Elliptical Marquee tool.

Precise and crosshair cursors

Finally, not so much a keyboard shortcut as something that can go horribly wrong –  pressing the Caps Lock key switches the Brush cursor into precise mode. This is a small crosshair cursor and hides the actual size of the brush. To return to the regular normal or standard brush tip, press the Caps Lock key again.

If I were helping a new user learn Photoshop, these are ten keystrokes I’d be teaching them. Do you agree or what keystrokes do you think are the most important to learn in Photoshop?

Helen Bradley