GOOGLE SEARCH TIP

Did you know that you can do a GOOGLE search from your cell phone?  You simply text message your search query to 466453 ('GOOGLE' on most devices) and they'll text message back results.  For example if you text "Pizza 10538" you'll get the messages below.

 

(1/2)Local Listings:
Nicky's Pizzeria & Restaurant
144 Chatsworth Ave
Larchmont, 10538
914-834-3232

 

(2/2)Villa Maria Pizza
6 Chatsworth Ave
Larchmont, 10538
914-834-8134

Wraps O Things
1936 Palmer Ave
Larchmont, 10538
914-833-7656

 

Check out the link below for more info and Happy Googling!

http://www.google.com/intl/en_us/mobile/sms/

 

 

-LW

Excel Tip - Excel Paste Function

How many times have you had to paste data to your worksheet that was either calculated by a formula or contained formatting that you didn't want? Well, we all know that you can right click in order to choose paste special and then select to paste formulas, values, formatting or any combination of types of pasting. (If you didn't know that, consider it a bonus tip!), but there is an easier way and it takes ONE less keystroke! All you need to do is copy the data that you wish to paste and then select the arrow next to the paste tool on the menu bar and select the appropriate way you would like to paste the data.

Excel Tip - Worksheet Tabs

Do you have a workbook with alot of worksheet tabs and you want to get from the first to somewhere in the middle without having to scroll through every tab?  Well now you can.  If you right click on the arrow keys to the left of the worksheet tabs a list of all the sheets in the workbook will be visible and then you can left click on the sheet you want to jump to.

 

 

 

 

Excel Tip - Column Headings

When you make column headings do you use 3 or 4 rows because you need to cut off the words at specific points?  This might work for the text alignment but what if you want to use Data Filtering or sorting?  Excel requires a single header row for filtering, and sorting without a header row is sometimes tricky.  You can use ONE cell for your column heading and you can break the words where ever you wish by using <<ALT + ENTER>>.

 

Say you want to enter the column heading "Investment Purchases for the period Jan. - Jun." and your column width is 25.  If you type this into one cell and use "wrap text" to format the cell the words are shown on 2 lines and the first line is cut off after "the"  like this:

 

                                Investment Purchases for the

                                period Jan. - Jun.

 

What you really want is the text on 3 lines like this:

 

                                Investment Purchases

                                for the period

                                Jan. - Jun.

 

You can do this by typing the following in the cell

 

                                Investment Purchases <<ALT + ENTER>>

                                for the period <<ALT + ENTER>>

                                Jan. - Jun. <<ALT + ENTER>>

 

Then you can format the cells with center alignment and your heading is complete in one cell just the way you want it.