Microsoft Excel FAQ

General tips index

2007-04-05T03:26:00.001-07:00

General tips index

This section contains general tips that apply to Microsoft Excel and the Windows Operating System. This includes general definitions, concepts, and more. Browse the index for more.

Check Box
Dialog Boxes
Dropdown Box
How To Install Fonts
Hyperlink
Multiple Instances Of Excel
Toggle Button
Tool Bars
Tool Tips
What Are True Type Fonts

Open file as copy

2007-04-03T19:57:00.000-07:00

How to open a new copy of a Excel file?
If a copy of a file is opened, where would be the copy?
I have opened a file as copy. Can I use access the file after it is closed?

To open a file as copy, just follow the steps

Select your file through the file open box (CTRL+O)
Now at the bottom you may notice an ARROW BOX next to the OPEN button (in fact, it is a drop down box)
Click the arrow and select OPEN AS COPY.
Now you could be having a copy of the original version of the file.

Where is my Copy file?
How to access my Copy file?
If you open a Excel file using the OPEN AS COPY option, then a new file is created and saved in the same directory of the original file. So if you have a file, say test.xls in D drive. Then if you open the file as copy, then Excel creates a file in the D drive with the name Copy(1) of test.xls.
You can access this file through the path D:/Copy(1) of test.xls. You can always rename and copy your file somewhere else but by default Excel saves the copy of the file in the same drive. Also, Excel duplicates the original file and whatever is in the original file, it is copied including formats, formulas and other functionalities.

Multiple copies of a single file
If you open multiple copies of a single file, then Excel number it in ascending order. So if you open a second copy then Excel gives it the name D:/Copy(2) of test.xls and the third copy is named D:/Copy(3) of test.xls. So you can always access the. If you open the copy of a copied file then excel names it as copy of copy, copy of copy of copy and so on.
In the above example, if you open the file Copy(1) of test.xls as a copy then Excel names it as Copy(1) of Copy(1) of test.xls and if you open this file again as Copy then Excel would name it as Copy(1) of Copy(1) of Copy(1) of test.xls. It may sound a bit confusing but its quite clear.

Open a file as copy only it is absolutely required or you are working on an important file or you are working on other's job and need to preserve the original data. Opening a file as copy takes up disk space (its nothing when compared to 40GB disks and more) and adds your files list and make us a mess of things if you open too many copies.

Toolbars in Microsoft Excel

2007-04-03T06:07:00.000-07:00

What are tool bars?
Tool bars available in Microsoft Excel
Can custom tool bars be created in Microsoft Excel?

Definition:
Tool bars are list of commands arranged in a bar to facilitate one click action. It's a set of buttons arranged in a organised manner, the set of buttons being called tool bars and the buttons being called command buttons (other names are also being used to define a command button). Clicking a button on the tool bar triggers an action.

Shown above is the standard tool bar in Microsoft Excel.

Tool bars in Microsoft Excel:
The following tool bars are available in Microsoft Excel (Excel 2003)

Standard
Formatting
Borders
Chart
Control Tool box
Drawing
Exit design mode
External Data
Forms
Formula Auditing
List
Picture
Pivot table
Protection
Reviewing
Text to speech
Visual Basic
Watch Window
Web
Word Art
Worksheet Menu Bar

The above are the frequently used tool bars in Microsoft Excel that are displayed by right clicking the worksheet menu bar. There are also other tool bars such as 3D, Shapes, Color and more in Microsoft Excel.

Custom tool bars in Microsoft Excel:
You can create custom tool bars in Microsoft Excel and also assign actions and events to the tool bars you have created. Excel supports this feature. But you need to program in Visual Basic environment to create and assign actions in tool bar.

Open file as read only

2007-03-05T05:17:00.001-08:00

How to open a Excel file as read only?
How to open a new copy of a Excel file?
Can I open my Excel file in Internet Explorer?

To open a file as read only, just follow the steps

Select your file through the file open box (CTRL+O)
Now at the bottom you may notice an ARROW BOX next to the OPEN button (in fact, it is a drop down box)
Click the arrow and select OPEN READ ONLY.
Now you could be having a read only version of the original file.

You could use this option if you just want to view the file and don't want to make any changes. You should select a file before using this option. If you navigated to the folder but haven't selected the file, the OPEN READ ONLY option would not be highlighted (The option would show up but you cannot click on it. It would be disabled)

To open a copy of a file, just follow the steps and instead of OPEN READ ONLY use the OPEN AS COPY option. The step by step instructions are:

Select your file through the file open box (CTRL+O)
Now at the bottom you may notice an ARROW BOX next to the OPEN button (in fact, it is a drop down box)
Click the arrow and select OPEN AS COPY.
Now you could be having a copy of the original version of the file.

Note:
If you open a copy of the file, then a duplicate version of the same file is created in the directory of the original file. See more here

You can also use the OPEN AND REPAIR option if you suspect your file is corrupted. Excel may present you with a message box which you may utilise.

You cannot view Microsoft Excel files in Internet Explorer from withing Microsoft Excel. But you can open it from Internet Explorer. The OPEN IN BROWSER button would not highlight if you select a Excel file but you can use this option with a html file (The option would get highlighted if you select a html file or any web page)

Create a read only file

2007-03-05T05:17:00.000-08:00

How to create a read only file?
How to make a file read only?
How to make a read only file read write?

By default, all files created and opened in Microsoft Excel are read write files. This applies not only to Microsoft Excel but almost all other applications. Also, a file cannot be created read only just because if you create a read only file you can never edit it. But you can make a file read only so that others don't tamper with it.

To make a Excel file read only (Microsoft Excel 2003),

Goto Tools ->Options->Security (The Tools menu in the worksheet menu bar)
Check the READ-ONLY RECOMMENDED box.

This would make your file read only and when the file is opened, it would prompt you with the message box whether you want the file to be opened in read only mode or not. If you click YES, the file would open in read only mode. If you click NO, the file would open in read write mode and you can save your changes.

For Microsoft Excel 2000 and other previous versions

Goto File->Save As
Click the TOOLS button on the right corner and select GENERAL OPTIONS
Now check the READ-ONLY RECOMMENDED box.

This works well in Microsoft Excel 2003 also.

The above option, though making the file read only, gives the user the option to edit it. So even if an user unknowingly presses the NO button , when prompted for read only opening, he may still be able to edit the file. If you want to prevent this then,

Navigate to your file through Windows Explorer or the File Open Box and select it.
RIGHT CLICK and select PROPERTIES
Check the READ ONLY box.

This always open the file read only and even if you already made your file read only, by using the first option, this overrides it since this function is part of the operating system rather than the application. To make the file read write again, just uncheck the READ ONLY box.

Read only file

2007-03-05T00:30:00.000-08:00

What is a read only file?
How to make changes to a read only file?
How to save changes made to a read only file?

READ ONLY FILE
A read only file, as the name implies, is a file whose contents can be only read but cannot be written into. In other words, you can view the contents of a read only file but cannot change or make modifications to that file. Of course, a read only file is not a protected file but one which cannot be written into. You can make changes and modifications to a read only file but the same cannot be saved in the same file name. For example, if you have a file name test.xls and you have made it a read only file, then changes can be made to that file but the same cannot be saved under the name test.xls but can be saved with an another name.

SAVING A READ ONLY FILE
As already pointed out, read only files cannot be saved in the original name and they must be saved in an another name. So follow the steps below to save a read only file

Go to FILE->SAVE AS (The save as dialog box would be displayed)
Now select the path where you want to save the file from the LOOK IN box.
Now type a file name in the FILE NAME box below
SAVE the file by clicking the SAVE button.

The above steps holds good for almost all applications.
If you want to save the read only file in its original name, then save the file in another name, delete the original file and rename the newly created file.

Also see,
Creating a read only file
Open a file as read only

Instance

2007-03-05T00:15:00.000-08:00

Instance
Multiple Instances
Opening multiple instances of Microsoft Excel.

The word instance can be defined as the number of occurrences of an event. Thus when you start Microsoft Excel for the first time, then it may said as the first instance of Microsoft Excel. When you open Microsoft Excel for the second time with the first instance already running, then it is said to be the second instance of Microsoft Excel.

Normally, applications are objects created by programming languages. So you can run multiple instances of the same application. But running multiple instance causes your CPU to allocate more memory. Thus the number of times you open an application depends on your CPU memory (RAM). As long as your CPU permits, you can keep on opening multiple instances of an application.

It is normally recommended that you don't run multiple instances of the same application. This is because running multiple instances not only act as a drag on your CPU but it is difficult for the user too to navigate through the applications. Thus unless it is necessarily required, you need not open multiple instances of an application. The above apply not only to Microsoft Excel, but almost for all applications, in general.

Opening Multiple Instances
To open an other instance of Microsoft Excel, just click the Excel icon on the desktop or select Microsoft Excel from Programs->Microsoft Office->Microsoft Excel

Possible errors and solutions:
Cannot open multiple instances of Microsoft Excel

This may due to the fact that CPU is already full on memory and cannot allocate memory for the new instance (This is almost a rarity and would happen only if you are using a RAM less than 64 MB and have loaded quite a good number of applications).
Some or all of the libraries required for Microsoft Excel cannot open (This may happen if you have loaded a lot of add-ins and COM automation at Excel start up. Reinstalling Microsoft Excel may sort out this problem)

I get a lot of message boxes when I open the second instance of Microsoft Excel

You may have specified Excel to open a set of files at start up. Since they are already opened in the first instance, when Excel tries to reopen them at the second instance, it displays a message box indicating the files are already open. To solve this problem, try sticking to a single instance of Microsoft Excel.

Microsoft Excel automatically opens a second instance

When an external application such as email contains an Excel attachment, it may launch Excel again to display the contents. This is because,the external application may instruct to create a new instance of Microsoft Excel to load the file (You normally may not experience such problems with Outlook and other recognised software creators). To solve this, download the file to the computer and open it.
If a new instance of Microsoft Excel is opened all of a sudden, then somebody might have scheduled to run it. Check Windows Scheduler for details.

I cannot open a file in the second instance of Microsoft Excel or my file open as read only

By rule, a file with the same extension cannot be opened more than one time. Thus if you have opened file in one instance, you cannot open the same file in second instance. Also, if the file is shared on network and is opened by an other user, you cannot open it. To solve this, close the file and try reopening again or if you need to just look at the contents, open the file as read only.

Default workbook

2007-03-05T00:12:00.000-08:00

Default workbook in Microsoft Excel

By default, Microsoft Excel (all versions) creates a workbook when you start Microsoft Excel. The name of the workbook is usually Book1. If you open multiple instances of Microsoft Excel, then each of the instance would open a new workbook. The number of worksheets in the workbook depend on the option set for the number of worksheets in the default options.

Microsoft Excel doesn't open a default workbook under the following circumstances,

When you open a file from START->DOCUMENTS.
When you open a file from Windows Explorer.
When you download and open a file from a web browser.
When Microsoft Excel is set to open a default workbook when it starts.
When any file is stored in the XLSTART folder.

There may also other circumstances where Microsoft Excel may not open a workbook. If you experienced such circumstances, you may post in the comments section.
There seems to be no way from making Microsoft Excel not open a workbook when it starts. If you have an idea, you may post it.

Entering percentages

2007-02-27T20:20:00.000-08:00

How to enter percentages in Excel?
When I format cells as percentages, the exact percentages don't show up. They get multiplied by 100.

To convert a number into percentage,
RIGHT CLICK->FORMAT CELLS->NUMBER->PERCENTAGE and CLICK OK.
You can also specify the number of decimal places to follow percentage.

Tip:

It is always advised to format cells as percentage before you enter values. This is because if you enter your values and format it to percentage, they get multiplied 100 since cent percentage is equal to 100. For example, if you enter the number 4 and format cells as percentage, you get the value 400%. But if you format the cells as percentage and enter 4, you get the value 4%.You can also enter decimal values if you format the cells prior to entering values.

Full screen

2007-02-15T19:54:00.003-08:00

How to maximize the screen capacity in Microsoft Excel?
How to view full screen in Microsoft Excel?
How to turn off full screen in Microsoft Excel?

Full screen is an option in Microsoft Excel, whereby you could hide all the tool bars and maximize the viewing capacity. This would especially be useful if you are to type in a large amount of data or the nature of your work don't need tool bars for a wrong time

To turn on FULL SCREEN, Go to VIEW menu and click FULL SCREEN.
To turn on FULL SCREEN, just repeat the step since the Full screen button is a toggle button.

By default, FULL SCREEN is turned off in Microsoft Excel.

When you use the Full screen option for the first time, you would see a new tool bar with the name CLOSE FULL SCREEN. Close this tool bar (To close it, click the X on the right) . Don't click the CLOSE FULL SCREEN button since it would turn off the full screen.

The full screen options removes the tool bars, status bar and the formula bar. Full screen doesn't mean that you could not have your tool bars. You can always have your favorite tool bar by selecting it from the view menu

Tool tips

2007-02-15T19:53:00.000-08:00

What are tool tips?
How to disable tool tips in Microsoft Excel?
How to enable tool tips in Microsoft Excel?

Definition
Tool tips are small graphical interfaces that shows up text (rarely images) when the mouse pointers hover them. Tool tips show a box with text when you hover the mouse on them. Tool tips provide important information and they are quite useful in giving us quick information about a tool bar or a command without activating them. It must be noted that tool tips just show information and do not activate a command nor they trigger any action. Tool tips often instruct on the command name or give a brief description about the action a command would trigger if it is clicked.Just move around your mouse on the tool bars to have a look at the tool tips

Tool tips in Microsoft Excel (and almost all other applications) show a short description of what the tool bars would do when clicked. Descriptions such as New,Open, Save indicate that clicking the button would create a new file, open a file, save a file. In fact, they provide quick reference to the actions that would be performed by the tool bar buttons.

To enable tool tips in Microsoft Excel (and almost all other applications)

