Blog

How to Change the Behavior of the Enter Key in Excel

00_lead_image_enter_key_behavior

By default, when you type information into Excel and then press “Enter”, Excel will move the selection box one cell down. However, what if you want to enter information from left to right instead?

We’ll show you a simple setting in Excel you can change that will solve your problem.

To change the direction the selection moves when you press “Enter”, click the “File” tab.

01_clicking_file_tab

On the backstage screen, click “Options” in the list of items on the left.

02_clicking_options

The “Excel Options” dialog box displays. Click “Advanced” in the list of items on the left.

03_clicking_advanced

In the “Editing options” section, make sure the “After pressing Enter, move selection” check box is selected. Then, select an option from the “Direction” drop-down list. For example, we chose “Right” to make the selection go from the “Price (Dollars)” column to the “Price (Euros)” column in the price sheet pictured at the beginning of this article.

04_after_pressing_enter_option

Click “OK” to accept the change and close the “Excel Options” dialog box.

05_clicking_ok

If you don’t want the selection to change when you press “Enter”, turn off (deselect) the “After pressing Enter, move selection” check box. The currently selected cell will stay selected when you press “Enter”.

 

 

Source: howtogeek.com

Posted in: Uncategorized

Leave a Comment (0) →

How to help teens stay safe online

 

We all think we know about the dangers of the internet, sexting, bullying, cyber crime. There are lots of articles and apps that help us keep younger children safe. Many tablet manufacturers are including parental controls with child profiles. Amazons Fire tablet is a good example and How To Geek have just written a great blog about the best way to utilise these features here.

teenager comp

But what about teenagers? Due to them being secretive by nature with adults and the propensity to be just a little bit stroppy, they are arguably more at risk as than their younger siblings.

What a teen does on line now can affect uni offers and even job prospects later in life. So how do we help today’s young people stay safe while still making the most of all technology has to offer?

One in five UK employers now admits to using social networking sites to research job candidates, while almost a third (29 per cent) of US university staff regularly Google students as part of their applications process.

We have to talk with our teenagers about this, they may not want to listen but we have to try!

 

Post sensibly

Only ever post something you would be happy to say to someone’s face.

Try not to post when you are angry/upset/drunk – it never ends well!

If it is none of your business, leave it alone.

 

Be Safe

Ok it’s embarrassing but talk to teenagers calmly about sexting, trolling, and bullying.

Help them decide what privacy settings they need on all of the platforms they use. Do they really want the whole of the web seeing their Facebook posts?

Look at strategies for dealing with issues like sexting. In 2013, ChildLine launched Zipit, a free app to help teenagers refuse requests for explicit images of themselves by offering a choice of witty responses instead.

 

Keep it real

Above all keep a sense of humour and perspective. Good luck!

Posted in: Uncategorized

Leave a Comment (0) →

Lookup an email address/phone number in Outlook’s Address book

When working in Outlook, do you often want to look up an email address or phone number in your Global Address Book?

This tip will show you how to display the Address book from any folder in Outlook, e.g. Mail, Calendar.outlook

Press CTRL + SHIFT + B to quickly display the Address Book.

Use the Address Book to search for an email address, phone number, or any other related address information.

Posted in: Uncategorized

Leave a Comment (0) →

Headers, Footers and Page Numbers

Headers and footers are useful for repeating the same piece of information at the top and/or bottomhelpful tips of each page, such as if you want to have the title of your book at the top of each page, or page numbers.

Word allows you to choose from a range of predesigned styles.

 

 

To create a header select the insert tab and then header.

headers1

 

 

 

 

 

 

 

 

 

When you have chosen a style, the header or footer will open. You will also see the Header/Footer Ribbon which will give you specific formatting options.

header3

 

 

 

 

 

 

 

Now you can type into your header or footer and decide how you would like it aligned, if it needs to be on every page etc.

In the same way you can add page numbers. If you want to “Format Page Numbers,” you can use dialogue box, which will allow you to change the number format, add chapter numbers, and choose where it starts from.

Posted in: Uncategorized

Leave a Comment (0) →

Remove paragraph formatting in Word

This is a little known, but powerful keyboard shortcut that removes all paragraph formatting with two keystrokes. 

helpful tips

For example, if a document contains a centered double spaced paragraph that you would like to return to the default left aligned single spaced paragraph formatting, press CTRL + Q.
The paragraph formatting will be instantly removed and the paragraph will be returned to the default single spaced left aligned paragraph formatting

Posted in: Uncategorized

Leave a Comment (0) →

Display the desktop and other Windows key shortcuts

helpful tipsLooking for the Start menu?
Press the Windows logo key to display the Start menu.

Looking for the Desktop?
Press the Windows logo key + D to easily display the desktop.

Open Windows Explorer faster
Are you still mousing over to a Windows Explorer icon or double-clicking on My Computer to browse your files?
Try pressing the Windows logo key + E instead, to instantly launch Windows Explorer.

Lock Windows quickly
Whether you’re at the office, library, or cafe, it’s always a good idea to lock Windows before you step away.
To lock Windows quickly, press the Windows logo key + L.

Posted in: Uncategorized

Leave a Comment (0) →

Reopen a recently closed Browser tab

That horrid feeling when you have just closed a browser tab by mistake or need to re-open a recently closed website? Don’t panic – all is not lost.helpful tips

With the browser still open, press Ctrl+Shift+T. The tab that you accidentally closed will re-open.
Repeatedly pressing Ctrl + Shift + T, will open previously closed tabs in the order they were closed.

Posted in: Uncategorized

Leave a Comment (0) →
Page 1 of 4 1234