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


This is what the HELP feature is for in the top toolbar :>)

  1. Right-click the text or graphic you want to represent the hyperlink, and then click Hyperlink on the shortcut menu.
  2. Under Link to on the left side of the dialog box, click Existing File or Web page.
  3. Do one of the following:
    • To select a file from the current folder, click Current Folder and then click the file you want to link to.

    • To select the Web page from a list of browsed pages, click Browsed Pages and then click the Web page you want to link to.

    • To select a file from a list of files you have recently used, click Recent Files and then click the file you want to link to.

    • If you know the name and location of the file or Web page you want to link to, you can type that information in the Address box.

    • To select the Web page by opening your browser and searching for the page, click Browse the Web 1922.gif, open the Web page you want to link to, and then switch back to Microsoft Excel without closing your browser.
  4. To assign a tip to be displayed when you rest the pointer on the hyperlink, click ScreenTip and then type the text you want in the ScreenTip text box. Click OK.

Microsoft Excel... | Answered on May 06, 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

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

Peter Dragonetti

Level 3 Expert

798 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...