Question about Microsoft Excel for PC

1 Answer

Drop Down Menus

Help. I am putting drop down menus in my Excel worksheet which is working fine but on some of the options I need to "filter" what is given in other menus. For eg, First drop down gives option and depending on what option you choose, another drop down menu gives options. Say I choose "Not Applicable" in the first menu then I want the second menu to automatically put in "Not Applicable" to prevent something being chosen. Or, I choose and option in the first drop down and then the second drop down will automatically give me the choices available for that option (ie. colours).
Can you help?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 48 Answers

Click on Data (Top menu), Choose Filter from the drop down list, Choose Auto filter from the shown list. Now you get filter list on each column. Choose the filter condition on the column(s) you want and the data get filtered based on the condition you have given.


Fixya?

Posted on Apr 01, 2008

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:

2 Answers

Problems showing reply drop down box on Craigslist.


Do you have pop ups disabled? You get a box you have to check to say you are not a robot.

Jan 28, 2016 | Amazon Kindle Fire HD

1 Answer

Cant open drop down menus


Does this only happen with a single web site, or is it any web site with drop-down menus? Have you tried a different browser, such as Chrome or Dolphin? What version of Android is on your tablet?

Jan 10, 2014 | Samsung Galaxy Tab Tablet PC

1 Answer

Cell freeze 3 rows together at a time.


Freeze a Row in Microsoft Excel
Microsoft Excel 2010 can freeze, or lock, a top row as you scroll down the worksheet.
For example, you may need to keep the top row of column titles visible at all times.
The "View" tab on the command ribbon contains the "Freeze Panes" button in the "Window" group.
A single row or a range of rows can lock through the "Freeze Top Row" or "Freeze Panes" options.

Open the Excel worksheet.
Click the top row heading.
The row heading displays a number just left of the first column of cells. The selected row appears shaded.


Click the "View" tab on the command ribbon.
Click the "Freeze Panes" button in the "Window" group.
A list of options appears.

Click the "Freeze Top Row" option.
A black horizontal line appears on the worksheet.
This line indicates the locked row that stays on the screen as you scroll down the worksheet.

http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP010342542.aspx?CTT=1
Freeze or lock rows and columns
also
Use Freeze Panes in Excel
Scrolling down to look at a number and then scrolling up to make sure the number you looked at is under the header you expected is not an efficient way to view a spreadsheet.
The Freeze Panes feature of Excel allows you to freeze the labels of your data in place while you review the data.
Follow the instructions in Section 1 to freeze the top row or the left column.
Freeze multiple rows, multiple columns, or rows and columns, by following the instructions in Section 2.Freeze the Top Row or Left Column
1
Open the Excel spreadsheet.
2
Navigate to the "View" tab on the top menu.


3 Click on "View," then click on "Freeze Panes." A drop-down menu opens.

4

Select the "Freeze Top Row" option to freeze the top row.

5

Select the "Freeze Left Column" or "Freeze First Column" option to freeze the left column.

6

Freeze the top row by using the keyboard and sequentially pressing the keys "ALT, W, F, R." Ignore Steps 3 through 7 if using this choice.

7

Freeze the left column using the keyboard by sequentially pressing the keys "ALT, W, F, C." Ignore Steps 3 through 7 if using this choice.

8

Unfreeze panes by repeating Steps 3 through 5 and selecting "Unfreeze Panes" or sequentially press the keys "ALT, W, F, F."

Freeze Rows and Columns, Multiple Rows, Multiple Columns, or Multiple Rows and Columns
9

Open the Excel spreadsheet.

10

Freeze column(s) and row(s) at the same time by selecting the cell to the right of and below the location you want to freeze.

11

Freeze multiple rows only by selecting the cell in the left (first) column below the rows you want to freeze.

12

Freeze multiple columns only by selecting the cell in the top row to the right of the columns you want to freeze.

13

Navigate to the "View" tab on the top menu.

14

Click on "View," then click on "Freeze Panes." A drop-down menu opens.

15

Select the "Freeze Panes" option. You have now frozen the columns or rows, or columns and rows you designated.

16

Freeze panes using the keyboard by sequentially pressing the keys, "ALT, W, F, F." Ignore Steps 5 through 8 if using this choice.

17

Unfreeze panes by repeating Steps 5 through 7 and selecting "Unfreeze Panes" or sequentially press the keys, "ALT, W, F, F."



http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx
Freeze or lock rows and columns
http://office.microsoft.com/en-us/excel-help/demo-hide-or-unhide-rows-and-columns-HA010241040.aspx
Hide or show rows and columns

Aug 14, 2013 | Microsoft Office 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

2 Answers

My drop down menus have turned white. How do I


close the program & restart it. Mine does that too after an extended time of leaving it on. I have no idea why, but it always seems to be fine after I restart the program.

Nov 03, 2009 | Intuit QuickBooks Pro 2008: Windows

1 Answer

How to create drop down menus by using the Flash CS3


You can make it in Frintpage or DreamWeaver or maybe manually in HTML.Check these links for each one:
Making Drop-down menu in HTML: http://www.hypergurl.com/dropmenu.html
http://www.daniweb.com/code/snippet234.html
http://www.2createawebsite.com/build/html.html
http://www.thehtmltag.com/htmldropdownlist.html

Making Drop-Down menu by Frontpage: http://www.dreamweavercoldfusion.com/frontpagedropdown.html
http://www.tutorialized.com/tutorial/How-to-Create-a-Drop-Down-Menu-in-Frontpage/33688
http://www.hypergurl.com/fpeforms.html

Making Drop-Sown menu by Dreamweaver: http://webdesign.about.com/od/dreamweaverhowtos/ig/Dreamweaver-Drop-Down-Menus/
http://www.rel7star.dk/tutorial/
http://www.informit.com/articles/article.aspx?p=29835
http://www.webdeveloper.com/forum/showthread.php?t=101474
http://www.bestechvideos.com/2008/06/11/wdtv-episode-11-create-a-drop-down-menu-in-dreamweaver-cs3

You can Also create it by CSS coding: http://www.seoconsultants.com/css/menus/tutorial/
http://tutorials.alsacreations.com/deroulant/
http://www.evolt.org/article/How_to_make_a_simple_CSS_dropdown_menu/17/52030/
http://docs.joomla.org/Creating_a_CSS_Drop_down_Menu

Hope they could help you Good luck

Mar 16, 2009 | Adobe Photoshop CS3 10

1 Answer

DropDown menus in Excel


The quickest and easiest way is to go to the data menu and choose filter and then autofilter. This will allow drop downs on all columns which can be picked to filter one or more columns. Custom in the drop down list will give you further options.

Feb 27, 2008 | Microsoft Excel for PC

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

Related Topics:

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