Search Contextures Sites

 

Learn how to create Excel dashboards.

 

 

Excel Quick Tips Videos 03

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.

   

 

Excel Tutorial Videos 01
Excel Tutorial Videos 02
Excel Tutorial Videos 03
Excel Tutorial Videos 04
Excel Tutorial Videos 05
Excel Tutorial Videos 06
Excel Tutorial Videos 07
Excel Tutorial Videos 08 
Excel Tutorial Videos 09 
Excel Tutorial Videos 10  
Excel Quick Tips Videos 01
Excel Quick Tips Videos 02
Excel Quick Tips Videos 03
Excel Quick Tips Videos 04
Excel Quick Tips Videos 05  

       Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact

 

Privacy Policy

 

Contextures Inc., Copyright ©2010
All rights reserved.

 

Search Contextures Sites

Last updated: January 6, 2010 10:25 PM