Number Of sheets In A New Workbook

We can easily set the number of sheets that will be created in a new workbook in Microsoft Excel 2003.

To Set up number of sheets in a New Workbook:

1) Click on Tools and Options

2) Click on General Tab and change the number of worksheets that we need in a new workbook by adjusting it in Sheets in new workbook option.

Click OK to get the new workbook with the set number of worksheets. This can be done in it higher versions that is 2007 and 2010.

Read More

Error Checking In Microsoft Excel 2003

Microsoft Excel we have error checking for formulas and functions. It will show the cell with some special characters with 'NAME?' followed by them. To know the error we need to click on that cell to see the error in the formula bar or we can see the details of the error by choosing the error checking option.

Read More

Excel Sheet Properties

In  Microsoft Excel we can know the properties of a workbook very easily. It has become very easy in Microsoft Office 2010 version. Here we will see how to find properties of it in Excel 2003.

Read More

Align Cells in Microsoft Excel 2003

When we are writing in Microsoft Excel 2003, the data we enter will be aligned to the right and to the left if it is Numbers and Text respectively. If we want to change the alignment we may need to change it manually. 

Read More

Magnify Cells In Microsoft Excel 2003

In Microsoft Excel we often come across instances where we will not be able to see the numbers or text in the cells. In such cases we may need to increase the size of the selected cells by magnifying the cells without actually increasing the size.

Read More

Delete Cells In Microsoft Excel

In Microsoft Excel we can delete data in cells or the entire cells and can bring the data into the place of cell that has been deleted. This will avoid the work of copying or moving the entire data into another cell. 

Read More

Apply Borders To Cells

In Microsoft excel we can apply or insert borders to single cell, or a group of cells or to entire worksheet. This can be done when we want to highlight an individual thing or a group of cells etc.

Read More

Upper and Lower Functions

If we want to change the text in a cell to upper case of lower case, we use functions UPPER and LOWER. In Microsoft Excel, from its initial versions, functions have been of great use reducing the time of adding up all the data and doing it individually.

Read More

Insert Current Date and Time In A Cell

There is a simple way of inserting Date and Time in to a cell in an Excel Worksheet. Microsoft Excel provides an easier way of entering a date and time that is static and which gets updated along with computer clock, just by pressing keys and also by using functions.The value of date and time can vary as well according to the computer clock.

Read More

Auto Sum in Microsoft Excel 2003

In Microsoft Excel 2003 we have functions that will help in doing quick mathematics. When we use them they ask for a specified range where data is present and we may need to keep the cursor in the cell where we need to keep the sum.

Steps to Auto Sum using functions :


1) Place the cursor at the end of data which need to be worked using functions.

2) Click on Auto Sum function Symbol at the top

3) we will get a box that automatically selects the range of the cells where data is present.

4) Pressing Enter will sum the data and will diaplay the result in the cell where we have placed the cursor and where the range is displayed.

Read More

Filter In Microsoft Excel

Filters are used to take the data that is required and remove all the unnecessary data. We can create filters by selecting columns and rows. It will give an arrow mark beside the field heading and will give the list of data in the rows below it. we see the data just by selecting any one or more or all of the row fields under it. 

Read More

Format Painter

This is a very helpful tool that helps in changing the text font or format easily and in less time. It reduces the time to change the selected text format just in one single click and drag. Microsoft Office has introduced this feature since 2007 version. 

Read More

Conditional Formatting

In a group of large data we may need all values of same value or same field or values greater or lesser than a particular value. Then we may use the option of conditional formatting in Microsoft Excel. 

Read More

Name A Work Sheet

As we name work space we have an option to name the worksheet as well. This provides us a clear information of the data present on that particular sheet. Microsoft Excel 2010 has the most easiest way of naming sheet. 

Read More

Adding Commands to Quick Launch Toolbar

In Microsoft Excel 2010 we have quick launch toolbar that will help in accessing few options easily. This is the toolbar that can be customized with the tools that we use frequently and we manipulate the worksheet data usually. 

Read More

Name The Workspace

While working on Excel huge numerical data can be at one place and it needs to be accessed quite many times, so it has to be easily accessed to save time and confusion. Since Office 2003 version, Microsoft has introduced an option to name a part of worksheet and can be easily accessed from Name box.

Read More

Save Workspace

When Data is large we may need to remember the range within which our required data is located. To avoid this inconvenience Microsoft Excel has a feature to save the data as a separate workspace. We can open the data directly when we open the workspace directly.

Read More

Auto Correct In Excel 2003

As we have auto correct in Microsoft Word we have auto correct  it in Microsoft excel as well. It helps us in avoiding any typing errors. 

Read More

Add Background Pictures In Excel 2007

Some times worksheets require background pictures along with charts so that it shows company profile or company picture etc. Microsoft Excel 2007 has made it possible with easy to add ribbon view. 

Read More

Import Text Into Microsoft Excel

Sometimes we need to just type the data in a notepad to Microsoft Excel, then we need not think of typing all the text into Excel sheet again, we can just import the text from the other documents into excel.

Read More