Microsoft Excel 2010 - Answered Questions & Fixed issues

Hello: After you get your value into the formula field, highlight that field, right click, copy, then "paste special", you should see an icon with numbers eg: 123, press enter.

Anonymous, that figures. You want to "round up" the total, of "Bldg_Program[Floor], square # C43", Plus the "Bldg_Program[Total NSF] Times 1.05, minus 2. Your answer will get rounded up to the next number.

I'm not sure what Version you're using, so I'll assume after Excel 2010. At the top of the page, under the Home tab and directly under the Font window, there is an icon which looks like a window frame (dotted all around except on the bottom edge). In your spreadsheet you have to select the area you want to work on. You can select a single cell to add lines to or the whole spreadsheet. Click on the icon I described above and a menu box will pop down. There many choices which allow you to select lines on all sides of your work. I prefer the one at the bottom which says 'More Borders'. With that window you select the edges you want lines on, the thickness/type of the line, or put an outline. I think that's enough for now and I hope that gets you started.

You have to start the sequence with a slightly different formula because there is no preceding value for Monday. The rest of the formulas are running totals so they are the same just dynamically duplicated down the column add infinitum. Just duplicate the the formula Picking up the value form the result column and subtracting the next running subtraction value.

There isn't one unless you but it but the help file has thousands of free tutorials. Press F1 in excel and type Video tutorials in the search bar.

1. Select a cell
2. in the Fx section type =SUM(
3. Click another cell
4. The cell should highlight and the Fx should display (for instance =SUM(C3
5. modify the Fx to read =SUM(C3-
6. Click another cell
7. Fx should read (for instance) =SUM(C3-D3
8. Modify the Fx to read =SUM(C3-D3) by adding a closing bracket
9. Put a number in C3
10. Put a number in D3
11. B3 will display the result of the subtraction

=$b$2*$b$8

That is an unsolveable question. You have to have a Non Zero Starting point in order to calculate a percentage of increase. Black is essentially 0. and no % increase of 0 will bring you anything but 0

you have to turn on the border. Highlight cells that you want to add the lines to, Right click on the highlighted cells, and select "Format Cells" Then choose the boarder tab. To only do horizontal lines, simply click on the top and bottom lines. This will turn the borders on, and then they will print.

I would ad an additional column where there is a 1 if the check mark is in the relevan column in he same row then add those. Ie if a1 is a check mark then b1=1 then add colum b

The "&" symbol is commonly known as "ampersand" and it is a calculation operator. Ampersand can be used in Excel 2010 to join text items from different cells. It functions much similar as "CONCATENATE" function. The output value you will get by using ampersand function will be the same as the one you will get by using CONCATENATE function. For example, =A1 & B1 returns the same value as=CONCATENATE(A1, B1) To know more about the CONCATENATE/ ampersand function, you can refer to the following webpages: http://office.microsoft.com/en-in/excel-help/concatenate-function-HP010342288.aspx (Important: Below mentioned link is of a third-party website. We recommend you to update your security software thoroughly before clicking on the link.) http://excelsemipro.com/2010/08/concatenate-function-or-ampersand-operator-in-excel/ (Important: Below mentioned link applies to Excel 2007. Still, you can refer it to understand more about ampersand function.) http://office.microsoft.com/en-in/excel-help/combine-the-contents-of-multiple-cells-HA010248390.aspx?CTT=1 GuruAid.com

The default worksheet direction in Excel 2007 or 2010 is Left-to-Right. To change a worksheet direction to Right-to-Left, follow these steps:

1. In Excel Ribbon click on the Page Layout tab.
2. In the Sheet Options group click Sheet Right-to-Left. The sheet direction will be changed. Column A will now be to the far right. Columns B, C, D.. etc. will follow to the left.

- See more at: http://www.exceldigest.com/myblog/2012/04/29/how-to-change-worksheet-direction-in-excel-2010-to-right-to-left/#sthash.lSG25YXq.dpuf

Move a page break Important To enable dragging of page breaks to another location in a worksheet, make sure that the cell drag-and-drop feature is enabled. If this feature is not enabled, you may not be able to move any page breaks. To verify that drag-and-drop is enabled, do the following: Click the File tab.

1. Under Help, click Options.
2. In the Advanced category, under Editing options, select the Enable fill handle and cell drag-and-drop check box, and then click OK.
3. Select the worksheet that you want to modify.
4. On the View tab, in the Workbook Views group, click Page Break Preview.
   1. 
   2. Tip You can also click Page Break Preview on the status bar.
   3. Note If you get the Welcome to Page Break Perview dialog box, click OK. To not see this dialog box every time you go to Page Break Preview view, select the Do not show this dialog again check box before you click OK.
5. To move a page break, drag the page break to a new location.

Note: Moving an automatic page break changes it to a manual page break. Delete a manually-inserted page break Note You cannot delete page breaks that Excel has added automatically. Adding manual page breaks, changing the page orientation, or adjusting column widths and row heights may affect automatically-inserted page breaks. To delete a manually-inserted page break, do the following:

1. Select the worksheet that you want to modify.
2. On the View tab, in the Workbook Views group, click Page Break Preview.

Tip You can also click Page Break Preview on the status bar. Note If you get the Welcome to Page Break Perview dialog box, click OK. To not see this dialog box every time you go to Page Break Preview view, select the Do not show this dialog again check box before you click OK.

1. Do one of the following:
   • To delete a vertical page break, select the column to the right of the page break that you want to delete.
   • To delete a horizontal page break, select the row below the page break that you want to delete.

Note You cannot delete an automatic page break.

http://computertrainer.wordpress.com/2011/08/22/delete-named-ranges-in-excel-2007-2010/

Hi, what is the exact error code you receive? If you can provide the exact error code or message, will narrow down troubleshoot. To get around the problem, try starting Excel in safe mode. The command is "C:\Program Files\Microsoft Office\Office14\EXCEL.EXE /s". To run the command: 1. Copy the above command without inverted commas. 2. Click Start and paste by pressing "Ctrl + V" and press the Enter key. See if this open Excel. Thereafter, exit Excel and try opening Excel again in normal mode without the "/s" switch at the end. If still having issue, suspect some of the system files may be corrupted. Run Office setup and hit Repair when prompted. Regards, Maha

COUNTIF(range,criteria) Counts the number of cells within a range that meet the given condition. This COUNTIF formula appears to count only the Employees that have the value "F" in the designated container. ie. Female.

1. Click Options on the Tools menu, and then click the International tab.
2. Do one of the following in the Right-to-left option group.
• Click Right-To-Left to have new objects displayed in a direction familiar to right-to-left users.
• Click Left-To-Right to have new objects displayed in a direction familiar to left-to-right users.

Right click on the cell that you need to display as a 7 digit number and then choose FORMAT CELL the choose CUSTOM in the NUMBER tab and type seven zeros into the TYPE field, you will see in the preview that the display is formatted as you have requested and the added bonus is that the field still retains is numeric characteristics and can be easily used for calculations etc.

Right click on the cell that you need to display as a 7 digit number and then choose FORMAT CELL the choose CUSTOM in the NUMBER tab and type seven zeros into the TYPE field, you will see in the preview that the display is formatted as you have requested and the added bonus is that the field still retains is numeric characteristics and can be easily used for calculations etc.

Try changing the associations by right clicking > Properties > Change. select from list or browse and link application. Make sure check the box to always use the selected... The cause maybe undetermined, but a good up to date virus scan could not hurt.