Solution:
Create a format string with "0;0;" or "#,##0;-#,##0;". This will hide zero values.
Solution:
Use the array formula =SUM((A1:A10=Low))
where High and Low are the limits you want.
Solution:
When adding new pages to a document, changing the orientation of the page can change all the existing pages. You can fix this:
1.On the File menu, click Page Setup.
2.Click the Page Size tab.
3.Under Page Size, the Same as printer page siz...
Solution:
Just format the SUM cell as "[h]:mm" or "[h]:mm:ss".
Solution:
The easiest and quickest way to create a chart in Excel is to highlight the cell range you want to include in the chart and press F11. This creates the default column chart. Excel will create the chart on a separate Chart sheet.
To test this, ...
Solution:
You can add a border around any cell or range of cells in Excel. This is a nice feature to use when you need to make a range of data stand out. To do this, all you have to do is select the cells to border and choose Format/Cells. When the Forma...
Solution:
1.Click File/Page Setup from the menu
2.Select the Sheet tab
3.Under the Print titles area click on rows to repeat at top field.
4.Click on red square box to hide the screen and highlight the columns heading
5.Click the red square box t...
Solution:
1.Tools/Option/Custom list
2.Click on the New list which will show the cursor on the list box
3.Type in list then click Add
Solution:
There's nothing that says an Excel worksheet has to have a plain white background. Suppose you have a photograph file on your hard disk that you'd like to use as a worksheet background. Choose Format/Sheet/Background. When the Sheet Background ...
Solution:
You can make a macro available to all your workbooks by saving the macro in personal.xls. Another way to make a macro available to all workbooks is to create an Add-in. If you save your workbook as an Add-in, only the macros are saved. However,...
Solution:
If you use Excel's Map very often, you might find it convenient to place a Map button into the toolbar. To do this, choose Tools/Customize. When the Customize dialog box opens, click the Commands tab. Now, under 'Categories,' click on Insert to...
Solution:
If you use Excel's Map very often, you might find it convenient to place a Map button into the toolbar. To do this, choose Tools/Customize. When the Customize dialog box opens, click the Commands tab. Now, under 'Categories,' click on Insert to...
Solution:
When you send your worksheets to others via email or on floppy disks, you may be able to help others by providing them with notes on cells that some might consider a problem. This is an easy thing to do in Excel. All you need to do is click the...
Solution:
Run the Excel workbook that contains your macro. Choose Tools | Customize. When the Customize dialog box opens, click the Commands tab (if necessary) and then select Macros from the Categories list. Now drag the Custom Button to the toolbar and...
Solution:
Run the Excel workbook that contains your macro. Choose Tools | Customize. When the Customize dialog box opens, click the Commands tab (if necessary) and then select Macros from the Categories list. Now drag the Custom Button to the toolbar and...
Solution:
Excel's Auto Fill works fine, but it does have a few quirks. For example, if you want to enter a series beginning with 1, you'll end up with nothing but ones, unless you know the trick. Here's the trick: type a 1 into cell A1. Hold down the Ctr...
Solution:
1. Open up Microsoft Word 97.
2. Find the graphic image you want to use and tap Print Screen on your keyboard. This copies the entire screen, not just the image you want.
3. Open up Paint by going to Start | Programs | Accessories | Paint....
Problem:
The following formula:
=IF(A5>0,B5+C5-A5)
returns the #VALUE! error because an inadvertant blank space is stored in cell B5.
Solution:
Use the IF and SUM functions as shown in the following formula:
=IF(A5>0,SUM(B5:C5)-A5)
Solution:
To calculate the quarter number for a calendar year:
Enter the formula:
=INT((MONTH(A2)-1)/3)+1
Solution:
Yes, you can do this with VBA. Use Activesheet.Name = Range("A1").Value.
Solution:
Colored tabs were introduced in Excel 2002. You cannot change the color of the tabs in earlier versions. In Excel 2002 and later, right click the sheet tab and choose Tab Color from the pop up menu. In no version of Excel can you change the fo...
Solution:
Vertically distribute lines of text in a cell
1. Select the cells that you want to adjust.
2. Right-click any selected cell, and then click Format Cells.
3. On the Alignment tab, in the Vertical box, click Distributed.
4. Under Text ...
Solution:
1. Assume you have a sample file:
2. Click on cell F2. Click on the Paste Function in the Standard Toolbar.
3. Click on All and find LOOKUP.
4. Click on LOOKUP and click OK.
5. Use the "Select Lookup value, array", and click OK.
6. ...
Solution:
Suppose you'd like to type and number into an Excel cell and then press Enter to move to the next cell on the right--not the next cell down. What you have to do is change the AutoEntry direction.
To make this change, choose Tools/Options. Whe...
Solution:
When using Excel, keep in mind that clearing a cell and deleting a cell are very different actions. When you clear a cell, its contents are removed, but the cell remains in the worksheet. When you delete a cell you remove the cell--contents and...
Solution:
1.Open or create a Summary file and select 1st cell you want to start.
2.Select Data/Consolidate
3.Function – Sum
4.Reference – Click shrink box icon, click open sheet1, highlights all area with column heading and totals, click expands bo...
Solution:
1.Open or create a Summary file and select 1st cell you want to start.
2.Select Data/Consolidate
3.Function – Sum
4,Reference – Click shrink box icon, click open sheet1, highlights all area with column heading and totals, click expands bo...
Solution:
If the steps in the preceding section don't solve the problem, you can reset Excel's menu bar:
1.Select View - Toolbars - Customize.
2.In the Customize dialog box, click the Toolbars tab.
3.Scroll down the Toolbars list and select Workshe...
Solution:
Suppose you'd like to combine two Excel cells. Let's say that cell A1 contains the text "Today's Date is," and cell D1 contains the date 12/31/01. Go to cell A4 and enter
=a1&d1
then press Enter. What you'll get in cell A4 is "Today's Date ...
Solution:
1.Copy the area in to the clipboard
2.Edit/Paste Special/ formats, value, formula etc..
3.Use Add to accumulate values on operation in paste special
Solution:
1.Select the header
2.Ctrl & drag the arrow will copy the header
3.Drag the arrow will move the header
Solution:
You may have used the Format Painter in Word, but it's possible that you have never noticed it in Excel. To see how Format Painter works, open a blank worksheet and enter anything in cell A1. Now, click cell A1 and choose Format/Cells. When the...
Solution:
1.Select the area
2.When cursor turn to an arrow, Ctrl & drag will copy
3.Drag will move the area in the same sheet
4.Alt & drag will move to another sheet (to the sheet tabs)
Solution:
When you want to copy a range of cells to a new location, you don't have to paste the cells into an empty range. Instead, try it this way. Select the range of cells you want to copy and press Ctrl + C. Now, move to the location where you want t...
Solution:
1.Select the sheet tab to copy from
2.Press Ctrl & click and drag to next blank area and let go the mouse first before let go the Ctrl key
3.Double click on the sheet tab to change the name
Solution:
When you need to frequently repeat a series of key strokes or mouse clicks, you may find it convenient to record a macro instead. To do this, run Excel and choose Tools|Macro|Record New Macro. When the dialog box opens, type in a name for your ...
Solution:
When you need to frequently repeat a series of key strokes or mouse clicks, you may find it convenient to record a macro instead. To do this, run Excel and choose Tools|Macro|Record New Macro. When the dialog box opens, type in a name for your ...
Solution:
If the problem only occurs when you start the Excel program, follow these steps:
1. Click Start, point to Search, and then click For Files or Folders.
2. In the Search for files or folders named box, type Excel.exe.
3. In the Look in list...
Solution:
1.Select a cell to create
2.Click on Data/Validation
Setting
Allow – Select ‘ list’
Source – highlight data range
OK
Solution:
There are times when a chart becomes the most effective way to present data. Charts aren't much of a problem for Excel. Here's how to create one.
Open a blank worksheet and enter some data. Perhaps you could enter
A
B
C
D
into cells...
Solution:
Although you can use Word Art in Excel by choosing Insert/Picture/WordArt, Excel has no Word Art button as does Word. But, you can add a Word Art button to the Excel toolbar. To do this, choose View/Toolbars/Customize. When the Customize dialog...
Solution:
There is a way to generate random numbers between two limits in Excel without writing a macro. Run Excel and open a blank worksheet. Let's say that you want to generate random numbers between 0 and 9. Click in cell A1, enter
=randbetween(0,9)...
Solution:
1.Highlight the range of cells
2.Data/Validation
Setting ---Allow – Decimal
Da ta – Between
Minimum – 0
Maximum – 10
3.Import message – Add message, title can be blank
4.Error Alert
Style - Stop
...
Solution:
(You need to divide with 2 columns and delete the first column)
1. Go to Data/Text to Columns
2. Choose Fixed Length
3. Click Next
4. Click on the desired position to cut and next. This will break into 2 columns.
5. Delete first col...
Solution:
When you want to simply add, subtract, or divide a few numbers in Excel, you can just type in an equal sign followed by the numbers. For example, if you want to add 96 and 23, you'd type
=96+23
and press Enter.
This is certainly simple en...
Solution:
Normally, double-clicking an XLS file starts Excel and opens that file. If this doesn't work for you, you'll need to re-register Excel. Do do so:
1.Close Excel
2.Click the Windows Start button
3.Click Run, to display the Run dialog box
...
Solution:
Let's suppose that you have a comment in one of the cells in your worksheet and you need to modify it to match some changes to the worksheet. Right-click the cell that contains the comment and choose Edit Comment. This opens the entry box with ...
Solution:
By default, double clicking an Excel cell opens it for editing. Is it possible to change this so that double clicking a cell does nothing?
To eliminate the double-click editing feature, run Excel and choose Tools/Options. When the Options di...
Solution:
Excel has no special requirements when it comes to entering formulas. The one always necessary item is the equal sign (=). All formulas must begin with an equal sign.
Although Excel will display all formulas in uppercase in the Formula Bar...
Solution:
Have you ever entered a fraction in an Excel cell and had it appear as a date? This is not a bug. The problem occurs simply because, in some cases, Excel has no way of knowing whether you want to enter a date or a fraction. For example, if you ...
Solution:
To temporarily work around these problems, remove all auditing arrows in the worksheet before you copy it. To remove the arrows, follow these steps:
1. Click the worksheet that contains the auditing arrows.
2. On the Tools menu, point to A...
Solution:
One way to produce a more attractive worksheet in Excel is to put a border around your data, or segments of your data. As an example, open a blank worksheet and type some data into several contiguous cells. Now, select the cells that contain da...
Solution:
One way to produce a more attractive worksheet in Excel is to put a border around your data, or segments of your data. As an example, open a blank worksheet and type some data into several contiguous cells. Now, select the cells that contain da...
Problem:
When Excel is started, it opens an *.xlb file, which contains your menu and toolbar customizations. If this file is damaged, it may cause Excel to crash when it it started. Also, this file may (for some reason) be very large. In such a case, thi...
Solution:
Another common problem is extraneous menu items. For example, you may have used an add-in that added a new menu item to the Tools menu. And, for whatever reason, the add-in did not remove that menu item. To remove the menu item:
1.Select View...
Solution:
Here's a way to create a formula in Excel--just click the appropriate cell to select it and then click the Paste Function button (its icon is fx) in the toolbar. To see how this works, enter
1
2
3
4
into cells A1 through A4. Now, clic...
Solution:
In the last tip, we discussed how to get Excel to print the guidelines. This time let's look at how to view those guidelines in some color other than the default black. To do this, choose Tools/Options. When the Options dialog box opens, click ...
Move to a task pane (task pane: A window within an Office application that provides commonly used commands. Its location and small size allow you to use these commands while still working on your files.) from another pane in the program window. (You may n...
Solutions:
Creates a chart of the data in the current range.
F11 or ALT+F1
Solution:
Selects a chart sheet: selects the next sheet in the workbook, until the chart sheet you want is selected.
CTRL+PAGE DOWN
Selects a chart sheet: selects th...
Solution:
Switch to the next program.
ALT+TAB
Switch to the previous program.
ALT+SHIFT+TAB
Display the Windows Start menu.
CTRL+ESC
Close the selected workbook window.
CTRL+W or CTRL+F4
Restore the window size of the selected w...
Solutions:
Display the Print dialog box.
CTRL+P or CTRL+SHIFT+F12
Use the following keys in print preview (to get to print preview, press ALT+F, then press V):
Move around the page when zoomed in.
Arrow keys
Move by one page when zoo...
Solution:
If your menus change, or if there is a delay before all menu items are not listed, you need to make a change.
1.Select View - Toolbars - Customize.
2.In the Customize dialog box, click the Options tab.
3.Place a checkmark next to the item...
Problem:
List1 (column A) consists of strings composed of numbers and characters.
Numbers may appear at the beginning or the end of the string, but not in the middle.
For each of the strings, we want to determine whether the numbers appear at the begin...
Solution:
1. Select a cell to make outstanding
2. Format/Cells/Alignment/Degrees
3. Change the Angle using degrees
** Can't have border and angle text at the same time
Use auto style
1. Select all worksheet
2. Format, Autoformat and select the...
Solution:
1. Select a cell to make outstanding
2. Format/Cells/Alignment/Degrees
3. Change the Angle using degrees
** Can't have border and angle text at the same time
Solution:
When you're working with Excel, you may often need to set the format of a specific cell. You can click the cell you want to change and choose Format/Cells to open the Format Cells dialog box. You can also right-click a cell and choose Format Ce...
Solution:
1.Clipboard can hold up to 12 files.
2.Cells are looking up first then left when double click for ranges.
3.To select non-contiguous cells, select first column and Ctrl & click next columns.
4.To select contiguous cells, select first colu...
Solution:
An easy way to get to the last cell in an Excel worksheet is to press Ctrl + End. However, you're in for a surprise if you press Ctrl + End in some worksheets: You may find yourself way outside of the work area sitting on a blank cell!
This h...
Solution:
Suppose you have data in cell A1 that you would like to hide from the rest of the world. To hide that data, click cell A1 and then choose Format/Cells. When the Format Cells dialog box opens, click the Numbers tab and then select Custom from th...
Solution:
Suppose you have some raw data on Sheet2 of your worksheet. You're going to display your workbook for a small group of people and you don't really want them to see the raw data. But, you don't want to delete the sheet either. In such a case, yo...
Soluiton:
1.Highlight areas
2.Format/Cell/Protection, click on Hidden, OK
3.Tools/Protection/Protection sheet, OK (don’t need to add a password)
Solution:
First select the sheets that you want to format, by clicking on the sheet tabs while
holding down the Ctrl key or Shift key. Then, apply your formatting to the cells on the active sheet. That formatting will be applied to all of the selected...
Solution:
Type the first line of text, press ALT+ENTER, and enter the next line.
Solution:
Create a custom number format of ";;;" (three semicolons). Your cell will contain the proper
value, but will appear empty. Another solution is to format the forecolor of the cell as the same color as the background (normally white).
Solution:
1.On your template, create a first page that you would like to use as a preview.
2.Save this template. Save your template into the program folders where the other Visio templates are saved.
3.When you save your template, a Properties dialog...
Solution:
Suppose your date is in A1 and you want to add 3 hours 15 minutes 10 seconds to this date, with the result in B1. Set B1 to =A1+TIME(3,15,10) Also, you could enter "3:15" in cell C1, and set B1 to =A1+C1.
Solution:
Suppose your date is in A1 and you want to add 3 months to this date, with the result in B1. Set B1 to =DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)). Excel will automatically handle this situation when MONTH(A1)+3 exceeds 12.
Solution:
Use the '&' concatenation operator. For example, ="The Sum Is: "& SUM(A1:A10)
Solution:
The current versions of Visio do not have the capability of entering curved text, but curved text can be created in another drawing package like Word Art and imported into Visio as a graphic.
Solution:
Format the cell as "ddd" to get "Wed" or as "dddd" for "Wednesday".
Solution:
You can just add grid lines into a document, but the most common and more efficient method is to create a background page that contains a grid pattern. Using a background page allows the grid pattern to be easily removed or added to other pages...
Solution:
Use the array formula =SUM((A1:A10=Low)*A1:A10)
where High and Low are the limits you want.
Solution:
1.Open a file
2.Click File from the menu bar, choose the Save As
3.Choose the Options, password to open.
Solution:
If you have modified the cell formats in a range of cells, and now need to get back to the original formatting without losing data, select the cells you want to clear and choose Edit/Clear/Formats. Doing so will take you back to the default for...
Solution:
Suppose you're working on an Excel worksheet and you place all your header information in the first two rows (1 and 2). Once the worksheet is finished, you scroll down to view more cells and the header information scrolls off the top so it's no...
Solution:
1.Open a file
2.Click File /Save As/Options
3.Press the delete key to remove the password, if the password is already highlighted.
Solution:
Office 2000 programs have a new Collect and Paste feature. To see how this works, let's use an Excel worksheet as an example.
Run Excel and enter some numbers into cells B1 through B5. Now, click cell B2 and press Ctrl + C to copy the cell's ...
Solution:
If you want text to appear on multiple lines in a cell, you can format the cell so that text wraps automatically, or you can enter a manual line break.
Wrap text automatically
1. Select the cells you want to format.
2. On the Format m...
Solution:
1.In Excel, click Options on the Tools menu, and then click the General tab.
2.Clear the Ignore other applications check box.
If this option is selected, Excel ignores requests from programs that link to Excel data by means of DDE rather th...
Solution:
To ensure that automatic links to data in other programs are updated, click Options on the Tools menu, click the Calculation tab, and make sure the Update remote references check box is selected. If this check box is cleared, the Automatic opti...
Solution:
You can restore your default spelling checker by setting the Dictionary language on the Spelling tab of the Options dialog box (Tools menu).
Solution:
You can restore your default spelling checker by setting the Dictionary language on the Spelling tab of the Options dialog box (Tools menu).
Solution:
There are two ways to get a picture into an Excel worksheet--you can copy it from another program and then paste it into Excel, or you can import it as a file. To import a picture, click where you want the upper left hand corner of the picture ...
Solution:
1. Bring the cursor down to the first cell that has numbers
2. Right click, Insert, Entire Column
Solution:
1.In order to insert an extra row to all sheets that link, select all sheets using select the first sheet and Shift click on last sheet tab
2.Insert a row or column in the first sheet then it will add to all sheets
3.Right click on sheet t...
Solution:
1. Press F10 to make the menu bar active.
2. Press CTRL+TAB or CTRL+SHIFT+TAB to make the PivotTable Field List active.
3. Press the DOWN ARROW or UP ARROW key to select the field you want. Press RIGHT ARROW or LEFT ARROW to open or clo...
Solution:
There are times when we can store some of our data on one worksheet and then link that data to another worksheet in the same workbook. As an example of how to do this, open a blank workbook and select Sheet3. Into cell A1, type 27 and press Ent...
Problem:
If Excel automatically opens lots of files at start-up, here are two things to check:
Solution:
1.Your XLStart directory. Files stored in your XLStart directory are opened automatically when Excel starts. Move the files in this folder to a dif...
Solution:
If Excel automatically opens lots of files at start-up, here are two things to check:
1.Your XLStart directory. Files stored in your XLStart directory are opened automatically when Excel starts. Move the files in this folder to a different ...
Solution:
You want an attractive header in an Excel worksheet. The only problem you have is that the header spans several columns and it's difficult to center. What you need to do is use Merge and Center in Excel's toolbar:
Type in your header, then ...
Solution:
To stop automatic corrections:
1.On the Tools menu, click AutoCorrect Options.
2.To prevent all automatic corrections, on the AutoCorrect tab, clear the Replace text as you type check box.
To prevent specific corrections, clear the corresp...
Solution:
Move from top to bottom within the selected range.
ENTER
Move from bottom to top within the selected range.
SHIFT+ENTER
Move from left to right within the selected range. If cells in a single column are selected, move down.
TAB
...
Solution:
Microsoft Excel lists a template in the Templates dialog box only if you save the template file in one of the following locations:
1.The Templates folder or a subfolder in the Templates folder, which is usually
C:\Documents and Settings\\A...
Solution:
When you need to move to a specific cell in an Excel worksheet, you can scroll to the area that contains the cell and then click it. However, if the cell you want to select is buried somewhere in a rather large worksheet, you might find it easi...
Solution:
For example, entering 154 appears as 1.54 in the cell. Somehow Excel's fixed-decimal mode was turned on. To return to normal:
1.Select Tools - Options to display the Options dialog box.
2.Click the Edit tab
3.Remove the checkmark from the ...
Solution:
Normally, Excel columns are labeled with letters. If they actually appear as numbers, you can change it back to the default:
1.Select Tools - Options to display the Options dialog box.
2.Click the General tab
3.Remove the checkmark from th...
Solution:
1.Click first file
2.Ctrl & click on others to open
Close multiple files
Shift & click file from the menu bar, select close all option
Solution:
1.Comment has to be showing on the screen (show comment open)
2.Select File/Page setup/ sheet
3.Select Comments from the box and print report.
Here is an excellent article on the subject of opening or repairing a corrupted excel file: http://office.microsoft.com/en-ca/assistance/ha010346561033.aspx
I am reproducing it below for convenience:
Microsoft Excel provides automatic recovery ...
Solution:
Standard international paper sizes like ISO A4 are widely used all over the world, but you may find that your printer does not accommodate A4 paper size. You can choose an option to automatically resize your A4 worksheets to letter size for p...
Problem:
We want to create a new list consisting of the values that are common to both List1 (column A) and List2 (Column B).
Solution:
Use the INDEX, SMALL, IF, COUNTIF, and ROW functions as shown in the following Array formula:
{=INDEX($A$2:$...
Solution:
If you can open the corrupted Excel file, you can filter it if you save it in HTML format, close the file, and then reopen it. To do this, follow these steps:
1. On the File menu, click Save as Web Page.
2. Under Save, click Entire Work...
Solution:
If you can open the corrupted Excel file, you can filter it if you save it in XML Spreadsheet format, close the file, and then reopen it. To do this, follow these steps:
1. On the File menu, click Save As.
2. In the Save as type list, click ...
Solution:
If you want to change the default Excel data folder. Here's how: Let's say you've created a folder name c:\Excel Files. With the folder created, run Excel and choose Tools/Options. When the Options dialog box opens, click the General tab. Now ...
Solution:
Excel defaults to its 'General' number format. So, if you enter 1.00 into a cell, Excel displays it as 1. If you need to set a range of cells to a fixed decimal format, select the range and choose Format/Cells. When the Format Cells dialog box ...
Problem: want to sort mixed text and numbers as if text
Solution: Create a helper column, use to following formula and fill down, then sort on the helper column.
=IF(ISBLANK(A1),CHAR(255), IF(ISTEXT(A1),A1,TEXT(A1,"@")))
Solution:
If you have trouble rembering the syntax of Excel function, try this:
Type the function's name and then press + + A, which will paste in "dummy" arguments. For example, if you type =pmt into a cell and then press + + A.
You will get the for...
Solution:
If Excel stops responding while you are working in your workbook, use the Microsoft Office Application Recovery program to recover Excel and your workbook. To do this, follow these steps:
1. Click Start, point to All Programs, point to Micro...
Solution:
Move to the same field in the next record.
DOWN ARROW
Move to the same field in the previous record.
UP ARROW
Move to each field in the record, then to each command button.
TAB and SHIFT+TAB
Move to the first field in the ne...
Solution:
Switches between command mode and dictation mode.
CTRL
Stops reading when text is being read aloud.
ESC
Solution:
How would you like to have a nice full-featured calculator in your Excel toolbar? It's easy to place the Windows calculator in the toolbar. All you have to do is Choose View/Toolbars/Customize. When the Customize dialog box opens, click the Com...
Solution:
Make sure your data has a leading "0:", as in "0:10:23" for 10 minutes and 23 seconds. Then format your SUM cell as "[mm]:ss". This format will display "73:10" rather than
"1:13:10" for one hour, thirteen minutes, ten seconds.
Solution:
In addition to the standard formats that are available in the Format->Cell->Number options dialog, you can create your own, customized formats. A custom format has four components, separated by semicolons: ;;;. Excel will use the appropriate fo...
Solution:
You've got the "Fixed Decimal" option turned on. Go into Tools->Options->Edit and uncheck the Fixed Decimal option. This feature is intended to allow you to enter dollar-and-cents amounts without having to enter the decimal point.
Solution:
When you save a file with an extension other than the default for that file type, your Microsoft Office program adds the default extension to the file name. For example, a file name for a Microsoft PowerPoint presentation might appear as Budget...
Solution:
You can't make changes to a read-only file. To save changes, save the file with a new name by using the Save As command on the File menu. You can use the same name if you save the file in a new or different folder.
Solution:
To avoid this error message and reinstall the same version of Internet Explorer and Outlook Express, follow these steps: 1. While you are logged on as an administrator, click Start, and then click Run.
2. In the Open box, type regedit, and th...
Solution:
When you open a workbook, you may be prompted to enable or disable macros --even though no macros exist in the workbook. Press Alt+F11 to activate the Visual Basic Editor. Locate your workbook in the projects window:
1.If the workbook contain...
Solution:
When you open a file that is in use, you'll get a message that tells you the file must be opened in read-only mode. In some cases, you may get this message even though the file is definitely not in use. This can be caused by an Excel crash, in ...
Solution:
When you need to get a closer look at a portion of your Excel worksheet, you can simply zoom in on it. Let's suppose that you need to have a close look at a range of cells from A1 through D8. Select the range and choose View/Zoom. When the Zoom...
Help Desk Software by Kayako Fusion