20 Most Recent Microsoft Excel 2010 Questions & Answers


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.

Microsoft Excel... • Answered on May 07, 2016


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.

Microsoft Excel... • Answered on Apr 08, 2015


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.

Microsoft Excel... • Answered on Mar 24, 2015


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

Microsoft Excel... • Answered on Mar 20, 2015


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. 25531319-qztzwsd5tae24twsq5kxbvm0-3-0.jpg

Microsoft Excel... • Answered on Mar 20, 2015


  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
25535401-qztzwsd5tae24twsq5kxbvm0-3-0.jpg

Microsoft Excel... • Answered on Mar 20, 2015


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

Microsoft Excel... • Answered on Sep 09, 2014


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.

Microsoft Excel... • Answered on Aug 25, 2014


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

Microsoft Excel... • Answered on Aug 09, 2014


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

Microsoft Excel... • Answered on Aug 01, 2014


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.
xl10rtl1-300x53.jpg - 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

Microsoft Excel... • Answered on Jul 20, 2014


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. za010165475.gif
    2. Tip You can also click Page Break Preview za010181030.gif 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.
za010165475.gif Tip You can also click Page Break Preview za010181030.gif 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.

Microsoft Excel... • Answered on Jul 20, 2014

Not finding what you are looking for?
Microsoft Excel 2010 Logo

46 questions posted

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

efs_perpends
efs_perpends

Level 3 Expert

1997 Answers

k24674

Level 3 Expert

8092 Answers

Jax Planet
Jax Planet

Level 2 Expert

923 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

View Most Popular

Microsoft Computers & Internet

  • Microsoft Computers & Internet

Most Popular Question

make b2 b8 absolute reference

  • Computers & Internet
Loading...