The Best Shortcut Keys in Microsoft Excel Moving to the Last (or First) Cell in a Range Selecting a Range of Non-Adjacent Cells Selecting the Current Region/List Selecting Cells from Any Cell to the Last Cell in the Sheet's Used Range Selecting a Column(s) or Row(s) Using Keyboard Shortcuts Selecting a row or rows in Microsoft Excel Hiding/Unhiding a Row(s) or Column(s) Hiding or unhiding a column or columns in Microsoft Excel Pasting Multiple Copied Ranges Using the Clipboard Fast Copying & Pasting in Adjacent Cells Copying & Pasting Cell Content to Thousands of Cells Moving Between Open Workbooks Quickly Entering Text into Cells from a List of Previous Entries or a Validation List Preventing Moving to the Next Cell After Typing Combining Text from Different Cells Displaying the Format Cells Dialog Box Change the cell formatted from date format to number format in Microsoft Excel Displaying the Serial Number Behind the Date Changing the Default Date Separator from a Slash to a Dot When Entering a Date into a Cell Change slash separator in date with period in Microsoft Excel Displaying the serial number behind Date format in Microsoft Excel Shortcuts to see the Help for the Syntax Function in Microsoft Excel Creating Charts with F11 in Microsoft Excel Sizing Charts with the Window in Microsoft Excel. Setting the Default Chart Type in Microsoft Excel Printing a Chart in Microsoft Excel Preventing charts from being printed in Microsoft Excel Using the Keyboard to Select Chart Items in Microsoft Excel Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft Excel Moving the Chart to a Different Place in the Sheet in Microsoft Excel Adding a Linked Picture to a Chart in Microsoft Excel Updating Charts by Dragging and Dropping in Microsoft Excel Displaying Numbers in Thousands in a Chart in Microsoft Excel Opening a Linked Workbook in Microsoft Excel Opening/Closing a Workbook(s) Select bottom right end corner of the used area Microsoft Excel Copying/Moving a Cell(s) Between Sheets/Workbooks Hiding Outline Symbols Adding Groups and Outlines Manually Shortcuts for opening the Function Arguments window in Microsoft Excel Insert or delete a Row/Column in Microsoft Excel Quick Move to end of range of cells in Microsoft Excel Selecting Cells in Horizontal or Vertical Ranges Fast Typing in Selected Area Quickly Selecting a Range of Cells Selecting Special Cells Selecting All Sheet Cells Fast Copying & Pasting Right or Down in a List
Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation
Site Developed By: Irubin Consulting