Monthly Archives: August 2014

Copy and Paste table while keeping column widths

A simple trick (click) can save you lots of time. Below is a commonly seen scenario in my work life: A user wanted to copy a table to a new worksheet/workbook, what he/she normally did was CRTL C then CTRL V. The … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Move cells by Right-click Drag and Drop

How to swap adjacent cell quickly? How to insert new items in the middle of a table? How to move cells more efficiently?… by using mouse… Last week, I learned from Debra Dalgleish to convert formula into value by using mouse.  What … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 2 Comments

Allow time input at 15-min intervals only – Data Validation

How to limit user to input time at 15-min intervals, i.e. 00:15, 00:30, 00:45, 01:00, etc.? We talked about how to limit user to input Time in the previous post.  Let’s go one step further with Custom Data Validation, where you … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | Leave a comment

Data Validation – TIME

How to limit user to input TIME only? Sometime, actually too many times, users may not input cell content in a way you want them to.  As a result, the formula you set for calculation may go wrong; and you … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 1 Comment

Fill Series

Auto Fill is a very handy feature in Excel.  I believe many users use it every day.  A simple example is to fill a list of sequential numbers, say from 1 to 18. What you need is to input 1 … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment