Question about Microsoft Business & Productivity Software

1 Answer

How to use the FITLER BUTTON IN EXCEL - Microsoft Business & Productivity Software

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

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

On my Excel worksheet there is no "Office Button" on the top left hand corner. I have been working through the learnmicrosoftexcel.com tutor and their worksheets show this button. How can I...


Are you using Office Excel 2003? That website is for the 2007 version. That button does not exist in the 2003 version. You will need to upgrade to Office 2010 if you want the button.

Jun 11, 2011 | Microsoft Office Excel 2003 for PC

6 Answers

Each time i attempt to quit Microsoft excel by clicking the close button, the program does not quit, and the tittle bar indicates that it is not responding. when i click the close button again, a dialog...


Hi,

It is clear case of MS excel corruption, probably your problem is due to virus attack, if yes then to completely uninstall MS excel you need to format your hard drive. Or use excel repair software to fix this issue.
http://www.stellarinfo.com/excel-recovery.htm

Oct 07, 2010 | Microsoft Excel for PC

2 Answers

My file is in excel 2007 i want to open in excel 2003 how would it happen or not


open the excel 2007 file in excel 2007 only and save as file.xls[xls is a 2003 version]

with this method u can open it though excel 2003
any issues kindly rate and revert

Jul 14, 2010 | Microsoft Excel 2007 Home and Student...

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

3 Answers

How can enable mail recipient as attachment excel


MAIL RECPEINT AS ATTECHMENT OPTION NOT VISIBLE IN MY OFFICE 2003 PROFESSIONAL

Apr 11, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

Windows excel file can't open


From Excel, try clicking on the 'down' arrow in the 'Open' button, then select, "Open and Repair," then select the file.

Nov 27, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Send a excel page directly from excel through net


hi,
Here is the Solution for you to try.
Create your File in Excel or Word or Powerpoint Click on Office Button --> Send--> Email.
Here you will get other options like For Review, as Attachment etc.

Hope your Query is Solved now.

bye.

Aug 20, 2008 | Microsoft Office Professional 2007:...

2 Answers

Ms excel


Try clicking the down arrow beside the autosum button in your Excel Standard toolbar. Then click More FUNCTIONS. An Insert Function dialog box appears. There use can explore all MS Excel functions.

Oct 10, 2007 | Microsoft Office Standard for PC

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?
Business & Productivity Software Logo

Related Topics:

20 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...