Contextures

Excel Quick Tips Videos 03

Short videos show how to quickly move to range border, create list of dates, select large range, rearrange data

Quickly Move to Range Border

In a large table, quickly move to the edge of the range with a double-click of the mouse, or a keyboard shortcut.

For more keyboard shortcuts and tips, see Excel Keyboard Shortcuts.

Create a List of Dates

Use the AutoFill handle to create a sequential list of dates, of a list with a single date

See more Excel Data Entry Tips.

Select Large Range

Instead of dragging down a long list of data, click the first cell in the range that you want to select. Then, scroll down, press the Shift key, and click on the last cell that you want to select.

For more keyboard shortcuts and tips, see Excel Keyboard Shortcuts.

Rearrange Data

If adjacent cells have a text label, you can use this quick technique to name cells.

For instructions on transposing cells in Excel 2003 and earlier versions, see Change Rows to Columns in the Excel FAQs.

Get All the Excel News

For regular Excel news, tips, videos, and special offers, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

More Excel Videos

Excel Videos Index

Names

Paste Special

Create UserForms

Mouse Shortcuts

Search Contextures Sites

 

Excel Tools Add-in

 

 

 

Last updated: December 28, 2016 11:59 AM
Contextures RSS Feed