Search Contextures Sites ![]()
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.
Contextures Inc., Copyright ©2010
All rights reserved.
Search Contextures Sites ![]()
Last updated: January 6, 2010 10:25 PM