Question about Computers & Internet

1 Answer

Excel I have list two columns in excel naming header as S.No. and S.Name I would like to create drop down box for the S.No. and S.Name. If I select an item from the drop down box of S.No the repective S.Name should appear. If I select a name from the drop down box of S.Name the respective S.No. should appear in the S.No. cell

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 6 Answers

Hey dude,

Select both the columns and click on Auto-filter option. This will give you a drop-down list box to select data of your choice.

Posted on Sep 22, 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:

Tip

Excel - Drop Down List Ever wish that you didn't have to type...





Excel - Drop Down List

Ever wish that you didn't have to type out the same thing over and over again? Well you can save time by using Excel's drop down list!


Drop Down Preparation

Imagine that we are creating an Excel spreadsheet to document our purchases from the grocery store. For each purchase we want to mark down the name of the food and the type of the food.
The way a drop down list works in Excel is that it takes values from some place on your spreadsheet and uses them to populate the options in the list. Lucky for us, the type of food is a perfect opportunity to use a drop down list!
In cells A1 through A7 enter the type of food that will be used for the drop down list.


Creating a Drop Down List

Now that we have a source for our drop down list, we can create a begin to create our drop down.
1. Select cells D2 though D20 (We will be creating a drown down list for each cell in this range)

2. Click the Data menu and select Validation
3. Choose List from the Allow drop down menu

4. Click the Source button that appears to the right of the textfield

5. Select our source cells A1 though A7

6. Press Enter and Click OK

Testing Your Drop Down

All of your cells in the Type column should now have a drop down list. To test to see if your drop down works, click on cell D2 and then click on the downward facing arrow and see if all the types of food are available.

on Nov 19, 2013 | Microsoft Excel Computers & Internet

Tip

Microsoft Excel tips


Auto sum shortcut key
Quickly create a Microsoft Excel formula to get the sum of all cells by highlighting the cells you wish to know the value of and pressing ALT and = .
Create hyper links in Excel
Quickly create hyper links in your Microsoft Word, Excel, or Front Page document by highlighting text and pressing "CTRL + K".
Close all open files at once
Close all open Microsoft Word and/or Excel files by holding down the shift key and clicking "File" and then "Close All".
Quickly open recently opened files
Quickly open the recent files by first pressing "ALT + F" to open the file Menu and press 1, 2, 3, or 4.
Create underlines without any text
This tip works with the majority of Microsoft Office applications. Easily create an underlined space by pressing CTRL + U to start the underline, then press SHIFT + Space for each underlined space you wish to create. An example of how this could be used is for printable forms, for example: Name: .
Print only sections of a document
Save on your printer ink by selectively printing in Windows programs such as Microsoft Word, Internet Explorer, WordPad, Outlook, etc. To do this highlight portions of text you wish to print and click print. In the printer dialog window under Page Range choose the option Selection. It is important to realize that not all programs or printer drivers support this feature.
Repeat recent action
Using the F4 key in Microsoft Office 2000 and above allows the user to repeat the last used action. For example, if you have changed the font of a selected text and wish to change another portion of text to the same font, pressing F4 will do this for you automatically.
Quickly undo
Quickly undo mistakes in the majority of most PC Windows program by pressing CTRL + Z.
Quickly above cell contents
In Microsoft Excel press CTRL + SHIFT + " to copy the above cells contents.
Using the Microsoft Excel Auto filter
Organize cells quickly by using Microsoft Auto filter. Columns that contains long listing of data can be easily sorted by using the Auto filter option, to use this option select the top rows of the columns you want to be used and select Data / Filter and Auto Filter. Once successfully completed you can use drop down arrows to filter the data automatically.

on Dec 27, 2009 | Computers & Internet

1 Answer

Sum numbers in a column down until you come to a blank, then start again


Sounds like your issue can be solved readily with a pivot table.
If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.
Insert the Pivot table into a new worksheet.
A new sheet will open with a strange-looking control panel on the right of the window.
Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

If this works for you, please vote my answer as "helpful".

Sep 03, 2014 | Microsoft Excel for PC

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

2 Answers

How to make a 7 row and a 7 coloum in a spreadsheet


Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | 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

    1 Answer

    How do you print envelopes?


    More information is required so I will only assume you are using Excel as a database. Excel is a spread sheet program used by accountants or for mathematical formulas and ledgers. Access is the Database program, however, Excel has functions which is faster to sort and work with address, phone number, zip codes. I will confess, I use Excel as Database because it is quick and easy. I do not know what version of Excel you are using so I will describe it from Office 2007. From Excel make sure you have headers above each column i.e. First Name in Cell A1 Last Name in Cell B1 Address in Cell C1 ect.

    Make sure your data is correct and case sensitive as you would like it. If you want zip+4 select the Colum and right click to format the cells using special and select Zip or Zip+4.
    It is easiest to use Microsoft Word for the next step rather than format the cells, add page breaks, and customize the print size.
    Save your document as an Excel document where you can find it to import it into Word.
    Open word and select Mailings then Start Mail Merge and Step by Step Mail Merge.
    Select Envelope and next. Select envelope options to change envelope size, font and print options.
    Click on Next Select recipients.
    Click on browse under select an existing list.
    Select the Excel file with your address information.
    From the Select Table check the First row of data contains column headers.
    Click on the OK buton.
    Arrange your envelope then Preview it and your good to go.
    If you have an older version of word selects Tools and click on Mail Merge.
    Select Get Data.
    Pull down Excel for document type.
    Select entire Spread Sheet.
    Layout your document and complete the merge.
    On old versions of word it may not recognize the Excel file. If this happens open the Excel file and save it as a Database File (.dbf) and it should work.
    I hope this helps since I did not have enough information from your question.

    Jul 15, 2009 | HP OfficeJet 6110 All-In-One InkJet...

    2 Answers

    VLookup?


    select all columns
    clik on data click filter select autofilter

    Jul 13, 2009 | Microsoft Excel for PC

    1 Answer

    Autosuggest Possible to use in Excel


    As long as your list in Excel is formatted without missing cells in column format with a header in the cell directly above your first list time. i/e if your list is in Column A and you have 500 entries, I am assuming Cell C1 is the column header, and cell C501 is the last item of your list.

    An easier way to view items similar would be to go to Data/ Filter and automatic filter.

    In the arrow or list format in Cell c1 - select custom, in the pop up box you can filter the contains to highlight smaller elements of your list.

    May 01, 2009 | Microsoft Excel 2003 (065-03992) for PC

    Not finding what you are looking for?
    Computers & Internet Logo

    Related Topics:

    129 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Computers & Internet Experts

    Brian Sullivan
    Brian Sullivan

    Level 3 Expert

    27725 Answers

    kakima

    Level 3 Expert

    102366 Answers

    David Payne
    David Payne

    Level 3 Expert

    14161 Answers

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

    Answer questions

    Manuals & User Guides

    Loading...