Question about Microsoft Computers & Internet

1 Answer

How to use the FITLER BUTTON IN EXCEL - Microsoft Computers & Internet

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Please go to the data fliter click there so where you want seclet the area so fliter can use

Posted on Feb 21, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

5 Answers

How Repair of Excel file?


If there was such problem, the simplest decision is described here:
http://www.excel.repair/ - Excel Repair Kit. A Microsoft Excel repair tool for corrupted Excel spreadsheets. Program open, read and save data from damaged Excel files.
If at you it didn't turn out to solve a problem, it is possible to try to solve it otherwise:
1. Click the Microsoft Office Button Office button image, and then click Open.
2. In the Open dialog box, select the corrupted workbook that you want to open.
3. Click the arrow next to the Open button, and then click Open and Repair.
4. Do one of the following:
3. To recover as much of the workbook data as possible, click Repair.
(a) To recover as much of the workbook data as possible, click Repair.
(b) To extract values and formulas from the workbook when an attempt to repair the workbook is not successful, click Extract Data.

Oct 17, 2015 | Computers & Internet

Tip

How to recover Excel 2007 password


Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
Set a password to open or modify Excel 2007 password
Set a password to open Excel 2007
  • 1. Click the Microsoft Office Button 3dac3a8.gif, point to Prepare, and then click Encrypt Document
  • fd07008.gif
  • 2. In the Password box, type a password, and then click OK.
  • You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
  • 3. In the Reenter password box, type the password again, and then click OK.
  • 4. To save the password, save the file.
Set a password to modify a Excel 2007 Spreadsheet
  • In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.
  • 1. Click the Microsoft Office Button office.gif , click Save As, and on the bottom of the Save As dialog, click Tools.
  • 2. On the Tools menu, click General Options. The General Options dialog opens.
  • 3. Under File sharing, in the Password to modify box, type a password.
  • 4. In the Confirm Password dialog, re-type the password. Click OK.
  • 5. Click Save.
Remove password protection from an Excel spreadsheet
  • 1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
  • 2. Click the Microsoft Office Button 3dac3a8.gif , point to Prepare, and then click Encrypt Document.
  • 245e5bd.gif
  • 3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  • 4. Save the spreadsheet.
Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007

on Jun 09, 2010 | Audio Players & Recorders

Tip

How to set, modify, remove and recover Excel 2007 password?


Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
Set a password to open or modify Excel 2007 password Set a password to open Excel 2007
  1. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document. excel-document.gif
  2. In the Password box, type a password, and then click OK. You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
  3. In the Reenter password box, type the password again, and then click OK.
  4. To save the password, save the file.
Set a password to modify a Excel 2007 Spreadsheet In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.
  1. Click the Microsoft Office Button office.gif , click Save As, and on the bottom of the Save As dialog, click Tools.
  2. On the Tools menu, click General Options. The General Options dialog opens.
  3. Under File sharing, in the Password to modify box, type a password.
  4. In the Confirm Password dialog, re-type the password. Click OK.
  5. Click Save.
Remove password protection from an Excel spreadsheet
  1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
  2. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document.

    excel-document.gif

  3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  4. Save the spreadsheet.
Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007
Related Office 2007 document password tips:
How to set, modify, remove and recover Word 2007 password?
How to set, modify, remove and recover PowerPoint 2007 password?

on May 21, 2010 | Computers & Internet

1 Answer

Hyperlink other document in excel button


The easy way (but labor intensive) is to put the file names in a column (can be any name you want or the pdf file name), right click on a cell, hit insert hyperlink, and in the address field at bottom, put in the file pdf file name. You would have to do this for each of your 100 files.

If you want to automate it, create a column with the directory path name, a 2nd column with the full file names, a 3rd column where you concatenate the two previous columns to create the full path, and then use the hyperlink command to provide the link:


Folder name Filename Concatenated LINK ../excel/ file1.pdf ../excel/file1.pdf file1.pdf ../excel/ file2.pdf ../excel/file2.pdf file2.pdf ../excel/ file3.pdf ../excel/file3.pdf file3.pdf

Here are the formulas behind this:
A B C D Folder name Filename Concatenated LINK ../excel/ file1.pdf =CONCATENATE(A2,B2) =HYPERLINK((C2),B2)
../excel/ file2.pdf =CONCATENATE(A3,B3) =HYPERLINK((C3),B3)
../excel/ file3.pdf =CONCATENATE(A4,B4) =HYPERLINK((C4),B4)
This should work like a charm and the other advantage is that excel won't rename your path locally depending on weather a file is open or not).

Feb 21, 2014 | Microsoft Excel for PC

1 Answer

Properties in importing excel table to an access table


This article explains how to import a Microsoft Excel file into Microsoft Access version 2.0 or 7.0. Microsoft Access can import files from Microsoft Excel version 2.0 through version 7.0. However, Microsoft Access cannot import Microsoft Excel 4.0 workbooks (.xlw). This article assumes that the Microsoft Excel file is using standard database formatting. That is:

