Tag Archives: Excel

Resize a program window to fit half your screen

This is a fantastic Windows 7 feature that quickly resizes a window to fit half your computer screen.
Display two windows side by side in this way to compare their contents or to drag text, objects and files from one window to the other.

1. Click the top bar of a window and attempt to drag it off one side of your screen. Keep dragging until your mouse pointer hits the edge of the screen (drag it as if you’re trying to drag it off the screen).
Then release your mouse.
– The window “snaps” to the side of the screen.

2. Click the top bar of another window and attempt to drag it off the other side of the screen. Again, keep dragging until your mouse pointer hits the edge of the screen.
– The window “snaps” to the side of the screen.

A few helpful tips here:
– Drag a window away from the screen edge to return it to its previous size.
– You can have 4 windows side by side if you have two screens (but you have to use the keyboard shortcut for this setup – see below).
– The keyboard shortcut for this is Windows/Start key + left or right arrow key.

Was this tip helpful to you? Anything else you want to know? Please leave a  comment below!

Like these tips? Want to see MORE?

Learning and Development

Email an open file from Microsoft Office programs

This is a repeat, but I still encounter staff who are overjoyed to discover that you can email a file directly from Word, Excel, PowerPoint… in fact, any Microsoft Office program.

This is very useful when you have finished working on a  file and wish to email it – a much quicker (and simpler) option that opening a new Outlook message and attaching the file to it.

  1. Ensure you have the file open  (as you will if you are working on it).
  2. Click the Email button on the  Quick Access Toolbar.

    quickaccesstoolbar

A new email displays, with the file attached to it.

  1. Complete and send the Email message.

Was this tip helpful to you? Anything else you want to know? Please leave a comment below!Like these tips? Want to see MORE?

Learning and Development

Press Enter!

Please…learn this tip. It’s agonising to watch people not doing this.

Any time you need to click an OK/Submit/Go button on your computer, this tip is going to save you effort and time!

So, you’ve just finished doing something on your computer, and you need to click the OK/Submit/Go button. Which of the following options is quicker, easier, and more efficient?

Option A: Reach out… find your mouse… move it to see where the cursor is on your monitor… move the mouse cursor to that OK/Submit/Go button… carefully, so you don’t miss… and… click it.

OR

Option B: Press Enter.

Yes, you can just press the Enter key on your keyboard!
This has exactly the same result as clicking the OK/Submit/Go button with your mouse, but it is a lot simpler. And easier!

So next time you need to click an OK/Submit/Go button,
JUST PRESS ENTER!

Note: some systems don’t respond to pressing Enter to activate the OK/Submit/Go button. On those systems you will still need to use the mouse.

Was this tip helpful to you? Anything else you want to know? Please leave a  comment below!

Like these tips? Want to see MORE?

Learning and Development

Use Jump Lists to quickly locate your regularly-used files

This tip is brilliant for quick access to files you are working on regularly.

  1. Right-click a program icon in the Taskbar or Start Menu.
    – A list of recently opened files displays.
  2. Click the file you wish to open.
  3. Click the grey pin icon next to a recently opened file to “pin” the file into the list regardless of how many other files are opened.

Use_Jump_Lists

  • NOTE: Pinning Folders in the Windows Explorer jump list is a useful way to create shortcuts to Search topics and Folders you access often.

I demonstrate using Jump Lists in this brief Video Tip.

Was this tip helpful to you? Anything else you want to know? Please leave a  comment below!

Like these tips? Want to see MORE?

Learning and Development