Excel Tips (General) divided into 9 main topics

Keyboard Shortcuts

To move 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

Hiding or unhiding a column or columns

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

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

Shortcuts to see the Help for the Syntax Function

Creating Charts with F11

Sizing Charts with the Window

Setting the Default Chart Type

Printing a Chart

Preventing charts from being printed

Using the Keyboard to Select Chart Items

Changing the Layout of the Chart from Rows to Columns and Vice Versa

Moving the Chart to a Different Place in the Sheet

Adding a Linked Picture to a Chart

Updating Charts by Dragging and Dropping

Displaying Numbers in Thousands in a Chart

Opening a Linked Workbook

Opening/Closing a Workbook(s)

Select bottom right end corner of the used area

Copying/Moving a Cell(s) Between Sheets/Workbooks

Hiding Outline Symbols

Adding Groups and Outlines Manually

Shortcuts for opening the Function Arguments window

Insert or delete a Row/Column

Quick Move to end of range of cells

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

Reducing the Used Area in a Sheet

Add a cell, Row or a column

Copying or Moving a Sheet

Showing All Items When Choosing from a Menu

E-mailing an Excel Workbook, Sheet, Data or Chart

Adding a Combo Box

Iteration

The Euro Currency Tools Add-In

Using Task Panes

Removing icons from toolbars

Opening a saved Workbook

Removing the Smart Tag Indicator

Expanded Paste Icon Features in Excel 2002 & Excel 2003

Cell Function Returns Sheet Name, Workbook Name and Path

Problem: Unnecessary Empty Characters in Cells

Customizing an Icon

Copying, Cutting and Pasting (Moving)

Adding the Page Setup Icon to the Excel Menu Bar

Adding the Camera icon to the toolbar

Changing the Name of the Cell Comment's Author

Changing the Default Cell Comment Format

Dual Monitors - Trouble Displaying separate spreadsheets on each Monitor

Removing Personal Information from a Workbook

Opening Workbooks from a List of Hyperlinks

Changing the font size of the Sheet name

Show the full name ( path and workbook name ) in the menu bar

Hide an excel sheet without the option of unhiding it using VBA

Adding the Properties Icon to the Standard Toolbar

Coloring Sheet Tabs

Increasing/Decreasing the Screen Magnification Percentage

Selecting a Sheet in the Workbook

Selecting a sheet from shortcut menu

Quickly Selecting a Range in the Workbook

Coloring Gridlines

Reducing the Workbook Size for Quick Sending via E Mail

Displaying Formulas and Values of the Same Cells

Auto-Recovering/ Auto-Saving a Workbook

Opening a Template File Automatically When Starting Excel

Changing the Number of Files Shown in the Recently Used File List

Create a hyperlink from a string

Changing the Default Number of Sheets in a New Workbook

Selecting a Sheet from a Sorted Sheets List

Sorting Sheets in Ascending Order

Grouping/ Ungrouping Sheets

Inserting a New Sheet from a Template Sheet

Recovering Data from a Corrupted Workbook That Cannot Be Opened

Displaying the Workbook's Path in the Address Box

Saving a Customized Workbook as a Template

Using a Workspace to Open a Number of Workbooks at Once

Range Name Syntax

Defining a Range Name

Deleting a Range Name

Automatically Defining Names for Ranges in Lists

Using a Range Name in a Formula

Saving a Frequently Used Formula/Numeric Value in the Define Name Dialog Box

Automatically Updating a Range Name Reference

Changing the Cell Comment Shape

Watch Cell Information at a Distance

Adding a Comment to a Formula

Getting Continuously Refreshed Data from a Web Site in Excel 2002 & 2003

Filtering is limited to 999 items

Put a line at Foot of print page

Adding Continuous Page Numbers While Printing

Adding the Full Path of the Saved File to the Header/Footer

Printing Non-Continuous Areas

Creating a Custom Report Manager

Hiding Data Before Printing

Printing an Already Saved Report Using Report Manager

Quickly Printing a Page from the Workbook Using a Custom View

Saving Defined Page Setups for Future Printing

Printing a Page Number in Portrait While the Page Is in Landscape Layout

Copying the Page Setup to Other Sheets

Printing Cell Comments

Inserting a picture (company logo) in the header

Inserting a Watermark Behind the Text

Hiding Errors in Cells Before Printing

Preventing the Printing of Objects

Replacing Data Markers with Pictures

Autoexpanding a Date Type Chart

Copying a series from one chart to another

Protecting Cells Containing Formulas in an Unprotected Sheet

Prevent Unauthorized Opening of Workbook

Password to prevent opening a workbook

Protecting a Workbook

Protecting and Unprotecting Workbooks

Protecting the Sheet or the Cells in the Sheet

Moving Between Unprotected Cells in a Protected Sheet

Protecting Data by Hiding a Row(s) and Column(s)

Preventing Movement in Protected Areas

Allowing Multiple Users to Edit Ranges

Protecting Workbooks with a Digital Signature