Data Validation-Microsoft Excel 2003

When we are working with tables where we need to type the same thing for a list of rows we may use this data validation as list. It is there in Microsoft Excel 2003 and next versions.

Read More

Share Workbook Among Users

Microsoft Excel gives us an option to share workbooks. We can add users who can work or edit a workbook. We can give them the level of editing capability. We can keep a track of changes made by other users.

Read More

Select Entire Column Or Row

There is an easier option to select whole column or row at a time in Microsoft Excel .

Read More

Change The Position Of Worksheets

When we are working with Excel sometimes we may need to move the sheets or we may need to refer the sheet 3 first and then sheet 2 or sheet one later at that time we can easily change the positions of the sheet by simple dragging.

Read More

How to Select Range Of Cells

When we are working with Excel we may sometimes need to select cells in a range or cells that are scattered in different rows and columns, at that time may do one of the following.

Read More

Filtering Same Records

In Microsoft Excel when we apply filters and get the data that is redundant be it in one column or multiple columns. In higher versions of Excel that is 2007 and 2010 we have filtering that is row specific and data specific.

Read More

Filter And Copy To Different Place

Once we filter the data we can copy that data in other cells as well in Excel sheet.

Read More

Change Sort Order To Rows

While sorting we may need data to be sorted in the row wise actually using different columns. Sometimes we may need to sort column wise from left to right in selected rows. Even this can be done in Excel 2003.

Read More

Filter option In Microsoft Excel 2010

Selecting values from a list and searching are the quickest ways to filter. When you click the arrow in a column that has filtering enabled, all values in that column appear in a list. The following illustration shows three methods for quickly filtering data. Excel has introduced this feature since 2003 version.

Read More

Sub Totals In Microsoft Excel

Microsoft Excel has a subtotal feature calculates subtotals and grand totals for columnar data. The feature supports eleven calculating processes: sum, count, average, maximum, minimum, product, count number, and more.

Read More

Hide The Formula From Being Displayed

In Microsoft Excel 2003, we have an option to hide a formula in a cell and make it invisible to others viewing that sheet.

Read More

Protect Worksheet From Being Edited

Microsoft Excel has an option to protect the worksheet from being edited. We can choose the option of formatting that needs to be protected. To restrict users to make changes we need to protect the worksheet by keeping a password and restricting the required changes.

Read More

Fill Color In A Cell or Group Of Cells

In Microsoft Excel we can fill a cell or group of cells with a color. That can be done in two ways.

Read More

Angle Text In Microsoft Excel

We enter text in cells in Microsoft Excel. If we want that text to be rotated in clockwise or anti clockwise we can do the following. 

Read More

Turn TaskPane On or Off

Task pane is a place where we can see the currently running tasks, previous tasks and an option to go online and connect to Microsoft Office site for further queries or document search. It will be there in all the Microsoft Office Programs. 

Read More

How To Get Drawing Toolbar In Excel

Drawing toolbar helps in editing any drawing object or picture that has been put on the document or spreadsheet. In Microsoft Excel it may not be visible by default. We can view it in following ways.

Read More

Copy Row Labels To The Additional Rows

Label is a name we add in any chart, we can add it for rows and columns as well. We can simple copy row labels to additional rows.

Read More

Excel Prints Only A Portion Of Worksheet

Microsoft Excel sometimes prints a portion of worksheet and leaves the rest of the sheet. It is because of there print area that might have been selected or defined but it is given to print whole document.

Read More

Hide Rows In Excel 2003

If we want to see the non adjacent row's data together we may need to hide the rows on the worksheet and can see the selected rows. Microsoft Excel do not delete the rows that are hidden. They will be in the background and it will show only the selected cells.

Read More

Hide Columns In Microsoft Excel 2003

In Microsoft Excel we may need to take print of adjacent columns and we don't want to delete the columns in between. In this situation we may hide the columns we don't want to print and can take the print without those columns very easily. 

Read More