RIGHT CLICK on the Worksheet Menu Bar (The menu bar at the top containing File, Edit, View menus)
Select CUSTOMIZE and select the OPTIONS tab
Now check the SHOW SCREEN TIPS ON TOOL BARS option.
Close the dialog box using the CLOSE button

By default, tool tips are enabled in Microsoft Excel unless you disable it. Most users don't disable it as it is quite useful and provides quick handy information.

To disable tool tips just follow the above steps and uncheck the SHOW SCREEN TIPS ON TOOL BARS option.

Step by step instruction

RIGHT CLICK on the Worksheet Menu Bar (The menu bar at the top containing File, Edit, View menus)
Select CUSTOMIZE and select the OPTIONS tab
Now check the SHOW SCREEN TIPS ON TOOL BARS option.
Close the dialog box using the CLOSE button.

Gridlines

2007-02-15T00:18:00.001-08:00

What are grid lines?
My grid lines are gone. Where can I find them?
How to change the color of the grid lines?

Grid lines are horizontal and vertical lines found in Microsoft Excel. They are just like graph lines.

By default, grid lines are on in Microsoft Excel. To turn them off,

Goto TOOLS->OPTIONS->VIEW
Uncheck the GRID LINES box.
Click OK

To turn them on,

Goto TOOLS->OPTIONS->VIEW
Check the GRID LINES box.
Click OK

To change the grid lines color,

Goto TOOLS->OPTIONS->VIEW
Next to GRIDLINES COLOR box, select your color.
Click OK.

Hyperlink

2007-02-15T00:17:00.004-08:00

What is a hyperlink?

A link in a document to information within that document or another document. These links are usually represented by highlighted words or images. When a reader selects a hyperlink, the computer display switches to the document or portion of the document referenced by the hyperlink.

Hyperlinks are mostly shown in blue color with a underline to indicate that clicking it would take you to a new page or an another document. Most hyperlinks are text links. If a graphic,image or a picture is used as a hyperlink, it is generally called a hot spot.

Delete columns

2007-02-15T00:17:00.003-08:00

How to delete columns in Microsoft Excel?

To delete rows RIGHT CLICK->DELETE->ENTIRE COLUMN
Alternatively, you may select the column you want to delete and EDIT-> DELETE->ENTIRE COLUMN. (This is not at all a shortcut)

If you want to delete column in a single click, you should

Select the entire column
RIGHT CLICK ->DELETE

If you want to delete more than one column in a single click just follow the above steps ,by selecting a range of cells, rather than a single cell.

You can also repeat deleting columns by pressing CTRL+Y. But to use this option you must have deleted the column from the EDIT menu.

Also see,
Delete rows
Insert columns
Insert rows

Delete rows

2007-02-15T00:17:00.001-08:00

How to delete rows in Microsoft Excel?

To delete rows RIGHT CLICK->DELETE->ENTIRE ROW.
Alternatively, you may select the column you want to delete and EDIT-> DELETE->ENTIRE ROW. (This is not at all a shortcut)

If you want to delete rows in a single click, you should

Select the entire row
RIGHT CLICK ->DELETE

If you want to delete more than one row in a single click just follow the above steps ,by selecting a range of cells, rather than a single cell.

You can also repeat deleting rows by pressing CTRL+Y. But to use this option you must have deleted the column from the EDIT menu.

Also see,
Delete columns
Insert columns
Insert rows

Insert Columns

2007-02-15T00:16:00.001-08:00

How to insert columns in Microsoft Excel?
How to insert more than one column at a time?

To insert rows, select the cells above which you want to insert rows. Go to the INSERT menu and select COLUMNS. Alternatively, you can RIGHT CLICK->INSERT->ENTIRE COLUMN to insert a column.
If you want to insert column in a single click, you should

Select the entire column
RIGHT CLICK ->INSERT

If you want to insert more than one column in a single click just follow the above steps ,by selecting a range of cells, rather than a single cell.

If you insert a column it is normally inserted to the left of the cell. So if you insert a column from B2 it would be inserted to the left of B2

You can also repeat inserting columns by pressing CTRL+Y. But to use this option you must have insert column from the Insert menu.

Also see,
Insert rows
Delete rows
Delete columns

Insert rows

2007-02-15T00:15:00.000-08:00

How to insert rows in Microsoft Excel?
How to insert more than one row at a time?

To insert rows, select the cells above which you want to insert rows. Go to the INSERT menu and select ROWS. Alternatively, you can RIGHT CLICK->INSERT->ENTIRE ROW to insert a row.
If you want to insert row in a single click, you should

Select the entire row
RIGHT CLICK ->INSERT

If you want to insert more than one row in a single click just follow the above steps ,by selecting a range of cells, rather than a single cell.

If you insert a row it is normally inserted above the cell. So if you insert a row from B2 it would be inserted above B2.

