Excel 2007
These tips gives you straightforward instructions and information on how to carry out a variety of tasks in Excel. Examples are included with many of the tips. The tips have been subdivided into a number of subcategories.
Excel Worksheet Help
The articles on this page cover a number of topics related to Excel worksheets - such as worksheet terms, adding and deleting worksheets, how to protect data in a worksheet, adding and removing columns and rows from a worksheet and much more.
The articles on this page cover a number of topics related to Excel worksheets - such as worksheet terms, adding and deleting worksheets, how to protect data in a worksheet, adding and removing columns and rows from a worksheet and much more.
Excel Tips - Time-Saving Tips for Excel 2007
What are your favorite time-saving tips for Excel 2007?
What are your favorite time-saving tips for Excel 2007?
Six Time Saving Tips for Excel 2007
Here is a list of six tips that will save you time and effort when working with your Excel 2007 spreadsheets.
Here is a list of six tips that will save you time and effort when working with your Excel 2007 spreadsheets.
Excel Formulas Order of Operations
If more than one operator is used in a formula, there is a specific order that Excel will follow to perform these mathematical operations. This article covers Excel's order of operations.
If more than one operator is used in a formula, there is a specific order that Excel will follow to perform these mathematical operations. This article covers Excel's order of operations.
Excel Name Box Navigation
The Name Box in Excel can be used to navigate to different cells in a spreadsheet. This article includes an example of how to use the Name Box to move to different cells.
The Name Box in Excel can be used to navigate to different cells in a spreadsheet. This article includes an example of how to use the Name Box to move to different cells.
Excel's Go To Feature
The Go To feature in Excel can be used to navigate to different cells in a spreadsheet. This article includes an example of how to use the Go To feature to move to different cells.
The Go To feature in Excel can be used to navigate to different cells in a spreadsheet. This article includes an example of how to use the Go To feature to move to different cells.
Turn Off AutoComplete in Excel 2007
This quick tip shows you how to turn off AutoComplete in Excel 2007.
This quick tip shows you how to turn off AutoComplete in Excel 2007.
Excel 2007 Wrap Text
Using Excel 2007's wrap text feature. Step by step example of using wrap text in Excel 2007.
Using Excel 2007's wrap text feature. Step by step example of using wrap text in Excel 2007.
Change Excel Worksheet Tab Color
This tip covers how to change the worksheet tab color in Excel. This tip includes an example of how to change the worksheet tab color in Excel 2007.
This tip covers how to change the worksheet tab color in Excel. This tip includes an example of how to change the worksheet tab color in Excel 2007.
Excel 2007 Options Button
Since there is no longer a tool's menu, or even a tool's tab on the Ribbon, you have to look elsewhere for the Excel Options feature in Excel 2007.
Since there is no longer a tool's menu, or even a tool's tab on the Ribbon, you have to look elsewhere for the Excel Options feature in Excel 2007.
Microsoft Office 2007 Diagnostics
Microsoft Office 2007 Diagnostics is a group of tests that can be used to help correct problems with Microsoft Office files. The diagnostic tests can correct certain problems directly and will give information on such things as your computer’s memory and hard drive, that can be used fix problems found on these devices.
Microsoft Office 2007 Diagnostics is a group of tests that can be used to help correct problems with Microsoft Office files. The diagnostic tests can correct certain problems directly and will give information on such things as your computer’s memory and hard drive, that can be used fix problems found on these devices.
Protect Data in Excel 2007 Pt. 2
How to protect data in Excel part 2 - protecting the worksheet. Includes a step by step example.
How to protect data in Excel part 2 - protecting the worksheet. Includes a step by step example.
Protect Data in Excel 2007 Pt. 1
How to protect data in Excel part 1 - locking/unlocking cells. Includes a step by step example.
How to protect data in Excel part 1 - locking/unlocking cells. Includes a step by step example.
Excel 2007 Cut and Paste
Using cut and paste in Excel 2007. Step by step example of using cut and paste in Excel 2007.
Using cut and paste in Excel 2007. Step by step example of using cut and paste in Excel 2007.
Excel 2007 Copy and Paste
Using copy and paste in Excel 2007. Step by step example of using copy and paste in Excel 2007.
Using copy and paste in Excel 2007. Step by step example of using copy and paste in Excel 2007.
Excel 2007 Paste Link
Using paste link in Excel 2007. Step by step example of using paste link in Excel 2007.
Using paste link in Excel 2007. Step by step example of using paste link in Excel 2007.
Excel 2007's Undo Feature
This tip shows you how to use Excel's Undo feature to quickly get back accidentally deleted data, or fix other problems with a spreadsheet.
This tip shows you how to use Excel's Undo feature to quickly get back accidentally deleted data, or fix other problems with a spreadsheet.
Excel 2007's Redo Feature
This tip shows you how to use Excel's Redo feature to quickly add back in changes made with Undo.
This tip shows you how to use Excel's Redo feature to quickly add back in changes made with Undo.
Select Non-Adjacent Cells in Excel
This article covers how to select non-adjacent cells in Excel using the mouse.
This article covers how to select non-adjacent cells in Excel using the mouse.
ALT - TAB Fast Switching in Windows
This article covers how to use ALT - TAB Fast Switching to move between different Excel Files. ALT - TAB Fast Switching is referred to as Windows Flip in Vista.
This article covers how to use ALT - TAB Fast Switching to move between different Excel Files. ALT - TAB Fast Switching is referred to as Windows Flip in Vista.
Adding a Series of Numbers with the Auto Fill Handle
The fill handle can be used to add a series of numbers to a spreadsheet. This article covers the steps to follow to use the fill handle in Excel.
The fill handle can be used to add a series of numbers to a spreadsheet. This article covers the steps to follow to use the fill handle in Excel.
Adding Data with the Auto Fill Handle
The auto fill handle can be used to add lists of preset data to a spreadsheet. This article covers the steps to follow to use the auto fill handle in Excel.
The auto fill handle can be used to add lists of preset data to a spreadsheet. This article covers the steps to follow to use the auto fill handle in Excel.
Copy Formulas with the Auto Fill Handle
The auto fill handle can be used to copy formulas from one cell to other cells in the spreadsheet. This article covers the steps to follow to use the auto fill handle in Excel.
The auto fill handle can be used to copy formulas from one cell to other cells in the spreadsheet. This article covers the steps to follow to use the auto fill handle in Excel.
Customizing Excel 2007 Auto Fill Handle
The Auto Fill handle is a very handy feature in Excel. It allows you to quickly add commonly used data or copy existing data to other cells. You can customize the lists of data that can be added. This article will show you how.
The Auto Fill handle is a very handy feature in Excel. It allows you to quickly add commonly used data or copy existing data to other cells. You can customize the lists of data that can be added. This article will show you how.
Copy a Formatting Style in Excel 2007
This tip shows you how to quickly copy a custom formatting style from one workbook to another in Excel 2007.
This tip shows you how to quickly copy a custom formatting style from one workbook to another in Excel 2007.
Excel 2007's Format Painter
Excel's format painter allows you to quickly copy formatting from one cell or group of cells to another part of the spreadsheet. This article includes an example of using the format painter.
Excel's format painter allows you to quickly copy formatting from one cell or group of cells to another part of the spreadsheet. This article includes an example of using the format painter.
Create a Formatting Style in Excel 2007
This tip shows you how to quickly create a custom formatting style in Excel 2007.
This tip shows you how to quickly create a custom formatting style in Excel 2007.
Create a Template in Excel 2007
A template in Excel is a spreadsheet file containing common data and formatting options that is used as a model for other spreadsheets. This tip shows you how to quickly create a template in Microsoft Office Excel 2007.
A template in Excel is a spreadsheet file containing common data and formatting options that is used as a model for other spreadsheets. This tip shows you how to quickly create a template in Microsoft Office Excel 2007.
Excel 2007 Calendar Template
This tip shows you how to quickly download and use a calendar template in Excel 2007.
This tip shows you how to quickly download and use a calendar template in Excel 2007.
Scroll Through Ribbon Commands in Excel 2007
In Excel 2007 you can scroll through the ribbon commands using the scroll wheel on the mouse.
In Excel 2007 you can scroll through the ribbon commands using the scroll wheel on the mouse.
Hide the Ribbon in Excel 2007
In Excel 2007 the "ribbon", which has replaced the menus and toolbars found in earlier versions of Excel, can quickly be hidden to give you more space in your spreadsheet.
In Excel 2007 the "ribbon", which has replaced the menus and toolbars found in earlier versions of Excel, can quickly be hidden to give you more space in your spreadsheet.
Excel 2007 Merge and Center Cells
The Merge and Center formatting feature in Excel 2007 is a handy option to quickly format titles and headings in Excel 2007 Spreadsheets. This tip will show you how to do it.
The Merge and Center formatting feature in Excel 2007 is a handy option to quickly format titles and headings in Excel 2007 Spreadsheets. This tip will show you how to do it.