Search Contextures Sites
Custom Search

 

 

More Excel Videos

Excel Videos - Index

Names

Paste Special

Create UserForms

Mouse Shortcuts

 

 

 

 

 

 

 

Excel Quick Tips Videos 03

How to quickly move to the edge of a range, create a list of dates, and more tips.

Quickly Move to Range Border in Excel 

Create a List of Dates in Excel 

Select Large Range in Excel 

Rearrange Data in Excel 

Quickly Move to Range Border in Excel

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 in Excel

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 in Excel

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 in Excel

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 Tutorial Videos

Excel Videos - Index

Names

Paste Special

Create UserForms

Mouse Shortcuts

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 

 

Last updated: August 21, 2016 3:53 PM