You can also repeat inserting rows by pressing CTRL+Y. But to use this option you must have insert row from the Insert menu.

Also see,
Insert columns
Delete rows
Delete columns

Hide or unhide a workbook

2007-02-14T21:21:00.001-08:00

How to hide a workbook?
How to unhide a workbook?

To hide a workbook,

Goto Window->Hide

To unhide a workbook,

Goto Window->Unhide

If you have more that one worksheet hidden, then the list of all workbooks hidden would be displayed, from which you may select the workbook you want to unhide.

Note:
Always unhide a worksheet when you quit Microsoft Excel. This is because if you start Microsoft Excel, the next time again, and open the file (workbook) you have hidden, you may not see it. Of course, you can unhide it from the window menu but it is preferred to unhide a workbook before closing it.

Tips and tricks index

2007-02-14T21:17:00.001-08:00

Microsoft Excel tips and tricks index

This section contains tips and tricks in Microsoft Excel, which you would find really useful. This covers a wide range of topics. Just browse from this index or use search to find your query.

Add A Range Of Cells
Cell Reference When Cut,Paste Formulas
Convert Grams Into Kilograms
Count A Range Of Cells
Count Numbers In A Range Of Cells
Delete Rows With Zero Values
Entering 00, Preceding Numbers With Zero
Entering Percentages In Excel
Find Average From A Range Of Cells
Find Maximum Value From A Range Of Cells
Find Minimum Value From A Range Of Cells
Hiding Zeroes In Worksheet
Short Cut For Entering Time And Date
Shortcut For Displaying Formulas

Dropdown box

2007-02-14T05:02:00.000-08:00

What is a drop-down box?

A drop-down box is a common control with several options among which the user should select one option. The drop down box often comes with a default option which would work in case the user fails to select a option. It acts as an interface between the user and the computer. One such drop down box is show on the side

Display formulas

2007-02-13T22:25:00.002-08:00

How to quickly find out the cells that contain formulas?
Shortcut to quickly display formulas.

To quickly display formulas in worksheet, press CTRL + ~
To display values, press CTRL + ~ again.

This would display all cells that contain formulas. If your worksheet is protected then pressing CTRL + ~ would not display the formulas but cells containing formulas can be identified by an increase in column width.

Delete rows or columns with zero values

2007-02-13T22:25:00.001-08:00

How to delete rows that contain zero values?

Sometimes you may be having a list of names and corresponding values. Certain names may contain zero values and to delete those names one by one, would rather turn out be a nightmare task. To do this within a few clicks, just follow the steps:

Goto DATA->FILTER and select AUTOFILTER
You would see a arrow mark in all the columns. This is the FILTER button
Now go the column that contains zero values and click the FILTER button.
The FILTER button would display the list of all values in the column in a drop-down box. Now select 0 from the drop-down box.
The FILTER button would turn into BLUE color and would display all the zero values. Now RIGHT CLICK and select DELETE ROW.
Click the FILTER button again and select ALL to display the values again.

Worksheet navigation

2007-02-13T02:25:00.000-08:00

How to navigate through worksheets?

In case you have lesser number of worksheets, say 4 or 5, you can easily navigate through them by clicking the sheet tab. In case you have a large number of worksheets, say 10 or more, you can use the worksheet navigation tab.

The above bar is located on the top left of the sheet tabs. Right click on the sheet tab to display the list of all worksheets. The worksheet navigation tab has four buttons. The first button takes you to the first worksheet and the last button to the last worksheet (similar to the Home and end key). The second button takes you to the next worksheet and the third button the the previous worksheet.

It is advised not to keep too many worksheets in a workbook, unless it is absolutely necessary, since they may result in navigation problems (not for the computer)

Convert grams into kilograms

2007-02-12T22:00:00.001-08:00

How to convert grams into kilograms?
How to convert kilograms into grams?

Assuming that you have typed your data in grams and your boss wants them in kilograms and that too in short time. To make things worse, your data is quite big to effect changes.
No problem, you can do this at a flash. Just follow the steps below:

