Unofficial Excel Stuff

Book

Suggestions

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Saturday, February 20, 2010 – Permalink –

Selection Address

What's the count
". . . know what range is selected at any given time. You can look at the Name Box, but that only show the active cell."

Display number of Rows and Columns

See all Topics
excel
Labels: Customize, Formulas, Macros, Reference, Shortcuts, Tips, VBA

<Doug Klippert@ 3:59 AM

Comments: Post a Comment

Sunday, January 03, 2010 – Permalink –

Keyboard and Key Tips

Finger it out

2007 apps look different because of the ribbon, but the keyboard can still be used to speed up tasks.
Microsoft has an online course that may help

After completing this course you will be able to:
Accomplish tasks by using sequential shortcut keys, known as Key Tips, shown on the Ribbon.
Navigate around the Ribbon using the TAB key and arrow keys.
Accomplish tasks by using key combinations — keys you press at the same time - exactly as you've done in previous versions of Office.

Office.Microsoft.com/Training

See all Topics
excel
Labels: Shortcuts, Tips

<Doug Klippert@ 3:54 AM

Comments: Post a Comment

Thursday, October 22, 2009 – Permalink –

Move Using Alt

One sheet to another

To move data from one worksheet to another, highlight the data.

Hold down the ALT key and move the mouse until the pointer arrow is on the border of the selection.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet.

Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data hold down the CTRL+ALT keys and perform the steps above.

BTW the screen will not scroll while you hold the ALT key down.

See all Topics
excel
Labels: General, Shortcuts

<Doug Klippert@ 3:56 AM

Comments: Post a Comment

Saturday, October 17, 2009 – Permalink –

Shortcut Borders

Keyboard trick

Use Ctrl+1 to bring up Excels Formatting dialog box. Shift+B will take you to the Borders tab.

Now you can use the following key strokes (2002+):

ALT+T

Apply or remove the top border.

ALT+B

Apply or remove the bottom border.

ALT+L

Apply or remove the left border.

ALT+R

Apply or remove the right border.

ALT+D

Apply or remove the downward diagonal border.

ALT+U

Apply or remove the upward diagonal border.

ALT+H

Apply or remove the horizontal interior border.

ALT+V

Apply or remove the vertical interior border.

ALT+O

outlines the cells.

ALT+I

give interior (vertical and horizontal).

ALT+N

removes all borders.

ALT+C

brings up the color palette.

Shortcuts for Applying Borders

Ctrl+Shift+7 will outline a cell without having to display the Format dialog.

See all Topics
excel
Labels: Formats, Shortcuts, Tips

<Doug Klippert@ 3:28 AM

Comments: Post a Comment

Wednesday, April 15, 2009 – Permalink –

Date an Octothorpe

Date an Octothorpe

Some more of those things I'm sure I used to know

The keyboard combination of Alt+Shift+D inserts the current date in MS Word and PowerPoint. Ctrl+; (semicolon) does it in Excel and Access.

If you do not like the date's format, select a different one with Insert>Date and Time and, if you would like to make that permanent, click on the Default button in the lower left corner of the dialog box (in PowerPoint it's in the lower right corner).

In Excel, Ctrl+Shift +# formats the entry as day-month-year. Ctrl+1 will display the "Format cells" dialog box.

BTW, the "hash, pound or number" sign # is also called an "octothorpe".

The person who named it combined Octo for the eight points and Thorpe for James Thorpe.

"Bell Labs engineer, Don Macpherson, went to instruct their first client, the Mayo Clinic, in the use of the new (touch tone phone system). He felt the need for a fresh and unambiguous name for the # symbol. His reasoning that led to the new word was roughly that it had eight points, so ought to start with octo-. He was apparently at that time active in a group that was trying to get the Olympic medals of the athlete Jim Thorpe returned from Sweden, so he decided to add thorpe to the end."

While we're at it, the "backwards P, Enter mark" ¶ is actually named a "pilcrow".

The pilcrow was used in medieval times to mark a new train of thought, before the convention of using paragraphs was commonplace.

Also see:
Geek-speak names for punctuation marks

Wikipedia:
Punctuation

See all Topics
excel
Labels: Formats, Shortcuts, Tips

<Doug Klippert@ 3:36 AM

Comments: Post a Comment

Saturday, January 31, 2009 – Permalink –

Kürzungen für jeder

Accessibility Shortcuts

Several resources are available to help increase speed and effectiveness for keyboard users. Here are keyboard shortcuts for leading Microsoft products that help save time and effort and provide an essential tool for some people with mobility impairments.

Internet Explorer 7/6/5/4

Office (2007/2003/XP/2002/2000/97)

PhotoDraw

PowerPoint

Producer

Publisher

Windows (Vista/2003/XP/2000/98/ME/NT)

Windows Media Player

Windows Movie Maker

Windows XP Media Center Edition 2005

Microsoft.com Keyboard Assistance.

See all Topics
excel
Labels: Shortcuts

<Doug Klippert@ 3:23 AM

Comments: Post a Comment

Thursday, May 29, 2008 – Permalink –

Fill Handle

Double click the handle

If you have a column of data, you may wish to insert a new formula on each row, number the lines, or add a date column.

To fill the column down to the bottom of the database, just double-click on the fill handle - the tiny square at the bottom right corner of the active cell.

The duplication continues as long as there are entries in the adjacent column.

If you wish to fill down a series, make at least two entries so that the interval is apparent. For instance if there is a column of data in A1:A400, enter the number "1" in B1, "2" in B2.
Select B1:B2. Double click on the fill handle and Excel will fill the series down to B400.

You can also select a longer series, such as the name of a supervisor and the team members.

