Word: Getting Rid of That Annoying Automatic List Indent

 

Scenario:      Word now indents numbered and bullet list – specifically .25” from the left margin.

 

But you want your list to start back flush with the left margin (like the olden days).

 

Full tip: Word tip

Categories: Word

Read Less

Word: Delete One Page in Your Document

 

Scenario:      You have a multi-page document and you want to delete a page (text and all) from somewhere in the middle.

 

Rather than have to try to select from the start to the end of the page (without accidentally deleting something you shouldn’t have) – let Word select the page for you.

 

Full tip: Word tip

Categories: Word

Read Less

Excel: Shading Alternative Spreadsheet Rows

 

Method #1: Format as Table

 

Method #2: Conditional Formatting

 

Full tip: Excel tip

Categories: Excel

Read Less

Excel (Advanced): Dependent Data Validation Drop-Down Lists

 

You can limit the choices in an Excel data validation list, by using named ranges and the INDIRECT function, to create dependent data validation lists.

 

Full tip: Advanced Excel tip

Categories: Excel

Read Less

Google Chrome: A Few Tiny (but Powerful) Tips

 

If you are not using Chrome for your web surfing – YOU SHOULD BE.

 

Internet Explorer is as good as dead (ask Microsoft – even they’ll tell you that). Firefox? It’s nice. But who wants NICE? You want powerful, efficient, and awesome – you want CHROME!

 

Three solid reasons why I love Chrome…

 

Full tip: Google Chrome tip

Categories: Google Google Chrome

Read Less

Windows 8: Some Mouse & Keyboard Tricks & Tips

 

Windows 8 was designed for touchscreens – but we don’t all have touchscreens. So here are a few little tips for maneuvering around Windows 8 efficiently with your mouse and/or keyboard.

 

First, you need to realize that there are really two “environments” in Windows 8: the METRO screen and the DESKTOP screen.

 

Full tip: Windows tip

Categories: Windows 8

Read Less

Excel: Transposing Columns-to-Rows and Vice Versa

 

Have you ever entered a spreadsheet then realized that you should have had the one set of headings go ACROSS the spreadsheet (instead of down) and the other set of headings go DOWN the spreadsheet (instead of across)?

 

You can quickly and easily transpose the data…

 

Full tip: Excel tip

Categories: Excel

Read Less

iPhone: Strength in Numbers

 

The signal bars at the top (left) corner of your iPhone don’t always reflect the exact strength of your signal. Yes, three bars are lit up – but you’re not feeling the love and wondering if it’s accurate.

 

Well, you can have your iPhone (sorry Droids! <snicker><snicker>) display the EXACT signal strength…in numbers.

 

Full tip: iPhone tip

Categories: iPhone

Read Less

Word: Fancy-schmancy Page Number Trick

 

Page numbering means numbers, right? Not necessarily…

 

Full tip: Word tip

Categories: Word

Read Less

iPhone: See WHO you’re texting

 

I had a friend recently tell me that they got into a bit of a pickle because they thought they texted a friend, X, about an issue they were having at work…when they actually (accidentally) texted a colleague, X – because both people have the same first name and only the first name shows up at the top of the text window. Yikes. Can you say awkward?

 

Well, you can indicate that you want more than just the first name of the recipient to appear at the top of the text window..

 

Full tip: iPhone tip

Categories: iPhone

Read Less