Type 1000 in an empty cell
Right click and select copy (or press CTRL+C)
Now select the range of your data (assume that your data in grams consists of the range A1:A120").
Right click and select PASTE SPECIAL.
Select the DIVIDE option from the OPERATION group box.
Click OK and your job is done.

To convert kilograms into grams repeat the above steps and the select the MULTIPLY option instead of the DIVIDE option from the OPERATION group box. You can use the same tip to convert any unit into another. Just use the appropriate option.

Default Font size

2007-02-12T21:59:00.005-08:00

What is the default font size in Microsoft Excel?
How to change the default font size in Microsoft Excel?

The default font size in Microsoft Excel is 10 points (all Excel versions)
The minimum font size is 1 point and the maximum font size is 409 points.

Know more about font size here

To change the default font size,

Go to TOOLS->OPTIONS
Select the GENERAL tab
Change the FONT SIZE in the SIZE box. (This would be located to the right of the Standard Font box.

To know how to change the default font,click here

Also see,
True type font
Install a font

Default Font

2007-02-12T21:59:00.003-08:00

What is the default font in Microsoft Excel?
How to change the default font in Microsoft Excel?

The default font in Microsoft Excel is Arial (all Excel versions)
The fonts displayed in Microsoft Excel is limited by the fonts available in the system.
We recommend reading this post for more

To change the default font size,

Go to TOOLS->OPTIONS
Select the GENERAL tab
Select you FONT from the STANDARD FONT drop down box. (The standard font box would display the list of all fonts available in the Windows folder)

To know how to change the default font size,click here

Also see,
True type font

Default number of worksheets

2007-02-12T21:59:00.001-08:00

What is the default number of worksheets in Microsoft Excel?
How many worksheets can I have in Microsoft Excel?

The default number of worksheets in a workbook is three (3).
You can have a maximum of two hundred and fifty five worksheets(255) in a workbook (though the same is limited by the available amounot of memory in your computer. Anyway, you cannot have more than 255 worksheets)

Thus, when you create a new file in Microsoft Excel, it would have three worksheets. To change the default number of worksheets when you create a new workbook,

Goto TOOLS->OPTIONS
Select the GENERAL tab
Under the SHEETS IN NEW WORKBOOK option, change the number of worksheets you want to have in a new workbook.
Click OK

The next time you create a new workbook you would have your choice of worksheets.

Note:
If you have changed the default option in Microsoft Excel, for your changes to take effect, you must restart Microsoft Excel.
This does not apply to workbooks already created.

Default definition

2007-02-12T20:01:00.000-08:00

What is a default option?

In computer science , the word Default refers to a setting or value automatically assigned to a computer program or device, outside of user intervention. In other words, this is the original setting as done by the software manufacturers.

To quote an example, when you run an application for the first time after installing it, you would see the menus, fonts, layout, print settings and options in a standard format. These are called the default options. We can customize either whole or part of these options. This depends on the application we are working upon. Some applications give you the option to wholly customize the option while others doesn't.

Quick Minimum

2007-02-10T05:31:00.000-08:00

How to quickly find the minimum value from a set of values in Microsoft Excel?

To quickly find the minimum value from a set of values in Microsoft Excel,

Select the cells you want to sum (Hold CTRL key to select non-adjacent cells)
Right click the status bar and select MIN (This is the default option)
Now check out the sum of the numbers you selected in the status bar.

You can use this same tip to count a range of cells, count the numbers in a range of cells, to find the average for a range of cells, to find the maximum value from a range of cells, to sum a range of cells. Just select the appropriate option from the status bar.

Note:
You can select only one option among Sum,Average,Count,Count Nums,Max,Min. But in Microsoft Excel 2007, you can use all the options by clicking them in the status bar.

Quick Maximum

2007-02-10T05:28:00.000-08:00

How to quickly find the maximum value from a set of values in Microsoft Excel?

To quickly find the maximum value from a set of values in Microsoft Excel,

Select the cells you want to sum (Hold CTRL key to select non-adjacent cells)
Right click the status bar and select MAX (This is the default option)
Now check out the sum of the numbers you selected in the status bar.

You can use this same tip to count a range of cells, count the numbers in a range of cells, to find the average for a range of cells, to sum a range of cells, to find the minimum value from a range of cells. Just select the appropriate option from the status bar.

Note:
You can select only one option among Sum,Average,Count,Count Nums,Max,Min. But in Microsoft Excel 2007, you can use all the options by clicking them in the status bar.

Quick Average

2007-02-10T05:26:00.000-08:00

How to quickly find the average from a set of values in Microsoft Excel?

To quickly find the average from a set of values in Microsoft Excel,

Select the cells you want to sum (Hold CTRL key to select non-adjacent cells)
Right click the status bar and select AVERAGE (This is the default option)
Now check out the sum of the numbers you selected in the status bar.

You can use this same tip to count a range of cells, count the numbers in a range of cells, to find the sum for a range of cells, to find the maximum value from a range of cells, to find the minimum value from a range of cells. Just select the appropriate option from the status bar.

Note:
You can select only one option among Sum,Average,Count,Count Nums,Max,Min. But in Microsoft Excel 2007, you can use all the options by clicking them in the status bar.

Quick Count

2007-02-10T05:25:00.000-08:00

How to quickly count a set of values in Microsoft Excel?

To quickly count a set of values in Microsoft Excel,

Select the cells you want to sum (Hold CTRL key to select non-adjacent cells)
Right click the status bar and select COUNT (This is the default option)
Now check out the sum of the numbers you selected in the status bar.

You can use this same tip to sum a range of cells, count the numbers in a range of cells, to find the average for a range of cells, to find the maximum value from a range of cells, to find the minimum value from a range of cells. Just select the appropriate option from the status bar.

Note:
You can select only one option among Sum,Average,Count,Count Nums,Max,Min. But in Microsoft Excel 2007, you can use all the options by clicking them in the status bar.

Quick Count Numbers

2007-02-10T05:22:00.000-08:00

How to quickly count the numbers in a set of values in Microsoft Excel?

To quickly count numbers from a set of values in Microsoft Excel,

Select the cells you want to sum (Hold CTRL key to select non-adjacent cells)
Right click the status bar and select COUNT NUMS (This is the default option)
Now check out the sum of the numbers you selected in the status bar.

You can use this same tip to count a range of cells, sum a range of cells , to find the average for a range of cells, to find the maximum value from a range of cells, to find the minimum value from a range of cells. Just select the appropriate option from the status bar.

Note:
You can select only one option among Sum,Average,Count,Count Nums,Max,Min. But in Microsoft Excel 2007, you can use all the options by clicking them in the status bar.

Quick Sum

2007-02-09T05:19:00.000-08:00

How to quickly sum a set of values in Microsoft Excel?

To quickly sum a set of values in Microsoft Excel,

Select the cells you want to sum (Hold CTRL key to select non-adjacent cells)
Right click the status bar and select SUM (This is the default option)
Now check out the sum of the numbers you selected in the status bar.

You can use this same tip to count a range of cells, count the numbers in a range of cells, to find the average for a range of cells, to find the maximum value from a range of cells, to find the minimum value from a range of cells. Just select the appropriate option from the status bar.

Note:
You can select only one option among Sum,Average,Count,Count Nums,Max,Min. But in Microsoft Excel 2007, you can use all the options by clicking them in the status bar.

Cut and paste formulas

2007-02-09T01:50:00.000-08:00

Don't cut and paste formulas

As a general rule, don't cut and paste formulas. This is because if you cut and paste a formula the relative references don't change. Just study the example below for better understanding

For simplicity assume you have the values 4 in cell A1 and 5 in cell B1. You enter the formula =A1+B1 in cell C1. If you normally copy the formula from C1 to C2, then the formula would automatically change to A2+B2 in cell C2. But if you cut the formula from C1 and paste it to C2 then the formula would remain the same. So, the next time you cut and paste a formula be sure of what you are doing.

Date and time in my own language

2007-02-08T01:26:00.000-08:00

Can I format date and time in my own language?
Can I format my date in locale?

Of course, you can get your date and time in your own language in Microsoft Excel. After entering you date or time,

Right click and select Format Cells (CTRL +1)
Select the NUMBER tab
In the CATEGORY list, select DATE
Select your language from the LOCALE tab (at the right side bottom of the dialog)
The available list of formats would be displayed in the TYPE box (above the locale box)
To have TIME in your language, repeat steps 1,2 and select TIME in the CATEGORY list and repeat step 4

Note: By default in Microsoft Excel, if you change the date in your language then the time tab would automatically give you options to have time in the language in which you formatted date and vice-versa

Check box and uncheck

2007-02-08T01:05:00.000-08:00

What is a check box?
Checking and unchecking a box?

Check box, as the name implies, is a control to represent the on or off state of a particular command or function. It is similar to a ON-OFF button with the check state representing the working of a command and the uncheck state the non-working of a command.

Check state is represented by

Uncheck state is represented by

So checking a box means turning ON a function and
unchecking a box means turning OFF a function.

Note:
This is a common control and its use is almost identical in all applications

Entering 00

2007-02-04T23:21:00.000-08:00

How to enter the value 00 in Excel?
How to precede a number with zeroes?
How to format numbers as text?

By default, you cannot enter the number 00 in Microsoft Excel. (If you don't believe it, try it). Neither you can precede a number with 0 (You cannot enter 070 in Excel)

To do this,

Right click and select Format cells (You can press CTRL+1)
Select the NUMBER TAB (By default, this should show up)
In the CATEGORY list, Select TEXT and click OK

Now you can enter 00 or 000 or precede any number with zero.

Note:
If you add two cells that contains numbers as text, it would add up. So you can have some cool calculations too.

Hiding zeroes

2007-02-04T23:14:00.000-08:00

How to hide zero values in Excel?
Zero values don't show up in Excel.What to do?

To hide zero values in Microsoft Excel,

GoTo->Tools->Options
Select the View tab
Now uncheck the box next to ZERO VALUES at the bottom.
Zero values wouldn't show up.
To show zeroes, check the box

Note:
By default, zero values are shown in Microsoft Excel.
This applies to all versions of Microsoft Excel.
When you use this option, zero values don't show up in the worksheet as well as in Print.
Though Excel hides zeroes, it is visible in the formula bar

Time and date

2007-02-04T21:24:00.000-08:00

How to quickly enter date and time in Microsoft Excel?

To quickly enter date, press CTRL+;
To quickly enter time, press CTRL+SHIFT+;

This works in all Microsoft Excel versions(97,2000,2003,2007)

The format for date and time would depend upon your regional settings.

You can format your date and time in your own language. To know more,click here

Dialog box in excel

2007-01-30T05:17:00.000-08:00

What is a dialog box?
What dialog boxes are available in Excel?

Dialog boxes are special windows which are used by computer programs or by the operating system to display information to the user, or to get a response if needed. They are so-called because they form a dialog between the computer and the user—either informing the user of something, or requesting input from the user, or both. In GUI terminology, a dialog box is a user control or widget. See more here.

These dialog boxes vary from simple message boxes to complex containers consisting of option buttons, command buttons, tabs, check boxes and more to facilitate interface with the user. The FORMAT CELLS box, the FILE OPEN box, the FILE SAVE box are all examples of dialog boxes in Excel. Excel has more than 100 built-in dialog boxes and if need be you can add your own dialog box.

True type font

2007-01-30T05:15:00.000-08:00

What is a true type font?

TrueType is a digital font technology designed by Apple Computer, and now used by both Apple and Microsoft in their operating systems. Microsoft has distributed millions of quality TrueType fonts in hundreds of different styles, including them in its range of products and the popular TrueType Font Packs.

TrueType fonts offer the highest possible quality on computer screens and printers, and include a range of features which make them easy to use.

The history of TrueType's development is discussed briefly in our History of TrueType document, which explains the various incarnations of the technology, as well as some of the reasons TrueType exists at all.

For more on true type fonts, click here.

Install a font

2007-01-23T05:15:00.000-08:00

How to install a font?

Fonts are installed with Operating Systems , not with applications(though a few applications come with their own fonts). Hence we should install font in the Operating system's root folder.
To install a font,Go to
Start->Settings->Control Panel->Appearance and Themes->Fonts (The fonts button would be seen in the right top hand corner if you are using category view)
Start->Settings->Control Panle->Fonts(if your are using classic view)
or
you may simply open Internet explorer and type or copy
Control Panel/Fonts

This would display the Fonts folder in your root directory.Now follow the steps

Go to File->Install font
Select the folder where font files are located by navigating through the DRIVES: box
Now the list of fonts box displays all the fonts available that are not installed (The list displays the fonts found only in the directory you specified)
Now select the fonts you wish to install and CLICK OK to install the fonts. (Hold the CTRL key to select different fonts at the same time)

To uninstall a font, simply delete the font using the delete key

Note:
A few websites automatically installs fonts in your fonts folder. Installing such fonts is not necessary.

Toggle button

2006-10-20T06:04:00.000-07:00

What is a toggle button?
What toggle buttons are available in Excel?

A toggle button is a toolbar that functions like a on/off swith. Clicking the button turns a feature on and clicking the same button turns the feature off. Examples of toggle button in Microsoft Excel are menus. You can check this by clicking the view menu. By default, there would be a tick mark to the right side of status bar,formula bar, task pane. Clicking it would make the respective bar disappear. Clicking the same would make the bar reappear

Task pane disappeared

2006-10-17T06:16:00.000-07:00

My task pane has disappeared?
Where could I find my task pane?
Can I turn off the task pane by default?

By default,Microsoft Excel opens the task pane whenever the application is opened. The task pane goes off once you create a new file or open an existing file but stays on when you do any other operation. The task pane gives you some useful tips and also shows the list of recently opened files. In short, it is just an extended help function. To make the task pane appear, go to View menu and then click the task pane button. If the task pane is visible, then a tick mark would be displayed on the left side. You can also press CTRL+F(CTRL key+F1 key) to make the task pane appear or disappear. To make the task pane appear by default, Go to Tools->Options and select the View tab and check the Startup task pane box. Uncheck the box to make the task pane not to appear by default whenever you open Microsoft Excel

What is the maximum font size in Excel?
What is the minimum font size in Excel?
Can I use decimal in font size?

The minimum font size available in Microsoft Excel is 1 point and the maximum size is 409 points. Thus the font size may range anywhere from 1 to 409 points. As regards decimal, you can use font sizes in multiples of 0.5(e.g)1.5,2.5,3.5 etc., You can only use one decimal point and if you use more than one decimal points its rounded off. Same is the case for other decimal values. Thus if you enter 12.3 then font size is rounded to 12.5 and when you enter 12.73 then it is rounded as 13.
It should be noted that the font values should be directly entered into the font size box and cannot be selected from the dropdown box since the dropdown box contains only standard font sizes.