Format the supervisors name differently, if you want.

Select the list and double click the fill handle. The list will be repeated down the page, as long as there is a corresponding entry in an adjacent column. The formatting will also be repeated.

Also:

Custom Lists

F. David McRitchie:
Fill Handle

Microsoft Office Online:
Fill data in worksheet cells

If you don't see the Fill handle:
Click Options on the Tools menu and click the Edit tab.
(Use the Office button in the upper left corner in 2007)
Select or clear the Allow cell drag and drop check box.

See all Topics
excel
Labels: General, Shortcuts, Tutorials

<Doug Klippert@ 6:20 AM

Comments: Post a Comment

Monday, November 19, 2007 – Permalink –

Smart Tags

Don't hide

In Excel, if you type a stock ticker symbol, the options offered on the Smart Tag are:

Stock quote from MSN MoneyCentral

Company report from MSN MoneyCentral

Recent news on MSN MoneyCentral

Insert a refreshable stock price

Remove the Smart Tag

Smart Tag options (This brings up the Smart Tags tab on the AutoCorrect menu.)

Complete tasks quickly with Smart Tags

How to turn on smart tags.

Smart tag functionality is turned off by default. Before you can use smart tag functionality, you must turn on smart tag recognition. To do this, follow these steps, as appropriate for the version of Excel that you are running.

Microsoft Office Excel 2007
Click the Microsoft Office Button, and then click Excel Options.

Click Proofing.

Click AutoCorrect Options.

In the AutoCorrect dialog box, click the Smart Tags tab.

Click to select the Label data with smart tags check box.

In the Recognizers box, click to select the check boxes next to the specific smart tag recognizers that you want to turn on, and then click OK.

Click OK to close the Excel Options dialog box.

Microsoft Office Excel 2003 and earlier versions of Excel
On the Tools menu, click AutoCorrect Options.

In the AutoCorrect dialog box, click the Smart Tags tab.

Click to select the Label data with smart tags check box.

In the Recognizers box, click to select the check boxes next to the specific smart tag recognizers that you want to turn on, and then click OK.

Smart tag functionality

OfficeZealot.com:
SmartTagz

See all Topics
excel
Labels: General, Shortcuts, Tips

<Doug Klippert@ 7:40 AM

Comments: Post a Comment

Monday, June 25, 2007 – Permalink –

Move a Column

No cut, No Paste

With a little practice you can quickly move Columns or rows.

Select the entire column or row you want to move
The move will effect whatever is selected; cells, or columns, or rows

Move your mouse pointer to the edge of the selection until it changes from a normal pointer cross to an arrow (four headed arrow in 2007).
(Put the pointer on the selected cells, not the Row or Column indicators.)

Hold down the shift key and click the left mouse button and drag the column/row to the new position.

Release the mouse button before releasing the shift key

See all Topics
excel
Labels: Shortcuts, Tips

<Doug Klippert@ 7:29 AM

Comments: Post a Comment

Sunday, May 27, 2007 – Permalink –

Unkept Secrets

HEADING

From Microsoft

"After supporting Microsoft Excel for years, technical Support Professionals have found that some of the most powerful and useful features and functions in Microsoft Excel remain undiscovered by you, our users.

For example, you may create a new macro to perform a calculation when an existing formula or function can perform the task. Or, you may create a new macro to perform a task when you could use an existing feature that performs the task."

Undiscovered Tips About Microsoft Excel for Windows
Here are just a few:

Secret #1: Joining Text Together

Secret #3: Excluding Duplicate Items in a List

Secret #7: Using a Data Form

Secret #11: Linking a Text Box to Data in a Cell

Secret #12: Linking a Picture to a Cell Range

Secret #17: Using OFFSET to Manipulate Data in Cells that are Inserted

Secret #21: Using INDEX and MATCH to Look up Data

Secret #25: Returning Every Nth Number

Secret #29: Using One Keystroke to Create a new Chart or Worksheet

Secret #30: Setting up Multiple Print Areas on the Same Worksheet

See all Topics
excel
Labels: Shortcuts, Tips

<Doug Klippert@ 6:35 AM

Comments: Post a Comment

Friday, April 06, 2007 – Permalink –

Getting '07 Reference Guides

Where'd they hide that thing?

Wondering where your favorite Word 2003 commands are located in the new Word 2007 interface? Or just want to explore the rich, new design with a little guidance?

... rest the mouse pointer over a Word 2003 menu or button to learn its new location in Word 2007. To see an animation of the location of the command or button in Word 2007, just click it.

Command reference guides for:

Word
Excel
PowerPoint

The versions above require an internet connection.
Below are the links to download the guides to your machine.

PowerPoint
Excel
Word

See all Topics
excel
Labels: 2007, Addins, Shortcuts, Tips

<Doug Klippert@ 7:39 AM

Comments: Post a Comment

Thursday, April 05, 2007 – Permalink –

Getting Started with '07

Ribbon add-in tutorial portal

Download the Get Started Tab for Word/Excel/PowerPoint 2007 .

(You'll have to do this separately for each application)

" This add-in adds a Get Started tab to the Excel 2007 Ribbon. Commands on this tab give you easy access to free content on Office Online, such as training courses, video demos, and other Office Online content designed to help you learn Excel 2007 quickly.

An Office Online interactive command mapping tool, also available on the Get Started tab, shows you where to find Excel 2003 buttons and commands in Excel 2007. Office Online Community discussions are also available directly from Excel with this add-in."

Also:
07 Reference Guides

See all Topics
excel
Labels: 2007, Addins, Shortcuts, Tips

<Doug Klippert@ 6:51 AM

Comments: Post a Comment