Unofficial Excel Stuff

Book

Suggestions

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Friday, February 11, 2011 – Permalink –

Data Validation

Control input

Mark Rowlinson provides a discussion by Kid Van Ouytsel that does an excellent job explaining data validation. He has also constructs a sample workbook that you can download and play with.

Data Validation

"Data validation is a tool that can help you control the input/changes someone can make in a spreadsheet. It can help you or your users to make choices, guide them to make relevant input/changes, or restrict input to a specific type of data or structure. It can help you or your users to save time and to keep formulae working properly."

Also:

Contextures:
Excel -- Data Validation

Ozgrid:
Data Validation and Conditional Formatting

MrExcel:
Data Validation

Microsoft Office Online:
Overview and samples of data validation

Microsoft Downloads:
Sample: Data Validation

See all Topics excel
Labels: Formats, Formulas, Functions, General, Tips, Tutorials

<Doug Klippert@ 3:11 AM

Comments: Post a Comment

Saturday, February 05, 2011 – 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: General, Shortcuts, Tips

<Doug Klippert@ 3:50 AM

Comments: Post a Comment

Tuesday, February 01, 2011 – Permalink –

Indent Code

Realign a bunch

Indenting blocks of VBA code, such as statements within loops or If...Then statements, makes reading a procedure much easier.

You probably indent a code statement using the [Tab] key, and outdent by using [Shift][Tab].

However, you may not be aware that the [Tab] and [Shift][Tab] techniques also work when multiple code lines are selected.

The Visual Basic Editor also provides Indent and Outdent buttons on the Edit toolbar that allow you to easily reposition blocks of code.

See all Topics excel
Labels: VBA

<Doug Klippert@ 3:21 AM

Comments: Post a Comment