To import a Microsoft Excel file in Microsoft Access 2.0 loadTOCNode(2, 'moreinformation');
  1. Save the file in Microsoft Excel using standard database formatting listed above. Close the file.
  2. Start Microsoft Access 2.0 and open the database you want to import the Microsoft Excel information into.
  3. On the File menu, click Import. From the Import dialog box, choose the appropriate version of Microsoft Excel that you are importing and click the OK button. Microsoft Excel 7.0 files are not on this list. If you are importing a version 7.0 file, choose the Microsoft Excel 5.0 option.
At this point options such as whether to append to an existing table or create a new table may be selected.
To import a Microsoft Excel file in Microsoft Access 7.0 loadTOCNode(2, 'moreinformation');
  1. Save the file in Microsoft Excel using standard database formatting listed above. Close the file.
  2. Start Microsoft Access 7.0 and open the database you want to import the Microsoft Excel information into.
  3. On the File menu, click Get External Data and then click Import.
  4. From the import dialog box, choose Microsoft Excel (*.xls) for the Files Of Type option.

    This will display only the Microsoft Excel files.
  5. Find the desired file and click the Import button.
The Import Spreadsheet Wizard appears and allows you to choose options specific to the file.

or you just use the link for any problem where you can get details of the importing
http://www.techrepublic.com/article/techniques-for-successfully-importing-excel-data-into-access/5276622

May 05, 2011 | Computers & Internet

6 Answers

My excel 2010 file .xlsx was damaged or corrupted. how can i repair and getback


Use in-build "open and repair"utility of MS excel to repair damaged .xlsx files. Follow thesesteps to it

  1. On the File menu, click Open.

  2. In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.

  3. Click Open and Repair, and then choose which method you want to use to recover your workbook.

Most probably your problem may get fixsuppose due to any reason it can't fix your problem then use thirdparty excel repair softwarehttp://www.stellarinfo.com/excel-recovery.htm

Dec 20, 2010 | Computers & Internet

1 Answer

Describe the each part of microsoft excel 2207


anmolsxn_0.gif
Parts of the Excel 2007 Screen

Active Cell In an Excel 2007 worksheet, the cell with the black outline. Data is always entered into the active cell.
Column Letter Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Formula Bar Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Row Number Rows run horizontally in an Excel 2007 worksheet and are identified by a number in therow header.
Sheet Tab Switching between worksheets in an Excel 2007 file is done by clicking on the sheet tab at the bottom of the screen.
Quick Access Toolbar This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.
Office Button Clicking on the Office Button displays a drop down menu containing a number of options, such as open, save, and print. The options in the Office Button menu are very similar to those found under the File menu in previous versions of Excel.
Ribbon The Ribbon is the strip of buttons and icons located above the work area in Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

4 Answers

Solution for Excel 2003 "the file is not in a recognizable format"


If you open an excel created by M/S Office 2007, Excel 2003 will not be able the file. You have to install Microsoft Office the "Compatibility Pack for Word, Excel, and PowerPoint File Formats" for M/S Office 2003 from Microsoft Site.

or

Your Excel file is corrupt!

Hope it helps.


Oct 01, 2010 | Computers & Internet

1 Answer

How to create macro button in microsoft excel 2007 because


well follow the steps below to get your job done:

To create an option button in Microsoft Office Excel 2007, make sure that you add Option Button (form control) to the Quick Access Toolbar. To do this, follow these steps:
  1. Click the Microsoft Office Button, and then click Excel Options.
  2. Click the Customize category, select All Commands in the Choose commands from list, select Option Button (form control), and then click OK.
To create an option button and to assign a macro to it, follow these steps:
  1. In Excel 2003 and in earlier versions of Excel, click Option Button on the Forms toolbar, and then draw the outline of the button on the sheet.

    In Excel 2007, click Option Button (form control) on the Quick Access Toolbar, and then draw the outline of the button on the sheet.
  2. Select any cell in the worksheet.
  3. In versions of Excel that are for Microsoft Windows, right-click the option button, and then click Assign Macro.

    In versions of Excel that are for Macintosh, press COMMAND while you click or press CTRL while you click, depending on your operating system version. Then, click Assign Macro.
  4. In the Assign Macro dialog box, click the name of the macro that you want to assign to the option button, and then click OK.
When you click the option button, the macro will run.


good luck ...:-)

Apr 08, 2010 | Microsoft Office Excel 2007

7 Answers

Microsoft excel file crrupted


To open a corrupt file; you have to repair the file first.
MS Excel has a special feature to repair corrupt file that is Open & Repair.
Repair a corrupt excel file by following steps:
  • Open a blank wordbook.
  • Go-to the File menu and click on the open button.
  • Now select your corrupt file and click on the arrow next to open button.
  • Select Open & repair option and click on the open button.
  • Save as the file and give the new name.

Additionally you can try 3rd party excel repair software if Open & Repair fails to repair corrupt file.

Sep 13, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?

Open Questions:

Computers & Internet Logo

Related Topics:

20 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...